Re: [Hsqldb-user] COUNT(*) in PreparedStatement?

[Lorna B. <lor...@sa...>]

Since you got back a prepared statement object (which you did, since the exception occurs during executeQuery, not prepareStatement), its a bug in the execution of the prepared form.

If we had (for some strange reason) decided that count(*) cannot be precompiled, we would through during prepareStatement, not during executeQuery.

I'll assume this is against 1.8.0.7 unless you response otherwise.

I'll reproduce the bug tonight at home and hopefully post something on patch before tomorrow.

----- Original Message -----
From: Dimitri Maziuk <dm...@bm...>
Date: Monday, April 30, 2007 4:44 pm
Subject: [Hsqldb-user] COUNT(*) in PreparedStatement?

> Hi all,
> 
> just noticed:
> 
> SELECT COUNT(*) FROM FOO WHERE BAR=?
> 
> dies with 
> java.sql.SQLException: This function is not supported
>        at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
>        at org.hsqldb.jdbc.jdbcUtil.<clinit>(Unknown Source)
>        at 
> org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown Source)
>        ...
> 
> "SELECT COUNT(*) FROM FOO WHERE BAR='" + string + "'"
> works fine.
> 
> Is that because HSQLDB cannot pre-compile "count(*)"?
> 
> Dima
> -- 
> Dimitri Maziuk
> Programmer/sysadmin
> BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu
> 
> --------------------------------------------------------------------
> -----
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Hsqldb-user mailing list
> Hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>