Hello,
This is a minor thing. I've experienced the fact that most RDBMS have
a CEIL function. Some provide both CEIL and CEILING.
Might this be an interesting addition for H2, to have CEIL as alias
for CEILING for improved compatibility?
http://www.h2database.com/html/functions.html#ceiling
I see.
So if I create a LOCAL TEMPORARY table it is persisted (possibly) to disk if I
don't define NOT PERSISTENT?
Only the indexes are kept in memory without unless CACHED is used.
So to sum it up:
CREATE CACHED TEMP TABLE - both rows and indexes are streamed to disk
CREATE [MEMORY] TEMP TABLE
Might this be an interesting addition for H2, to have CEIL as alias
for CEILING for improved
compatibility?http://www.h2database.com/html/functions.html#ceiling
The same thing might apply for having an LN alias for LOG...
--
You received this message because you are subscribed to the Google
Hi,
I came across this issue. Essentially the problem seems to be that:
CURRENT_DATE+1 // works (adds one day)
?+1 // where ? is set as a date
does not work
Which seems to me to be inconsistent. I realise that I should be using
the dateadd/datediff
Resurrecting a thread from the dead is always fun...
We use H2 in our product as a small JDBC backend suitable for development
before deployment over larger, enterprise servers.
In times past, H2 was always *lots* faster than Postgres, for example, at
least on smaller (1million row) datasets.
i hope can reply my question :D ...pass like 20 days and not have a single
reply if someone can provide an information would be great for me...
grettings
mavirr...@gmail.com
Manuel Rodriguez Coria
--
You received this message because you are subscribed to the Google Groups H2
Database
Hi,
What is the reason you have used '{' and '}'? Does this work with any
other database?
The '{' and '}' are JDBC escape characters, so that {t is parsed as
a time literal (so the T is removed). I guess the database should
throw an exception instead.
Regards,
Thomas
On Thu, Apr 14, 2011 at
Hi,
Thanks a lot! I will have a look. It will take some time however, as I
just returned from my vacation and now have a lot of work ahead of
me...
Regards
Thomas
On Wed, Apr 20, 2011 at 5:09 PM, mb michal.bergm...@gmail.com wrote:
Hi,
I'm submitting patch, that adds support for sorting
Hi,
Thanks a lot. I got connected.
I came to know that there is a way to split db files. My question is - what
will happen if I use a single db file and it goes beyond the max file size
of OS?
I will better document this.
If the logical file is larger than the maximum file size, then the