Issue #57 _log_query errors when given raw ? or %

Thanks to Jeff Roberson <[email protected]> for his regex skills.

1 files changed, 9 insertions, 1 deletions

diff --git a/test/test_queries.php b/test/test_queries.php
index 1f2acc6..bcd4c7e 100644
--- a/test/test_queries.php
+++ b/test/test_queries.php
@@ -296,7 +296,15 @@
     $widget = ORM::for_table('widget')->select('widget.*')->find_one();
     $expected = "SELECT `widget`.* FROM `widget` LIMIT 1";
     Tester::check_equal("Issue #12 - incorrect quoting of column wildcard", $expected);
-
+    
+    $widget = ORM::for_table('widget')->where_raw('username LIKE "ben%"')->find_many();
+    $expected = 'SELECT * FROM `widget` WHERE username LIKE "ben%"';
+    Tester::check_equal('Issue #57 - _log_query method raises a warning when query contains "%"', $expected);
+    
+    $widget = ORM::for_table('widget')->where_raw('comments LIKE "has been released?%"')->find_many();
+    $expected = 'SELECT * FROM `widget` WHERE comments LIKE "has been released?%"';
+    Tester::check_equal('Issue #57 - _log_query method raises a warning when query contains "?"', $expected);
+    
     // Tests that alter Idiorm's config are done last
 
     ORM::configure('id_column', 'primary_key');