Programming Languages: Java
License: BSD License
It does appear to be fixed in the latest 2.3 SNAPSHOT. I did notice one change, not sure if it is intentional or not. It doesn't affect me as I don't check the return value of sqltool but shutdown now results in an error. Thought I would mention it. [code]java -jar sqltool.jar --inlineRc=url=jdbc:hsqldb:hsql://localhost,user=SA,password= --sql="shutdown;" [Server@257db177]...
2013-05-17 13:16:34 PDT by thomasnospam
Sent by email. Thank you.
2013-05-17 03:50:53 PDT by paolobax
attached my script file.
2013-05-17 02:50:04 PDT by kunalghosh84
2013-05-17 02:37:05 PDT by kunalghosh84
Will be checked and replied to in the next few days.
2013-05-17 02:06:37 PDT by fredt
This has been fixed for 2.3.0. You can try the latest snapshot jar. http://www.hsqldb.org/repos/org/hsqldb/hsqldb/SNAPSHOT/.
2013-05-16 16:13:56 PDT by fredt
HSQLDB: 2.2.9 MIN() and MAX() give value one greater than expected when used on a column generated by ROWNUM() Example: [code] Create Table Test ( a INTEGER ); Insert Into Test Values( 1 ); Insert Into Test Values( 2 ); Insert Into Test Values( 3 ); Insert Into Test Values( 3 ); Insert Into Test Values( 2 ); [/code] [code]Select t.*, ROWNUM() as r From Test t;[/code] [code] 1...
2013-05-16 15:36:23 PDT by thomasnospam
Yes, I forgot to remove the SUM() from the SELECT. Please zip the file and attach it to this bug report. If there is any problem, send it to my email address, which is fredt at users.sourceforge.net I need the raw data to find out which values cause the problem.
2013-05-16 08:14:18 PDT by fredt
Hi, I would like to use hsql as a back-end database for a data mining application because of its reported high speed. Unfortunately I'm having problems importing the large (15 millions rows and 103 columns and 10.5 GB) csv files that hold the data. I see that the hsqldb datafile limit is reached withing a few hours. data file reached maximum size C:\opt\icedb.data...
2013-05-16 07:28:58 PDT by kunalghosh84
I can't run the query you asked because I get this error: expression not in aggregate or GROUP BY columns: STATS.CONNECTION.TIME_STAMP. I changed it to: SELECT TIME_STAMP AS X, COUNTER AS Y FROM STATS.CONNECTION WHERE TIME_STAMP>=1262214000000 AND TIME_STAMP<=1262383200000 but it returns 1233 rows, so a little difficult to write them here. I can send by email if you like. Not sure if...
2013-05-16 07:03:55 PDT by paolobax