Re: [sqlite] sqlite_master structure

On 2 Nov 2017, at 5:05am, Igor Korot wrote: > So if I want table, it is cleaner to use tbl_name, correct? > Provided I have "WHERE type = 'table'" in the query... For that specific thing, the two are always the same. I think that it might make more sense to use "name"

Re: [sqlite] sqlite_master structure

Simon, On Wed, Nov 1, 2017 at 10:44 PM, Simon Slavin wrote: > > > On 2 Nov 2017, at 3:37am, Igor Korot wrote: > >> I see that sqlite_master have 2 fields: name and tbl_name. It looks >> like they have >> the same value in my case. >> >> Is there a

Re: [sqlite] sqlite_master structure

On 2 Nov 2017, at 3:37am, Igor Korot wrote: > I see that sqlite_master have 2 fields: name and tbl_name. It looks > like they have > the same value in my case. > > Is there a scenario when those 2 are different? sqlite_master includes rows for things that aren’t tables.

[sqlite] sqlite_master structure

Hi, ALL, I see that sqlite_master have 2 fields: name and tbl_name. It looks like they have the same value in my case. Is there a scenario when those 2 are different? And what should I check for the "table name"? Thank you. ___ sqlite-users mailing

[sqlite] System.Data.SQLite version 1.0.106.0 released

System.Data.SQLite version 1.0.106.0 (with SQLite 3.21.0) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at: https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the

Re: [sqlite] Introduction to SQLite

Hi Simon, Thanks for sharing! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Introduction to SQLite

A small introduction to using SQLite. Starts out using the command-line tool, the progresses using Python (native sqlite3 library), then unusually ventures in to using user-defined functions in Python, then Jupyter Notebooks and Pandas DataFrames (I have no idea).

Re: [sqlite] sqlite 3.21.0 bug? SELECT CAST ('9223372036854775807 ' AS NUMERIC);

Encountering this in Fedora as well while trying to package latest 3.21.0 version. Only on i386. Additionally the test suite fails on some architectures (aarch64, ppc64, s390x) when running the test case fts3expr5-1.5: ! fts3expr5-1.5 expected: [1 {invalid matchinfo blob passed to function

Re: [sqlite] Segfault when query again in-memory db

Hi Richard Thanks for taking care of the issue. I was using the the ubuntu 16.04.3 with /usr/lib/x86_64-linux-gnu/libsqlite3.so.0.8.6, it's shipped byubuntu. I compiled the latest sqlite3 with the suggested params, I force the python to load the debug sqlite3.so and my app is not crashing now,

Re: [sqlite] bug: explain Rewind Le

Thank you for checking the issue. It seems I use an outdated version 3.11.0: $ uname -a Linux chrx 4.8.17-galliumos #1 SMP PREEMPT galliumos4 Thu Feb 23 02:27:28 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux $ sqlite3 --version 3.11.0 2016-02-15 17:29:24 3d862f207e3adc00f78066799ac5a8c282430a5f

Re: [sqlite] bug: explain Rewind Le

Yes, absolutely correct On Nov 1, 2017 10:55 AM, "Clemens Ladisch" wrote: > Egor Shalashnikov wrote: > > create table t(n number, v varchar2(10)); > > insert into t values (1, 'one') > > explain select * from t where 0 < n; > > If you omit the EXPLAIN, is the code executed

Re: [sqlite] bug: explain Rewind Le

Egor Shalashnikov wrote: > create table t(n number, v varchar2(10)); > insert into t values (1, 'one') > explain select * from t where 0 < n; If you omit the EXPLAIN, is the code executed correctly? > addr opcode p1p2p3p4 p5 comment > -