Hi,
It seems that CHAR column in Oracle Db(10g Express Edition Release
10.2.0.1.0) table can not be used when you use table through LinkedTable.
<<Example>>
Table definition :
CREATE TABLE TEST1
(
KEY1 VARCHAR2(20) NOT NULL,
VALUE1 CHAR(15),
CONSTRAINT TEST1_PK PRIMARY KEY (KEY1)
)
then, insert record such that :
insert into TEST1 values('data1', 'test1')
* the value 'test1' is converted to 'test1 '
because the data type of column 'VALUE1' is CHAR.
finally, create LinkedTable 'LINK_TEST1' (same name).
In this case, the following query to LinkedTable
do not return any results.
1)
SELECT * FROM LINK_TEST1
WHERE VALUE1 = 'test1'
2)
SELECT * FROM LINK_TEST1
WHERE VALUE1 = 'test1 '
It seems buggy.
Sincerely,
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
