Bug #39563 SQLPrimaryKeys returns clobbered resultset rows for some tables

• Submitted: 20 Sep 2008 19:39
• Modified: 25 Feb 2010 15:29
• Reporter: Farid Zidan (Candidate Quality Contributor)
• Status: Duplicate
• Category: Connector / ODBC
• Severity: S1 (Critical)
• Version: 5.1.5
• OS: Windows (XP SP3)
• CPU Architecture: Any
• Tags: clobbered resultset data, qc, SQLPrimaryKeys

[20 Sep 2008 19:39] Farid Zidan

Description:
Executing SQLPrimaryKeys on a bunch of tables, some tables SQLPrimaryKeys resultset is ok, for others ( same ones always ) the driver returns clobbered data for the SQLPrimaryKeys resultset for the tables.

How to repeat:
See attached screen shot. Where SQLPrimaryKeys is executed on a bunch of tables using 3.51.21 driver ( top side ) and 5.1.5 driver ( lower side ) against the same community 5.0.67 server/database. Settings tab shows how resultset columns were bound for the two sides respectively

Suggested fix:
Not sure what is going on. The clobbered resultset data is consistent for the same table( ie, is clobbered or not depending on the table )

[10 Oct 2008 0:36] Jess Balint

Farid,

Please include the output of "SHOW CREATE TABLE" for the problematic tables.

[10 Oct 2008 2:55] Farid Zidan

Hello

here is ddl for table that shows this issue. I also tried to view primary key info in WinSQL and do not get primary key name ( even if named the PK in the create DDL ).

CREATE TABLE  `test_pk` (
  `cpt4` char(5) NOT NULL default '',
  `cpt4group` char(5) NOT NULL default '',
  `section_type` char(1) default NULL,
  `runid` int(11) default NULL,
  `rec_type` char(1) default 'X',
  `cpt4_rec_type` char(6) NOT NULL,
  `cpt4_desc` varchar(50) default NULL,
  `cpt4group_desc` varchar(50) default NULL,
  PRIMARY KEY  (`cpt4_rec_type`),
  UNIQUE KEY `AK_Key_2` (`rec_type`,`cpt4`),
  UNIQUE KEY `x1_cpt4_cpt4group` (`cpt4`,`cpt4group`,`section_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

[10 Oct 2008 2:57] Farid Zidan

Viewing PK name in WinSQL for the test table

Attachment: TestPK.jpg (image/jpeg, text), 137.64 KiB.

[25 Feb 2010 15:26] Lawrenty Novitsky

I think this bug is a duplicate of the Bug#36441.
If nobody minds, i will close it.

[25 Feb 2010 15:29] Lawrenty Novitsky

setting as "duplicate" so far