db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eranda Sooriyabandara <erandaj...@gmail.com>
Subject Problem with insertng values to varchar column
Date Sun, 25 Apr 2010 09:55:27 GMT
Hi,
While I was do buddy testing I encounter a problem with inserting values to
a varchar column which does not end until I forced exit from it.


ij> CONNECT 'jdbc:derby:memory:dummy;create=true;user=eranda' AS
eranda_conn;

ij> CREATE TABLE table1(a int);

0 rows inserted/updated/deleted

ij> INSERT INTO table1 VALUES(1),(2),(3);

3 rows inserted/updated/deleted

ij> CREATE TABLE table2(a varchar(255));

0 rows inserted/updated/deleted
ij> INSERT INTO table2 VALUES(`aa'),(`ab'),(`ac');

The message I got after fored exit,

ERROR 42X02: Lexical error at line 1, column 27.  Encountered: "`" (96),
after :

 "".

Can anyone reproduce it to see whether it is a bug or not.
Thanks
Eranda

Mime
View raw message