Details
-
Type: Bug
-
Status: Resolved
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.3.0
-
Component/s: None
-
Labels:None
Description
During a free form query import on Oracle, the generated bounds query is as follows:
SELECT MIN(BAR), MAX(BAR) FROM (SELECT * FROM FOO WHERE (1=1)) AS TABLE_NAME
This query does not work with Oracle since it does not allow the use of AS to project a sub-query as table. Instead the correct syntax will be something like the following:
SELECT MIN(BAR), MAX(BAR) FROM (SELECT * FROM FOO WHERE (1=1)) TABLE_NAME