com.akiban.sql.parser.ParseException: Encountered "" for complex SQL
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Akiban SQL Parser |
New
|
Undecided
|
Unassigned |
Bug Description
SQL Template:
-------------
select IS_VOD_TELECAST, count(1), 1, AVG(TELECAST_
SUM(TELECAST_
count(distinct PROGRAM_LONG_NAME) as distPgmNameCount, count(distinct PROGRAM_
max(TELECAST_
I am using Akiban SQLParser to parse the above sql code snippet, and it fails with below error exactly at the point where CONVERT starts within DISTINCT.
final SQLParser sqlParser = new SQLParser();
final StatementNode statementNode = sqlParser.
Caused by: com.akiban.
When i run the same query without the "count(distinct (convert(
However, this SQL syntax works perfectly fine with Sybase.
Is this a bug? If so, can this be fixed?