In x86_64 GNU/Linux machine i installed mysql-5.1.34-linux-x86_64-glibc23,
mysql-connector-odbc-5.1.5-linux-x86-64bit and unixOdbc as unixODBC-2.2.14.tar.gz.

I have created table as

create table t1(f1 int unique,f2 int,primary key(f2));

The odbc driver function SQLPrimarykey does not gives correct primary field name.

Again if the table is like create table t1(f1 int unique,f2 int);

then dbc driver function SQLPrimarykey driver function gives f1 as primary key.

Can someone tell me is it a bug or i have chosen wrong package or wrong way


bijaya