Great, thank you!
On Thu, Feb 13, 2014 at 11:48 PM, Rami Ojares wrote:
> Yes, it is supported.
> See: http://www.h2database.com/html/grammar.html#referential_constraint
>
> - Rami
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To un
Yes, it is supported.
See: http://www.h2database.com/html/grammar.html#referential_constraint
- Rami
--
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+
Yes, strict type checking is certainly desirable. I've checked the latest
draft documents of the the SQL:2011 standard. The PostgreSQL driver shows
the expected behaviour when we use a CAST:
6.13
[...]
10) If TD is fixed-length character string, then let LTD be the length in
characters of TD.
[..
Hi!
Does anybody knows if ON DELETE CASCADES and ON UPDATE CASCADES is
supported in H2?
Suppose I have this:
DROP TABLE IF EXISTS SIBS;
CREATE TABLE SIBS (
NAME VARCHAR(25) NOT NULL,
SIB_ID VARCHAR(25) NOT NULL,
CREATION_TIME VARCHAR(25),
PRIMARY KEY(NAME, SIB_ID)
);
DROP TABLE
I vote for strict type checking.
This means that setting a value with wrong type should produce an error.
Maybe someone has saved his booleans as "T" and "F" or "t" and "f" or
"true" and "false" or "yes" and "no" ...
Of course as a compatibility feature for different modes it is
defendable.
I did some more testing on Postgres and it looks like this is not as simple
as I thought; given a sufficiently large DB postgres too ends up relatively
slow. Looks like my previous experiment looked to be much faster in PSQL
because it still cached the entire table in memory.
But, compound indi
Hi,
Is it possible to look at fixing it? This is an issue for us as it also
applies when using square bracket delimiters rather than double-quotes.
We like to use h2 both as a cache and as a unit test mock for our MS SQL
Server based java apps. So it's not easy for us to avoid sql queries with