[sqlite] Insert mode shows wrong type

[BareFeet]

Hi all,

If I have a text column, insert text into it, the ask SQLite for the  
insert statement, shouldn't it show a text result? SQLite appears to  
coerce it to a number if it can, but shouldn't.

Here's an example:

.mode insert
create temp table "Test" (MyString text);
insert into Test values (123);
insert into Test values ('456');
insert into Test values ('789x');
select * from Test;

should give what I put in, ie:

insert into Test values (123);
insert into Test values ('456');
insert into Test values ('789x');

but it instead gives:

INSERT INTO table VALUES(123);
INSERT INTO table VALUES(456);
INSERT INTO table VALUES('789x');

The 456 value seems incorrect. It should show a literal '456', not a  
number.

Is this a bug?

I'm using SQLite 3.6.11 on Mac OS X.

Thanks,
Tom
BareFeet

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users