[sqlite] SQLite.NET Class Library Documentation Feedback: Welcome

I don't really how the class library documentation Sent from Windows Mail ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Autoincrement sequence not updated by UPDATE

This has been the case since Microsoft stole SQL Server from Sybase (where it is/was the case as well). > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of James K. Lowden > Sent: Thursday, 3 November, 2016 19:50 > To: SQLite mai

Re: [sqlite] Is msync necessary for SQLite?

On 11/3/16, sanhua.zh wrote: > So, if I am already using an old version before 3.11 and enable the mmap, > the data may lost after os crash. It’s that right? I don't know. I suppose it depends on your OS. -- D. Richard Hipp d...@sqlite.org ___ sqlite-

Re: [sqlite] Autoincrement sequence not updated by UPDATE

On Tue, 1 Nov 2016 11:01:24 + Simon Slavin wrote: > attempts to change a value in that column using UPDATE always > generate an error. I didn't know that. I looked it up. Apparently > Microsoft's SQLSERVER blocks it Blocks but does not prevent. https://msdn.microsoft.com/en-us/library/ms1

Re: [sqlite] Is msync necessary for SQLite?

So, if I am already using an old version before 3.11 and enable the mmap, the data may lost after os crash. It’s that right? 原始邮件 发件人:Richard hipp...@sqlite.org 收件人:SQLite mailing listsqlite-us...@mailinglists.sqlite.org 发送时间:2016年11月3日(周四) 21:21 主题:Re: [sqlite] Is msync necessary for SQLite?

Re: [sqlite] Are identical calls to deterministic functions coalesced?

>Does the query optimizer coalesce identical calls to deterministic functions? It’s not coalesce identical calls when inserting new record. CREATE TABLE t(x json); CREATE INDEX i2 on t(json_extract(x,'$.type')) where json_extract(x,'$.type') not null; explain insert into t values(?); addr opco

Re: [sqlite] Are identical calls to deterministic functions coalesced?

On 11/3/16, Richard Hipp wrote: > On 11/3/16, Jens Alfke wrote: >> Does the query optimizer coalesce identical calls to deterministic >> functions? I’m thinking in particular of a statement like: >> >> CREATE INDEX byFoo ON jtable (json_extract(body, ‘$.foo’)) WHERE >> json_extract(body, ‘$.

Re: [sqlite] Are identical calls to deterministic functions coalesced?

On 11/3/16, Jens Alfke wrote: > Does the query optimizer coalesce identical calls to deterministic > functions? I’m thinking in particular of a statement like: > > CREATE INDEX byFoo ON jtable (json_extract(body, ‘$.foo’)) WHERE > json_extract(body, ‘$.foo’) IS NOT NULL > > where it would im

[sqlite] Are identical calls to deterministic functions coalesced?

Does the query optimizer coalesce identical calls to deterministic functions? I’m thinking in particular of a statement like: CREATE INDEX byFoo ON jtable (json_extract(body, ‘$.foo’)) WHERE json_extract(body, ‘$.foo’) IS NOT NULL where it would improve performance if the JSON were not

Re: [sqlite] Possible optimization oppurtunity

On 11/3/16, Quan Yong Zhai wrote: > Dear SQLite developers, > > SQLite does not use covering index on following situation > CREATE TABLE t(x json); > CREATE INDEX i1 on t( json_extract(x, "$.name")); I have this on my to-do list. But there are technical difficulties in the implementation that I

[sqlite] Possible optimization oppurtunity

Dear SQLite developers, SQLite does not use covering index on following situation CREATE TABLE t(x json); CREATE INDEX i1 on t( json_extract(x, "$.name")); explain query plan select json_extract(x,"$.name") from t where json_extract(x,"$.name")=?; 0|0|0|SEARCH TABLE t USING INDEX i1 (=?) explain

Re: [sqlite] Is msync necessary for SQLite?

On 11/3/16, sanhua.zh wrote: > Here is a part of code in [unixWrite]. (os_unix.h) > Is not it written by mmap ? You are looking at older code that is not longer used. Look at latest sources and you will see that the code you quote below is enclosed within #if defined(SQLITE_MMAP_READWRITE)

Re: [sqlite] UNIQUE INDEX behaves differently depending on the order rows are inserted

On Wed, Nov 02, 2016 at 11:30:37PM -0400, Richard Hipp wrote: > On 11/2/16, Ben Hearsum wrote: > > I've also had a couple of kernel panics lately, and I imagine that could > > either directly cause issues, or cause issues the next time Firefox starts > > (and tries to recover). > > SQLite is supp

Re: [sqlite] Is msync necessary for SQLite?

So, it means that this is a bug in old version of SQLite ? 原始邮件 发件人:Dan kennedydanielk1...@gmail.com 收件人:sqlite-userssqlite-us...@mailinglists.sqlite.org 发送时间:2016年11月3日(周四) 18:38 主题:Re: [sqlite] Is msync necessary for SQLite? On 11/03/2016 04:53 PM, sanhua.zh wrote: Here is a part of code in

[sqlite] undefined symbol: Tcl_CreateObjCommand

Hi guys, I am using a module called Tcl-1.05 in perl. But when i try to load a tclsqlite3.5.3.so file it throws an error like undefined symbol: Tcl_CreateObjCommand. If i just specify the tclsqlite-3.5.3.so it will search in this particular location which is /usr/local/lib/tclsqlite-3.5.

Re: [sqlite] Is msync necessary for SQLite?

On 11/03/2016 04:53 PM, sanhua.zh wrote: Here is a part of code in [unixWrite]. (os_unix.h) Is not it written by mmap ? It changed to avoid writing via mmap for version 3.10.0. http://www.sqlite.org/src/info/67c5d3c646 And I don't think mmap() was used on IOS until 3.11.0. http://www.sql

Re: [sqlite] Is msync necessary for SQLite?

Here is a part of code in [unixWrite]. (os_unix.h) Is not it written by mmap ? #if SQLITE_MAX_MMAP_SIZE0 /* Deal with as much of this write request as possible by transfering ** data from the memory mapping using memcpy(). */ if( offsetpFile-mmapSize ){ if( offset+amt = pFile-mmapSize ){

Re: [sqlite] Is msync necessary for SQLite?

On 11/3/16, sanhua.zh wrote: > I run in iOS. The mmap is enable in recent version. > So, once a mmap enable, data may lost after os crash unless msync. But I > can’t find anywhere in the source of SQLite call the msync. Is it a bug? No. Mmap() is only used for reading, not writing. All changes

Re: [sqlite] Is msync necessary for SQLite?

I run in iOS. The mmap is enable in recent version. So, once a mmap enable, data may lost after os crash unless msync. But I can’t find anywhere in the source of SQLite call the msync. Is it a bug? 原始邮件 发件人:Dan kennedydanielk1...@gmail.com 收件人:sqlite-userssqlite-us...@mailinglists.sqlite.org 发送时

Re: [sqlite] VACUUM causes Out of memory error

On 11/3/16, Christian Czech wrote: > > This bug in a release version did a lot of damage to us. > > Especially frustrating was that nobody really cared when I reported it: We cared, and we looked into the problem, but we couldn't reproduce it at that time. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Is msync necessary for SQLite?

On 11/03/2016 02:13 PM, sanhua.zh wrote: I notice that SQLite may not call msync for mmap. Instead, it calls the fsync. As my search, fsync does not imply the msync. See this,https://groups.google.com/forum/#!topic/comp.unix.programmer/pIiaQ6CUKjU So, is it necessary call a msync for SQLite?

Re: [sqlite] as close as possible to Oracle

On 3 Nov 2016, at 8:00am, Christoph P.U. Kukulies wrote: > How close to Oracle's PL/SQL can Sqlite be? Are there pragmas allowing for > this? Or is there a matrix showing the differences? I believe the only difference matrix in the whole SQLite documentation at the moment is the one on

Re: [sqlite] VACUUM causes Out of memory error

sqlite is a great tool! And I also use (and bought) the SEE version. This bug in a release version did a lot of damage to us. Especially frustrating was that nobody really cared when I reported it: - We have a problem with the latest stable release of SQLite. When compiled for 32 bit und

Re: [sqlite] as close as possible to Oracle

Christoph P.U. Kukulies wrote: > How close to Oracle's PL/SQL can Sqlite be? There is no "PL" in SQLite's dialect of SQL. This depends mostly on how many of Oracle's nonstandard features you have been using. > Are there pragmas allowing for this? Or is there a matrix showing the > differences?

[sqlite] as close as possible to Oracle

How close to Oracle's PL/SQL can Sqlite be? Are there pragmas allowing for this? Or is there a matrix showing the differences? I'm thinking of bringing a database from Oracle to Sqlite. -- Christoph ___ sqlite-users mailing list sqlite-users@maili

Re: [sqlite] undefined symbol: Tcl_TranslateFileName

Ravi Just curious. Why do ya need Tcl at all with Perl? Ought to some advantage? regards Nataraj On Wed, Nov 2, 2016 at 2:56 PM, ravi.shan...@cellworksgroup.com < ravi.shan...@cellworksgroup.com> wrote: > Hi guys, > > I am using a module called Tcl-1.05 in perl. But when i try to >

[sqlite] Is msync necessary for SQLite?

I notice that SQLite may not call msync for mmap. Instead, it calls the fsync. As my search, fsync does not imply the msync. See this,https://groups.google.com/forum/#!topic/comp.unix.programmer/pIiaQ6CUKjU So, is it necessary call a msync for SQLite?