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

Bug 359172

Summary:	Replace for SQLResultSet should NOT support using or with clause
Product:	z_Archived	Reporter:	Yu Hao <yuhaodl>
Component:	EDT	Assignee:	Justin Spadea <jspadea>
Status:	CLOSED FIXED	QA Contact:
Severity:	normal
Priority:	P3	CC:	pharmon, yuhaodl, zhuzhi
Version:	unspecified
Target Milestone:	---
Hardware:	PC
OS:	Windows 7
Whiteboard:

Description Yu Hao

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

2011-09-27 23:48:51 EDT

Should be a compiler error,

Comment 2 Justin Spadea

2011-10-27 14:23:48 EDT

This was fixed when writing the SQL validation code.

Comment 3 Yu Hao

2011-10-27 21:32:45 EDT

verified in 201110262101