On 14/12/2014, at 4:17 am, Simon Slavin slav...@bigfraud.org wrote:
On 13 Dec 2014, at 12:38pm, Richard Hipp d...@sqlite.org wrote:
Also, if there are indices available, SQLite attempts to count the smallest
index (it has to guess at which is the smallest by looking at the number
and
On 30/09/2014, at 12:04 pm, Paul Sanderson sandersonforens...@gmail.com wrote:
I two tables of the form
create table1 (person1 text, person2 text)
create table2 (person text, picture blob)
Is it possible to create a join so I can get a resultant dataset of the form
person1,
I get similar results on OS X 10.9.4 if I try to use the version of SQLite
supplied with the operating system (3.7.13) to import a CSV.
The simple .mode csv and .import filename tab1 method works if I run the
copy of SQLite 3.8.5 I built myself from the source code, or if I use the Mac
OS X
On 24/07/2014, at 10:15 pm, Peter Waller pe...@scraperwiki.com wrote:
I too am sad that CRLF is mandated in the specification and still in wide use
because of Windows.
It may be nothing to do with Windows. CRLF is the Internet standard for the end
of a line, as mentioned in RFC2234 and
In this case, sqlite3VdbeAllocUnpackedRecord is called with pSpace = 0 and
szSpace = 0.
The calculated value of nOff will also be 0, since pSpace is 0. nByte must be
greater than zero, as it is the sum of two positive terms.
Therefore the test if( nByteszSpace+nOff ) will be true, and the code
of the clues.
--
David Empson
demp...@emptech.co.nz
Snail mail: P.O. Box 27-103, Wellington 6141, New Zealand
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 18/06/2014, at 5:54 pm, David M. Cotter d...@kjams.com wrote:
i have a table with a numeric column (not the key column)
i want to obtain from this table a list of unique numbers appearing in that
one column
some cells in the column may have nothing, some may have duplicate numbers eg:
On 16/06/2014, at 11:36 pm, Richard Hipp d...@sqlite.org wrote:
On Mon, Jun 16, 2014 at 5:07 AM, David Empson demp...@emptech.co.nz wrote:
It appears SQLite 3.8.1 removed an optimisation where earlier versions of
the query planner were checking for two or more lower bound comparisons
I've recently noticed a major drop in performance in one part of our main
application at work, and have managed to track it down to a change in recent
versions of SQLite.
We are storing a log in a simple SQLite table, and have a viewing screen which
allows the user to browse through the log.
On 16/06/2014, at 11:36 pm, Richard Hipp d...@sqlite.org wrote:
On Mon, Jun 16, 2014 at 5:07 AM, David Empson demp...@emptech.co.nz wrote:
It appears SQLite 3.8.1 removed an optimisation where earlier versions of
the query planner were checking for two or more lower bound comparisons
.
--
David Empson
demp...@emptech.co.nz
Snail mail: P.O. Box 27-103, Wellington 6141, New Zealand
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 10/04/2013, at 11:06 AM, Nico Williams n...@cryptonector.com wrote:
On Mon, Apr 8, 2013 at 8:52 AM, Alexandr Němec a.ne...@atlas.cz wrote:
The first warning is harmless and results from a prior datatype change.
Dan has already fixed that one. The other four appear to be due to an
MSVC
12 matches
Mail list logo