]
Steven Hawkins moved TEIIDDES-970 to TEIID-1620:
------------------------------------------------
Project: Teiid (was: Teiid Designer)
Key: TEIID-1620 (was: TEIIDDES-970)
Issue Type: Feature Request (was: Bug)
Affects Version/s: (was: 7.2)
Component/s: Query Engine
(was: Validation)
Fix Version/s: 7.5
(was: 7.5)
Fetch keyword not handled
-------------------------
Key: TEIID-1620
URL:
https://issues.jboss.org/browse/TEIID-1620
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Environment: JBDS 4.0
Reporter: Joel Tosi
Priority: Minor
Fix For: 7.5
Try to limit your query using native SQL construct fetch. While there are other ways to
do this inside designer, support the native SQL construct for ease of use by data
architects:
select * from SAMPLE_DATABASE fetch first 100 rows only
jBoss Designer error:
select * from SAMPLE_DATABASE fetch first 100 rows only
Remote org.teiid.api.exception.query.QueryParserException: Parsing error:
Encountered "fetch" at line 1, column 36.
Was expecting one of:
<EOF>
"group" ...
"having" ...
"intersect" ...
"limit" ...
"makedep" ...
"makenotdep" ...
"order" ...
"where" ...
"," ...
";" ...
"union" ...
"except" ...
"option" ...
"cross" ...
"right" ...
"left" ...
"full" ...
"inner" ...
"join" ...
Elapsed Time: 0 hr, 0 min, 0 sec, 0 ms.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: