test regexp

mvorisek · mvorisek · commit 71fdd5ff0e49 · 2022-07-03T14:50:49.000+02:00
diff --git a/tests/ConditionSqlTest.php b/tests/ConditionSqlTest.php
@@ -440,13 +440,20 @@ public function testLikeCondition(): void
 
         $t = (clone $u)->addCondition('name', 'like', '%John%');
         $this->assertCount(1, $t->export());
+        $t = (clone $u)->addCondition('name', 'regexp', '^Joh');
+        $this->assertCount(1, $t->export());
 
         $t = (clone $u)->addCondition('name', 'like', '%john%');
         $this->assertCount(1, $t->export());
+        $t = (clone $u)->addCondition('name', 'regexp', '^joh');
+        $this->assertCount(1, $t->export());
 
         $t = (clone $u)->addCondition('created', 'like', '%19%');
         $this->assertCount(2, $t->export()); // only year 2019 records
 
+        $t = (clone $u)->addCondition('created', 'regexp', '19');
+        $this->assertCount(2, $t->export());
+
         $t = (clone $u)->addCondition('active', 'like', '%1%');
         $this->assertCount(2, $t->export()); // only active records
 
