[sqlite] Crash on failure in database corruption detection, and patch

Hi, oss-fuzz on GDAL has spotted a crashing bug in SQLite: https://bugs.chromium.org/p/oss-fuzz/issues/detail?id=10750 (not accessible yet) Here's the way to reproduce it: $ valgrind ~/install-sqlite-3.25.1/bin/sqlite3 corrupt.db \ "SELECT 1 FROM gpkg_tile_matrix WHERE table_name =

Re: [sqlite] Query performance slower in 3.25

On Sat, Sep 29, 2018 at 5:33 PM Richard Hipp wrote: > On 9/29/18, Stephen F. Booth wrote: > > A query that ran fine under SQLite 3.24 is substantially slower in 3.25: > > Thanks for the data sent off-list > > Your work-around is to add a plus sign "+" before the "a.id" in the > GROUP BY

[sqlite] Issue altering table name

Hi sqliters, Is this a bug? sqlite> SELECT sqlite_version(); 3.25.1 sqlite> CREATE TABLE x(f1 integer NOT NULL PRIMARY KEY); sqlite> CREATE VIEW y AS SELECT f1 AS f1 FROM x; sqlite> CREATE TRIGGER t INSTEAD OF UPDATE OF f1 ON y BEGIN UPDATE x SET f1 = NEW.f1; END; sqlite> CREATE TABLE z (f1

Re: [sqlite] Can write to database using API but get an error on writing with sqlite3.exe

Em qui, 27 de set de 2018 às 00:59, Luiz Américo escreveu: > > > Em qui, 27 de set de 2018 às 00:30, Keith Medcalf > escreveu: > >> >> Have you checked to make sure the ID that you are using (interactively) >> is permitted read/write access to the directory containing the db files and >> to the

Re: [sqlite] Is SQLITE_DETERMINISTIC ignored on an aggregate?

Bug I found in my code. Wanted to know if I need to do a recall or just fix it in the next release. Thanks! - Deon -Original Message- From: sqlite-users On Behalf Of Richard Hipp Sent: Thursday, September 27, 2018 10:25 AM To: SQLite mailing list Subject: Re: [sqlite] Is

[sqlite] Calling sqlite3_create_module from a DLL

I have a DLL that makes a series of sqlite3_create_function_v2 calls. It all works fine and the DLL is usable. I've tried adding a sqlite3_create_module into the same DLL, but I get an assert in: sqlite3_mutex_try over here: assert( sqlite3GlobalConfig.mutex.xMutexTry ); xMutexTry (really

Re: [sqlite] Database locked problem

On 30 Sep 2018, at 3:14pm, Lars Frederiksen wrote: > In fact I had the same error some time ago where the solution was to put my > database in a C-drive root folder. But that is where the db is right now!! It is very unusual under Windows to have enough privileges to change files in C:\ .

[sqlite] Database locked problem

Hello, Delphi 10.2 - FireDAC - SQLite FDConnection1 - FDQuery - DataSource - DBGrid My DBGrid is is Showing words ("gloser") from my database with SQL = 'SELECT * FROM Gloser'. BUT When I fill out som editfields and want to append the data I get the error message: Database Locked

Re: [sqlite] CLI feature request: .import option -h

A more flexible approach might be to add a way to have .import run a command and use its standard output as the data source, instead of a file. sqlite> .import "!tail +2 data.csv" mytable for this example. Lets you do basic ETL stuff for any import format without having to use temporary files or

Re: [sqlite] Crash observation in certain conditions (SQLite v.3.25.2)

I tried to make the issue more detailed (as you asked me in the beginning). Each attached file is referenced in the letter. Regards, Vladimir. сб, 29 сент. 2018 г. в 23:37, Richard Hipp : > On 9/29/18, Vlad Khokholkov wrote: > > Yes, you are right that is a link to compiler. > > Please, see

[sqlite] CLI feature request: .import option -h

Hi all, I'm sorry if I'm wrong on this list, but I have a small feature request for the CLI. I regularly import CSV data with a first line of headers into a SQLite database by using the .import command. On the first run the destination table gets automatically created. Later I get more data