You think words "SQLite is backwards compatible" describe implementation in some way? If this sentence is removed from the documentation you will be happier and finally read the whole document to understand how SQLite's type system work in details?
I agree that this statement can be a bit too much general and is not applicable in some cases. But all cases are explained in the rest of the document, so I think it's not quite right to extract just this one statement and based on it accuse the whole SQLite that it doesn't work correctly. Pavel On Fri, Oct 30, 2009 at 11:19 AM, Alexey Pechnikov <pechni...@mobigroup.ru> wrote: > Hello! > > On Friday 30 October 2009 18:03:29 Pavel Ivanov wrote: >> Don't use word 'terrible' for things that you don't understand >> completely. To understand it read once more about SQLite datatypes, >> affinity and about cases when datatype is changed automatically in >> expressions: http://www.sqlite.org/datatype3.html. It will explain to >> you why 1 ='1' doesn't work but a = 1 and a = '1' work. > > Please see paragraph "Datatypes In SQLite Version 3" in the document. > This speaking about "The dynamic type system of SQLite is backwards > compatible with the more common static type systems". But some tests > show the serious compatible problem. > >> Although I can admit that your case with trigger and my own tests show >> that for some reason affinity rules do not work in the "instead of" >> trigger but work in simple selects and all other types of triggers >> (I've tested "after insert" and "before insert"). > > Yes, there are some differents. But documentation of SQLite datatypes is not > right correspond to the realization. So documentation is wrong or realization > is wrong. > > Best regards, Alexey Pechnikov. > http://pechnikov.tel/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
