Re: [sqlite] [System.Data.SQLite.DLL] Retrieving table names with column names

Short answer: YES. This question crops up regulary. The SQL Standard mandates only that column names set with AS be reliably returned. Otherwise each implementation is free to choose whatever name it deems appropriate, because - by omitting the AS clause - you state that you "don't care". The

Re: [sqlite] Fwd: Your message to sqlite-users awaits moderator approval

On 7/22/16, Chris Locke wrote: > Bit of a noob question, but whenever I post to the group, I get the below > email - 'you're not part of the group'. How does one join the group? I've > subscribed, so get all the emails... just wondering if there was a second > step, or

[sqlite] Fwd: Your message to sqlite-users awaits moderator approval

Bit of a noob question, but whenever I post to the group, I get the below email - 'you're not part of the group'. How does one join the group? I've subscribed, so get all the emails... just wondering if there was a second step, or if all group messages get moderated. Thanks, Chris On Wed, Jul

[sqlite] [System.Data.SQLite.DLL] Retrieving table names with column names

I've a table I'm calling recursively. CREATE TABLE "staff" ( `id` TEXT, `logonName` TEXT, `firstname` TEXT, `surname` TEXT, `departmentId` TEXT, `managerId` TEXT, `holidayDaysEntitlement` INTEGER, `holidayDaysTaken` REAL, PRIMARY KEY(`id`) ) managerId points to the same table, so my join is

Re: [sqlite] SQL to SQLite

Thanks, Dana. Yes, that's vb.net. -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of dmp Sent: Thursday, July 21, 2016 11:58 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQL to

Re: [sqlite] In what case will the online backup api hang for acquiring the Btree lock of the destination on-disk file?

On 22 Jul 2016, at 3:10am, Quan Yong Zhai wrote: > If remove use of shared cache from file specifications, they will be two > separated memory databases I am sorry. I didn't think of that. I agree that you need shared cache to make your program work. Simon.

Re: [sqlite] In what case will the online backup api hang for acquiring the Btree lock of the destination on-disk file?

If remove use of shared cache from file specifications, they will be two separated memory databases 发件人: Simon Slavin 发送时间: ‎2016/‎7/‎22 9:32 收件人: SQLite mailing list 主题: Re: [sqlite] In

Re: [sqlite] In what case will the online backup api hang for acquiring the Btree lock of the destination on-disk file?

On 22 Jul 2016, at 2:12am, Yihong Zhan wrote: > Thanks Quan Yhong and Stephen. Today I did more experiment and finally > narrowed down the cause (but not the root cause) of the problem. Please remove all use of shared cache from your file specifications and try again.

Re: [sqlite] In what case will the online backup api hang for acquiring the Btree lock of the destination on-disk file?

Thanks Quan Yhong and Stephen. Today I did more experiment and finally narrowed down the cause (but not the root cause) of the problem. Under the following situation the in-memory source database and the NFS disk destination database will meet deadlock across 2 threads: * Thread 1 (T1)

Re: [sqlite] SQL to SQLite

> Thanks Dana, > I think you're talking about doing what I did, but I'm not 100% sure. > Below is my solution. Could you let me know if yours is the same or > something more elegant? Hello, I'm not sure of the programming language, VBasic, ?, but generally looking through it looks like

Re: [sqlite] Error or Crash using OR in MATCH clause

Dan Thank you, and another member - Simon Slavin, for replying so quickly. It does look exactly like my problem: we'll await 3.14 with interest. Julian Dohmen | developer Evelyn Manufacturing | Alexandria & KeepnTrack 801.943.7277 ext 565 | jdoh...@companioncorp.com From: Dan Kennedy

Re: [sqlite] Error or Crash using OR in MATCH clause

On 07/21/2016 11:16 PM, Julian Dohmen wrote: I am encountering errors or crashes when using FTS5 and MATCH expressions involving OR combined with ORDER BY rank = Thanks for the detailed report. I think this one was fixed a couple of weeks after 3.13 was released:

Re: [sqlite] Error or Crash using OR in MATCH clause

In SQLite.exe [the source of the simple example I sent] PRAGMA integrity_check; Ok Julian Dohmen | developer Evelyn Manufacturing | Alexandria & KeepnTrack 801.943.7277 ext 565 | jdoh...@companioncorp.com From: Simon Slavin To: SQLite mailing list

Re: [sqlite] Error or Crash using OR in MATCH clause

On 21 Jul 2016, at 5:16pm, Julian Dohmen wrote: > SELECT * FROM VTest WHERE VTest MATCH 'wrinkle in time OR a wrinkle in time' > ORDER BY rank; > ERROR > Error: database disk image is malformed What is the result of PRAGMA integrity_check ? Simon.

[sqlite] Error or Crash using OR in MATCH clause

I am encountering errors or crashes when using FTS5 and MATCH expressions involving  OR combined with  ORDER BY rank = Simplest example [using SQLite program]: --- DROP TABLE IF EXISTS VTest; CREATE virtual TABLE VTest USING

Re: [sqlite] SQL to SQLite

On 20 Jul 2016 at 23:14, Robby Helperin wrote: > Thanks, Simon, this looks promising! > > Is this something that can be done programmatically in code (vb.net) or only > from the command prompt? > > If programmatically, could you shoot me a quick syntax example? Here's

Re: [sqlite] SQL to SQLite

Thanks, Simon, this looks promising! Is this something that can be done programmatically in code (vb.net) or only from the command prompt? If programmatically, could you shoot me a quick syntax example? -Original Message- From: sqlite-users-boun...@mailinglists.sqlite.org

Re: [sqlite] SQL to SQLite

Thanks Dana, I think you're talking about doing what I did, but I'm not 100% sure. Below is my solution. Could you let me know if yours is the same or something more elegant? If it's the same, maybe this code will be helpful for other people. How'd I do? (I'm not a pro, so go easy):

Re: [sqlite] [Spellfix] Inexplicable discrepancy concerning query results

Yes, you are right. I am using an older SQLite version in Python: 3.8.6. I will update and check that. Thanks. -Ursprüngliche Nachricht- Von: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Stephan Beal Gesendet:

Re: [sqlite] [Spellfix] Inexplicable discrepancy concerning query results

On Thu, Jul 21, 2016 at 10:54 AM, Adamek, Jochen (CQTN) < jochen.ada...@carmeq.com> wrote: > The first 4 rows have a different score and a different distance. This > discrepancy occurs with most example queries. But changing the scope value > of the query in my Python code, it changes the result,

[sqlite] [Spellfix] Inexplicable discrepancy concerning query results

Hello, using the spellfix-functionality in SQLite, I realized, that in Python, the following query leads to different results compared to the direct execution with SQLite. Code fragment in Python: qS = "select * from pf where word MATCH