[sqlite] Sqlite subqueries

2015-02-24 Thread Paul Sanderson
Search the mail list for "Column name as a variable" for a similar discussion Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work

[sqlite] Appropriate Uses For SQLite

2015-02-24 Thread James K. Lowden
On Thu, 19 Feb 2015 07:21:17 -0800 Roger Binns wrote: > There is a lot that would have to be done with it: > > - - make the IR stable across releases > - - add more general instructions beyond only what is needed for SQL > - - expose an API that takes the IR > - - possibly redesign it to make

[sqlite] Sqlite subqueries

2015-02-24 Thread Igor Tandetnik
On 2/24/2015 8:42 PM, russ lyttle wrote: > The 'a' table defines spaces to be controlled, the 'b' tables the > control schedules and parameters. > It would not be unreasonable to assume the 'a' table has >100 rows. > Each row in the 'a' table is associated with 3 'b' tables, all the names > known

[sqlite] Complex insert query to normalised database

2015-02-24 Thread James K. Lowden
On Wed, 18 Feb 2015 14:16:32 +0100 Staffan Tylen wrote: > I suspect that this is wrong as nobody has suggested it but isn't > this what triggers are meant to solve? Triggers were invented before SQL defined what we now call Declarative Referential Integrity (DRI). It is (I'm going to say)

[sqlite] Sqlite subqueries

2015-02-24 Thread russ lyttle
ng list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 473 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150224/c2381c45/attachment.pgp>

[sqlite] Behaviour when subquery behind comparison operator in where-clause returns empty result

2015-02-24 Thread James K. Lowden
On Wed, 18 Feb 2015 08:55:37 +0100 gunnar wrote: instead of > SELECT * > FROM ordercallback > WHERE account=@ACCOUNT >AND cb_seq_num>( > SELECT cb_seq_num > FROM ordercallback > WHERE cb_uuid=@CBUUID); SELECT * FROM ordercallback ocb WHERE account=@ACCOUNT AND exists (

[sqlite] Database connection from within Visual Studio

2015-02-24 Thread Erik Ejlskov Jensen
Maybe a smaller number of downloads and a more readable download page would improve the user experience here. Mvh / Regards Erik Ejlskov Jensen http://twitter.com/erikej

[sqlite] Err

2015-02-24 Thread Jonathan Camilleri
Unusual output when trying a SQL Select statement from the command line SQLite version 3.8.8.2 2015-01-30 14:30:45 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .open taxi-invoicing-db sqlite> .stats on

[sqlite] Sqlite subqueries

2015-02-24 Thread Igor Tandetnik
On 2/24/2015 4:37 PM, russ lyttle wrote: > I'm trying to create a field in a table to hold the name of a second > table, then retrieve that name for use. You can't. SQL doesn't work this way. Reconsider your design. -- Igor Tandetnik

[sqlite] Sqlite subqueries

2015-02-24 Thread russ lyttle
--- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 473 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150224/3389318b/attachment.pgp>

[sqlite] outer join/order by bug?

2015-02-24 Thread Simon Davies
On 24 February 2015 at 15:20, Simon Davies wrote: > On 24 February 2015 at 15:02, Grisha Vinevich wrote: >> There seems to be some problem with left outer join in Windows version of >> sqlite3. >> I try to use the following (simplified) schema: >> . . . >> When I run this on

[sqlite] outer join/order by bug?

2015-02-24 Thread Simon Davies
On 24 February 2015 at 15:02, Grisha Vinevich wrote: > There seems to be some problem with left outer join in Windows version of > sqlite3. > I try to use the following (simplified) schema: > > CREATE TABLE "A" ( "Name" text); > CREATE TABLE "Items" ( "ItemName" text , "Name" text ); > INSERT

[sqlite] outer join/order by bug?

2015-02-24 Thread Grisha Vinevich
There seems to be some problem with left outer join in Windows version of sqlite3. I try to use the following (simplified) schema: CREATE TABLE "A" ( "Name" text); CREATE TABLE "Items" ( "ItemName" text , "Name" text ); INSERT INTO "Items" VALUES('Item1','Parent'); INSERT INTO "Items"

[sqlite] Using incremental BLOB functions against a BLOB column in a virtual table

2015-02-24 Thread Evans, Randall
Thanks to Richard Hipp and Hick Gunter for their replies on this topic. Given that support for support for BLOBs in virtual tables differs from that for BLOBs in physical tables, is there any method or function available to the sqlite3_x() caller that can be used to distinguish tables

[sqlite] Err

2015-02-24 Thread Igor Tandetnik
On 2/24/2015 12:42 PM, Jonathan Camilleri wrote: > Unusual output when trying a SQL Select statement from the command line So what's unusual about it? What specifically seems to be the problem? -- Igor Tandetnik

[sqlite] sqlite doesn't log reason for failing to open WAL file

2015-02-24 Thread Török Edwin
Hi, When SQLite fails to create a file it tries reopening readonly and only if that fails too it logs the error. However by that time the original error (for file creation) is lost. Testcase: $ cat >testcase.sh

[sqlite] Database connection from within Visual Studio

2015-02-24 Thread Joe Mistachkin
Erik Ejlskov Jensen wrote: > > Maybe a smaller number of downloads and a more readable download page > would improve the user experience here. > Various parties have, at one time or another, requested each and every one of the release package "variations" listed on the download page. Do you

[sqlite] outer join/order by bug?

2015-02-24 Thread Richard Hipp
On 2/24/15, Grisha Vinevich wrote: > There seems to be some problem with left outer join in Windows version of > sqlite3. Thanks for the report. This appears to be a query planner bug introduced for SQLite version 3.8.8 by the check-in at https://www.sqlite.org/src/timeline?c=d95d03 We'll

[sqlite] Is readline ubiquitous on 32-bit x86 Linux?

2015-02-24 Thread Andreas Kupries
A possible (and small alternative) to readline would be Antirez "linenoise". Steve Bennet's fork adds windows portability and some other things. https://github.com/antirez/linenoise https://github.com/msteveb/linenoise That is small enough to be directly built as part of the shell, I

[sqlite] Using incremental BLOB functions against a BLOB column in a virtual table

2015-02-24 Thread Hick Gunter
Incremental BLOB I/O makes certain assertions that cannot be guaranteed (much less verified at runtime) for virtual tables (e.g. 1: unique rowids that 2: can be used for access) and needs to know how to read/write them (which is under the control of the virtual table author).