Re: [h2] Re: DB growing just by reading LOBs

On 2017/12/07 9:42 AM, Silvio wrote: Why not transfer all LOBs to the client at once during transaction closing when it does such a nonsensical thing as reading them after closing the transaction they where acquired in? Backwards compatibility is important to us, and the H2 code has

Re: [h2] Usage of 'classpath:/filename.csv' - SQLSyntax and IOExceptions

Sorry, CSVREAD does not support URL's or anything smarter than a normal file path.​ -- 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: DB growing just by reading LOBs

On 6 December 2017 at 21:13, wburzyns wrote: > Noel, can you elaborate a bit why reading LOBs results in writes to the > database? Is it because the LOB content is copied somewhere in the DB so > that the client does not need to keep transaction open to access LOB > content?

Re: [h2] Re: DB growing just by reading LOBs

please log this in our issue tracker along with your test case, because it's not something I can fix in the near future. My preliminary analyis is that there is no leak in our LOB management (unlike the first bug you reported). We just don't seem to be doing a very good job of compacting here,

Re: [h2] NoClassDefFoundError when trying to define a java UDF

yup , that could work too​ -- 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] NoClassDefFoundError when trying to define a java UDF

ah, yes, this does indeed look like a lombok problem, not a javac problem. You'll need to ask them why they are hooked into the javac compiler like 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] 1.4.196: Discrepancy between ANALYZE documentation and implementation

On 2017/12/05 10:06 AM, t603 wrote: analyze table t1 sample_size 0 thanks for reporting this, it has already been 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

Re: [h2] NoClassDefFoundError when trying to define a java UDF

that is very weird. you seem to be missing part of the javac compiler in your installation.​ -- 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] Slow query execution (bug suspected)

We don't currently implement that kind of optimisation.​ Would require either some kind of disjoint cursor over the index or splitting the query (i.e. emulating the UNION ALL) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from

Re: [h2] Re: DB growing despite transaction rollback

thanks for the excellent test case, I have pushed a fix for this. -- 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] DB growing despite transaction rollback

On 2017/11/28 11:29 AM, Noel Grandin wrote: This doesn't seem to happen with current master. Ooops, no, my mistake, looked at the wrong file, this is still happening with current master. Yeah, this is pretty much expected behaviour. MVStore, due to being a MVCC engine, is much less

Re: [h2] DB growing despite transaction rollback

What version are you testing against? This doesn't seem to happen with current master. Also MAX_LOG_SIZE is not support with the MVStore engine, only the older PageStore engine. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe

Re: [h2] 1.4.196: alter schema rename to end with the error General error: "java.lang.RuntimeException

Looks like one of the DB schema objects (DATA_D06 ???) has a comment associated with it, that has not been correctly moved. Not sure why that is, would need some kind of standalone test case. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] problems migrating from 1.4.177 to 1.4.195

MASTER / HEAD / trunk / tip of development / current github source code -- 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] problems migrating from 1.4.177 to 1.4.195

this seems to be working on current MASTER, not sure where we fixed 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.

Re: [h2] Re: Subquery for altering a system generated sequence

In general, no, our DDL commands do not support such late binding of parameters -- 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] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

On 18 November 2017 at 17:12, Stuart McMillan wrote: > Noel, > > Yes - certainly the session locking (system or connection session) is one > issue I have been wrestling with - especially when the CTE persistent views > have to join the parent views lifecycle - I did a

Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

Stuart, I have just pushed some meta-locking debug infrastructure. If you add the -Dh2.check2=true command line option when running H2, it will be turned on. The TestAll code also turns it on. The extra code fails nice and early when a single thread attempts to lock the meta info using

Re: [h2] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

On 2017/11/16 3:29 PM, Stuart McMillan wrote: All except create view as are currently working on master branch. Create view as is taking much much longer than i thought, as cte are hard to persist between connections in current architectured form. Got any ideas for fixing that? Maybe we

Re: [h2] LOCK_MODE=0 and read-only database

if you're not doing any updates then LOCK_MODE=0 won't make much difference, ​ -- 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] RFE: Enable Common Table Expression (CTE with...) in INSERT, UPDATE, DELETE, CREATE TABLE AS, CREATE VIEW AS

@stumc was working on such things, but he seems to have taken a break ?​ -- 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: embedded vs in-memory performance

given the small size, both cases will be executing with all of the data in-memory, so wouldn't expect much difference​ -- 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] Accessing DB file within a JAR Fails when the JAR is incorporated in parent JAR

http://h2database.com/html/features.html#database_in_zip ​ -- 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

Re: [h2] error 24001 when connencting to h2 local db file.

somehow you created a column with a name of CONSTRAINT which is reserved keyword. normally names like that must be quoted, which means either H2 failed to check the name when you created the table, or it stored the name incorrectly. ​ -- You received this message because you are subscribed to

Re: [h2] appears to have started a thread named [H2 File Lock Watchdog (Socket) HELP

You need to shut h2 down properly and then that thread will also go away. On Fri, 03 Nov 2017 at 22:59, RM wrote: > This happens when I undeploy my app from Tomcat. To get control back I > have to shutdown TOMCAT. > > > but has failed to stop it. This is very likely to

Re: [h2] possible incorrect index reuse in alter table

On 31 October 2017 at 16:12, Petr Kureš wrote: > Hi Noel, that's great :) I will try to provide a patch ASAP. What's the > preferred way of submitting a patch ? Creating an issue on github and > attaching the patch ? > submit a PR on github. > Also, where should I put the

Re: [h2] possible incorrect index reuse in alter table

Hi Your analysis looks accurate, please feel free to submit a patch (prefereably with a test case) Thanks, Noel -- 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] mvstore api - index?

the MVStore is like a Map, so the index is whatever key you use.​ -- 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] Implementing Hash Join Algorithm in H2 Database

http://h2database.com/html/architecture.html On 26 October 2017 at 18:37, Jon Catanio wrote: > If I were to implement a hash join algorithm for the H2 database for a > university course where would I start? Is there any source code > documentation? The closest I got to

Re: [h2] In memory snapshots with MVStore

FilePathMem and related classes.​ -- 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] H2 doesn't use index when I use IN and EQUAL in one query

I have pushed a fix for this. -- 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 kill the watchdog without the shutdown hook?

use a debugger and have a look at the data structures in the Database class. Or do a heap dump and use the Eclipse MAT tool to look for the Connection objects. You could also try (from your test) connecting to H2 and executing the SHUTDOWN command ​ -- You received this message because you are

Re: [h2] In memory snapshots with MVStore

On 25 October 2017 at 22:07, Max Englander wrote: > I finally got around to working on this, and ended up using the steps > outline here > , which > worked great for my purposes. > > Using "SET EXCLUSIVE 2"

Re: [h2] Is there A way to kill the watchdog without the shutdown hook?

I think you might be overthinking this. Instead of doing "new DbServer" just let H2 start itself up and shut itself down. Which it will do automatically when you try and connect to it, and when the last connection disconnects. ​ -- You received this message because you are subscribed to the

Re: [h2] Add a custom datatype to h2 database.

This is the easier approach http://h2database.com/html/grammar.html#create_domain CustomDataTypeHandler is more sophisticated. Have a look at the unit test for it, to see how it works. On 25 October 2017 at 14:09, Thomas Binu wrote: > I am new to the h2 database. I

Re: [h2] H2 doesn't use index when I use IN and EQUAL in one query

On 2017/10/19 11:15 AM, Дмитрий Лукьяненко wrote: I agree that X=? condition will produce less rows than X IN(..). But I doesn't agree that X=? will produce less rows than Y IN (..). This condition excludes IN values from Row. Hmmm, We have the USE INDEX thing which forces use of an index,

Re: [h2] MVStore Pluggable Serialization

http://h2database.com/html/mvstore.html#dataTypes -- 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] H2 tcpserver to be shutdown and restarted if the port is already in use.

try and open the socket, if it succeeds, then imeddiately close the socket, and shutdown the server -- 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] Recover not working for split database

On 2017/10/16 5:14 PM, John Patrick wrote: My question is can Recover work with split files? I don't think so. -- 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] H2 trying to access "/private/var/empty/test.trace.db",

probably because you changed your current folder to /private/var/empty and then tried to open a H2 database in the current folder. -- 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

Re: [h2] JVM CPU and memory consumption by H2 server

you'd have to do a deeper investigation to see what exactly is happening and where the memory is going to. You could try using the older engin (MV_STORE=false) which might have less background activity because it doesn't need background compaction. -- You received this message because you

Re: [h2] SELECT NOW() returns same timestamp if transaction is rolled back

thanks for the excellent bug report, a 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

Re: [h2] NPE in simple Common Table Expression

Can you try a master build, we have fixed various WITH problems recently (thanks to people like @stumc)​ -- 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] ENUM data type is not nullable?

that sounds like a bug​, I think we might have fixed that one already, perhaps try current 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

Re: [h2] Performance improvement advice

you might want to create the table first and do a INSERT INTO ... SELECT FROM CSVREAD​ -- 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] Row_number behaviour change beteeen versions 1.4.194 and 1.4.195

thanks for reporting, 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 to this

Re: [h2] Query on embedded database a lot slower than on sqlite, database file three times as big

hard to tell, but I'd guess that our planner is picking a slow plan than sqlite (which is generally a pretty good db) In this case, it would probably be faster to scan across the main table rather than use a secondary index and then have to access the main table in a random hop. Particularly

Re: [h2] Re: H2 Database table size

http://h2database.com/html/functions.html#disk_space_use ​ -- 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

Re: [h2] build of jarClient results in 1620 KB (complains and warns, but still builds)

hmm, that means that at some point some change got merged that pulls in more class files into the client jar. Any chance you could bisect that? ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving

Re: [h2] Java 1.6 compatibility has broken between 2016 and 2017, I tried fixing it, but result is very messy

​I'm sorry, but we made a decision with 1.4.192 to drop Java6 compatibility, we now require Java7 to compile. -- 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: ALTER TABLE "table-name" MODIFY "columne" NOT NULL; fail with Unknown data type: "NOT";

This is our official syntax for such things: http://h2database.com/html/grammar.html#alter_table_alter_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 from it, send an email to

Re: [h2] Re: Question about "check before insert"

h2 does do triggers: http://h2database.com/html/features.html#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] Re: (corrected): has it gone multi-threaded when MULTI_THREADED=1 but MULTI_THREADED=false?

very good analysis. The constructor should either perform the same check, or call setMultiThreaded() so that the checks are applied. On 29 August 2017 at 17:40, wrote: > Found it. :) > > In DbSettings.java, there is a hash map entry MULTI_THREADED which also > gets printed in

Re: [h2] Pull Request 592. Small server mode protocol fixes

On 27 August 2017 at 17:45, Piotr Dubrovskiy wrote: > Btw, I'm a bit concerned by failed CI build > . > I have seen the log and it's seems like test fails isn't

Re: [h2] Re: Issues joining the cluster IO Exception: "java.io.FileNotFoundException: backup.sql (The system cannot find the file specified)"; "backup.sql" [90031-191]

something like this: http://h2database.com/html/build.html#providing_patches sent to the mailing list, acts as our informal process for verifying contributions :-) thanks ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from

Re: [h2] Re: Issues joining the cluster IO Exception: "java.io.FileNotFoundException: backup.sql (The system cannot find the file specified)"; "backup.sql" [90031-191]

sounds OK to me but I never use the cluster stuff. please submit a PR for this (and a license email if you haven't already sent one) thanks ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving

Re: [h2] Nested CALL

glad to here you sorted it out - feel free to submit a pull request, the relevant file is src/docsrc/help/help.csv :-) ​ -- 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] Nested CALL

something like this: insert into EmailSubscription ( Email, IsSubscribed, DateSubscribed, SubCode ) values ( "t...@test.com", true, current_timestamp(), rawtohex(hash('SHA256', concat("t...@test.com", current_timestamp()), 1)) ); On 19 August 2017 at 07:15,

Re: [h2] Re: Problem migrating from 1.3.176 to 1.4.195

when you use 1.4 it by default uses a new engine which creates a file with a different extension. so when you upgraded you were actually connecting to a completely empty database. ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe

Re: [h2] DB computed columns - reference to table field

sorry, you'll have to use a trigger for that.​ -- 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] NPE In delete query

maybe try turning on the trace options and see what shows up in the server-side trace log http://h2database.com/html/features.html?highlight=trace=trace#trace_options ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this

Re: [h2] NPE In delete query

So if I am reading that right, the actual exception source is inside the JDBI library that you are using? Caused by: java.lang.NullPointerException: null at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1338) ​ -- You received this message because you are subscribed to the

Re: [h2] NPE In delete query

Sorry, I have no idea what is going on there. The stack trace is incomplete for some weird reason, so I don't even know where the NullPointerException is actually coming from.​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from

Re: [h2] NPE In delete query

what does the full stack trace look like, that one seems to be missing some bits​ -- 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] NPE In delete query

you're using two different versions of H2 there, try using the same version on both sides -- 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] Cache hits

no​ -- 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 h2-database@googlegroups.com.

Re: [h2] Very slow "SELECT TOP 10 * FROM foo ORDER BY id DESC", full table scan?

we don't currently do ORDER BY .. DESC where the index is ASC. i.e. we don't know how to iterate backwards through an index. ​ You'd have to define a secondary index with your preferred ordering -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] DATE / TIME types are not consistent across timezones / DST!

How the data is presented is up to you, we just make sure the same data is stored and retrieved. -- 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] H2 query taking a long time on "SELECT * FROM test" , and ResultSet not streaming from table as sqlite does

@sergi, any change you could work up some documenation for your nice new feature? maybe in advanced.html and the help.csv lang reference? ​ -- 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] H2 query taking a long time on "SELECT * FROM test" , and ResultSet not streaming from table as sqlite does

we don't support "row streaming" unless you use the rather new LAZY_QUERY_EXECUTION feature (add ";LAZY_QUERY_EXECUTION=1") to your URL. In general, trying to retrieve 10 million rows in one result set is not good idea. ​ -- You received this message because you are subscribed to the Google

Re: [h2] DATE / TIME types are not consistent across timezones / DST!

our DATE/TIME fields very specifically do not change across time zones. But if other layers are converting backwards and forwards through types like Timestamp, it is quite possible that they may influence the results. ​ -- You received this message because you are subscribed to the Google

Re: [h2] Multiple Custom Data Types

CustomDataTypeHandler already supports more then one new datatype.​ -- 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] H2 very slow compared to others?

what does your H2 URL look like?​ Are you using the H2 JDBC driver? If your app is heavily multi-threaded, you could try MULTI_THREADED=true, which is almost production-ready -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from

Re: [h2] copy data from one h2 db to another h2 db

http://h2database.com/html/advanced.html#linked_tables ​ -- 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

Re: [h2] Re: H2 v. 1.3.176 file.db does not stop growing

pretty much the same thing as MAX_MEMORY_ROWS, just for a slightly different class of query, which is why we removed MAX_MEMORY_ROWS_DISTINCT quite a while go so we only have the one setting to worry about :-)​ -- You received this message because you are subscribed to the Google Groups "H2

Re: [h2] H2 v. 1.3.176 file.db does not stop growing

check that something in your code has not started accidentally holding a transaction open.​ -- 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] H2 v. 1.3.176 file.db does not stop growing

probably your queries are sufficiently large that they are generating temporary tables. it is possible that the temporary tables are then leaking, we have had bugs like that in the past. you could try changing your queries, or playing with the MAX_MEMORY_ROWS setting, if you have a lot of free

Re: [h2] Can I prevent is null checks for columns after alter table

ALTER TABLE ADD COLUMN XXX INT NOT NULL DEFAULT 0 -- 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] Index usage/performance with in-statements

try using EXPLAIN PLAN to see what the optimizer is doing -- 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

Re: [h2] Has CHECK become a keyword in H2 v1.4?

Hmmm, that is a pity. CHECK has always been a keyword, e.g. http://h2database.com/html/grammar.html#alter_table_add_constraint but we only recently became more pedantic about it to avoid ambiguity in the CREATE TABLE syntax. Your best bet is to escape all such usages using quotes. -- You

Re: [h2] Index usage/performance with in-statements

looks like this issue https://github.com/h2database/h2database/issues/529 -- 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] CTE name resolution wrong (or at least non-standard)

On 2017/06/30 1:05 PM, Thomas Kellerer wrote: But to be consistent you would need to throw an exception for derived tables as well, as they have the same visibility. good point -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe

Re: [h2] CTE name resolution wrong (or at least non-standard)

I'm inclined to take the simple approach and throw an exception if a CTE alias is declared with the same name as an existing table or view. -- 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] Analyze Table Unexpected Error

there was a bug in the parsing code. I've just pushed a fix​ -- 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

Re: [h2] what's the difference of MVStore's default file storage and OffHeapStore

OffHeapStore uses memory, but not the Java heap, the heap that exists outside of Java,but in the same process. It trades off GC pressure for a little performance. ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group

Re: [h2] Support for CHAR(N) PostgreSQL semantics in MODE=PostgreSQL

looks good, can i get a license statement please, as mentioned here: http://h2database.com/html/build.html#providing_patches ​ -- 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] Support for CHAR(N) PostgreSQL semantics in MODE=PostgreSQL

Nice progress! Since this is only for testing, I would prefer you do the simpler thing, and add the spaces at insert time.​ I really don't want to complicate our codebase and impair performance for a testing-only feature, where performance is largely not an issue. -- You received this message

Re: [h2] Hibernate fails to process auto_increment primary key when using mode=mysql

On 16 June 2017 at 01:23, Gerry Matte wrote: > Hibernate: > /* insert ca.gerrymatte.finance.model.Tags > */ insert > into > tags > (created, createdBy, disabled, invisible, tagDescription, > tagName, toBeDeleted, updated,

Re: [h2] Support for CHAR(N) PostgreSQL semantics in MODE=PostgreSQL

sounds you're most of the way to a patch On 16 June 2017 at 22:29, kburjack via H2 Database < h2-database@googlegroups.com> wrote: > Thanks for the info. > I dug into H2's source code and it seems that H2 actually has no notion of > a "maximum" string length for fixed-length CHAR(N) types. I

Re: [h2] Support for CHAR(N) PostgreSQL semantics in MODE=PostgreSQL

possibly. I seem to remember someone trying (not very hard) to work up a patch to do that, but they didn't seem keen enough to do it right, so the patch got rejected.​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this

Re: [h2] JUnit testing fails, "Attempt to define a second primary key"

serial columns are automatically treated as PK in normal H2 mode. You'll have to specify postgresql mode to H2 if you want it otherwise​ -- 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] Re: Composite types (UDT)

I can't see us ever supporting something like that. At the moment, the closest thing we have is this: http://h2database.com/html/datatypes.html#other_type ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop

Re: [h2] In memory snapshots with MVStore

I suspect you might have more luck by creating a custom FilePath that wraps the existing FilePathMem (i.e. the jdbc h2:mem: functionality) which you can use to copy/restore the db. You'd still need to open/close H2, but you could avoid the seed data step. With some real cleverness, you could

Re: [h2] org.h2.jdbc.JdbcSQLException: Numeric value out of range: "-9223372036854775808"

it should be calculating the higher/wider of the types and then converting each arg to that. Looks like to Function#optimize is not being called for some reason​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and

Re: [h2] h2 Database - Alter ADD Column

Have a look at the options at the bottom of this document: http://h2database.com/html/performance.html ​ Note that you should only use them while doing your ALTER TABLE and nothing else should be touching your DB when you do it, and you should have backups in case anything goes wrong -- You

Re: [h2] valueExpression and column names

Not at the moment, currently tracked as this bug: https://github.com/h2database/h2database/issues/409 On 15 June 2017 at 18:28, Pieter Martin wrote: > Hi, > > I am trying to execute the following query. > It works on Postgresql and Hsqldb but now is breaking on my

Re: [h2] Re: Bug in H2 (1.4.195 and 1.3.176) concerning column names CHECK or CONSTRAINT

On 2017/06/12 3:26 PM, Silvio wrote: But the problem is still there for existing tables containing a table with a column named "CHECK" created with earlier versions of H2. yeah, sorry, not much we can do about that -- You received this message because you are subscribed to the Google Groups

Re: [h2] How to auto update current time stamp ?

http://h2database.com/html/features.html#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 h2-database+unsubscr...@googlegroups.com. To post to this

Re: [h2] Cannot connect to DB with error "org.h2.message.DbException.getJdbcSQLException(DbException.java:345)"

looks like you a corrupt 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to

Re: [h2] Requesting contributor access to push, create pull request and create/edit issues for CTE fixes

this might help: ​https://help.github.com/articles/creating-a-pull-request/ glad to here you are going to be helping! -- 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

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