Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 359172 - Replace for SQLResultSet should NOT support using or with clause
Summary: Replace for SQLResultSet should NOT support using or with clause
Status: CLOSED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: EDT (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows 7
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Justin Spadea CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-09-27 23:06 EDT by Yu Hao CLA
Modified: 2017-02-23 14:20 EST (History)
3 users (show)

See Also:

Attachments
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 Yu Hao CLA 2011-09-27 23:06:51 EDT 
Build Identifier: 201109272101

Syntax
Replace_statement ::=
	replace action_target to  data_source_expr 
		[usng_or_with_clause | for_clause];

•	If the data source type is eglx.persistence.sql.SQLResultSet then no USING or WITH clause is allowed.


Reproducible: Always

Steps to Reproduce:
1.Create a function
2.replace rec to RS using(12345)
3.There should be an error for can NOT use "USING clause"
Comment 1 Zhi Zhu CLA 2011-09-27 23:48:51 EDT 
Should be a compiler error,
Comment 2 Justin Spadea CLA 2011-10-27 14:23:48 EDT 
This was fixed when writing the SQL validation code.
Comment 3 Yu Hao CLA 2011-10-27 21:32:45 EDT 
verified in 201110262101