Aha! GLOB is an implementation of the UNIX Glob function. It just
borrows the regex character notation of [^1-9].
I have 3.15 and 3.16 CLIs installed. Trying any other CLI versions at
this point won't help for the customer. They will be using a SQLite3
GUI. I will explain the difference between the CLI and the GUI versions.
Where is this UNIX Glob notation spelled out? My system is Linux. I
expect the UNIX version will be somewhat different.
The Linux GLOB is used to find patterns in pathnames (not databases.) Is
the Unix version the same?
Thanks,
Ken
On 01/04/2017 11:51 AM, R Smith wrote:
On 2017/01/04 7:01 PM, Jens Alfke wrote:
On Jan 4, 2017, at 5:57 AM, R Smith <rsm...@rsweb.co.za> wrote:
As I have it (and as is implemented by SQLite) the GLOB operator
implements a REGEXP that matches against a regexp pattern
No, these are NOT regular expressions in the usual sense of the word.
GLOB's syntax is incompatible with what are commonly called “regular
expressions”, and its feature set is a lot more limited. (It may
technically implement a type of regular expression in the underlying
algorithmic sense, but I think using the term is misleading.)
Quite correct, I meant REGEXP as an internal function of the
Regular-expression type, not the official "regular expression" syntax
- So a "misleading term" then in your words. Allow me to be more clear
then: GLOB in SQLite specifically matches Unix file globbing syntax
(which is very different to official RegEx). 3rd party utilities can
override both the internal REGEXP and GLOB functions with custom
versions.
https://sqlite.org/lang_expr.html#glob
The bit I don't know for sure is whether Unix file globbing will
regard 'AB5' as matching '*[^1-9]*' or not? I know in SQLite it
matches (and I believe this to be correct, but I could be mistaken and
I don't have a Unix box handy to test).
Either way, the concern is more towards consistency than specific
operation.
The SQLite scripts I sent previously will reveal any difference
between versions if they exist. Have you tried it on different
versions of the CLI?
_______________________________________________
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
