Hi SQLite,
In the SQLite3 Tutorial the following query is said to find all names
WITHOUT numbers in them. But it fails to do so.
select trackid, name from tracks where name GLOB '*[^1-9]*'; per the
tutorial fails to list names WITHOUT numbers in them.
However, this DOES work:
select trackid, name from tracks where name not GLOB '*[1-9]*';
Is this a tutorial error? Using SQLiteMan the first query DOES work.
But not in SQLite 3.15.1 or 3.16.1.
Is this a bug or a tutorial error? Can't tell which version of SQLite
SQLiteMan is using.
System: Ubuntu 16.04, SQLite3 (3.15.1 and 3.16.1). Also tested using
Ruby 2.3.3 with ruby-sqlite extension.
Thanks,
Ken Wagner
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users