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

[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 there any mention about the additional parameter T when setting the
result here:

https://sqlite.org/draft/c3ref/result_blob.html

Nor here:

https://sqlite.org/draft/c3ref/bind_blob.html

I suppose that's consistent but it would be nice to read about the new API.

The only clue about how it works is a brief statement in change header of
remember.c:

"The pointer type is a string that must compare equal using strcmp() or
else the pointer comes through as a NULL."

On Thu, Jul 13, 2017 at 11:49 AM, Richard Hipp  wrote:

> The 3.20.0 release of SQLite is expected in about a week.  Please
> report any issues that you have with the beta as soon as possible.
>
> Code is available in the "prerelease snapshot" at
> https://sqlite.org/download.html
>
> An overview of changes is at https://sqlite.org/draft/
> releaselog/3_20_0.html
>
> You can send issues to this email list, or directly to me.
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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 readline.
(Doing so will require manual changes to the Makefile as it does not
appear to be supported by ./configure at this time - something that we
should fix for the next release.)

I still power up a PPC mac from time to time in order to verify that
SQLite works on big-endian platforms.  But it is painfully slow.  Why
are you still using a PPC mac?


Thanks for pointing this out and I managed to use linenoise from 
https://github.com/antirez/linenoise
I was pleased to find that the use of the linenoise library is already  
anticipated in shell.c (HAVE_LINENOISE)

Indeed only Makefile need to be changed manually aftter .configure.
The difference in size of the library source code is impressing:

$ du -hs readline-7.0/
 11Mreadline-7.0/
$ du -hs linenoise/
144Klinenoise/

Point about new PC taken. Even download from github seems not to work  
on a PPC mac.

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Disable trigger?

[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  t...@qvgps.com
**   +264 (0)81 3329923
**   +49  (0)6182 8492599
***/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[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
0,id,INTEGER,1,,1





On Sun, Jul 16, 2017 at 12:19 AM, gwenn  wrote:

> 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) VALUES (NULL);
> sqlite> SELECT rowid, id FROM test;
> id|id
> 1|1
>
> Regards.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] PRAGMA table_info and not nullable rowid alias

[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) VALUES (NULL);
sqlite> SELECT rowid, id FROM test;
id|id
1|1

Regards.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users