Ryan,
Thanks. I have saved the Unix GLOB reference.
When I inferred that other versions of SQLite gave the other results, it
was thru the other SQLite GUI tools and the version of SQLite that they
used.
Thanks for helping to make clear what was going on.
Ken
On 01/05/2017 02:53 AM, R Smith wrote:
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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users