Open dynamobi-build opened 12 years ago
[author="elin", created="Mon, 3 Jul 2006 11:49:13 -0500 (GMT-05:00)"] Khanh, please check test to update ref file and remove knownFailure tag from test in open/luciddb/test/sql/calc/varbinary.sql when issue is resolved. thanks.
[reporter="kvu", created="Wed, 7 Jun 2006 16:37:54 -0500 (GMT-05:00)"] CREATE TABLE foo (x int, y varbinary(6));
insert into foo values (1, X'1bad3bad');
insert into foo values (1, X'1bad3aad');
insert into foo values (1, X'1bad3cad');
insert into foo values (2, X'1bad2bad3bad');
-- 0-byte value inserted to table
insert into foo values (3, X'X');
0: jdbc:luciddb:> select * from foo;
+----+---------------+
| X | Y |
+----+---------------+
| 1 | 1BAD3BAD |
| 1 | 1BAD3AAD |
| 1 | 1BAD3CAD |
| 2 | 1BAD2BAD3BAD |
| 3 | |
+----+---------------+