On 4 Jan 2017, at 1:43pm, Ken Wagner <beauco...@gmail.com> wrote: > There is yet another product "DB Browser for SQLite" using SQLite v 3.9.2. > It, too, omits any row where name contains any char 1 thru 9. It appears > SQLite at one point did this as 'GLOB '*[^1-9]*'. > > But it does not do so now. Does SQLite3 provide a detailed syntax description > of the GLOB permutations honored (and, perhaps, those deprecated?)
No. Not only is there no documentation for GLOB but a programmer can replace SQLite’s GLOB function with their own one, using the external function interface. You should not produce important production code which relies on the implementation of GLOB unless you control every link in the programming chain. And if you’re using a 3rd Party browser then you are obviously not doing that. If you want to test how SQLite itself handles GLOB, please use the SQLIte command-line tool. This can be downloaded as one of the 'precompiled binaries' for your platform, and is documented here: <https://sqlite.org/cli.html> This tool is written and supported by the SQLite development team and conforms in all ways to how SQLite is meant to be used. If you find a bug in that tool, it will be fixed. If you have problems with any other program which uses SQLite you are going to get better results by contacting whoever developed that program. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
