[sqlite] drop table if link view error pragma_table_info view

2019-05-20 Thread Kirill
Hello If you delete a table that is associated with a view. An error occurs when calling pragma_table_info Example: CREATE TABLE COMPANY( ID INT PRIMARY KEY NOT NULL, NAME TEXTNOT NULL, AGEINT NOT NULL, ADDRESSCHAR(50), SALARY REAL

Re: [sqlite] Bug: sqlite ARM endian problem

2019-05-20 Thread Sebastian Kemper
On Mon, May 20, 2019 at 02:46:47PM -0400, Richard Hipp wrote: > On 5/20/19, Sebastian Kemper wrote: > > In OpenWrt's forum a user raised a topic about being unable to use > > Asterisk on his armeb xscale device. > > Please download a tarball of the latest trunk version of SQLite > (check-in

Re: [sqlite] Bug: sqlite ARM endian problem

2019-05-20 Thread Richard Hipp
On 5/20/19, Sebastian Kemper wrote: > In OpenWrt's forum a user raised a topic about being unable to use > Asterisk on his armeb xscale device. Please download a tarball of the latest trunk version of SQLite (check-in https://www.sqlite.org/src/info/b7aad929619f7043 or later) and verify that it

[sqlite] Bug: sqlite ARM endian problem

2019-05-20 Thread Sebastian Kemper
Hello list, In OpenWrt's forum a user raised a topic about being unable to use Asterisk on his armeb xscale device. We narrowed it down to sqlite. Asterisk was unable to insert a simple table. Couldn't prepare statement 'CREATE TABLE IF NOT EXISTS astdb(key VARCHAR(256), value VARCHAR(256),

[sqlite] Segmentation fault can result from setting error message parameter to NULL when calling sqlite3session_diff

2019-05-20 Thread Micah Moore
Hello, We have found a minor bug in the session extension. The problem can occur in sqlite3session_diff, when there is a table schema mismatch, if no error pointer is provided. According to the documentation of sqlite3session_diff: > ** If the operation successful, SQLITE_OK is returned.

Re: [sqlite] readfile() enhancement request

2019-05-20 Thread Jose Isaias Cabrera
Rowan Worth, on Monday, May 20, 2019 03:02 AM, wrote... >On Sat, 18 May 2019 at 00:34, Tony Papadimitriou wrote: > >> It’s quite often (for me, at least) the case I need to do something like >> this from the command line: >> >> >sqlite3.exe my.db “insert into t values(‘simple field’,’multi-line

Re: [sqlite] readfile() enhancement request

2019-05-20 Thread Rowan Worth
On Sat, 18 May 2019 at 00:34, Tony Papadimitriou wrote: > It’s quite often (for me, at least) the case I need to do something like > this from the command line: > > >sqlite3.exe my.db “insert into t values(‘simple field’,’multi-line text > copied from some other app’) > > The problem is the