Re: [h2] h2 support double quotes on table or not?

2013-11-25 Thread Noel Grandin
quoted names are case sensitive. http://h2database.com/html/grammar.html#quoted_name On 2013-11-22 19:22, ken cheng wrote: h2 support double quotes on table or not? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this gro

Re: [h2] H2 Server consume 1G memory to load a 250m file based database?

2013-11-25 Thread Noel Grandin
I have committed a patch which should reduce the memory cost of the Table View metadata objects. -- 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+unsu

Re: [h2] Re: Adding support for "GRANT ALTER ANY SCHEMA TO "

2013-11-25 Thread Noel Grandin
On 2013-11-19 23:10, John Yates wrote: > The attached patch addresses this part of the (discussed above) functionality. It does so by allowing all table > function rights to the grantee of ALTER ANY SCHEMA rights. Hi At this point I am confused. I didn't see the earlier discussion before this

[h2] Possible bug: IDENTITY ignored for added column

2013-11-25 Thread Thomas Kappler
Here's a snippet for testSimple.in.txt that shows the problem: create table test1 (foo varchar(100)); alter table test1 add id bigint identity(5, 5) not null; insert into test1 values (null, null); insert into test1 values (null, null); select count(*) from test1 where id=5; > 1; select count(*)

[h2] Perenity of H2

2013-11-25 Thread Marc Eyrignoux
Hi everybody, I would like to use H2 for a project at my work, but my boss is afraid of its perenity, with the usual questions like "who is using it ? is there a guarantee that someone will still maintain it in 10 years ? etc...". I couldn't find any hint about big famous companies that would u

Re: [h2] Questions about MVCC

2013-11-25 Thread Thomas Mueller
Hi, > Does MVCC even support different isolation modes? Up to some point, yes, see http://www.postgresql.org/docs/9.3/static/transaction-iso.html Regards, Thomas On Mon, Nov 25, 2013 at 3:56 AM, Ryan How wrote: > This is interesting :) > > Does MVCC even support different isolation modes?.

Re: [h2] H2 Server consume 1G memory to load a 250m file based database?

2013-11-25 Thread Min Huang
That's fast! Thanks. I will check it out. On Monday, November 25, 2013 4:22:39 AM UTC-5, Noel Grandin wrote: > I have committed a patch which should reduce the memory cost of the Table > View metadata objects. > > -- You received this message because you are subscribed to the Google Groups

Re: [h2] Re: Adding support for "GRANT ALTER ANY SCHEMA TO "

2013-11-25 Thread John Yates
The rights involved with the patch are only those associated with standard tables. The user granted this right will be unable to (for example) create or manage users (for example, would not be able to run ALTER USER ADMIN TRUE). It is a powerful right. But not an all powerful right. -- Yo

Re: [h2] Questions about MVCC

2013-11-25 Thread Gili
Thomas, I just want to make sure that you don't lose track of this question (since you replied to a follow-up discussion): what is the difference between SERIALIZABLE isolation when MVCC is on or off? Thanks, Gili On Sunday, November 24, 2013 10:50:18 AM UTC-5, Gili wrote: > > Hi Thomas, > >

[h2] Upgrade mechanism on a running instance

2013-11-25 Thread Goel
Can someone please point me to the right documentation / code about how H2 deals with upgrades? For example, an H2 instance is running, and the binary needs to be updated. In that case, does the new instance that comes up need to read data from disk to recover its state, or is there some other

[h2] Status of MVStore?

2013-11-25 Thread Steve Ash
What is the current status of MVStore? Is it stable enough to try and use it for some low-risk work? I searched the group for status updates on it and I haven't seen any updates for many months. What major features are missing? Thanks, Steve -- You received this message because you are sub

[h2] JDBC lint

2013-11-25 Thread gaul
JDBC lint helps Java programmers write correct and efficient code when using the JDBC API. This includes resource management, e.g., missing Connection.close, incorrect use of JDBC, e.g., Statement.addBatch without Statement.executeBatch, and potential optimizations, e.g., unread ResultSet colu

Re: [h2] Status of MVStore?

2013-11-25 Thread Thomas Mueller
Hi, > I haven't seen any updates for many months. Well, you should check the source code history :-) There were quite many changes. The MVStore in the trunk is relatively stable; I expect few changes in the API. Missing or incomplete: I think it's relatively feature complete for simple use case