Hi,
Thomas, this effect can be reproduced when you use the linked tables.
Let's assume that you have SQL Server base with table 'foo' which
consists of two columns - 'ID' and 'Bar'. You create H2 linked table
to copy data from SQL Server to H2 base:
create linked table
foo_linked('com.microsoft.sqlserver.jdbc.SQLServerDriver',
'jdbc:sqlserver://localhost', 'sa', 'sa', 'foo');
create table foo as select * from foo_linked;
Statement 'select id from foo' works as expected. But if you try to
execute 'select bar from foo' statement, you'll see the 'Column "BAR"
not found' exception.
Column name in statement was converted to upper case by engine, but
column name in table was not.
--
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.
