Code

Programming Languages: Java

License: BSD License

Repositories

browse code, statistics, last commit on 2013-05-15 svn co https://hsqldb.svn.sourceforge.net/svnroot/hsqldb hsqldb

browse code, statistics cvs -d:pserver:anonymous@hsqldb.cvs.sourceforge.net:/cvsroot/hsqldb login

cvs -z3 -d:pserver:anonymous@hsqldb.cvs.sourceforge.net:/cvsroot/hsqldb co -P modulename

browse code, statistics git clone git://hsqldb.git.sourceforge.net/gitroot/hsqldb/hsqldb (read-only)

Show:

What's happening?

  • Followup: RE: MIN() and MAX() give incorrect value

    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

  • Comment: TRUNC function causing java.lang.IllegalArgumentException

    Sent by email. Thank you.

    2013-05-17 03:50:53 PDT by paolobax

  • Comment: Bulk Data Insert Problem

    attached my script file.

    2013-05-17 02:50:04 PDT by kunalghosh84

  • Comment: Bulk Data Insert Problem

    thanks.

    2013-05-17 02:37:05 PDT by kunalghosh84

  • Comment: Bulk Data Insert Problem

    Will be checked and replied to in the next few days.

    2013-05-17 02:06:37 PDT by fredt

  • Followup: RE: MIN() and MAX() give incorrect value

    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

  • MIN() and MAX() give incorrect value

    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

  • Comment: TRUNC function causing java.lang.IllegalArgumentException

    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

  • Bulk Data Insert Problem

    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

  • Comment: TRUNC function causing java.lang.IllegalArgumentException

    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

Our Numbers