[sqlite] Using The Session Extension
Hello, I am interested in exploring the capabilities of [The Session Extension](http://www.sqlite.org/sessionintro.html). The documentation is currently a bit weak. Does anyone have any examples of how this extension might be used from the sqlite3 application or a Tcl interface? Thanks! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite 3.13.0 does not use indexes as 3.8.11.1 does
On 7/26/16, Richard Hipp wrote: > > Two possible fixes are: > > (1) Disable the new query algorithm introduced in 3.12. This does not > fix the cost estimate for the 3.11 algorithm, but as there are no > other reasonable competing algorithm choices, the 3.11 algorithm will > still win. The problem here is that there exist queries for which the > new 3.12 algorithm is desirable, and so disabling it will cause those > queries to run more slowly. > > (2) Invest the time and code needed for the query planner to make a > better cost estimate for the 3.11 algorithm in cases where the WHERE > clause can be checked using terms taken from only the index. This > will be a good deal of work, and will likely delay the release of > 3.14. > > I do not yet know which resolution we will take on this issue. Resolution (2) is now on trunk and is in the latest Prerelease Snapshot. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite 3.13.0 does not use indexes as 3.8.11.1 does
On 7/26/16, Alessandro Fardin wrote: > After updating from sqlite 3.8.11.1 to sqlite 3.13.0. > > The Query planner with the same SELECT statement on same table with the > same indexes does not use index at all, but parse the entire table. > Of course this causes a dramatically slow down of the application. This problem should now be fixed in the latest Prerelease Snapshot available at https://www.sqlite.org/download.html - please confirm that the problem is resolved. We are holding up the release of SQLite version 3.14 waiting on your confirmation. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SqliteDataAdapter fill wrong data when select data from database
On 27 Jul 2016, at 11:09am, Jin ZhiQiao (Joe) wrote: > My table schema and data is like this. Table name is "a". > > IDTEXT DOUBLE > > 1 AA 1 > 2 BB 1.2 > 3 CC 2 Please show us the result of SELECT sql FROM sqlite_master WHERE name='a' Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SqliteDataAdapter fill wrong data when select data from database
When I use sqlite ado.net, I met a bug made me confused. My table schema and data is like this. Table name is "a". IDTEXT DOUBLE 1 AA 1 2 BB 1.2 3 CC 2 When I run SQL statement("select * from a"); I got double column's data is 1 1 2, and column dataType is system.Int64(Long) the 1.2 converted to 1. this make me got wrong value. But, if table is like this. IDTEXT DOUBLE 1 AA 1.3 2 BB 1.5 3 CC 2 I got double column's data is 1.3 1.5 2, and column dataType is double the dataType and correct value is very import for us. I can not create a dataTable that defined tableschema, because the select result is can not prediction. I can not know how many columns and column's data type will be return. Please try this. If this is a bug, please fixed it as soon as possible. If this is not a bug, can you give me a way to get correct value and column type ? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users