On Mon, Jul 15, 2019 at 6:01 AM J. King <jk...@jkingweb.ca> wrote: > On July 14, 2019 11:56:15 p.m. EDT, Donald Shepherd < > donald.sheph...@gmail.com> wrote: > >sqlite> create table x(a int, b text, c real, d blob, e vartext, > fgarbage); > >sqlite> pragma table_info(x); > >0|a|int|0||0 > >1|b|text|0||0 > >2|c|real|0||0 > >3|d|blob|0||0 > >4|e|vartext|0||0 > >5|f|garbage|0||0 > >sqlite> create table y as select * from x; > >sqlite> pragma table_info(y); > >0|a|INT|0||0 > >1|b|TEXT|0||0 > >2|c|REAL|0||0 > >3|d||0||0 > >4|e|TEXT|0||0 > >5|f|NUM|0||0 > > Blobs have no affinity. The result you're seeing is correct, just > represented in a surprising way. >
Still. The fact garbage is mapped to NUM, and BLOB to nothing, is at the very least "surprising", despite being "correct" as per SQLite's "flexible typing" as DRH puts it. Definitely worthy of the "new" quirks.html page though IMHO. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users