This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 143321 - column values doesn't correspond to columns names
Summary: column values doesn't correspond to columns names
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: _ ahimanikya
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-08-08 16:24 UTC by Jan Horvath
Modified: 2008-08-19 14:26 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jan Horvath 2008-08-08 16:24:52 UTC
Product Version: NetBeans IDE 6.5 Beta (Build 200808080301)

steps:
-create following tables in mysql database:

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS A;
CREATE TABLE A (
    ID INT(11),
    B_ID INT(11),
    PRIMARY KEY (ID),
    CONSTRAINT `BB` FOREIGN KEY (`B_ID`) REFERENCES `B` (`ID`)
) ENGINE=InnoDB;

DROP TABLE IF EXISTS B;
CREATE TABLE B (
    ID INT(11),
    TEST INT(11),
    PRIMARY KEY (ID)
) ENGINE=InnoDB;

INSERT INTO A VALUES (1,1);
INSERT INTO B VALUES (1, 42);

SET FOREIGN_KEY_CHECKS=1;

-execute query on this db:
SELECT * FROM A, B WHERE A.B_ID = B.ID

-ERROR: value 42 should be displayed under the column TEST but appears under B_ID
Comment 1 _ ahimanikya 2008-08-19 11:58:55 UTC
http://hg.netbeans.org/main/rev/27c7290ebc7d
Comment 2 Roman Mostyka 2008-08-19 14:26:11 UTC
Verified with build 080819.