SQLite Forum

Tiny doc bug: sqlite_source_id() has outdated SHA1 reference
Login

Tiny doc bug: sqlite_source_id() has outdated SHA1 reference

(1) By Stephan Beal (stephan) on 2021-02-24 11:34:06 [link] [source]

https://sqlite.org/lang_corefunc.html#sqlite_source_id

seems to be slightly out of date:

The string returned by sqlite_source_id() is the date and time that the source code was checked in followed by the SHA1 hash for that check-in.

(Emphasis added.)

It's currently an SHA3-256 hash:

SQLite version 3.35.0 2021-02-22 16:42:09
Enter ".help" for usage hints.
sqlite> select sqlite_source_id();
'2021-02-22 16:42:09 b5a0778cc5a98a864bea72670f83262da940aceb91fa4cdf46ec097337a3alt1'

(2) By Larry Brasfield (larrybr) on 2021-02-24 18:13:54 in reply to 1 [link] [source]

Thanks for the report. Fixed here.

(3) By jake on 2021-02-25 00:18:00 in reply to 2 [source]

It's good to see that you're now an authorised doc contributor. To avoid spamming the forum with a new topic, here's another minor doc bug:

https://www.sqlite.org/lang_aggfunc.html#list_of_built_in_aggregate_functions

both the min and max links here incorrectly refer to the core functions instead of the aggregate versions.

(4) By Larry Brasfield (larrybr) on 2021-02-25 07:14:59 in reply to 3 [link] [source]

This is fixed on trunk; not sure when it will get to the site docs.

New threads with the word "bug" in their title get attention somewhat promptly. That seems less likely with add-on reports.