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

2016-08-01 Thread skywind mailing lists
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

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

2016-08-01 Thread Richard Hipp
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

[sqlite] Strange SQLite bug(?!)

2016-08-01 Thread skywind mailing lists
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

Re: [sqlite] Compiling issue

2016-08-01 Thread Miroslav Rajcic
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

Re: [sqlite] Compiling issue

2016-08-01 Thread Richard Hipp
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:

Re: [sqlite] Compiling issue

2016-08-01 Thread Miroslav Rajcic
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] Compiling issue

2016-08-01 Thread Miroslav Rajcic
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

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

2016-08-01 Thread Richard Hipp
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

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

2016-08-01 Thread Simon Slavin
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: > >

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

2016-08-01 Thread Ralf Junker
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.

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

2016-08-01 Thread Ralf Junker
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