Added unit test for bug #15253

git-svn-id: https://svn.typo3.org/TYPO3v4/Extensions/dbal/trunk@36500 735d13b6-9817-0410-8766-e36946ffe9aa

diff --git a/typo3/sysext/dbal/ChangeLog b/typo3/sysext/dbal/ChangeLog
index 49babb6..1ec419e 100644 (file)
--- a/typo3/sysext/dbal/ChangeLog
+++ b/typo3/sysext/dbal/ChangeLog
@@ -1,5 +1,6 @@
 2010-08-08  Xavier Perseguers  <typo3@perseguers.ch>
 
+       * Added unit test for bug #15253: NOT LIKE is not remapped using dbms_lob.instr with Oracle
        * Fixed bug #12535: DAM-related: Element browser crashes as where-clause cannot be parsed
 
 2010-07-27  Xavier Perseguers  <typo3@perseguers.ch>

diff --git a/typo3/sysext/dbal/tests/dbOracleTest.php b/typo3/sysext/dbal/tests/dbOracleTest.php
index 0a2671e..0a7cd4d 100644 (file)
--- a/typo3/sysext/dbal/tests/dbOracleTest.php
+++ b/typo3/sysext/dbal/tests/dbOracleTest.php
@@ -657,6 +657,28 @@ class dbOracleTest extends BaseTestCase {
                $this->assertEquals($expected, $select);
        }
 
+       /**
+        * @test
+        * @see http://bugs.typo3.org/view.php?id=15253
+        */
+       public function notLikeIsRemappedAccordingToFieldType() {
+               $select = $this->cleanSql($GLOBALS['TYPO3_DB']->SELECTquery(
+                       '*',
+                       'tt_content',
+                       'tt_content.bodytext NOT LIKE \'foo%\''
+               ));
+               $expected = 'SELECT * FROM "tt_content" WHERE NOT (dbms_lob.instr("tt_content"."bodytext", \'foo\',1,1) > 0)';
+               $this->assertEquals($expected, $select);
+
+               $select = $this->cleanSql($GLOBALS['TYPO3_DB']->SELECTquery(
+                       '*',
+                       'fe_users',
+                       'fe_users.usergroup NOT LIKE \'2\''
+               ));
+               $expected = 'SELECT * FROM "fe_users" WHERE NOT (instr("fe_users"."usergroup", \'2\',1,1) > 0)';
+               $this->assertEquals($expected, $select);
+       }
+
        /**
         * @test
         * @see http://bugs.typo3.org/view.php?id=14479