Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 360117

Summary: EGL Compiler fails on SQL get with into clause
Product: z_Archived Reporter: Paul Hoffman <hoffmanp>
Component: EDTAssignee: Justin Spadea <jspadea>
Status: CLOSED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: jspadea, jvincens, pharmon, zhuzhi
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Whiteboard:
Attachments:
Description Flags
Test program
none
Library to load database for test case none

Description Paul Hoffman CLA 2011-10-06 11:51:42 EDT
Created attachment 204683 [details]
Test program

EGL compiler tags get with into clause line with following error messages:

Description	Resource	Path	Location	Type
IWN.JavaGen.9998.e 18/445 Exception occurred: java.lang.NullPointerException	NoDefaultSQLForGetWithInto.egl	/test.edt.sql.test/EGLSource/sql/test/defects	line 18	EDT Generation Problem
IWN.JavaGen.9999.e 18/445 Stack Trace: java.lang.NullPointerException	NoDefaultSQLForGetWithInto.egl	/test.edt.sql.test/EGLSource/sql/test/defects	line 18	EDT Generation Problem

Use attached test case to recreate.
Comment 1 Paul Hoffman CLA 2011-10-06 11:52:05 EDT
Created attachment 204684 [details]
Library to load database for test case
Comment 2 Justin Spadea CLA 2011-10-06 14:08:04 EDT
NPE comes from JavaGen not IDE Core.
Comment 3 Joseph Vincens CLA 2011-10-06 18:31:50 EDT
on page 38 the OPEN action has the following:
Note that for now the specification of INTO clause along with syntax or properties to handle various result set properties like being updateable is not defined yet in this spec.

If I comment the INTO the error goes away so this is a validation issue.
Comment 4 Paul Harmon CLA 2011-10-07 08:04:13 EDT
This validation should be added when Bug 356407 is fixed
Comment 5 Justin Spadea CLA 2011-10-13 10:46:02 EDT
Validation now prevents INTO clauses with OPEN, GET, and FOREACH statements.
Comment 6 Paul Hoffman CLA 2011-10-13 11:01:46 EDT
Externals have changed with EDT.

Instead of coding:

get with #sql{ select .... } into a, b, c

code:

get a, b, c with #sql { select .... }  ;
Comment 7 Paul Hoffman CLA 2011-10-17 14:54:42 EDT
verified, fixed