Re: [sqlite] Was there an announcement of 3.27?
On 9/2/62 03:31, Dominique Pellé wrote: David Raymond wrote: SQLite version 3.27.1 is now available on the SQLite website: https://sqlite.org/ https://sqlite.org/download.html https://sqlite.org/releaselog/3_27_1.html Release notes https://sqlite.org/releaselog/3_27_1.html say: === BEGIN QUOTE === Added the remove_diacritics=2 option to FTS3 and FTS5. === END QUOTE === I wonder that this does. FTS3 or FTS5 doc were not updated, since they only document remove_diacritics=0 and 1. Thanks for reporting this. And the typos. I just added the following to the docs: remove_diacritics: This option should be set to "0", "1" or "2". The default value is "1". If it is set to "1" or "2", then diacritics are removed from Latin script characters as described above. However, if it is set to "1", then diacritics are not removed in the fairly uncommon case where a single unicode codepoint is used to represent a character with more that one diacritic. For example, diacritics are not removed from codepoint 0x1ED9 ("LATIN SMALL LETTER O WITH CIRCUMFLEX AND DOT BELOW"). This is technically a bug, but cannot be fixed without creating backwards compatibility problems. If this option is set to "2", then diacritics are correctly removed from all Latin characters. Dan. I also use the opportunity to report a few typos in https://sqlite.org/fts5.html: - the second character replaced with an *asterix* (-> asterisk) - fts5 extension function made as part *of of* (repeated word "of") - *an the* (-> the) auxiliary data is set to NULL Regards Dominique ___ 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] Was there an announcement of 3.27?
On February 8, 2019 3:31:51 PM EST, "Dominique Pellé" wrote: >David Raymond wrote: > >> SQLite version 3.27.1 is now available on the SQLite website: >> >> https://sqlite.org/ >> https://sqlite.org/download.html >> https://sqlite.org/releaselog/3_27_1.html > >Release notes https://sqlite.org/releaselog/3_27_1.html say: > >=== BEGIN QUOTE === >Added the remove_diacritics=2 option to FTS3 and FTS5. >=== END QUOTE === > >I wonder that this does. FTS3 or FTS5 doc were not updated, >since they only document remove_diacritics=0 and 1. > >I also use the opportunity to report a few typos in >https://sqlite.org/fts5.html: > >- the second character replaced with an *asterix* (-> asterisk) >- fts5 extension function made as part *of of* (repeated word "of") >- *an the* (-> the) auxiliary data is set to NULL > >Regards >Dominique >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users I'm sure someone savvier will correct me, but the source does indicate that 1 is "simple" and 2 "complex". It's not entirely clear, but it seems like " complex" is able to handle multiple diacritics on one base character and "simple" cannot? -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Was there an announcement of 3.27?
David Raymond wrote: > SQLite version 3.27.1 is now available on the SQLite website: > > https://sqlite.org/ > https://sqlite.org/download.html > https://sqlite.org/releaselog/3_27_1.html Release notes https://sqlite.org/releaselog/3_27_1.html say: === BEGIN QUOTE === Added the remove_diacritics=2 option to FTS3 and FTS5. === END QUOTE === I wonder that this does. FTS3 or FTS5 doc were not updated, since they only document remove_diacritics=0 and 1. I also use the opportunity to report a few typos in https://sqlite.org/fts5.html: - the second character replaced with an *asterix* (-> asterisk) - fts5 extension function made as part *of of* (repeated word "of") - *an the* (-> the) auxiliary data is set to NULL Regards Dominique ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Was there an announcement of 3.27?
On 2/8/19, Simon Slavin wrote: > On 8 Feb 2019, at 6:25pm, David Raymond wrote: > >> https://sqlite.org/releaselog/3_27_1.html > > "Add options "--expanded", "--normalized", "--plain", "--profile", "--row", > "--stmt", and "--close" to the ".trace" command." > > Is there a discussion of these anywhere ? Not that I know of, apart from the ".help" text in the CLI. -- 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
Re: [sqlite] Was there an announcement of 3.27?
On 8 Feb 2019, at 6:25pm, David Raymond wrote: > https://sqlite.org/releaselog/3_27_1.html "Add options "--expanded", "--normalized", "--plain", "--profile", "--row", "--stmt", and "--close" to the ".trace" command." Is there a discussion of these anywhere ? Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Was there an announcement of 3.27?
As mentioned the release announcements is a separate mailing list, so people can get those without being deluged by stuff from this list. Pasting the announcement here. -Original Message- From: sqlite-announce [mailto:sqlite-announce-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Friday, February 08, 2019 10:20 AM To: sqlite-announce Subject: [sqlite-announce] Version 3.27.1 SQLite version 3.27.1 is now available on the SQLite website: https://sqlite.org/ https://sqlite.org/download.html https://sqlite.org/releaselog/3_27_1.html The only big enhancement in this release is the addition of the VACUUM INTO command, which allows a database to be backed up atomically such that the backup is minimal in size and contains no forensic traces of deleted content. There are also enhancements to the command-line interface and to some of the APIs such as sqlite3_deserialize(), and general improvements to the robustness of SQLite when it is reading and writing maliciously corrupted database files. There was a 3.27.0 release yesterday. But a bug report came in just after we had tagged the 3.27.0 release and before we had uploaded the code and made the release announcement. The bug report was for a query optimizer problem in 3.20.0 and was an older bug, completely unrelated to recent changes. Rather than announce the 3.27.0 release, then turn around an announce a 3.27.1 patch release the next day, we just omitted the 3.27.0 release announcement, and thereby (hopefully) spared people the trouble of having to upgrade twice. It would have been better, of course, if the bug report had come to our attention prior to tagging the 3.27.0 release so that we could have fixed the problem in 3.27.0. But sometimes bug reports arrive at inopportune moments. Some of the Windows build products on the download page are still on version 3.27.0. They will be updated to version 3.27.1 within 24 hours. -- D. Richard Hipp d...@sqlite.org ___ sqlite-announce mailing list sqlite-annou...@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Christian Schmitz Sent: Friday, February 08, 2019 12:47 PM To: SQLite mailing list Subject: Re: [sqlite] Was there an announcement of 3.27? > Am 08.02.2019 um 18:43 schrieb Jens Alfke : > > I see 3.27 was released yesterday (and quickly followed up with 3.27.1.) I The announcement was on the sqlite-annou...@mailinglists.sqlite.org list. 3.27 was ready to go, a bug was found, so 3.27.1 was announced today, so everyone could skip 3.27. Sincerely Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/ ___ 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] Was there an announcement of 3.27?
> Am 08.02.2019 um 18:43 schrieb Jens Alfke : > > I see 3.27 was released yesterday (and quickly followed up with 3.27.1.) I The announcement was on the sqlite-annou...@mailinglists.sqlite.org list. 3.27 was ready to go, a bug was found, so 3.27.1 was announced today, so everyone could skip 3.27. Sincerely Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users