Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 361168 - SQL - Validation fails for get a,b,c from ds with #sql{}
Summary: SQL - Validation fails for get a,b,c from ds with #sql{}
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: Joseph Vincens CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-17 13:21 EDT by Paul Hoffman CLA
Modified: 2017-02-23 14:15 EST (History)
3 users (show)

See Also:


Attachments
test program for defect (1.34 KB, application/octet-stream)
2011-10-17 13:21 EDT, Paul Hoffman CLA
no flags Details
Library to load database for test (3.53 KB, application/octet-stream)
2011-10-17 13:22 EDT, Paul Hoffman CLA
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Paul Hoffman CLA 2011-10-17 13:21:04 EDT
Created attachment 205356 [details]
test program for defect

This variation came from Tim.    The "get scalar list from ds" should not require the variables in the list to be in an annotated record or entity.

See attached test program.
Comment 1 Paul Hoffman CLA 2011-10-17 13:22:20 EDT
Created attachment 205357 [details]
Library to load database for test
Comment 2 Joseph Vincens CLA 2011-10-18 14:21:22 EDT
I talked to Tim if a non entity variables are used a WITH clause must be used. 
We need to decide if some variables are non entity or if the variables point to multiple entities which map to different tables 
What does validation and generation do for the following
 -some variables are non entity 
 -if the variables point to multiple entities which map to different tables

Variables need to be validated that they are primitive types.

If there are multiple or no entities represented in the variables list then a WITH clause must be specified.

Are there other ambiguous situations? 

After validation changes are made reassign the defect back to me so I can test the gen/run.
Comment 3 Justin Spadea CLA 2011-10-19 14:25:49 EDT
Validation now allows primitives that are not within an entity type. If the targets do not map to a single table, then the FOR clause must be used for ADD, or the WITH clause must be used for GET.
Comment 4 Joseph Vincens CLA 2011-10-26 15:56:18 EDT
fixed
Comment 5 Paul Hoffman CLA 2011-11-01 16:44:42 EDT
Closed and verified