Thread: [ODBC] Severe bug in SQLPrimaryKeys function in psqlODBC 09.06.0500

Hello,

there seems to be a new bug in the SQLPrimaryKeys function - e.g. called with (042C0FB0, , 0, , 0, table, -3).
It generates this SELECT:
select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta,
pg_catalog.pg_attributeia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n,
pg_catalog.pg_classic where tc.relname = E'table' AND n.nspname = E'xxx' AND tc.oid = i.indrelid AND n.oid =
tc.relnamespaceAND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum =
i.indkey[ia.attnum-1]AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by
ia.attnumselectta.attname, ia.attnum, ic.relname, n.nspname, NULL from pg_catalog.pg_attribute ta,
pg_catalog.pg_attributeia, pg_catalog.pg_class ic, pg_catalog.pg_index i, pg_catalog.pg_namespace n where ic.relname =
E'ktom_pkey'AND n.nspname = E'mbs' AND ic.oid = i.indexrelid AND n.oid = ic.relnamespace AND ia.attrelid = i.indexrelid
ANDta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped)
orderby ia.attnum 

In 09.06.0410 everything is okay.

I have the psqlODBC logs in case you need them.

Best regards,

Peter


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Hello,

I must correct myself. Within the same transaction SQLColumns is being called before SQLPrimaryKeys. So it's most
likelythis function that does not work correctly. After SQLPrimaryKeys function SQLStatistics is being called.
 

Best regards,

Peter


-- 
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Hello,

there seems to be a new bug in the SQLPrimaryKeys function - e.g. called with (042C0FB0, , 0, , 0, table, -3).
It generates this SELECT:
select ta.attname, ia.attnum, ic.relname, n.nspname, tc.relname from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class tc, pg_catalog.pg_index i, pg_catalog.pg_namespace n, pg_catalog.pg_class ic where tc.relname = E'table' AND n.nspname = E'xxx' AND tc.oid = i.indrelid AND n.oid = tc.relnamespace AND i.indisprimary = 't' AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) AND ic.oid = i.indexrelid order by ia.attnum　select ta.attname, ia.attnum, ic.relname, n.nspname, NULL from pg_catalog.pg_attribute ta, pg_catalog.pg_attribute ia, pg_catalog.pg_class ic, pg_catalog.pg_index i, pg_catalog.pg_namespace n where ic.relname = E'ktom_pkey' AND n.nspname = E'mbs' AND ic.oid = i.indexrelid AND n.oid = ic.relnamespace AND ia.attrelid = i.indexrelid AND ta.attrelid = i.indrelid AND ta.attnum = i.indkey[ia.attnum-1] AND (NOT ta.attisdropped) AND (NOT ia.attisdropped) order by ia.attnum

In 09.06.0410 everything is okay.

I have the psqlODBC logs in case you need them.

Best regards,

Peter