Re: HSQLDB 2.3.0 snapshot jar is available

You cannot use TO_DATE or TO_TIMESTAMP functions in a DEFAULT clause.
Use a date literal.

Complex subqueries are supported. You just need to write them in
standard SQL dialect.

Fred

On Fri, May 24, 2013, at 9:49, risaldeep wrote:
> Hello Fred,
> 
> 
> I have used all 2.2.x version to support to_date,to_timestamp in build
> function but it's not working and finally i tried this latest beta
> version
> 2.3.0 ,still those function are not supporting...
> 
> Also complex subquery are also not supporting..what might be the
> problem...???
> 
> Error:
> Caused by: java.sql.SQLSyntaxErrorException: unexpected token: TO_DATE :
> line: 12778
> 	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
> 	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
> 	at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
> 	at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
> 	at org.codehaus.mojo.sql.SqlExecMojo.execSQL(SqlExecMojo.java:1056)
> 	at org.codehaus.mojo.sql.SqlExecMojo.runStatements(SqlExecMojo.java:1018)
> 	at org.codehaus.mojo.sql.SqlExecMojo.access$200(SqlExecMojo.java:68)
> 	at
> org.codehaus.mojo.sql.SqlExecMojo$Transaction.runTransaction(SqlExecMojo.java:1252)
> 	at
> org.codehaus.mojo.sql.SqlExecMojo$Transaction.access$100(SqlExecMojo.java:1199)
> 	at org.codehaus.mojo.sql.SqlExecMojo.execute(SqlExecMojo.java:647)
> 	... 21 more
> Caused by: org.hsqldb.HsqlException: unexpected token: TO_DATE : line:
> 12778
> 	at org.hsqldb.error.Error.parseError(Unknown Source)
> 	at org.hsqldb.ParserBase.unexpectedToken(Unknown Source)
> 	at org.hsqldb.ParserRoutine.readDefaultClause(Unknown Source)
> 	.....
> Please any suggestion!!!
> 
> 
> 
> --
> View this message in context:
> http://hsqldb.10974.n7.nabble.com/HSQLDB-2-3-0-snapshot-jar-is-available-tp1798p3890.html
> Sent from the HSQLDB - User mailing list archive at Nabble.com.
> 
> ------------------------------------------------------------------------------
> Try New Relic Now & We'll Send You this Cool Shirt
> New Relic is the only SaaS-based application performance monitoring
> service 
> that delivers powerful full stack analytics. Optimize and monitor your
> browser, app, & servers with just a few lines of code. Try New Relic
> and get this awesome Nerd Life shirt!
> http://p.sf.net/sfu/newrelic_d2d_may
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service 
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may