Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 362818 - SQL - execute SQL update fails
Summary: SQL - execute SQL update fails
Status: CLOSED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: EDT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-11-03 12:23 EDT by Paul Hoffman CLA
Modified: 2017-02-23 14:20 EST (History)
1 user (show)

See Also:

Attachments
Test case. (2.92 KB, application/octet-stream)
2011-11-03 12:23 EDT, Paul Hoffman CLA 		no flags Details
library for loading database for test program (11.05 KB, application/octet-stream)
2011-11-03 12:24 EDT, Paul Hoffman CLA 		no flags Details
Test case for add / insert variations (2.13 KB, application/octet-stream)
2011-11-03 12:45 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-11-03 12:23:42 EDT 
Created attachment 206415 [details]
Test case.

SQL - execute SQL update fails where default replace and CNTL-1 saved default replace work and same update statement is being executed.

Upload both test case and library for loading database.

Test case report:

Create annotated table
Add 10 annotated rows
Start test for defect:  replace annotated record variations fail
default replace statement works
Check updated row 2
CNTL-1 default replace statement works
Check updated row 4
execute update sql statement fails
Failure:  Exception = A null value was used.
CNTL-1 default statement plus using clause fails
Failure:  Exception = A null value was used.
Comment 1 Paul Hoffman CLA 2011-11-03 12:24:01 EDT 
Created attachment 206416 [details]
library for loading database for test program
Comment 2 Paul Hoffman CLA 2011-11-03 12:45:39 EDT 
Created attachment 206418 [details]
Test case for add / insert variations

Similar issue occurs with Add / insert.

Default add and CNTL-1 saved add statement work.    Execute SQL for same insert statement as saved by CNTL-1 fails.   Looks like host variables associated with ? are not being inserted in the correct order.

Addition test case for add is attached.
Comment 3 Joseph Vincens CLA 2011-11-04 15:11:53 EDT 
fixed
Comment 4 Paul Hoffman CLA 2011-11-09 16:15:07 EST 
verified and closed