[sqlite] Using The Session Extension

2016-07-27 Thread Adam Jensen
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!

Re: [sqlite] sqlite 3.13.0 does not use indexes as 3.8.11.1 does

2016-07-27 Thread Richard Hipp
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 probl

Re: [sqlite] sqlite 3.13.0 does not use indexes as 3.8.11.1 does

2016-07-27 Thread Richard Hipp
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 ap

Re: [sqlite] SqliteDataAdapter fill wrong data when select data from database

2016-07-27 Thread Simon Slavin
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] SqliteDataAdapter fill wrong data when select data from database

2016-07-27 Thread Jin ZhiQiao (Joe)
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