[sqlite] Reseting total_changes() to 0

Greetings! Can total_chages() be set to zero or reset? thanks. josé ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

i find it not enter the unixdelete. 发自我的 iPhone > 在 2014年8月28日，22:42，Andy Ling 写道： > > Sorry, I meant unixDelete > > My guess is that because you are using the host filing system vxWorks will be > setting yet another error code for a file that doesn’t exist. So it

Re: [sqlite] blob + rowID Insert question

Thanks!! -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: sexta-feira, 29 de Agosto de 2014 00:20 To: sqlite-users@sqlite.org Subject: Re: [sqlite] blob + rowID Insert question On 8/28/2014 2:18 PM,

Re: [sqlite] blob + rowID Insert question

On 8/28/2014 2:18 PM, Carlos Ferreira wrote: In the next line: UPDATE myTable SET theBlob = WHERE id = The "whatever" is a long string containing the data? The "whatever" should be ? (question mark) - a parameter placeholder ( could be another one). Prepare the statement, bind the data to

[sqlite] String compare scoring functions

Hello, I need a function that gives a real result from 0 to 100 representing the similarity of two input strings. I need to compare a dataset of addresses with a dataset of addresses with house numbers, having coordinates, to get a geolocalization of the addresses. Since the addresses aren't

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Thanks for looking into it! I'll follow up with the ORM package authors. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Thursday, August 28, 2014 11:41 AM To: 'General Discussion of SQLite Database'

Re: [sqlite] Window functions?

On Wed, 27 Aug 2014 23:04:40 +0200 Petite Abeille wrote: > > On Aug 27, 2014, at 10:57 PM, Eduardo Morras > wrote: > > > Sorry, don't understand why others will throw an exception in the > > group by, perhaps I'm misunderstanding the group by, but

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Zachary Yates wrote: > > create view ProgrammingMapView as > select > p.Id ProductId > , pt.Id ProtocolId > , m.Id Mid > from Mid m > join MidProduct mprod on (mprod.RegisteredMid = m.Id) > join Product p on (p.Id = mprod.ProductId) >

Re: [sqlite] blob + rowID Insert question

On 28 Aug 2014, at 7:18pm, Carlos Ferreira wrote: > Using your suggestion of the UPDATE Statement, and assuming I have a block > of memory with pointer p and size s ( different from the previous size ), > that I want to use as the data of my new blob, do you suggest I

Re: [sqlite] blob + rowID Insert question

One other question: I use the SQLite3_BindBlob to add a new blob to a given record. From this point on I know how to change the BLOB ( but not its size ) using the incremental BLBO direct Access functions. Using your suggestion of the UPDATE Statement, and assuming I have a block of memory

Re: [sqlite] blob + rowID Insert question

Thanks :) :) -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: quinta-feira, 28 de Agosto de 2014 19:08 To: General Discussion of SQLite Database Subject: Re: [sqlite] blob + rowID Insert question On 28 Aug

Re: [sqlite] blob + rowID Insert question

On 28 Aug 2014, at 7:06pm, Carlos Ferreira wrote: > Is there any way to replace a BLOB for a give ROW ID? Use the UPDATE command: UPDATE myTable SET theBlob = WHERE id = Simon. ___ sqlite-users mailing list

[sqlite] blob + rowID Insert question

Hi All, I have a table with one unique column of the type BLOB. Because I am using the direct SQLite functions to read and write BLOBS, the access is made referencing the ROW IDs. Is there any way to replace a BLOB for a give ROW ID? If I perform DELETE and INSERT I am not sure the

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Here is the DDL for the scenario: create table Country ( Id integer primary key, Code text, Title text, ShortTitle text, ModifiedOn text, ModifiedBy integer ); create table Mid ( Id integer primary key, CountryCode text,

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Clemens Ladisch wrote: > > Your query did not involve the query flattener. Try this: > I used the query as originally reported. However, as others have stated, without AS clauses, the column names are not well-defined. In this case, the IDataRecord.GetName method of the SQLiteDataReader class

Re: [sqlite] Integrity check

On 28 Aug 2014, at 4:57pm, Jan Slodicka wrote: > Simon Slavin-3 wrote >> ...If the database is corrupted because your hardware flipped bits during >> power-loss and overwrote the wrong part of the disk, the corruption might >> well be in a different table... > > Clear. I just

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Joe Mistachkin wrote: > I'm unable to replicate this issue Your query did not involve the query flattener. Try this: select "t".x from (select x from (select 1 x)) t; Regards, Clemens ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Integrity check

Thanks, Simon. Simon Slavin-3 wrote > Your solution seems to do it by exchanging data accessed using the SQLite > API so you shouldn't have that sort of problem. Yes, only standard SQLite API is used. > I assume that you aren't using any PRAGMAs which speed up SQLite at the > expense of

Re: [sqlite] FTS full-text query vs. query by rowid

Dne 28.8.2014 16:48, Clemens Ladisch napsal(a): Then try with 3.8.6. Ouuu . .sorry again. I have tested it with 3.8.6 and the query plan looks ok now. SCAN TABLE nameftsTable VIRTUAL TABLE INDEX 18: EXECUTE LIST SUBQUERY 1 But I also tested it with my version again and I'm getting

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Zachary Yates wrote: > > There's a lot more detail to this question posted at: > http://stackoverflow.com/questions/25534898/trouble-with-sqlexpressiont-join -and-column-names > I'm unable to replicate this issue using System.Data.SQLite. Here is what I've tried so far: set db [sql open

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Sorry, I meant unixDelete My guess is that because you are using the host filing system vxWorks will be setting yet another error code for a file that doesn’t exist. So it will need another check adding to unixDelete Regards Andy Ling From: 王庆刚 [mailto:2004wqg2...@163.com] Sent: 28 August

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Is unixUnlink an function? If it is , but I can not find the funtion in sqlite3.c. Regards Wang Qinggang At 2014-08-28 00:03:23, "Andy Ling" wrote: So you are using a host file system. You should be able to make the open work by using rc =

Re: [sqlite] Window functions?

On 28 Aug 2014, at 3:45pm, Richard Hipp wrote: > On Thu, Aug 28, 2014 at 10:38 AM, Gabor Grothendieck < > ggrothendi...@gmail.com> wrote: > >> The wording in the cited link is that >> >> "Queries of the form: "SELECT max(x), y FROM table" returns the value >> of y on the same

Re: [sqlite] Integrity check

> On 28 Aug 2014, at 12:23pm, Jan Slodicka wrote: > > Simon Slavin-3 wrote >> When you exchange data, do you exchange data accessed as records (e.g. >> accessed using the SQLite API) or do you exchange files ? > > DB tables are being synchronized. The server sends xml data over

Re: [sqlite] FTS full-text query vs. query by rowid

Milan Kříž wrote: > Dne 28.8.2014 14:54, Clemens Ladisch napsal(a): >> Milan Kříž wrote: >>> So does it mean that the full-text search is not performed for the >>> following query at all? >> >> No, it means that you are using a different version. > > But I still cannot understand that query plan.

Re: [sqlite] Window functions?

On Thu, Aug 28, 2014 at 10:38 AM, Gabor Grothendieck < ggrothendi...@gmail.com> wrote: > The wording in the cited link is that > > "Queries of the form: "SELECT max(x), y FROM table" returns the value > of y on the same row that contains the maximum x value." > > There is some question of whether

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

Sorry, I meant unixDelete My guess is that because you are using the host filing system vxWorks will be setting yet another error code for a file that doesn’t exist. So it will need another check adding to unixDelete Regards Andy Ling From: 王庆刚 [mailto:2004wqg2...@163.com] Sent: 28 August

Re: [sqlite] Window functions?

The wording in the cited link is that "Queries of the form: "SELECT max(x), y FROM table" returns the value of y on the same row that contains the maximum x value." There is some question of whether min(x) is "of the form" max(x). On Thu, Aug 28, 2014 at 10:28 AM, Clemens Ladisch

Re: [sqlite] Window functions?

Adam Devita wrote: >>> select id, category_id, name, min(price) as minprice >>>from cat_pictures >>> group by category_id; >>> > > I'd be reluctant to write that query because it is non standard SQL and I > can't easily (5 minutes of searching) point at a document that tells me the > expected

Re: [sqlite] Window functions?

dbase3 would give an error if you did not include all the non-aggregate fields in the Group By. (One could also step forward/backward in a row-set, so some crude windowing was available if one coded to do that.) on this: > > select id, category_id, name, min(price) as minprice > >from

Re: [sqlite] FTS full-text query vs. query by rowid

Dne 28.8.2014 14:54, Clemens Ladisch napsal(a): Milan Kříž wrote: So does it mean that the full-text search is not performed for the following query at all? SELECT docId FROM ftsTable WHERE ftsTable MATCH 'a*' AND rowId IN (20,21, 22, 23) SCAN TABLE ftsTable VIRTUAL TABLE INDEX 1:

Re: [sqlite] Integrity check

Richard Hipp-3 wrote > Have you reviewed the list of corruption causes at > http://www.sqlite.org/howtocorrupt.html and eliminated them all as > possibilities? Multiple times, but I did it again. In general I can exclude only a few points... 1.0 File overwrite by a rogue thread or process

Re: [sqlite] FTS full-text query vs. query by rowid

Milan Kříž wrote: > So does it mean that the full-text search is not performed for the following > query at all? > > SELECT docId FROM ftsTable WHERE ftsTable MATCH 'a*' AND rowId IN (20,21, 22, > 23) > > SCAN TABLE ftsTable VIRTUAL TABLE INDEX 1: > EXECUTE LIST SUBQUERY 1 No, it means

Re: [sqlite] Integrity check

On Thu, Aug 28, 2014 at 7:31 AM, Jan Slodicka wrote: > Thanks, may I ask about PRAGMA synchronous=Normal? > > The worst-case scenario I can imagine is that the app is killed by the OS > when a checkpoint operation is in process... > That should be safe. -- D. Richard Hipp

Re: [sqlite] Integrity check

Thanks, may I ask about PRAGMA synchronous=Normal? The worst-case scenario I can imagine is that the app is killed by the OS when a checkpoint operation is in process... -- View this message in context: http://sqlite.1065341.n5.nabble.com/Integrity-check-tp77519p77558.html Sent from the

Re: [sqlite] Integrity check

Have you reviewed the list of corruption causes at http://www.sqlite.org/howtocorrupt.html and eliminated them all as possibilities? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Integrity check

Simon Slavin-3 wrote > On 27 Aug 2014, at 4:21pm, Jan Slodicka > jano@ > wrote: > >> - There is one potentionally risky operation that our app performs: The >> data >> exchange with a remote WebService. This can take long (10+ min). Users >> often >> switch to email reading or similar

Re: [sqlite] Integrity check

On Thu, Aug 28, 2014 at 6:11 AM, Jan Slodicka wrote: > > If NOCASE is a custom collation, could a bug in that collation explain > corruption of indexes FK_account_transactioncurrencyid and > FK_account_ownerid? (Both have NUMERIC affinity and store blobs such as >

Re: [sqlite] Integrity check

Thank you for the answer. > Your custom collation function would be my prime suspect here. Yes, it was. Some time ago we really corrected a bug in the collation, which resulted in decreased number of user reports. Even later we switched to the ICU library, which - I suppose - should be

Re: [sqlite] FTS full-text query vs. query by rowid

Clemens Ladisch wrote: Milan Kříž wrote: Clemens Ladisch wrote: "INDEX 1" is the full-text search. Sorry, that's wrong. So does it mean that the full-text search is not performed for the following query at all? And that only the docId index is used to get entries in the IN sub-clause and

Re: [sqlite] FTS full-text query vs. query by rowid

Milan Kříž wrote: > Clemens Ladisch wrote: >> "INDEX 1" is the full-text search. Sorry, that's wrong. The idxNum value is determined as follows: (see fts3Int.h) /* ** The Fts3Cursor.eSearch member is always set to one of the following. ** Actualy, Fts3Cursor.eSearch can be greater than or equal

Re: [sqlite] FTS full-text query vs. query by rowid

Clemens Ladisch wrote: 4) The I have a query with both 'match ?' sub-clause and 'rowid=?' sub-clause. It is not clear to me which variant will be used. But according to definition of Full-text query it should use full-text query at first. And then? Will it use index to rowid after full-text

Re: [sqlite] FTS full-text query vs. query by rowid

Milan Kříž wrote: > 3) A query which should use a linear scan according to the SQLite >documentation (http://www.sqlite.org/fts3.html#section_1_4) > SELECT docId FROM ftsTable WHERE docId BETWEEN 20 AND 23 > - gets a following query plan: > SCAN TABLE ftsTable VIRTUAL TABLE INDEX

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Simon Slavin wrote: > you're free to consider this a peculiarity of the ADO driver. It's a peculiarity of SQLite itself (introduced in 5526e0aa3c). > It might be easily fixable. But it's not a bug. The comment "Dequote column names generated by the query flattener" shows that combined

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

> Yes, you're free to consider this a peculiarity of the ADO driver. It might be easily fixable. But it's not a bug. I respectfully disagree with that. GetName() is supposed to return a _Column_ Name, not a _Table_ Name. Even more, it is supposed to return a Value to identify a Column, so