On 2017/01/05 9:04 AM, Ken Wagner wrote:
Keith,
It appears that the folks at SQLiteTutorial.net have a coding anomaly.
They are not following the UNIX / SQLite3 GLOB patterns. And so, too,
do the other guys.
I am adjusting my usage accordingly. I will advise users of the other
products to NOT use the GLOB "*[^1-9]*" pattern. SQLiteTutorial.net
has already been advised. (No reply, thus far in 2 days.)
What the 3rd party people do is likely override the GLOB and REGEXP
functions, either when compiling their SQLite versions or at runtime
using the user-function api. People add their own GLOB sometimes purely
because they add REGEXP functions (which is not defined by default in
SQLite) and the new REGEXP comes with a GLOB sibling that gets added and
they perhaps prefer the outcome as it happens in SQLite tutorial and DB
Browser etc. These alternate globbing methodologies may even be
preferred by you or your customers.
The similarity between the different tools suggest to me they probably
use the same added code / library which someone made to "improve" over
the standard Unix file globbing. I wouldn't want or expect the SQLite
tutorial people to change how they implement the globbing, but they
should at least notify learners of the difference.
What you and your customers need to know is:
- SQLite uses Unix file globbing exactly
- 3rd party tools which implement SQLite engine may override this
(and seemingly mostly do so)
- You can expect different GLOB returns via different tools, and
these need to be understood during use. (Hopefully most tools are
consistent in their alteration)
- SQLite engine as used in the SQLite CLI will always return the
exact same Unix file globbing results in queries.
The big question here was on the last point where you suggested you saw
different results using some version of the SQLite CLI than another -
but I think Keith is correct in assuming it's simply a mistake, however,
if you DO find a difference in any version, please let us know - that
would be a bug (or a concern at the very least).
Thanks,
Ryan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users