Hello! On Friday 30 October 2009 18:30:26 Pavel Ivanov wrote: > > 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?
The datatype conversion logic is not correct and is not compatible with other RDBMS. So the declared tasks of the SQLite datatypes system is not performed and document is not consistent. I think the text '1' must be equal to numeric 1 always like to standart de-facto for RDBMS. > 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. I did find some datatypes bugs in tclsqlite interface and fix it as http://geomapx.blogspot.com/2009/10/tclsqlite.html Note: the original code produce different results from tclsh shell and from tcl script file. As you can see the datatyping is not ideal now. 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
