Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 362484 - SQL - default ADD statement fails with invalid SQL statement - regression
Summary: SQL - default ADD statement fails with invalid SQL statement - regression
Status: CLOSED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: EDT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 major (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-31 09:33 EDT by Paul Hoffman CLA
Modified: 2017-02-23 14:15 EST (History)
2 users (show)

See Also:

Attachments
Test case. (277 bytes, application/octet-stream)
2011-10-31 09:33 EDT, Paul Hoffman CLA 		no flags Details
library for loading database for test program (4.21 KB, application/octet-stream)
2011-10-31 09:33 EDT, Paul Hoffman CLA 		no flags Details
View All 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 Paul Hoffman CLA 2011-10-31 09:33:07 EDT 
Created attachment 206207 [details]
Test case.

Statement "add row to ds" fails with invalid SQL statement.   This is a regression.

It would help to understand the error if the error information included the text of the invalid SQL statement.

See attached sample program.    LoadDataBase.egl attachment is modified.   Make sure you load new copy.

Build is 10310901.

Exception message is: 

Add row 1
Load database failed on previous action, ex = Syntax error: Encountered "," at line 1, column 21.: [sqlstate:42X01][sqlcode:30,000]
Syntax error: Encountered "," at line 1, column 21.: [sqlstate:42X01][sqlcode:30,000]
Comment 1 Paul Hoffman CLA 2011-10-31 09:33:37 EDT 
Created attachment 206208 [details]
library for loading database for test program
Comment 2 Joseph Vincens CLA 2011-10-31 16:01:26 EDT 
fixed
Comment 3 Paul Hoffman CLA 2011-11-01 10:23:44 EDT 
Verified and closed.