On 10/26/16, Smith, Randall wrote:
> This question may be off-topic for this list, since it deals with using
> SQLite in a specific setting rather than SQLite itself. Apologies if so.
> Thanks very much if anyone can provide any insight.
>
> I am one of the hapless souls who need access to SQLite
On Wednesday, 26 October, 2016 19:05, Smith, Randall
wrote:
> This question may be off-topic for this list, since it deals with using
> SQLite in a specific setting rather than SQLite itself. Apologies if so.
> Thanks very much if anyone can provide any insight.
> I am one of the hapless sou
This question may be off-topic for this list, since it deals with using SQLite
in a specific setting rather than SQLite itself. Apologies if so. Thanks very
much if anyone can provide any insight.
I am one of the hapless souls who need access to SQLite's CTE capabilities
(introduced in v3.8.3
On 10/26/16, Ján Hric wrote:
> Hello
> I would like to report a bug in the latest version of SQLite (3.15.0).
Thanks for a very clear and succinct bug report. Well done!
The ticket is here:
https://www.sqlite.org/src/tktview/fef4bb4bd9185ec8f18d9912abb444da61d02ff2
>
> Description:
> If compa
Hello
I would like to report a bug in the latest version of SQLite (3.15.0).
Description:
If comparison of row-values is used in the expression of a LEFT JOIN clause
and no mach is found, instead of one row with values from the left-hand
table, no rows are returned.
Example code:
CREATE TABLE t1
On 10/25/2016 01:25 AM, Christian Czech wrote:
We have a problem with the latest stable release of SQLite. When
compiled for 32 bit under windows and vacuum a database file larger
than 2GB, memory storage usage gets up to 2GB and than vacuum crashes
with not enough memory. It seems that a temp
On 10/26/2016 10:53 AM, Jeff Archer wrote:
Hi and thanks in advance for your help.
I have a table of words and counts and I am trying to make a query which
sorts in descending order of count but with each group of words that have
the same count sorted alphabetically.
MY table:
CREATE TABLE word
On 2016/10/26 4:53 PM, Jeff Archer wrote:
Hi and thanks in advance for your help.
I have a table of words and counts and I am trying to make a query which
sorts in descending order of count but with each group of words that have
the same count sorted alphabetically.
MY table:
CREATE TABLE wor
Hi and thanks in advance for your help.
I have a table of words and counts and I am trying to make a query which
sorts in descending order of count but with each group of words that have
the same count sorted alphabetically.
MY table:
CREATE TABLE words
(id INTEGER PRIMARY KEY AUTOINCREMENT
,cnt
On 2016/10/25 5:44 PM, Bart Smissaert wrote:
Try this:
UPDATE mytable
SET myfield1 = (SELECT 1 from mytable
ORDER BY EXISTS (SELECT 1
WHERE mytable.myfield2 = 1
)
)
RBS
Thing
I've gotten this with this version and with some previous ones (Windows 7).
Closest I was ever able to guess as to what was going on was that Windows was
memory mapping the file even though I had the CLI compiled with
SQLITE_DEFAULT_MMAP_SIZE=0, and SQLITE_MAX_MMAP_SIZE=0. (First should be
usel
11 matches
Mail list logo