I have following script:
CREATE TABLE a (d datetime);
INSERT INTO a insert into('01-01-01');
CREATE TABLE b AS SELECT d FROM a;
Then I use this sql:
SELECT d FROM b;
In SQLite version 3.6.4 the "datetime" affinity is persisted, but from version
3.6.16
(maybe earlier) the affinity is lost (sqlite3_column_decltype returns "NUM")
For first table (SELECT d FROM a) the "datetime" is returned in all SQLite
versions.
Please fix this.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
