Re: [sqlite] Version 3.20.0 coming soon...

2017-07-16 Thread petern
Missing documentation or wrong extension source? https://www.sqlite.org/src/file/ext/misc/remember.c line 51: -> ptr = sqlite3_value_pointer(argv[1], "carray"); This signature, 'void* sqlite3_value_pointer(V,T)' , is not documented here: https://sqlite.org/draft/c3ref/value_blob.html Nor is

Re: [sqlite] Version 3.20.0 coming soon... _rl_completion_matches undefined on old iMac

2017-07-16 Thread E.Pasma
Richard Hipp wrote: E.Pasma wrote: Is there any otrher choice except ./configure --disable-readline. Other options: (1) You can upgrade the readline library on your PPC to something more recent that supports tab completion. (2) You can compile the shell using linenoise instead of

[sqlite] Disable trigger?

2017-07-16 Thread Thomas Flemming
Is there a way in SQLite, to temporary disable and enable a trigger without dropping and recreating ? Tom -- / ** Flemming Software Development CC ** Thomas Flemming ** PO Box 81244 ** Windhoek, Namibia ** http://www.quovadis-gps.com ** mail

Re: [sqlite] PRAGMA table_info and not nullable rowid alias

2017-07-16 Thread petern
That's interesting. Apparentely PRAGMA table_info() reports the declared column type not the operational column type. sqlite> CREATE TABLE test (id INTEGER PRIMARY KEY NOT NULL); Run Time: real 0.454 user 0.00 sys 0.00 sqlite> PRAGMA table_info(test); cid,name,type,notnull,dflt_value,pk

[sqlite] PRAGMA table_info and not nullable rowid alias

2017-07-16 Thread gwenn
Hello, PRAGMA table_info reports that a rowid alias is nullable: sqlite> .headers on sqlite> CREATE TABLE test (id INTEGER PRIMARY KEY); sqlite> pragma table_info("test"); cid|name|type|notnull|dflt_value|pk 0|id|INTEGER|0||1 sqilte> --0|id|INTEGER|1||1 expected sqlite> INSERT INTO test (id)