This query causes segmentation fault in SQLite 3.26.0 (on macOS 10.14.1).
--
SELECT * FROM(
SELECT * FROM (SELECT 1 AS c) WHERE c IN (
SELECT (row_number() OVER()) FROM (VALUES (0))
)
)
--
However, no error occurs in the following queries. The only
Any reason I haven't heard back about this bug?
Thanks
_
From: Gene Connor [mailto:neothreeei...@hotmail.com]
Sent: Wednesday, April 30, 2014 12:21 AM
To: sqlite-users@sqlite.org
Subject: Bug in division?
SELECT DISTINCT 2/4 AS RESULT FROM TABLE;
returns 0
SELECT DISTINCT 2/4.0
SELECT DISTINCT 2/4 AS RESULT FROM TABLE;returns 0
SELECT DISTINCT 2/4.0 AS RESULT FROM TABLE;returns 0.5 (correct)
SELECT DISTINCT 2.0/4 AS RESULT FROM TABLE;returns 0.5 (correct)
SELECT DISTINCT 2.0/4.0 AS RESULT FROM TABLE;returns 0.5 (correct)
SELECT DISTINCT 2.0/4.01 AS RESULT FROM
it works with a raw DataSet or
DataTable.
Thanks,
Gene
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Like can I say Select * from
table_name except Select orderno from table_name where name = 'something'
except Select orderno from table_name where name = 'something else'
2.a) does the second except apply to the original query?
Thank you for your guidance,
Gene
-Original Message-
Fr
and 2 don't match.
Due to a limitation in my program, I have to do this in a single select
statement.
Any advice would be wonderful!
Thanks,
Gene
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
'while do.'
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Machin
Sent: Thursday, May 28, 2009 7:19 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] corrupt database recovery
On 29/05/2009 9:34 AM, Ge
Yeah.
Since my code works in blocks, read/compress/encrypt/write, loop. Almost
all the real data was being written to the compressed file, however any
finalization and flushing of the stream wasn't occurring (since the encrypt
was failing) so the last bit of any SQLite database wouldn't be
required that a DWORD boundary (blowfish) and since 0 is on such a boundary
but at the wrong end...it would fail.
I fixed the code to test for 0 bytes being read, instead of solely relying
on feof() and all seems well. :)
I would like to say thank you for all your help and advice.
Gene
out and let run on a secondary machine while you continue your main
search.
Good luck either way.
Doug
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Gene Allen
> Sent: Wednesday, May 27, 2009 4:52
rough idea on where I'm screwing up
>> the
>> database.
>>
>>
>> -Original Message-
>> From: sqlite-users-boun...@sqlite.org
>> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Elrick
>> Sent: Wednesday, May 27, 2009 12:58 PM
>> T
e Database
> Subject: Re: [sqlite] corrupt database recovery
>
> What platform? Any chance they are using a network drive?
>
>
> John
>
> Gene wrote:
>> My code is outside the database layer. So I do all my database work,
>> then
>> compres
?
John
Gene wrote:
> My code is outside the database layer. So I do all my database work, then
> compress and encrypt it. No errors are returned anywhere. I'm guessing
> that it's going to be an uninitialized variable or byte alignment problems
> somewhere.
>
> This code is r
27, 2009 10:59 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] corrupt database recovery
Gene Allen wrote:
> Ok...it's happened again and I've decided that I need to track this down
> once and for all!
>
> Here is what I'm seeing: I get errors when I do a integrit
let a dump work correctly?
Many thanks for any advice on tracking down this ugliness.
Gene
>>Output details
sqlite> pragma integrity_check;
*** in database main ***
On tree page 3 cell 26: invalid page number 469
On tree page 3 cell 26: Child page depth differs
On tree page 3 cell 27: inv
(datetime(eventtime, 'unixepoch', 'localtime'), '%W')
based on http://www.sqlite.org/lang_datefunc.html
it seemed to me that the date function needs a string so I passed in a
formatted string. No joy.
Can someone point out the error in my ways?
Thank you,
Gene
on the fly.
Thank you.
Gene
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Machin
Sent: Saturday, April 25, 2009 9:30 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] corrupt database recovery
On 26
-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John Machin
Sent: Saturday, April 25, 2009 8:15 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] corrupt database recovery
On 26/04/2009 5:47 AM, Gene wrote:
> Every now and again, we have a datab
,
Gene
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
since there wasn't 20 gazillion rows to munge thru.
Granted, I did keep my database schema flat for so I could do this easily.
I don't know if it will help you, but that's what I did.
Good luck,
Gene
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun
That is what I did, did my select into a temp table filtered and sorted just
the way I wanted it and used the rowid since it would match the index in the
list control.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Nicolas
Is there anyway to test for this condition so I handle it properly?
Gene Allen
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I have a large sqlite database and I'm inserting a bunch of records into it.
My question is this..shouldn't the -journal be getting larger since I've
wrapped all the inserts inside a transaction?
I'm watching the file sizes change and the main file is getting larger, but
the journal files is
Sorry, mispost
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Companion on the start menu, it will package up your
rules and FTP them to me.
Gene
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
; 1
) as multiused
on Upper(ar.filename) = multiused.filename
On a database of 2.5 million records, it ran over 11 hours before I killed
it. On smaller datasets it works fine.
Any Advice?
Gene
___
sqlite-users mailing list
sqlite-us
te> attach 'c:\test\b.db3' as toMerge;
sqlite> insert into AuditRecords select * from toMerge.AuditRecords;
sqlite> detach database toMerge;
Is there a faster/better way to do this? Should I wrap the insert in a
transaction or something?
27 matches
Mail list logo