Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 360117 - EGL Compiler fails on SQL get with into clause
Summary: EGL Compiler fails on SQL get with into clause
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: Justin Spadea CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-06 11:51 EDT by Paul Hoffman CLA
Modified: 2017-02-23 14:17 EST (History)
4 users (show)

See Also:


Attachments
Test program (703 bytes, application/octet-stream)
2011-10-06 11:51 EDT, Paul Hoffman CLA
no flags Details
Library to load database for test case (3.53 KB, application/octet-stream)
2011-10-06 11:52 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-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