Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 361439 - SQL - annotated column values not returned by get row / rows
Summary: SQL - annotated column values not returned by get row / rows
Status: CLOSED INVALID
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-19 13:25 EDT by Paul Hoffman CLA
Modified: 2017-02-23 14:21 EST (History)
1 user (show)

See Also:

Attachments
test case. (4.25 KB, application/octet-stream)
2011-10-19 13:25 EDT, Paul Hoffman CLA 		no flags Details
library for loading database for test program (3.53 KB, application/octet-stream)
2011-10-19 13:25 EDT, Paul Hoffman CLA 		no flags Details
Test case. (3.82 KB, application/octet-stream)
2011-11-02 15:12 EDT, Paul Hoffman CLA 		no flags Details
library for loading database for test program (5.51 KB, application/octet-stream)
2011-11-02 15:15 EDT, Paul Hoffman CLA 		no flags Details
Show Obsolete (2) 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-19 13:25:23 EDT 
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.
Comment 1 Paul Hoffman CLA 2011-10-19 13:25:53 EDT 
Created attachment 205549 [details]
library for loading database for test program
Comment 2 Joseph Vincens CLA 2011-10-26 15:55:56 EDT 
fixed
Comment 3 Paul Hoffman CLA 2011-11-02 15:12:36 EDT 
Created attachment 206367 [details]
Test case.
Comment 4 Paul Hoffman CLA 2011-11-02 15:15:06 EDT 
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
Comment 5 Paul Hoffman CLA 2011-11-02 15:15:45 EDT 
See previous comment for reopen reason.
Comment 6 Joseph Vincens CLA 2011-11-03 10:01:44 EDT 
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.
Comment 7 Paul Hoffman CLA 2011-11-04 08:37:29 EDT 
Verifed and closed.    Sorry for the user error.