Documentation bug: remove gmane address on Bug Report page

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Documentation bug: remove gmane address on Bug Report page

積丹尼 Dan Jacobson
Please fix
https://www.sqlite.org/src/wiki?name=Bug+Reports .
It says to see
http://news.gmane.org/gmane.comp.db.sqlite.general
but that page is no longer working.
Maybe tell them to see
http://sqlite.1065341.n5.nabble.com/
(But I don't know if that is the canonical URL.)
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Documentation bug: remove gmane address on Bug Report page

積丹尼 Dan Jacobson
By the way, you might want to unlock
http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/
as one can read it on Nabble anyway.
Then you could just tell users to see the Archives.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Documentation bug: cli.html#csv_import should warn about NULLs

積丹尼 Dan Jacobson
In reply to this post by 積丹尼 Dan Jacobson
sqlite3-doc/cli.html#csv_import should warn
that there is no way to preserve NULL with CSV.

You can even add a proof if you want,

$ sqlite3 mydata.db<<EOF
CREATE TABLE memos(a);
INSERT INTO memos VALUES(NULL);
.mode csv
.once mmm.csv
SELECT * FROM memos;
.import mmm.csv memos
.dump
EOF

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE memos(a);
INSERT INTO memos VALUES(NULL);
INSERT INTO memos VALUES('');
COMMIT;

(Thus no way to do "If no ROWID is specified on the insert, or if the
specified ROWID has a value of NULL, then an appropriate ROWID is
created automatically" mentioned in
file:///usr/share/doc/sqlite3-doc/autoinc.html )
https://www.google.com/search?q=CSV+NULL+SQLite
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Documentation bug: lang_insert.html needs examples

積丹尼 Dan Jacobson
In reply to this post by 積丹尼 Dan Jacobson
file:///usr/share/doc/sqlite3-doc/lang_insert.html says
"The INSERT statement comes in three basic forms."
OK, but you need to add examples of all three.
E.g., you say

"The first form (with the "VALUES" keyword)"
well there is no example.

So near the top of the article add this synopsis of the three basic forms,
INSERT INTO moz_cookies VALUES(1,'Bart',12);
INSERT INTO moz_cookies SELECT ..... ????
INSERT INTO moz_cookies DEFAUT_VALUES ???
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Documentation bug: lang_insert.html needs examples

Simon Slavin-3


On 2 Jul 2017, at 12:08am, 積丹尼 Dan Jacobson <[hidden email]> wrote:

> So near the top of the article add this synopsis of the three basic forms,
> INSERT INTO moz_cookies VALUES(1,'Bart',12);
> INSERT INTO moz_cookies SELECT ..... ????
> INSERT INTO moz_cookies DEFAUT_VALUES ???

If those are "the" three forms, there are actually four and there needs to be one for

INSERT INTO moz_cookies (id_number, name, age) VALUES(1,'Bart',12);

or whatever the columns are actually called.

Simon.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

sorry I glued these all into the same thread

積丹尼 Dan Jacobson
In reply to this post by 積丹尼 Dan Jacobson
Sorry I glued these all into the same thread. I'll be more careful next time.
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Documentation bug: lang_insert.html needs examples

Keith Medcalf
In reply to this post by Simon Slavin-3

Actually there would be six since you can either specify or omit the columns list for each ...

--
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı

> -----Original Message-----
> From: sqlite-users [mailto:[hidden email]]
> On Behalf Of Simon Slavin
> Sent: Saturday, 1 July, 2017 17:14
> To: SQLite mailing list
> Subject: Re: [sqlite] Documentation bug: lang_insert.html needs examples
>
>
>
> On 2 Jul 2017, at 12:08am, 積丹尼 Dan Jacobson <[hidden email]>
> wrote:
>
> > So near the top of the article add this synopsis of the three basic
> forms,
> > INSERT INTO moz_cookies VALUES(1,'Bart',12);
> > INSERT INTO moz_cookies SELECT ..... ????
> > INSERT INTO moz_cookies DEFAUT_VALUES ???
>
> If those are "the" three forms, there are actually four and there needs to
> be one for
>
> INSERT INTO moz_cookies (id_number, name, age) VALUES(1,'Bart',12);
>
> or whatever the columns are actually called.
>
> Simon.
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Loading...