Hi,
> Thomas, this effect can be reproduced when you use the linked tables.
You are right. I didn't know that, identifiers in MS SQL Server are
case insensitive even if they are quoted:
drop table foo;
drop table foo2;
drop table foo3;
create table foo(ID int, Bar varchar(255));
create table "foo2"("ID" int, "Bar" varchar(255));
create table [foo3]([ID] int, [Bar] varchar(255));
select id, bar from foo;
select id, bAr from foo2;
select iD, baR from foo3;
select "iD", "bAr" from foo;
select [Id], "BAr" from foo2;
select [iD], [baR] from foo3;
All of those statements work. I will change the behavior in the next
release. My test case:
MS SQL Server (Microsoft SQL Server 9.00.1399):
drop table foo;
create table foo(ID int, Bar varchar(255));
insert into foo values(1, 'Hello');
H2:
drop table if exists foo;
drop table if exists foo_linked;
create linked table foo_linked(null,
'jdbc:sqlserver://localhost;DatabaseName=test',
'sa', '...', 'foo');
insert into foo_linked values(2, 'World');
select Id, Bar from foo_linked;
create table foo as select * from foo_linked;
select Id, Bar from foo;
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
