[h2] Re: dropping JAQU?

On Friday, November 30, 2012 1:49:57 PM UTC+1, Thomas Mueller wrote: > Hi, > > I think it's worth to revive it once Java 8 is available, using closures > for conditions. So instead of: > Now that Java 8 is out, is it time to resurect? > Product p = new Product(); > List restock = db.from(p).

Re: [h2] Re: Index-not-used-in-NOT-IN-or-NOT-LIKE-query

On Thu, Apr 3, 2014 at 4:35 PM, Steve McLeod wrote: > Or can you add a 'IS_OPINION' boolean column that is populated when you > create the table or insert into the table? > > then with an index on that column you'd have extremely fast performance > with SELECT COUNT(*) FROM PUBLIC.OPINION WHERE N

Re: [h2] Excessive amount of time spent in org.h2.util.DateTimeUtils.getTimeTry()

Is there any solution to this? PreparedStatement.setTimestamp(int parameterIndex, Timestamp x) gives you the milliseconds since the Epoch without any timezone. It may be the result of converting some future date in Middle-earth. Now the in Elbonia residing server stores it as its local time and af

Re: [h2] Excessive amount of time spent in org.h2.util.DateTimeUtils.getTimeTry()

Sorry for being unclear, let me retry: In Middle-earth, the user enters 2020-10-10 00:00, which the server (based in Elbonia, but aware about the Middle-earth's TZ) correctly translates to x = new java.sql.Timestamp(1234568000L) and stores via ps.setTimestamp(1, x). For a TIMESTAMP column, MySql u

[h2] Hash index

I'm just looking at the created indexes and getting with SELECT sql, index_class FROM information_schema.indexes WHERE table_name = 'USER' AND primary_key = FALSE this result SQL INDEX_CLASS

Re: [h2] Hash index

PM, Noel Grandin wrote: > We only have real hash indexes for in-memory databases. > > For persistent databases, the hash qualifier doesn't do anything. > > What did you think a persistent hash-index would look like, if not a > b-tree ? > > > On 2014-05-16 13:28, Marti

Re: [h2] H2 - Inconsistent results while dividing numbers with high precisions

That's a funny bug! It's stripping trailing zeros from 1.35822361752313607260107721120531135706133161972E-1*0* :D ValueDecimal.java:101 On Fri, May 16, 2014 at 12:37 PM, Ankur Goyal wrote: > Has anyone come across issues with H2 where divisions are not working as > expected. > > In the exam

[h2] Persistent console history

The console history is a nice feature, but sometimes I get kicked out and have to log in again and the history is gone. I don't know exactly when and why I get kicked out. Is there something I could do about it? I didn't mean the persistency literarily, it's just that I'd love if it could survive

Re: [h2] Persistent console history

prefs.Preferences stuff. > > > On 2014-05-28 16:18, Martin Grajcar wrote: > >> The console history is a nice feature, but sometimes I get kicked out and >> have to log in again and the history is gone. >> >> I don't know exactly when and why I get kicked out

Re: [h2] Persistent console history

On Wed, May 28, 2014 at 8:13 PM, Thomas Mueller < thomas.tom.muel...@gmail.com> wrote: > Hi, > > The H2 Console tool stores the settings in a file called > ".h2.server.properties" in the current user home directory > (Constants.SERVER_PROPERTIES_NAME). > I'd also prefer Properties to Preferences,

Re: [h2] Re: REGEXP and a point

While Java doesn't seem to care to explain what "word boundary" means, perl does: A word boundary (\b ) is a spot between two characters that has a \w on one side of it and a \W on the other side of it (in either order), counting the imaginary characters off the beginning and end of the string as

Re: [h2] Re: REGEXP and a point

On Wed, Jun 11, 2014 at 5:44 PM, Cecil Westerhof wrote: > 2014-06-11 17:30 GMT+02:00 Martin Grajcar : > > While Java doesn't seem to care to explain what "word boundary" means, >> perl does: >> >> A word boundary (\b ) is a spot between two characters t

Re: [h2] Persistent console history

Hi! On Thu, Jun 5, 2014 at 6:52 PM, Thomas Mueller wrote: > Hi, > > I will not have time to implement this feature, but if you want to try, > please go ahead. Patches are welcome. > Sure. I wrote something (attached), let me know what do you think. It gets allowed by creating an entry "commandH

Re: [h2] Persistent console history

Hi Noel, nice! Let me know if you want an improvement. Regards, Martin. On Mon, Jun 30, 2014 at 9:01 AM, Noel Grandin wrote: > Thank for the patch, it has been committed to SVN. > > > On 2014-06-13 07:09 PM, Martin Grajcar wrote: > >> >> Sure. I wrote something (

Re: [h2] Persistent console history

On Wed, Jul 2, 2014 at 1:59 PM, Noel Grandin wrote: > > There is always lots of stuff to work on if you're keen :-) > For example, see: > https://groups.google.com/d/msg/h2-database/SL2hdB7VlnY/6RanPmy_WVsJ > which is also a problem I have seen, but haven't had a chance to track > down yet.

Re: [h2] BigInt[IDENTITY] field not incrementing correctly

Does it also mean that there's no need for a Hi/Lo algorithm as H2 does it already? On Sat, Aug 16, 2014 at 1:54 PM, Thomas Mueller < thomas.tom.muel...@gmail.com> wrote: > Hi, > > Some more detail: numbers are only skipped if the process is killed. > > Regards > Thomas > > > On Saturday, August