[BUGFIX] Add SQL-comparator <> to SQL parser
authorStefan Neufeind <typo3.neufeind@speedpartner.de>
Fri, 16 Dec 2011 22:48:00 +0000 (23:48 +0100)
committerXavier Perseguers <xavier@typo3.org>
Tue, 20 Dec 2011 09:28:03 +0000 (10:28 +0100)
Comparator != was supported before.
But <> is ANSI SQL and therefore should be
supported as well.

Change-Id: I49dde6f06715ecd33df044d8a2e85a813516d6ad
Fixes: #32626
Releases: 4.4, 4.5, 4.6, 4.7
Reviewed-on: http://review.typo3.org/7417
Reviewed-by: Xavier Perseguers
Tested-by: Xavier Perseguers
t3lib/class.t3lib_sqlparser.php

index 3acf88b..e052c6d 100644 (file)
@@ -1252,7 +1252,7 @@ class t3lib_sqlparser {
 
                                                // Find "comparator":
                                        $comparatorPatterns = array(
-                                               '<=', '>=', '<', '>', '=', '!=',
+                                               '<=', '>=', '<>', '<', '>', '=', '!=',
                                                'NOT[[:space:]]+IN', 'IN',
                                                'NOT[[:space:]]+LIKE[[:space:]]+BINARY', 'LIKE[[:space:]]+BINARY', 'NOT[[:space:]]+LIKE', 'LIKE',
                                                'IS[[:space:]]+NOT', 'IS',