3.30, though it goes back to at least 3.8.7 (the oldest version I have available to test with)
On Sun, Oct 13, 2019, 3:03 PM Igor Korot <[email protected]> wrote: > Hi, > > On Sun, Oct 13, 2019 at 4:12 PM Shawn Wagner <[email protected]> > wrote: > > > > The documentation for a column with NUMERIC affinity says > > > > > When text data is inserted into a NUMERIC column, the storage class of > > the text is converted to INTEGER or REAL (in order of preference) if such > > conversion is lossless and reversible. > > > > But consider: > > > > sqlite> create table foo(bar numeric); > > sqlite> insert into foo values ('0012'); > > sqlite> select bar, typeof(bar) from foo;bar typeof(bar) > > ---------- -----------12 integer > > > > > > As you can see, the leading zeros in the original string are gone and > it's > > been converted to an integer. This seems to violate the "lossless and > > reversible" constraint. Shouldn't it be kept as text? > > What version of SQLite do you use? > > Thank you. > > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
