The 'Show SQL script for INSERT' function (found in the context menu of the 'View Data' result rows) returns strings
for decimal column values. These are incompatible when using the generated query again to insert data. E.g. if I have
and stuff it with some values:
CREATE TABLE "test" (
"id" INT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
"value" DECIMAL(5,2) NOT NULL,
PRIMARY KEY ("id")
I get the following back when using the 'Show SQL script for INSERT' function on one or more rows:
INSERT INTO TESTDB."test" ("id", "value") VALUES (1, '5.00');
INSERT INTO TESTDB."test" ("id", "value") VALUES (1, 5.00);
This results in an unusable (error generating) statement if you want to execute it because the string can not be
converted to a suitable value.
I'm using Netbeans 6.5.1 in combination with Apache Derby. Let me know if you need any more information.
NB6.7 was released already - http://www.netbeans.org/community/releases/67/
Postpone fixing this issue on the next release.
Seems to work fine on NetBeans 7.2.
Please reopen if you still encounter this problem on the latest release.
Thank you for reporting.