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

Reply via email to