Re: [sqlite] [EXTERNAL] Internal Logic Error

You are not showing your schema or the statement you are executing. Also, Sqlite3_StdCall.dll is not maintained by the Sqlite development team. Can you reproduce the error while executing your statement in the sqlite3 shell? -Ursprüngliche Nachricht- Von: sqlite-users

Re: [sqlite] [EXTERNAL] Does mmap increase PSS?

Your guess is wrong. "pragma cache_size=2000" will limit the internal page cache to 2000 PAGES (of whatever page size the db file has) PER OPEN FILE. To set a limit of 2000kBytes PER OPEN FILE, use "pragma cache_size=-2000". The page cache is process private memory. Whatever portion is

Re: [sqlite] [EXTERNAL] Internal Logic Error

Deeper research revealed that the DLL Error is raised by the Excel error object. I have passed the query on to the support email at GitHub. Thanks for your reply. Keith Hoar kah...@zhetosoft.com WWW.Zhetosoft.com On Tue, 10 Apr 2018 23:03:37 -0700 Hick Gunter

Re: [sqlite] Help using 'attach database' or Why is this an error?

Try this: attach database 'test.db' as con2; On 4/11/18, 9:51 AM, "sqlite-users on behalf of J Decker" wrote: When I attempt to use attach database I get an error about 'no such column'

[sqlite] Insert with foreign keys enabled prevented in transaction

I was trying to debug this set of commands, which is actually run on two connections within the same process... but that detail apparently doesn't matter. PRAGMA foreign_keys=on; create table `option4_name` (`name_id` char(36) NOT NULL,`name` varchar(255) NOT NULL default

Re: [sqlite] Insert with foreign keys enabled prevented in transaction

J Decker wrote: > foreign key mismatch - "option4_map" referencing "option4_name" > > create table `option4_name` (`name_id` char(36) NOT NULL, > ... > create table `option4_map` (... > FOREIGN KEY (`name_id`) REFERENCES `option4_name`(`name_id`) name_id in the parent table must

Re: [sqlite] Help using 'attach database' or Why is this an error?

On Wed, Apr 11, 2018 at 7:54 AM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > Try this: > > attach database 'test.db' as con2; > ahh that makes sense. I'll split this into a separte thread for the real issue... > > On 4/11/18, 9:51 AM, "sqlite-users on behalf of J Decker" < >

[sqlite] Help using 'attach database' or Why is this an error?

When I attempt to use attach database I get an error about 'no such column' M:\sqlite3\sqlite3\build>sqlite3 test.db SQLite version 3.23.0 2018-04-02 11:04:16es Enter ".help" for usage hints. sqlite> attach database test.db as con2; Error: no such column: test.db sqlite> I was trying to debug

Re: [sqlite] Constraints must be defined last?

On 11 Apr 2018, at 6:41pm, J Decker wrote: > Is there something about SQL that requires constraints to follow all column > definitions? I don't know if it applies to SQL in general, but it is in SQLite: The table constraints

Re: [sqlite] Constraints must be defined last?

On 11/04/2018 19:45, Simon Slavin wrote: On 11 Apr 2018, at 6:41pm, J Decker wrote: Is there something about SQL that requires constraints to follow all column definitions? I don't know if it applies to SQL in general, but it is in SQLite:

[sqlite] Constraints must be defined last?

Is there something about SQL that requires constraints to follow all column definitions? sqlite> create table `option4_blobs` (`option_id` char(36) default '0', CONSTRAINT `value_id` UNIQUE (`option_id`),`binary` blob, FOREIGN KEY (`option_id`) REFERENCES `option4_map`(`option_id`)ON UPDATE

Re: [sqlite] UPPER function depends on Locale?

Simon Slavin-3 wrote > https://www.sqlite.org/src/artifact?ci=trunkfilename=ext/icu/README.txt; However the example described here is a little bit simplistic: lower('I', 'en_us') -> 'i' lower('I', 'tr_tr') -> 'ı' (small dotless i) You depend on the encoding of the text editor,

Re: [sqlite] Constraining FTS5 results based on offsets()

Thank you Dan! This should be much easier to implement than a full blown virtual table, but as far as I can tell(as I've mentioned, I'm not an expert in this) it doesn't do exactly what I want. I need all the locations of the search phrases, subject to the attribute constraint, in a document,

[sqlite] Does mmap increase PSS?

Hi, I guess that "cache_size=2000" means PSS of my process will always less than 2M. But, when I use PRAMGA mmap_size to enable mmap, I found the PSS of my process will almost the same as my db. Is that correct? -- Sent from: http://sqlite.1065341.n5.nabble.com/