On 30 Oct 2009, at 4:31pm, Alexey Pechnikov wrote: > The datatype conversion logic is not correct and is not compatible > with > other RDBMS.
It is impossible to be compatible with even the three most popular SQL DBMSs. They are not compatible with one-another. I can show you places where MSSQL truncates strings, and Postgres rejects them, and the specification isn't clear which on, if either, is doing the wrong thing. However, it's possible to be compatible with the SQL specification, and SQLite is pretty good at doing that. Before you ask, the ways in which SQLite fails SQL standard compatibility are not to do with typing. > I think the text '1' must > be equal to numeric 1 always like to standart de-facto for RDBMS. Personally I think that 1 and 1.0 are the same, and that '1' is never the same as either. Some people and some languages feel that 1 is never the same as 1.0. It's all a point of view. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
