Done: https://github.com/h2database/h2database/issues/312
Thanks,
Gili
On Thursday, June 30, 2016 at 9:06:46 AM UTC-4, Noel Grandin wrote:
>
> Probably because no-one wanted it till now.
> Feel free to submit a PR, or log a bug.
>
--
You received this message because you ar
of code portability (e.g. using MySQL code in production, H2 in unit tests).
Thanks,
Gili
--
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-databas
)?
Do you plan to release an official update in the upcoming week?
Gili
On Thursday, November 13, 2014 1:42:43 AM UTC-5, Noel Grandin wrote:
Hi
Sorry, this turned out to be a bug I recently introduced with some code
that prevents connection starvation.
Should be fixed now in SVN
, but I can
reproduce this issue 100% so if you tell me how to look up the locks I can
debug this further on my end.
Thanks,
Gili
On Thursday, October 14, 2010 5:34:22 AM UTC-4, IntensiveH2 wrote:
In some case (not systematically reproducible and I don't understand
why), I have an exception
FYI: This is marked as fixed in version 1.4.182 Beta:
http://www.h2database.com/html/changelog.html
Gili
On Tuesday, September 2, 2014 1:17:40 AM UTC-4, Gili wrote:
Hi Thomas,
Will this be fixed in 1.3 in the near future? I am avoiding the beta
builds because I am under the impression
stack-trace but QueryException.printStackTrace() does
not (you get the truncated stack-trace seen above).
It's not (yet) clear whether QueryException or JdbcBatchUpdateException's
implementation is at fault.
Gili
On Tuesday, October 14, 2014 12:42:43 AM UTC-4, Gili wrote:
Hi Noel,
Does
()).
Is it possible to further improve the implementation so it prints
getNextException() if printStackTrace() is invoked on a wrapper exception
(where getCause() returns the JdbcBatchUpdateException)?
Thanks,
Gili
On Tuesday, October 14, 2014 2:55:47 AM UTC-4, Gili wrote:
Sorry for the false
)
at
com.mysema.query.sql.dml.AbstractSQLClause.executeBatch(AbstractSQLClause.java:161)
at
com.mysema.query.sql.dml.AbstractSQLClause.executeBatch(AbstractSQLClause.java:171)
at
com.mysema.query.sql.dml.SQLUpdateClause.execute(SQLUpdateClause.java:190)
Does this indicate a bug in H2 or in my own code?
Thank you,
Gili
--
You received this message
known this was a limitation I would have used the
workaround. Instead, I spent 2 days trying to figure out what was wrong
with the query logic (when in fact there was nothing wrong).
Thank you,
Gili
On Thursday, June 5, 2014 1:13:07 PM UTC-4, Lukas Eder wrote:
Hmm, wouldn't it be better
Out of desperation if nothing else...
I am attempting to implement an adjacency list and (as far as I know) there
is no efficient way to implement it without recursive CTE. Firing a
separate query per node is very problematic in my case because this is a
frequently-run query.
Gili
On Monday
readable, stable, and runs
just as fast.
Gili
On Monday, October 6, 2014 3:39:13 AM UTC-4, Gili wrote:
Out of desperation if nothing else...
I am attempting to implement an adjacency list and (as far as I know)
there is no efficient way to implement it without recursive CTE. Firing
understand why.
The user function has this prototype:
public static void log(short permissionId, String action, long
dependentId)
What is the correct way to pass a long into a user function without it
getting confused for a byte[]?
Thanks,
Gili
--
You received this message because you
I filed a bug report
at https://code.google.com/p/h2database/issues/detail?id=585
Gili
On Friday, September 5, 2014 1:39:06 AM UTC-4, Gili wrote:
Noel, I think you were wrong about this only working for sequences.
I ran into http://stackoverflow.com/a/12319823/14731 which states that
SET
and walk you
through what lines to look at.
Gili
On Tuesday, September 16, 2014 2:12:02 AM UTC-4, Thomas Mueller wrote:
Hi,
I'm not aware of any bugs in this area. It would be great if you could
provide a reproducible test case!
Regards,
Thomas
On Sunday, September 14, 2014, Gili cow
I understand. I'll keep my eyes open for future updates.
Thanks,
Gili
On Tuesday, September 16, 2014 2:15:52 AM UTC-4, Thomas Mueller wrote:
Hi,
I'm afraid the only thing I can do currently is to improve the
documentation. H2 does not currently support using different transaction
I'll try to put something together later on this week. It's possible I had
a configuration problem because one part of my project was referencing 1.4
while another part was referencing version 1.3. I've since fixed this
problem and rebuilt. We'll see if I run into this exception again.
Gili
is intermittent so I've been unable to create a testcase for it.
Thanks,
Gili
--
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
as you are working on MVCC, is this something you could fix in the
near future?
Thanks,
Gili
--
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
to do
with the use of negative numbers with AUTO_INCREMENT or the use of primary
keys that are smaller than BIGINT.
Gili
On Saturday, September 13, 2014 4:53:16 PM UTC-4, Gili wrote:
Hi,
I'm running into constraint violations that I believe should be impossible
using H2 1.4.181. My table
Is 1.4 with MV_STORE=false as stable as 1.3 builds? Or is there anything
more unstable about this build when MV_STORE is disabled?
Thanks,
Gili
On Friday, September 12, 2014 11:21:30 AM UTC-4, Noel Grandin wrote:
You could use 1.4 with MV_STORE=false, then you'd get the 1.3 storage
engine
)
at
com.jolbox.bonecp.PreparedStatementHandle.executeUpdate(PreparedStatementHandle.java:205)
at
com.mysema.query.sql.dml.SQLDeleteClause.execute(SQLDeleteClause.java:159)
... 9 common frames omitted
Gili
On Friday, September 12, 2014 3:49:43 AM UTC-4, Noel Grandin wrote:
This has been fixed in a newer version
: H2 should indicate the operation failed due to a
deadlock, as opposed to complaining about a trigger rolling back the
transaction.
Is this a bug? If not, what am I supposed to do?
Thanks,
Gili
--
You received this message because you are subscribed to the Google Groups H2
Database group
.
Gili
On Thursday, September 11, 2014 10:39:08 PM UTC-4, Gili wrote:
Hi,
I am getting Commit or rollback is not allowed within a trigger under H2
1.3.176 but I am not actually rolling anything back. As far as I understand
the following sequence of events occurs:
1. Java code invokes: delete
Excellent. Thanks ;)
Gili
On Friday, September 5, 2014 1:58:54 AM UTC-4, Noel Grandin wrote:
CREATE ALIAS PRINTLN FOR java.lang.System.println;
CALL PRINTLN()
On Fri, Sep 5, 2014 at 3:37 AM, Gili cow...@bbs.darktech.org
javascript: wrote:
Hi,
Is there a built
point... we need to create user functions to do the logging
ourselves.
Gili
On Friday, September 5, 2014 1:58:54 AM UTC-4, Noel Grandin wrote:
CREATE ALIAS PRINTLN FOR java.lang.System.println;
CALL PRINTLN()
On Fri, Sep 5, 2014 at 3:37 AM, Gili cow...@bbs.darktech.org
Hi,
Is there a built-in println function of sorts?
For example, I'd like to able to print out the values of @variables at
different points of an SQL script, or print out the values returned by an
SQL statement (again from within an SQL script).
Thanks,
Gili
--
You received this message
marking the offending column or value with a star, as you
have done for other errors.
Gili
--
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
Hi Thomas,
Can you please document this syntax? The documentation should mention that
SELECT SET(@variable, column_name) is now supported.
Thanks,
Gili
On Friday, April 18, 2008 4:16:55 PM UTC-4, skyfox01_99 wrote:
Hi Thomas,
Thanks for the response.
I will add this to the roadmap
IDENTITY() to return the wrong value.
All the forums recommend using SCOPE_IDENTITY() for this purpose, but it
doesn't work for H2.
Is there a workaround I can use in the meantime?
Thanks,
Gili
On Thursday, July 3, 2014 10:56:35 AM UTC-4, Noel Grandin wrote:
I don't know since it predates
To be clear, I believe my definition of SCOPE_IDENTITY() is a function that
returns the same value as
http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#getGeneratedKeys()
Gili
On Friday, September 5, 2014 12:52:15 AM UTC-4, Gili wrote:
On second thought I think this issue
not reset
SCOPE_IDENTITY()?
Gili
On Friday, September 5, 2014 12:52:15 AM UTC-4, Gili wrote:
On second thought I think this issue should be reopened.
1. The microsoft documentation doesn't say this function is limited to
sequences. I think it should work on all tables.
2. I need a way
Hi Thomas,
Will this be fixed in 1.3 in the near future? I am avoiding the beta builds
because I am under the impression they are less stable than 1.3.
Thanks,
Gili
On Saturday, August 30, 2014 7:57:14 AM UTC-4, Thomas Mueller wrote:
Hi,
I know what the problem is. readLong will first try
) and definitely very weak in comparison to
Postgresql and MySQL.
I understand you are currently focused on improving MVCC support, but is it
possible for you to focus on this thereafter?
To the community: is anyone else interested in this feature?
Gili
--
You received this message because you
Noel,
Both the H2 documentation and java.lang.Long.MIN_VALUE indicate that
-9223372036854775808 is a legal value, yet H2 rejects it. Isn't this a bug?
Gili
On Saturday, August 30, 2014 1:36:15 AM UTC-4, Noel Grandin wrote:
Our internal implementation of sequences uses longs for everything
be added?
Gili
--
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
types at their minimum values.
BIGINT seems to be the only type that has a problem with this.
Gili
--
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
be supported? I assume
you're not talking about removing foreign keys? :)
Thanks,
Gili
--
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
in the second statement. Any ideas why this is not
happening?
I am using H2 1.3.176.
Thanks,
Gili
--
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
http://www.percona.com/live/mysql-conference-2013/sessions/cap-theorem-two-out-three-aint-right
The article is a year old, but I think you will find it interesting.
Gili
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To unsubscribe from
SYSTEM_SEQUENCE_92282573_A9B5_4684_8F33_3D00A93F02E7 because of invalid
attributes (start value 0, min value 1, max value
9223372036854775807, increment 1); SQL statement:
CREATE TABLE table_type (id TINYINT NOT NULL AUTO_INCREMENT(0), name
VARCHAR(30) NOT NULL) [90009-175]
Why is a value of 0 disallowed?
Thanks,
Gili
--
You received
I'm guessing this was done for the sake of MySQL
compatibility: http://stackoverflow.com/a/1142588
Shouldn't this behavior only be on in MySQL compatibility mode?
Gili
On Wednesday, February 5, 2014 5:14:09 PM UTC-5, Gili wrote:
Hi,
I have the following table definition:
CREATE TABLE
,
Gili
On Wednesday, February 5, 2014 5:20:07 PM UTC-5, Gili wrote:
I'm guessing this was done for the sake of MySQL compatibility:
http://stackoverflow.com/a/1142588
Shouldn't this behavior only be on in MySQL compatibility mode?
Gili
On Wednesday, February 5, 2014 5:14:09 PM UTC-5, 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
?
Thanks,
Gili
--
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
Done: https://code.google.com/p/h2database/issues/detail?id=511
Gili
On Thursday, October 3, 2013 2:43:17 AM UTC-4, Noel Grandin wrote:
Feel free to log it in the issue tracker here:
https://code.google.com/p/h2database/issues/list
On 2013-10-03 04:42, Gili wrote:
Ping.
Can we
Ping.
Can we at least open an issue to track this? I don't want this to fall
through the cracks.
Gili
On Tuesday, July 30, 2013 8:11:33 PM UTC-4, Gili wrote:
Hi Thomas,
Good thing you asked for the updated test, because I now see a huge
performance difference:
Multiple
primary
key. I ended up implementing this using two separate statements (insert
followed by select) but I was wondering if there was a better way.
Thanks,
Gili
On Sunday, September 22, 2013 8:09:45 AM UTC-4, Thomas Mueller wrote:
Hi,
How can we insert a new row unless one already exists
I'm also curious about this:
How can we insert a new row unless one already exists, and in either case
return the primary key of the inserted/matched row?
Thanks,
Gili
On Thursday, October 25, 2012 4:31:19 PM UTC-4, Brent Ellwein wrote:
OK, so how would the return case look? I assume
for
MVCC? If not, do you plan on doing so in the future?
Thank you,
Gili
On Sunday, June 23, 2013 11:23:16 AM UTC-4, Gili wrote:
Thanks Thomas. So you're saying I can use other isolation modes with
MVCC as I normally would?
Gili
On 23/06/2013 7:39 AM, Thomas Mueller wrote
this information to the log? At the very least, I
need H2 to declare The current thread corresponds to session #X when
creating the session initially. That way I can track the thread id to the
session id for the rest of its lifetime.
Thanks,
Gili
--
You received this message because you
hoped
to implement it myself. Unfortunately, my work schedule has gotten
completely out of hand and I no longer believe that I will be able to work
on it after all. I am sharing it with the community in the hopes that you
will pick up where I left off.
Kind regards,
Gili
--
You received
BIGINT NOT NULL,
UNIQUE (LEAST([*]FROM_PARTICIPANT_ID, TO_PARTICIPANT_ID),
GREATEST(FROM_PARTICIPANT_ID, TO_PARTICIPANT_ID))) ; expected ASC, DESC,
NULLS, ,, ); SQL statement: trimmed [42001-172]
What am I doing wrong? How would you implement the desired behavior under
H2?
Thanks,
Gili
--
You
AS
LEAST(from_participant_id, to_participant_id), greatest_participant_id
BIGINT AS GREATEST(from_participant_id, to_participant_id), UNIQUE
(least_participant_id, greatest_participant_id));
Gili
On Wednesday, June 19, 2013 12:52:49 PM UTC-4, Gili wrote:
Hi,
Is it possible to invoke
Hi,
Looking at PageBtree.java:121, doesn't H2 have sufficient information (from
SearchRow on line 116) to indicate what key/value pairs causes the unique
constraint? Right now we're only told of the column names but not what
values caused a conflict. Can this be improved?
Thanks,
Gili
-trace should reference CHECK constraint, not
INSERT statement.
Can I file a bug report for this?
Thanks,
Gili
--
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
So to follow-up on http://stackoverflow.com/q/16705097/14731, are triggers
the only way to go? Or is there a better way to implement this?
Thank you,
Gil
On Thursday, May 23, 2013 8:17:30 PM UTC-4, Gili wrote:
Hi,
Based on the third answer at https://groups.google.com/
forum/#!msg/h2
)
at org.bitbucket.cowwoc.h2triggerdeadlock.App.main(App.java:45)
Please let me know what you think.
Thanks,
Gili
On Friday, May 24, 2013 3:22:24 AM UTC-4, Noel Grandin wrote:
It's a new internal Connection, but it's running on the same internal
Session, so it's running inside the context
this
question: http://stackoverflow.com/q/16705097/14731
Thanks,
Gili
--
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
from within the
same connection since they are supposed to run from within the same
transaction and avoid this kind of locking problem?
Thanks,
Gili
On Thursday, May 23, 2013 8:17:30 PM UTC-4, Gili wrote:
Hi,
Based on the third answer at
https://groups.google.com/forum/#!msg/h2-database
in table by the SQL
2008 standard as found in 5CD-02-Foundation-2006-01.pdf
in: http://en.wikipedia.org/wiki/SQL#cite_note-39
Gili
--
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
of a
database might change over time.
Thank you,
Gili
--
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
Hi,
Can you please document the QUEUE INT parameter of
http://www.h2database.com/html/grammar.html#create_trigger?
Thank you,
Gili
--
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
Hi,
Does the SQL standard specify the locking order in the case of ON DELETE
CASCADE? Is it possible to use this feature in a way that guarantees
locking order in order to avoid deadlocks?
Thank you,
Gili
--
You received this message because you are subscribed to the Google Groups H2
,
Gili
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/TWc8HBsMbp8J.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from
Hi,
Is it possible to INSERT into a table and, if a conflict occurs, lock the
conflicting table?
See also
http://stackoverflow.com/questions/13614965/select-for-update-and-conflicting-inserts
Thanks,
Gili
--
You received this message because you are subscribed to the Google Groups H2
of these APIs
in H2?
Thanks,
Gili
On Dec 15, 5:34 am, Thomas Mueller thomas.tom.muel...@gmail.com
wrote:
Hi,
If there is a way to callFlushFileBuffers() / F_FULLFSYNC then it
would be great (too bad no option for Linux), but I'm afraid if it's
not already supported then filing an RFE at Oracle
Excellent advice. This has been asked before (but never answered):
what are the advantages/disadvantages between using JdbcConnectionPool
and DBCP?
Thanks,
Gili
On Dec 1, 2:11 am, Noel Grandin noelgran...@gmail.com wrote:
Also, with a webapp, you should really be using some kind of connection
://timecapsule.cs.st-andrews.ac.uk/h2o/docs/h2o/classorg_1_1h2_1_1message_1_1_trace_writer_adapter.html
Thanks,
Gili
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from
Another interesting read:
http://www.humboldt.co.uk/2009/03/fsync-across-platforms.html
Gili
On Nov 24, 12:18 am, Gili Tzabari cow...@bbs.darktech.org wrote:
Good news! It looks like JDK7 invokes FlushFileBuffers() in the
following cases:
1. MappedByteBuffer.force(). Seehttp://bugs.sun.com
of FlushFileBuffers() does
it flush to disk correctly? Next, assuming this works, we need to
figure out whether this API is accessible through Java. If not, we can
file a RFE with Oracle as well as looking into using JNI under H2
(ugly, but doable).
What do you think?
Gili
--
You received
APIs.
This should make it easier for you to retrofit your test program.
Gili
Hopefully this means they also invoke it from other places...
Gili
On Nov 24, 12:01 am, Gili Tzabari cow...@bbs.darktech.org wrote:
Hi Thomas,
I wanted to follow up your post about Durability
problems:http
. If binaries are stored
outside the DB, I'm more likely to be able to recover files (and it's
easier to do so than running a database recovery tool).
What are your thoughts on this?
Thanks,
Gili
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post
You're right. My mistake.
Thank you,
Gili
On Sep 14, 4:58 pm, Thomas Mueller [EMAIL PROTECTED]
wrote:
Hi,
I tried doing a search but couldn't find the answer.
Strange, if I do a search I find the documentation. I typed 'isolation
levels' in the search box on the left (just below 'Search
73 matches
Mail list logo