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

[ODBC] Severe bug in SQLPrimaryKeys function in psqlODBC 09.06.0500

From
"Jan-Peter Seifert"
Date:
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

Re: [ODBC] Severe bug in SQLPrimaryKeys function in psqlODBC09.06.0500

From
"Jan-Peter Seifert"
Date:
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

Re: [ODBC] Severe bug in SQLPrimaryKeys function in psqlODBC09.06.0500

From
"Inoue, Hiroshi"
Date:
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

Re: [ODBC] Severe bug in SQLPrimaryKeys function in psqlODBC09.06.0500

From
"Jan-Peter Seifert"
Date:
Hello Hiroshi,
 
Gesendet: Donnerstag, 28. September 2017 um 15:10 Uhr
Von: "Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>
An: "Jan-Peter Seifert" <Jan-Peter.Seifert@gmx.de>
Cc: pgsql-odbc@postgresql.org
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