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.
| Summary: | column values doesn't correspond to columns names | ||
|---|---|---|---|
| Product: | db | Reporter: | Jan Horvath <jhorvath> |
| Component: | Show Data | Assignee: | _ ahimanikya <ahimanikya> |
| Status: | VERIFIED FIXED | ||
| Severity: | blocker | CC: | romanmostyka |
| Priority: | P2 | ||
| Version: | 6.x | ||
| Hardware: | All | ||
| OS: | All | ||
| Issue Type: | DEFECT | Exception Reporter: | |
Verified with build 080819. |
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