CAST AS STRING always returns 0 for columns that are already of STRING type.
Steps to reproduce:
sqlite> CREATE TABLE A(col1 STRING);
sqlite> INSERT INTO A VALUES('asdf');
sqlite> SELECT CAST(col1 AS STRING) FROM A;
0
We are generating SQL code programmatically, and it would be useful to not
have to special-case casting based on column type.
--
--
Ben Caine | Software Engineer | Verily
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
