[h2] I encountered one difference between 1.3.174 and 1.3.173.

Is this bug ? or spec change ? --Preparation DROP TABLE TESTTBL IF EXISTS; CREATE TABLE TESTTBL AS SELECT 'VAL' AS TESTCOL; --##TEST START## --This query doesn't work on ver1.3.174. But works on 1.3.173. SELECT * FROM ( SELECT TESTCOL AS TESTCOL FROM TESTTBL ORDER BY TESTCOL ASC ); -

[h2] tcp broken after shutdown/restart Connection refused: localhost" [90067-169]

I recently shutdown this H2 database and after restarting the service, I can no longer connect via TCP. I've been troubleshooting from command line; the web interface just times out. Here's what I see: java -cp /home/rules/h2/bin/h2-1.3.169.jar org.h2.tools.Shell -url jdbc:h2:tcp://localhost//

[h2] Re: Newbe Question: H2 on Raspberry

Hi Thomas, thank you for the support. Still cannot finde the database file. Maybe this ist because I start the application with sudo (because I use pi4j wich need admin rights). Peter Am Donnerstag, 2. Januar 2014 14:12:37 UTC+1 schrieb Famco: > > Hi, > > I am working on a home project with h2

Re: [h2] Only show changes in GROUP BY

Wouldn't you usually do that in your reporting software? Or on any layer on top of the database? In MS Access I've done it using a custom function which stores the last value and then only outputs the next value if it is different. Not sure how to do that in H2 ? Probably via a custom function

Re: [h2] Re: Two more fix patch for H2 Database

Hi, Ok, thank you. I will work on using H2 Value instead of the inner class. -Nicolas IRSTV FR CNRS 2488 Le vendredi 20 décembre 2013 17:37:08 UTC+1, Thomas Mueller a écrit : > > Hi, > > I have now committed the patch to allow using user defined functions that > return are result set. > > Aggre