Bugzilla – Full Text Bug Listing
| Summary: | SQL - execute SQL update fails | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | z_Archived | Reporter: | Paul Hoffman <hoffmanp> | ||||||||
| Component: | EDT | Assignee: | Project Inbox <edt.javagen-inbox> | ||||||||
| Status: | CLOSED FIXED | QA Contact: | |||||||||
| Severity: | normal | ||||||||||
| Priority: | P3 | CC: | jvincens | ||||||||
| Version: | unspecified | ||||||||||
| Target Milestone: | --- | ||||||||||
| Hardware: | PC | ||||||||||
| OS: | Windows XP | ||||||||||
| Whiteboard: | |||||||||||
| Attachments: |
|
||||||||||
Created attachment 206416 [details]
library for loading database for test program
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.
fixed verified and closed |
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.