Re: [sqlite] Help with assigning default values...

Thanks. Yes, saw it. -Original Message- From: Simon Slavin Sent: Tuesday, December 20, 2016 11:54 PM To: SQLite mailing list ; jic...@barrioinvi.net Subject: Re: [sqlite] Help with assigning default values... On 20 Dec 2016, at 9:37pm, jose isaias cabrera wrote: Trying to learn

Re: [sqlite] Help with assigning default values...

On 20 Dec 2016, at 9:37pm, jose isaias cabrera wrote: > Trying to learn or understand constraints. Will you please look at the > following... Answers were posted to the mailing list. If you’re not seeing them there’s something wrong with your subscription. Simon. __

Re: [sqlite] Incorrect calculation in sqlite3VdbeAllocUnpackedRecord?

On 12/20/16, Alexey Romanov wrote: > It looks to me like the test in line 3512 of > http://www.sqlite.org/src/annotate?filename=src/vdbeaux.c&checkin=8165f88bb1d40693 > should use `szSpace - off` instead of +, because that's the remaining space > after &pSpace[off] used in the else branch. > I th

[sqlite] Help with assigning default values...

Trying to learn or understand constraints. Will you please look at the following... sqlite> PRAGMA foreign_keys=1; sqlite> BEGIN TRANSACTION; sqlite> DROP TABLE IF EXISTS Years; sqlite> CREATE TABLE Years ...> ( ...> IDYear INTEGER PRIMARY KEY, ...> Year TEXT DEFAULT '1980'

[sqlite] Incorrect calculation in sqlite3VdbeAllocUnpackedRecord?

It looks to me like the test in line 3512 of http://www.sqlite.org/src/annotate?filename=src/vdbeaux.c&checkin=8165f88bb1d40693 should use `szSpace - off` instead of +, because that's the remaining space after &pSpace[off] used in the else branch. I am unsure about this because I would expect such

Re: [sqlite] Assigning default values...

FYI, the syntax of the INSERT statement is described here: http://www.sqlite.org/lang_insert.html and this paragraph describes your situation exactly: • The first form (with the "VALUES" keyword) creates one or more new rows in an existing table.

Re: [sqlite] Assigning default values...

On 20 Dec 2016, at 8:19pm, jic...@yahoo.com wrote: > sqlite> INSERT INTO Years VALUES(4); > Error: table YEARS has 2 columns but 1 values were supplied > > […] > > How can I make DEFAULT work? INSERT INTO Years (IDYear) VALUES (4); Simon. ___ sqlite

[sqlite] Assigning default values...

Trying to learn or understand constraints. Please take a look at the following… sqlite> PRAGMA foreign_keys=1; sqlite> BEGIN TRANSACTION; sqlite> DROP TABLE IF EXISTS Years; sqlite> CREATE TABLE Years ...> ( ...> IDYear INTEGER PRIMARY KEY, ...> Year TEXT DEFAULT '1980' ...> ); sqlit

Re: [sqlite] Performance degradation 3.10->3.13

On 12/20/16, Tobel, Ralf wrote: > Hello Everybody, > > I’m facing a strange performance degradation from SQLite 3.10 to 3.13. > The code posted below is around 10 times slower in a release build for > 64bit. > Two Visual Studio projects where the problem can be reproduced can be > downloaded here:

Re: [sqlite] Weird chars inserted

Ariel, Keith, Rowan,  apologies, I re-ran the queries a few times, and I decided to include "rowid" to keep track of the changes. The experiments were conducted by cut-and-paste of the í character from the email, hence UTF8, and using x'...' for inserts and concats. Note, I use sqlite3 shell

[sqlite] Performance degradation 3.10->3.13

Hello Everybody, I’m facing a strange performance degradation from SQLite 3.10 to 3.13. The code posted below is around 10 times slower in a release build for 64bit. Two Visual Studio projects where the problem can be reproduced can be downloaded here: https://drive.google.com/open?id=0B0DoU-QPeg

Re: [sqlite] Unexpected 'no such column' with expression in subquery ORDER BY

Keith. You are correct. The online help is the only design document. Furthermore, from my observations about this forum, the intrepid Dr. Hipp will often never weigh in to disclose the full design or thought process of the intended product behavior. You can put the arbitrary outer column expres

[sqlite] Failed tests on ppc64

Hi everyone, I hit some failures in fts3conf.test while buidling latest version of sqlite for the ppc64 architecture: ! fts3conf-3.1 expected: [X'01000200'] ! fts3conf-3.1 got: [X'00010002'] ! fts3conf-3.2 expected: [X'02000300'] ! fts3conf-3.2 got: [X'000