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 172281 - 'Show SQL script for INSERT' returns invalid strings for varchar
Summary: 'Show SQL script for INSERT' returns invalid strings for varchar
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jaroslav Havlin
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-15 13:11 UTC by prodoc
Modified: 2012-04-25 09:57 UTC (History)
0 users

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 prodoc 2009-09-15 13:11:33 UTC
This issue is related to issue #161048 though instead of problems with DECIMAL it has to do with VARCHAR.

Suppose a VARCHAR column has content like the following stored:
<svg xmlns:xlink="http://www.w3.org/1999/xlink" ...> ... </svg>

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, svg xmlns:xlink="http://www.w3.org/1999/xlink" ...> ... </svg);

Instead of:

INSERT INTO TESTDB."test" ("id", "value") VALUES (1, '<svg xmlns:xlink="http://www.w3.org/1999/xlink" ...> ... </svg>');

Note the lack of surrounding quotes, the leading '<' and trailing '>'.

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.7.1 in combination with Apache Derby. Let me know if you need any more information.
Comment 1 Jaroslav Havlin 2012-04-23 16:48:43 UTC
http://hg.netbeans.org/core-main/rev/29f23c1172ab
Fixed.
Comment 2 Quality Engineering 2012-04-25 09:57:45 UTC
Integrated into 'main-golden', will be available in build *201204250400* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/29f23c1172ab
User: Jaroslav Havlin <jhavlin@netbeans.org>
Log: #172281 - 'Show SQL script for INSERT' returns invalid strings for varchar