Hi,
Am Montag, 15. Juli 2013 08:30:10 UTC+2 schrieb Noel Grandin:
>
> Hi
>
> Your test case is working fine for me.
> Which means we might have fixed it already.
>
>
I've built from source to make sure, that i am using the latest master,
the version is: H2 1.3.172 (2013-05-25)
it fails here:
create table foo (bar char(1) default 'N' not null check (bar in ('Y',
'N')));
alter table foo alter bar rename to baz;
select SQL from INFORMATION_SCHEMA.TABLES
shows, that it is broken, check constraint was not renamed:
"CREATE CACHED TABLE PUBLIC.FOO(BAZ CHAR(1) DEFAULT 'N' NOT NULL CHECK (BAR
IN('Y', 'N')))"
disconnect
connect: error:
Column "BAR" not found; SQL statement:
CREATE CACHED TABLE PUBLIC.FOO(
BAZ CHAR(1) DEFAULT 'N' NOT NULL CHECK (BAR IN('Y', 'N'))
) [42122-172] 42S22/42122
Thanks
David
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
