Bugzilla – Full Text Bug Listing
| Summary: | SQL - annotated column values not returned by get row / rows | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | z_Archived | Reporter: | Paul Hoffman <hoffmanp> | ||||||||||
| Component: | EDT | Assignee: | Project Inbox <edt.javagen-inbox> | ||||||||||
| Status: | CLOSED INVALID | QA Contact: | |||||||||||
| Severity: | major | ||||||||||||
| Priority: | P3 | CC: | jvincens | ||||||||||
| Version: | unspecified | ||||||||||||
| Target Milestone: | --- | ||||||||||||
| Hardware: | PC | ||||||||||||
| OS: | Windows XP | ||||||||||||
| Whiteboard: | |||||||||||||
| Attachments: |
|
||||||||||||
Created attachment 205549 [details]
library for loading database for test program
fixed Created attachment 206367 [details]
Test case.
Created attachment 206368 [details]
library for loading database for test program
Reopen: Default get of annotated record with generated key fails
CNTL-1 saved get row from ds works.
Default get row from ds fails.
See attached test case and updated load database program
Test results:
create annotated record table
success: default add
success: CNTL-1 default get row
Row id = 2
Row varCharCol = Some Char 1
Row nullableCol =
Row updateableCol =
Row insertableCol = 1
Row derivedCol = 1001
Row transientCol = 0
failure: default get row
Row id = 0
Row varCharCol =
Row nullableCol =
Row updateableCol =
Row insertableCol =
Row derivedCol = 0
Row transientCol = 0
See previous comment for reopen reason. This looks like a testcase problem. Here is the code: log ( "failure: default get row" ) ; set row empty ; id int = 2 ; get row from ds ; showRowContents ( row ) ; you are setting the row empty so row.id will be 0, then you set id = 2, but you don't use it. If I set row.id = 2 or 'using id' I will see the expected result. Verifed and closed. Sorry for the user error. |
Created attachment 205548 [details] test case. Annotated and derived column values are not being returned by get row / rows. Get scalar list works correctly. In the attached test, the zero values are returned on get row / rows for the generated id column and the derived column. The nullable column is also being returned as zero value when I think a null value was inserted in the table for the row. See attached test program.