[h2] Re: Problem with dropping and recreating index

2013-06-09 Thread Thomas Mueller
Hi, Of course the index should not get corrupt in the first place. If you have a simple, reproducible test case that reproduces the corrupt index (starting with a fresh database) with the latest version of H2, could you please post it? Regards, Thomas On Wed, May 22, 2013 at 5:30 PM, Sanjeev

[h2] Re: Get methods on limitExpr, offsetExpr, distinct in org.h2.command.dml.Query (and more)

2013-06-09 Thread Thomas Mueller
Hi, Right now I'm against applying the patch. I would like to keep the internals of the database internal. It seems to me creating a public API for the AST would open a big can of worms, for example it would mean we need to maintain backward compatibility, we would need documentation, we would be

[h2] Re: Java-level deadlock in 1.3.171

2013-06-09 Thread Thomas Mueller
Hi, I believe this is fixed with the latest version of H2. Regards, Thomas On Sat, May 4, 2013 at 7:04 AM, Ainimyoung aiminyo...@gmail.com wrote: Hi, I'm working on a project with H2 1.3.171 in server mode. Everything was fine while data growing daily until H2 hung due to a Java-level

[h2] Discoverability of CHECK constraints in INFORMATION_SCHEMA

2013-06-09 Thread Lukas Eder
Hello, Here's a simple script creating a table with two CHECK constraints: *create table* x ( a int *check *(a 0), b int, *constraint *x_c *check *(a b) ); The first check constraint is scoped to a single column, whereas the second one is scoped to the whole table. When trying to

[h2] Display varbinary as TEXT in h2 console

2013-06-09 Thread Pierre
Hello, How to display varbinary field in text format in the h2 console ? It displays the varbinary field with hex representation, so I tryied cast(field as varchar) and convert(field,varchar) but it keep displaying varbinary in hex format. How to display it like it was a String ? Thx --

Re: [h2] Display varbinary as TEXT in h2 console

2013-06-09 Thread Thomas Mueller
Hi, The function UTF8TOSTRING should help: http://h2database.com/html/functions.html#utf8tostring Regards, Thomas On Sun, Jun 9, 2013 at 5:09 PM, Pierre pierz.h...@gmail.com wrote: Hello, How to display varbinary field in text format in the h2 console ? It displays the varbinary field

[h2] About TRACE_LEVEL_SYSTEM_OUT

2013-06-09 Thread Augusto Caligares
Hi, I am a bit confused Why there are two traces? (TRACE_LEVEL_FILE and TRACE_LEVEL_SYSTEM_OUT) the TRACE_LEVEL_FILE is printed in trace file right? and the TRACE_LEVEL_SYSTEM_OUT is printed in console or where? Thanks -- You received this message because you are subscribed to the Google