Ahmed
08/17/2021, 8:54 AMosquery> PRAGMA case_sensitive_like=1; <Query>
E0817 04:50:29.635751 8504 sqlite_util.cpp:295] Authorizer denied action 19 case_sensitive_like 1 null null
Error: not authorized
seph
08/17/2021, 1:42 PMAhmed
08/17/2021, 1:44 PMGLOB
that would be great, i’ll try to research that.LIKE
operator, the GLOB
operator is case sensitive and uses the UNIX wildcards. In addition, the GLOB
patterns do not have escape characters.
https://www.sqlitetutorial.net/sqlite-glob/seph
08/17/2021, 1:46 PMselect 'a' GLOB 'A'
for exampleAhmed
08/17/2021, 1:47 PMosquery> select 'a' GLOB 'A';
+--------------+
| 'a' GLOB 'A' |
+--------------+
| 0 |
+--------------+
osquery> select 'a' GLOB 'a';
+--------------+
| 'a' GLOB 'a' |
+--------------+
| 1 |
+--------------+
seph
08/17/2021, 1:49 PMcase_sensitive_like=1;
which is setting case sensitivity. LIKE defaults to insensitiveLIKE
defaults to case insensitive, and needs that pragma to become case sensitive.
Most other comparators default to case sensitive, and you can use COLLATE NOCASE
to make them insensitive.
I’m not sure what you’re looking for thoughAhmed
08/17/2021, 1:50 PMseph
08/17/2021, 1:51 PMAhmed
08/17/2021, 2:05 PM