Problem with count function.

Status: Alpha

Brought to you by: manningr, ultimoamore

Problem with count function.

Forum: Open Discussion

Creator: Nobody/Anonymous

Created: 2007-04-18

Updated: 2012-12-07

Nobody/Anonymous - 2007-04-18

Hi all

I want to parse the below query .but i am getting an exception

"Select count(distinct id) from AB"

StackTrace is given below

net.sf.jsqlparser.JSQLParserException
    at net.sf.jsqlparser.parser.CCJSqlParserManager.parse(CCJSqlParserManager.java:40)
    at net.sf.jsqlparser.test.mytest.Mypareser.parse(Mypareser.java:118)
    at net.sf.jsqlparser.test.mytest.Mypareser.main(Mypareser.java:110)
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered "( distinct" at line 1, column 14.

Can anyone help me to solve this??

Thanks in advance
Gokul

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Leonardo Francalanci - 2007-04-24
  
  I'll look at that
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Nobody/Anonymous - 2010-07-08

I have the same problem:

"Select count(distinct id) from AB"

JSQLParser tells me that this query is wrong, and it doesn't…

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Leonardo Francalanci - 2010-11-18

I'll upload version 0.6.4, which should solve the problem

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.