Re: [sqlite] Strange SQLite bug(?!)

HI, it seems to be that I am not allowed to add zip files to these e-mails. This is what I am doing to create the database: ExecuteStatement(databaseHandle,"CREATE TABLE A(ID INTEGER PRIMARY KEY,AnotherID INTEGER, Notes TEXT);"); ExecuteStatement(databaseHandle,

Re: [sqlite] Strange SQLite bug(?!)

Hi, I have added a database but it seems to be that the zip file got lost. Regards, Hartwig > Am 2016-08-02 um 01:13 schrieb Richard Hipp : > > Do you have a database schema to go with your sample program? > > On 8/1/16, skywind mailing lists > wrote: >> Hi, >

Re: [sqlite] Strange SQLite bug(?!)

Do you have a database schema to go with your sample program? On 8/1/16, skywind mailing lists wrote: > Hi, > > I have got a database that works using SQLite 3.7.7 but not with version > SQLite 3.13.0. I get the assertion > > Assertion failed: (((Fts3Table *)pVtab)->mxSavepoint < iSavepoint), fun

[sqlite] Strange SQLite bug(?!)

Hi, I have got a database that works using SQLite 3.7.7 but not with version SQLite 3.13.0. I get the assertion Assertion failed: (((Fts3Table *)pVtab)->mxSavepoint < iSavepoint), function fts3SavepointMethod, file /.../sqlite/sqlite3.c, line 144649. I have compiled the SQLite amalgamation wit

Re: [sqlite] Compiling issue

Thanks Richard. Regards, Miroslav On 1.8.2016. 20:38, Richard Hipp wrote: On 8/1/16, Miroslav Rajcic wrote: Hello, just tried to compile "sqlite-snapshot-201607290155.tar.gz" (amalgam) on OS X and I got these errors: sqlite/sqlite3.c:108772: error: redefinition of typedef 'sqlite3_api_rou

Re: [sqlite] Compiling issue

On 8/1/16, Miroslav Rajcic wrote: > Hello, > > just tried to compile "sqlite-snapshot-201607290155.tar.gz" (amalgam) on > OS X and I got these errors: > > sqlite/sqlite3.c:108772: error: redefinition of typedef > 'sqlite3_api_routines' > sqlite/sqlite3.c:5970: error: previous declaration of > 'sql

Re: [sqlite] Compiling issue

Sorry for the typo, correct sentence would be: Removing the definition at line 108772 solved the problem. Regards, Miroslav On 1.8.2016. 20:25, Miroslav Rajcic wrote: Hello, just tried to compile "sqlite-snapshot-201607290155.tar.gz" (amalgam) on OS X and I got these errors: sqlite/sqlite

[sqlite] Compiling issue

Hello, just tried to compile "sqlite-snapshot-201607290155.tar.gz" (amalgam) on OS X and I got these errors: sqlite/sqlite3.c:108772: error: redefinition of typedef 'sqlite3_api_routines' sqlite/sqlite3.c:5970: error: previous declaration of 'sqlite3_api_routines' was here Removing the err

[sqlite] Testing begins on the SQLite "pi" release

After various unexpected delays, testing on the SQLite "pi" release (version 3.14) has begun. You can follow the progress at https://www.sqlite.org/checklists/314/index - the release will occur when all checklist items go green. Thanks everyone for testing and feedback. Many of your suggesti

Re: [sqlite] csv.c - Unicode filename failure (Windows, at least)

On 1 Aug 2016, at 8:28am, Ralf Junker wrote: > At current, the csv extension fails to open Unicode file names like > > CREATE VIRTUAL TABLE t1 USING csv( >filename = "äöü.csv"); > > because internally the filename is passed to fopen() as UTF-8: > > http://www.sqlite.org/src/artifact/816

[sqlite] #include - angle brackets instead of quotation marks

The files csv.c and vfsstat.c use #include with angle brackets http://www.sqlite.org/src/artifact/816a3715356e4210?ln=42 http://www.sqlite.org/src/artifact/bf10ef0bc51e1ad6?ln=17 where quotation marks are otherwise used throughout SQLite, i.e. http://www.sqlite.org/src/artifact/16c1b

[sqlite] csv.c - Unicode filename failure (Windows, at least)

At current, the csv extension fails to open Unicode file names like CREATE VIRTUAL TABLE t1 USING csv( filename = "äöü.csv"); because internally the filename is passed to fopen() as UTF-8: http://www.sqlite.org/src/artifact/816a3715356e4210?ln=131 However, fopen() does not honor UTF-8,