Re: [h2] Asc order problem in a Date Data type Column using Pluggable / User-Defined Table

I updated our unit tests to test this case, and it seems to be working fine. If you are convinced the problem lies in H2, try creating a small standalone test case, and then we could help you debug it. -- You received this message because you are subscribed to the Google Groups "H2 Database"

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

I'm sorry, but that's just a silly combination to be using. You should only using be "split:" for FAT filesystems, and you should certainly not be using it in combination with "nioMemLZF:" -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] Missing lob entry on concurrent update read of a row

yes, because you are not holding the transaction open while reading the LOB, so the LOB is disappearing while you are reading it. i.e. connection.setAutoCommit(false); read the LOB completely here.. connection.commit(); -- You received this message because you are subscribed to

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

It appears I was wrong about this, we already implement reading/writing without synchronisation for all of our other file implementations, I just missed that you are using the "split:" stuff. I have pushed a fix for this. -- You received this message because you are subscribed to the Google

Re: [h2] MVStore -- can I ignore it?

On 2016/12/21 10:26 AM, SkiAddict wrote: How do we migrate to the MV_STORE format? Dump and restore. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] MVStore -- can I ignore it?

MV_STORE is a completely separate storage engine from the old PageStore. The old PageStore engine generates files with a .h2.db extension, the new MV_STORE engine generates files with a .mv.db extension. So it's not possible to mix and match opening the same files with the different engines. I

Re: [h2] Re: The last stable release Version 1.3.176 was published at 2014-04-05, when will 1.4.x stable version release?

We already require java7 for current 1.4​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send

Re: [h2] Concurrency at org.h2.store.fs.FileBase.read()

Not without changing the structure considerably - FileBase inherits from java.nio.channels.FileChannel, which has a position field, and multiple things changing that at the same time would cause problems. We'd probably need to switch to using Java's asynchronous IO API to avoid that, which is

Re: [h2] SELECT FOR UPDATE does not work with MERGE

we don't currently have an answer for that, other than "be careful what order you do your MERGE statements in" because MERGE will take a full-table lock even in MVCC mode, and, as you found out, if you do MERGE statements in different orders in different transactions, you will get a timeout.

Re: [h2] SELECT FOR UPDATE does not work with MERGE

SELECT FOR UPDATE doesn't actually do anything useful in MVCC mode, I'm afraid. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] Re: Please help, h2 console in El Capitan very very slow!!!

Also, this might be useful http://osxdaily.com/2014/11/20/flush-dns-cache-mac-os-x/ ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] Missing lob entry on concurrent update read of a row

On 2016/12/19 3:20 PM, Mayank Tankhiwale wrote: I am getting exceptions stating "Missing lob entry" on concurrent update and read of a row in the table. i.e. one thread/connection is reading(in loop) meanwhile another thread comes and updates the CLOB. After that when the previous thread

Re: [h2] Re: Please help, h2 console in El Capitan very very slow!!!

ok, so it's hanging in the at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method) at java.net.InetAddress$2.lookupAllHostAddr(InetAddress.java:928) at java.net.InetAddress.getAddressesFromNameService(InetAddress.java: 1323) at

Re: [h2] Re: Please help, h2 console in El Capitan very very slow!!!

Nice work so far, thanks. Hmmm, ok, so this has something to do with Bonjour/MDNS and Java1.8. Could you perhaps use VisualVM or jstack to capture a stacktrace of what the Console java process is doing during that gap between the browser launching and the console finishing loading? Those tools

Re: [h2] Set time part in timestamp

it doesn't look like we support that form of the TIMESTAMPDIFF function http://h2database.com/html/functions.html#datediff ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send

Re: [h2] odd issue with create table duplicate columns

yeah, using experimental options probably not a good idea unless you want to debug them: http://h2database.com/javadoc/org/h2/engine/DbSettings.html?highlight=DATABASE_TO_UPPER=database_to_upper ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group.

Re: [h2] Recommendation for Analyze

unless you have modified the default settings, ANALYZE will run automatically, I should really update the Performance page to reflect that http://h2database.com/javadoc/org/h2/engine/DbSettings.html?highlight=analyze=analyze#ANALYZE_AUTO ​ -- You received this message because you are subscribed

Re: [h2] Escape apostrophe in H2

there is this thing called "documentation" http://h2database.com/html/grammar.html#string ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] No STRAIGHT_JOIN ?

for which I'd be happy to accept a patch, since it looks like a simple change to the Parser (assuming that we don't implement the actual semantics, which would be a much more complicated thing) On 14 December 2016 at 08:42, Noel Grandin <noelgran...@gmail.com> wrote: > that appears to b

Re: [h2] Re: Please help, h2 console in El Capitan very very slow!!!

On 17 December 2016 at 09:42, SkiAddict wrote: > > - I'm sorry, but can you please explain how to set a system property? > I've googled java.net.preferIPv4Stack and all I see is Java code, calls to > System.setProperty(). Also how do I get the current value of >

Re: [h2] Re: Please help, h2 console in El Capitan very very slow!!!

you could try running things like wireshark to watch the tcp stream, and dtruss to watch the networking system calls. Look for any long gaps between calls, or particularly long times for the call to complete. ​ -- You received this message because you are subscribed to the Google Groups "H2

Re: [h2] Re: SQLServer Linked Table and Column Name Case Sensitivity

If your MSSQL DB is in case-sensitive mode, why is returning true from DatabaseMetaData#storesMixedCaseIdentifiers ? Where the JavaDoc for that method says it means "Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case."

Re: [h2] No STRAIGHT_JOIN ?

that appears to be a MySQL-specific thing which we don't currently support.​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] Re: The last stable release Version 1.3.176 was published at 2014-04-05, when will 1.4.x stable version release?

depends on your definition of beta. It is stable enough for us to use in production, but some people are still experiencing the occasional problem, notably around excessive file size growth. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] Re: Multithread insert performance issue

I had a look through those traces but I did not seem any signs of a memory leak. I've personally never tried to run H2 that hard, and Im sorry but I don't have time to track down this sort of problem right now. You are more than welcome to submit patches however :-) -- You received this

Re: [h2] Re: threads blocking in PageStore.getPage

(a) you need to use MV_STORE=FALSE to select PageStore in 1.4​ (b) we have not done any work on making MULTI_THREADED work better with PageStore, nor do we intend to. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this

Re: [h2] Re: Multithread insert performance issue

thanks. looks like we are bottlenecking on the locking on the undoLog object in TransactionStore, particularly in the commit() method. I see a comment there // TODO could synchronize on blocks (100 at a time or so) which means perhaps Thomas had some ideas how this could be improved. Bit

Re: [h2] Re: Multithread insert performance issue

Sorry, that's not something I can analyze myself. I suggest you hook up a profiler like visualvm and take CPU sampling profiles of both cases. Then we could compare them to see what the problem is. Also take a heap dump of the tcp case so we can see if there is a memory leak. On Sun, 11 Dec 2016

Re: [h2] NullPointerException at concurrent updates (MULTI_THREADED)

thank you for the test case, fix is in master​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group,

Re: [h2] Re: threads blocking in PageStore.getPage

multi_threaded was very very experimental back then. it's getting better now, and with current master I'm running it myself (with the MVStore) engine in my QA to flush out issues. ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe

Re: [h2] Re: Very slow calculateCost

I suspect that we have an O(n^2) problem here, triggered by the way TableView and ViewIndex tend to pass around query information as a SQL string. Which causes us to unnecessarily reparse and re-optimise subtrees of queries. Changing that, however, is a fair amount of work which I'm not likely

Re: [h2] Speed issues.. is MVCC + MV_STORE good to go? grasping for anything.. ( Large DB )

our CLOB/BLOB implementation can be troublesome. I would suggest just using VARBINARY, we have no real per row size limitation. MVCC is on by default with MV_STORE and works fine for me. You can't turn MV_STORE off without it creating a new DB, since MV_STORE and the old engine use two different

Re: [h2] Re: Very slow calculateCost

Also, which version are you testing against? One of our recent versions had a regression where it prepared statements slower than before. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails

Re: [h2] TimeNanos out of range when using different version of jar - No check when DB upgraded

That's not a format change, that's a "we prefer to detect corruption earlier rather than later" change​ Obviously your DB become corrupted at some point in the past, but H2 didn't notice back then because it was not checking the range of such things. I suggest you revert to an earlier version,

Re: [h2] Commit of rolled back transaction works

Yes, that number is session ID. This might have something to do with XA stuff, which some connection pools use, but I don't understand that stuff.​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop

Re: [h2] Commit of rolled back transaction works

that does sound dodgy, a commit directly after a rollback should have no effect yes, a test case would be very useful ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an

Re: [h2] Data stored in the INFORMATION_SCHEMA.LOBS and INFORMATION_SCHEMA.LOB_MAP tables seems to blow up our database

On 2016/11/24 12:02 PM, Reinhold Bihler wrote: Another approach would be to monitor the count of entries in the INFORMATION_SCHEMA.LOBS and INFORMATION_SCHEMA.LOB_MAP. What do you think? Does this sound more promising? yes, good idea, If it is a LOB problem, that will point it out fairly

Re: [h2] Data stored in the INFORMATION_SCHEMA.LOBS and INFORMATION_SCHEMA.LOB_MAP tables seems to blow up our database

those tables are related to LOB/CLOB/BLOB space management. it's quite possible we have a leak somewhere in our handling of those, particularly if you are generating temp tables with LOBs. Unfortunately, without a test case, it is unlikely that we can fix it. ​ -- You received this message

Re: [h2] Explain for queries with parameters

follow the preparedstatement code down, to see how the parsing is different from regular statement. shouldn't be too hard to implement ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails

Re: [h2] Is Java 7 the new H2 baseline Java version?

yup, we now need Java7 or better -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to

Re: [h2] Implementation issue in method of class org.h2.store.fs.FilePathRetryOnInterrupt

good spotting, fix has been committed. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send

Re: [h2] Re: Can't get H2 1.4.193 in embedded mode to connect to existing ~/test.mv.db

that looks like you are using an old version of H2 in your application, which is opening a database based on the PageStore engine, hence the .h2.db file extension. the web console is running a newer version, and is defaulting to the MVStore engine, hence the .mv.db file extension ​ -- You

Re: [h2] Recovery DB Help

I'm afraid your database is corrupt, there is not really anything you can do. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] How to determine whether a file is H2 database?

Nope. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to

Re: [h2] What will happen if......

No. But if the primary application exits, the secondary application will lose it's connection to the database. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] order of updates

mostly, yes, but given how threads are scheduled it's not a hard guarantee​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] Huge memory requirements for simple select order by - why?

we don't do server-side cursors yet. which is what you're asking for. use SELECT..LIMIT..OFFSET to limit the amount of data you pull in one SELECT ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop

Re: [h2] regex_replace does not work with the 4th parameter argument

Looks like a bug, noone bothered to write a unit test. Fixed now in commit d9190f409b5e749409b71949391fda1ac49857e8 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email

Re: [h2] Upgrade existing databases (1.3.x) to mvstore?

http://h2database.com/html/tutorial.html#upgrade_backup_restore -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post

Re: [h2] Upgrade existing databases (1.3.x) to mvstore?

No, you'll need to either do a dump/restore sequence, or keep using the old PageStore engine by appending ";MV_STORE=FALSE" to your connection URL. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop

Re: [h2] numServers internal use and clientInfo problem

it's internal in the sense that you can't override it by setting it explicitly - that's a safety feature, to prevent people accidentally sticking their own property with the same name in and then getting confused when they get a different value back out. -- You received this message because

Re: [h2] numServers internal use and clientInfo problem

I would be surprised if anyone else is using it. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group,

Re: [h2] numServers internal use and clientInfo problem

Unfortunately, you can pretty much either patch H2 or patch Payara. Payara should really not be doing that, that's very dodgy behaviour. I suspect it is doing it to work around some other databases behaviour, in which case it should probably be checking and only doing it for that database. ​ --

Re: [h2] INSERT .. ON DUPLICATE KEY UPDATE may not work depending on table indexes order and columns participating in statement

thanks for the good test cases, this has been fixed on master -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post

Re: [h2] INSERT .. ON DUPLICATE KEY UPDATE may not work depending on table indexes order and columns participating in statement

If I execute your new test, my result is select * from test_table; ID DUP COUNTER 1 1 2 ??? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email

Re: [h2] INSERT .. ON DUPLICATE KEY UPDATE may not work depending on table indexes order and columns participating in statement

On 2016/10/19 2:24 PM, Filipp Zhinkin wrote: Suppose we have following table: CREATE TABLE test_table ( id INT, dup INT, counter INT, UNIQUE(dup), PRIMARY KEY(id) ); I'm expecting to observe counter == 2 after following statements being executed: INSERT INTO test_table (id, dup,

Re: [h2] H2 compatibility with Oracle

Our compatibility with things like that is not perfect. I am always happy to accept patches, however. ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] MVstore - off heap storage

On 2016/10/18 1:27 AM, Adam McMahon wrote: [1] Off heap storage - is there any way to designate the size of the offheap store, or does it just continue to fill up until it runs out of memory? [2] Off heap storage - Can we designate how much of the map should be in heap vs offheap? [3]

Re: [h2] Deterministic functions optimization

alternative, you can optimise this by hand by either declaring a variable, or using a column to compute the value and then refer to that column from the other columns​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this

Re: [h2] Deterministic functions optimization

Feel free to submit a patch -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to

Re: [h2] Re: Is there a way to create an UNIQUE INDEX in H2?

Confirmed that that this is indeed a bug, even in latest master, please log an issue in our tracker so we don't forget it. https://github.com/h2database/h2database/issues Thanks, ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe

Re: [h2] Re: Is there a way to create an UNIQUE INDEX in H2?

For starters, your script does not run on H2 because it is using weird syntax. However, if I fix it, H2 correctly throws a constraint violated exception. ​ CREATE TABLE SOMETHING_TABLE ( COLUMN1 CHAR(10), COLUMN2 CHAR(10), COLUMN3 CHAR(2), COLUMN4

Re: [h2] Re: Error while executing query "Subquery is not a single column query; SQL statement:"

we don't support multiple-column-IN queries, you'll need to rewrite it as a JOIN​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] Force database writes

On 2016/10/03 12:02 PM, Silvio wrote: Thank you Noel. So I force all connections but one to close and execute the SHUTDOWN on the last connection. Any reason why I might better opt for SHUTDOWN IMMEDIATELY or does that make little difference. Shouldn't make any real difference. The

[h2] anybody using the "timestamp utc" datatype?

HI This was an experiment that I did not end up actually making use of. Since it was never documented, I'm inclined to just remove it, rather than leaving unused and undocumented features lying around cluttering up the codebase Regards, Noel -- You received this message because you are

Re: [h2] Re: What version to pick for production

On 28 September 2016 at 17:02, Vitali wrote: > P.S. Our optimizations concerned nested selects like WHERE FK_COLUMN > IN (SELECT... ) . Often when index exists for FK_COLUMN, parent table > contains 20 records and nested SELECT retrieves thousands of values >

Re: [h2] Re: Update from 1.4.191 to 1.4.192 leads to unit test failure

That is unfortunate. Luckily Philippe Marschall has already implemented that method properly, so if you build a jar from our repository, that should fix your bug. ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this

Re: [h2] Java 6 compatibility

Sorry about that, the documentation is out of date. We've need Java7 since version 1.4.192 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] Re: Triggers and session's scope identity

I suspect that our pluggable tables feature: http://h2database.com/html/features.html#pluggable_tables is going to be a better match for updateable views. Our current code heavily assumes that views are read-only.​ -- You received this message because you are subscribed to the Google Groups

Re: [h2] org.h2.api.TimestampWithTimeZone questions

On 20 September 2016 at 08:13, Philippe Marschall < philippe.marsch...@gmail.com> wrote: > Hi > > I'm looking at org.h2.api.TimestampWithTimeZone in the master branch > compared to the 1.4.192 release and have a few questions > >- Why return getYear(), getMonth() and getDay() longs instead of

Re: [h2] How does secondary indexing based on MVStore work?

https://github.com/h2database/h2database/blob/master/h2/src/main/org/h2/mvstore/db/MVSecondaryIndex.java Looks like we actually store it as a map of -> sentinel_value ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this

Re: [h2] Re: how are subqueries executed in an IN Select

Convert it to a join.​ Or pick a newer version, but stick with the PAGE_STORE engine, I'm pretty much we've made lots of plannerimprovements since 1.3.176 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop

Re: [h2] How does secondary indexing based on MVStore work?

Also see our documentation here: http://h2database.com/html/mvstore.html On 18 September 2016 at 00:56, Alan Darkworld wrote: > indexing, and I would be very interested in learning how that works on a > conceptual level. In particular, I am interested in the case of

Re: [h2] H2 behaviour for long identifiers different than in Oracle DB

Doesn't sound hard, how about supplying a patch/PR ? Start with the org.h2.engine.Mode class, adding a maxIdentifierLength field, which defaults to Integer.MAX_INT Then add a check somewhere in the org2.h2.command.Parser class Don't forget to add a unit test in the

Re: [h2] Tomcat7 memory leak

It's possible that mahout is not closing all of it's connections. Best way to debug it is to trigger a memory heap dump and then examine the heap dump in the Memory Analyzer tool in Eclipse. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] Re: org.h2.message.DbException: General error: "java.util.ConcurrentModificationException" [50000-187]

Try updating to the latest version​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email

Re: [h2] Quickly adding multiple columns at a certain position

Cheers, > > -hendrik > > On Friday, September 9, 2016 at 12:38:08 PM UTC+2, Noel Grandin wrote: >> >> I'd be ok with taking a patch that adds support for the multi-column >> syntax with an AFTER clause. >> > -- > You received this message because you are subscrib

Re: [h2] How to make a huge star-like join as fast as possible?

Yeah, given those sizes, we are almost certainly buffering to disk. You can try playing with the http://h2database.com/html/grammar.html#set_max_memory_rows setting, that might help. Also, explicitly giving the VM lots of RAM via the "-Xmx" setting might help. -- You received this message

Re: [h2] Re: Error 50200-192 if delete from table after upgrading from 1.3.176 to 1.4.192

Sorry, but I'm not going to find time to track this down. At a guess I would say it might have something to do with the Timestamp column -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails

Re: [h2] What is the maturity of "Timestamp with Timezone" support in v1.4.192

Sorry, but I only built the bare minimum of TZ support. If you need more functionality, you'll have to supply patches, I don't have time to work on it right now.​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and

Re: [h2] How to make a huge star-like join as fast as possible?

The output of EXPLAIN ANALYZE would actually be best I suspect we are creating temporary tables and there are some settings that can help with that ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop

Re: [h2] How to make a huge star-like join as fast as possible?

Sigh. What does the output of EXPLAIN PLAN for one of the queries look like? Also: What DB settings are you using in your URL? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it,

Re: [h2] Quickly adding multiple columns at a certain position

I'd be ok with taking a patch that adds support for the multi-column syntax with an AFTER clause. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] How to make a huge star-like join as fast as possible?

what does EXPLAIN PLAN say for one of the queries ?​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this

Re: [h2] Storing data of tables

Looks like that function is not implemented for the MVStore engine (search for the "getDiskSpaceUsed()" code in the codebase). Feel free to log a bug, or even better, supply a patch :-) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] Re: Alias for Existing functions

How about you contribute a patch that adds the extra optional parameter to the built-in function?​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] Error 50200-192 if delete from table after upgrading from 1.3.176 to 1.4.192

Sorry to say, but that looks like a corrupt DB Suggest you try the recovery process and rebuild the DB -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] how to insert a "TIMESTAMP WITH TIMEZONE" value?

Currently, all it supports is (a) ISO 8601 time in string format. https://en.wikipedia.org/wiki/ISO_8601#Time_zone_designators (b) using preparedstatement and org.h2.api.TimestampWithTimeZone -- You received this message because you are subscribed to the Google Groups "H2 Database" group.

Re: [h2] Shall I add H2 to Travis CI?

Note that there are a couple of OOM tests, so you need to make sure that the Java for the tests runs with limited heap, i.e. with the -Xmx parameter. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop

Re: [h2] Migrate H2 database to mariadb

Depends on how big your DB is. If it's small, the SCRIPT command would get you a nice export http://h2database.com/html/grammar.html#script And then some tweaking of that should then import nicely into MariaDB If it's bigger, you probably want to use the SCRIPT command to move the schema

Re: [h2] Trigger on system table not fired

I'd be happy to accept a patch that fixed the sessions table functionality to work with triggers. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] Trigger on system table not fired

Those are kind of virtual tables, so it's probable that the trigger logic is simply not implemented on them.​ you could try using the http://www.h2database.com/javadoc/org/h2/api/DatabaseEventListener.html functionality to achieve a similar thing -- You received this message because you

Re: [h2] Is h2 db 1.4.x range is still in beta stage?

That is correct. Some of us run 1.4 in production, but you do that at your own risk. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [h2] Updating security of H2 database encrypted file format from AES to ChaCha20

Patches are always welcome -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to

Re: [h2] Alternative for FORMAT keyword in h2

nope, sorry, we don't have that kind of functions in H2. You could probably write your own using CREATE ALIAS and some Java code http://h2database.com/html/grammar.html#create_alias -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] Shall I add H2 to Travis CI?

On 2016/08/15 10:01 AM, Sergi Vladykin wrote: Ok, I enabled it and it seems to work. I also added build status icon on README.md for convenience. Nice work people! -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this

Re: [h2] Database size is strangely big, actual data is not so much, dropping/adding rows/tables does not modify file size, Database size after cleaned is anyway very big even if no data is present an

If you want to downgrade, you will need to do a dump and restore​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To

Re: [h2] Potential performance improvement

which version are you testing against? Because in recent versions we already cache the Calendar object in DateTimeUtils.CACHED_CALENDAR, at which point the ZONE_OFFSET should be cheap to calculate. -- You received this message because you are subscribed to the Google Groups "H2 Database" group.

Re: [h2] DbException

thanks for the report, problem fixed in master. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group,

Re: [h2] Numeric value out of range error (22003) on DELETE with expression in WHERE clause

On 2016/08/04 11:49 AM, Vedran Pavić wrote: Can you elaborate a bit on this? Notice when the prepareStatement call is executed. That is when we compile the query plan. I'm sympathetic to your position that the engine should just "do the right thing", but I simply don't have time to make

<    1   2   3   4   5   6   7   8   9   10   >