Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Cannot Reproduce
-
1.4.1
-
None
-
SLES 12
Description
Regex in filter does not work as expected.
rule files1 deny regex '^(?i)load.*data.*infile*'
|
should be true for all combinations of lower an upper case:
MySQL [(none)]> load data infile;
ERROR 1141 (HY000): Access denied for user 'rz4a016'@'134.100.3.64': Permission denied, query matched regular expression. WORKS
MySQL [(none)]> LOAD data infile;
ERROR 1141 (HY000): Access denied for user 'rz4a016'@'134.100.3.64': Permission denied, query matched regular expression. WORKS
MySQL [(none)]> LOAD DATA infile;
ERROR 1141 (HY000): Access denied for user 'rz4a016'@'134.100.3.64': Permission denied, query matched regular expression. WORKS
MySQL [(none)]> LOAD DATA INFILE;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
Does not work!