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 184124 - Insert records dialog shows error in it's own sql code
Summary: Insert records dialog shows error in it's own sql code
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: PC Linux
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-04-14 10:22 UTC by Michael Nazarov
Modified: 2010-12-09 14:27 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
screenshot (27.89 KB, image/png)
2010-04-14 10:22 UTC, Michael Nazarov 		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 Michael Nazarov 2010-04-14 10:22:28 UTC 
Created attachment 97300 [details]
screenshot

While adding records using Insert Record(s) dialog it shows errors in
the generated code. Check screenshot for details.
Reproduced on Linux not on Windows.
Comment 1 Jiri Rechtacek 2010-04-26 13:21:00 UTC 
Could you describe datatypes of columns? I cannot reproduce it on Linux with my datatypes. Thanks
Comment 2 Michael Nazarov 2010-04-27 08:27:05 UTC 
I think type doesn't matter steps to reproduce more important, so check below.

There is existing empty table with VARCHAR(1024) and BIT(3)

Steps to reproduce:

1. Open Insert Record dialog.
2. Fill first row.
3. Press Show SQL button to view SQL code.
4. Add new row.
5. Fill second row.

With last field of second row filled there will be error.
Comment 3 Jiri Rechtacek 2010-04-27 11:44:11 UTC 
Thanks, I'm able to reproduce it now on MySQL, not Java DB.
Comment 4 Michael Nazarov 2010-04-27 11:46:14 UTC 
Was it filed against JavaDB? Sorry.
Comment 5 Jiri Rechtacek 2010-04-27 11:53:56 UTC 
No, you didn't. I tried on JavaDB previously where it works correctly. It's reproducible on MySQL.
Comment 6 Jiri Rechtacek 2010-12-09 14:27:05 UTC 
Worksforme on in recent build.
  Product Version         = NetBeans IDE Dev (Build 101122-0f6ce06434f3) (#0f6ce06434f3)
  Operating System        = Linux version 2.6.35-23-generic running on amd64
  Java; VM; Vendor        = 1.6.0_20; Java HotSpot(TM) 64-Bit Server VM 16.3-b01; Sun Microsystems Inc.
  Runtime                 = Java(TM) SE Runtime Environment 1.6.0_20-b02
  Java Home               = /usr/local/share/java/jdk1.6.0_20/jre