Re: Severe bug in SQLPrimaryKeys function in psqlODBC 09.06.0500

Hello Hiroshi,

Gesendet: Donnerstag, 28. September 2017 um 15:10 Uhr

Von: "Inoue, Hiroshi" <[email protected]>

An: "Jan-Peter Seifert" <[email protected]>

Cc: [email protected]

Betreff: Re: [ODBC] Severe bug in SQLPrimaryKeys function in psqlODBC 09.06.0500

Hi Peter,

On 2017/09/28 19:05, Jan-Peter Seifert wrote:

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.

Thanks for the report.

Could you please try the test drivers 9.6.0502 on Windows at

http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/ ?

regards,

Hiroshi Inoue

I have the psqlODBC logs in case you need them.

Best regards,

Peter

version 9.6.0502 doesn't show this error.

Thank you very much!

Best regards,

Peter