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 143316 - unable to run query on two tables from JavaDB sample database
Summary: unable to run query on two tables from JavaDB sample database
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:02 UTC by Jan Horvath
Modified: 2008-08-19 17:13 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
143316 (220.59 KB, image/jpeg)
2008-08-08 18:06 UTC, _ ahimanikya 		Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jan Horvath 2008-08-08 16:02:58 UTC 
steps:
-connect to sample db
-execute following query: "select * from APP.CUSTOMER, APP.DISCOUNT_CODE where DISCOUNT_CODE.DISCOUNT_CODE=CUSTOMER.DISCOUNT_CODE"
-ERROR:
Error code 20000, SQL state 22018: Invalid character string format for type java.math.BigDecimal.
Line 1, column 1

-the query is obviously valid. I've successfully executed it from java.
Comment 1 _ ahimanikya 2008-08-08 18:04:02 UTC 
How old is your build, I followed the steps as mentioned, it did work for me (see the attachment) 

Try the latest build.
Comment 2 _ ahimanikya 2008-08-08 18:06:36 UTC 
Created attachment 66916 [details]
143316
Comment 3 Jan Horvath 2008-08-08 18:47:20 UTC 
I'm sorry I foregot. I can reproduce it in 6.5 Beta
Comment 4 Jan Horvath 2008-08-08 19:37:28 UTC 
ahimanikya I've just reproduced it in the latest daily build 200808081401 so reopening the issue.
Comment 5 _ ahimanikya 2008-08-19 11:58:18 UTC 
http://hg.netbeans.org/main/rev/27c7290ebc7d
Comment 6 Roman Mostyka 2008-08-19 14:24:01 UTC 
Verified with build 080819.
Comment 7 Quality Engineering 2008-08-19 17:13:06 UTC 
Integrated into 'main-golden', available in build *200808191401* on http://bits.netbeans.org/dev/nightly/
Changeset: http://hg.netbeans.org/main/rev/27c7290ebc7d
User: ahimanikya@netbeans.org
Log: When more than one table was used the columns were not properly associated with resultset. This will fix issues #143316,143321,143799,144030