Ticket #11608: 11608-tests.php

### Eclipse Workspace Patch 1.0
#P wordpress-trunk
Index: wp-content/plugins/debug-11608-tests.php
===================================================================
--- wp-content/plugins/debug-11608-tests.php    (revision 0)
+++ wp-content/plugins/debug-11608-tests.php    (revision 0)
@@ -0,0 +1,84 @@
+<?php
+/**
+ * @link http://core.trac.wordpress.org/ticket/11608
+ */
+
+/*
+ * test: just run
+ * 
+ * should return null on broken implementation, false on fixed one
+ */
+var_dump( $wpdb->prepare( ) );
+
+/*
+ * test: run prepare()
+ * 
+ * should return false and throw an error on debug in case a
+ * query is invalid (fixed behaviour)
+ * 
+ * should return null|false in case a query is invalid (broken,
+ * old behaviour)
+ */
+$tests = array(
+       '% wrong query' => array( '' ), # invalid 
+       'SELECT * FROM `table` WHERE `column` = %s AND `field` = %d' => array( 'foo', 1337 ), # valid 
+       "SELECT DATE_FORMAT(`field`, '%%c') FROM `table` WHERE `column` = %s" => array( 'foo' ), # valid 
+       "SELECT DATE_FORMAT(`field`, '%c') FROM `table` WHERE `column` = %s" => array( 'foo' ), # invalid
+);
+
+foreach ( $tests as $query => $args) {
+       var_dump( $wpdb->prepare( $query, $args ) );
+}
+
+
+/*
+ * test: quote lits 
+ * 
+ * test the concrete quote routine for query parameter
+ */
+$tests = array(
+       '',
+       '%',
+       '%%',
+       '%s',
+       '%%s',
+       '%%%s',
+       '%d',
+       '%-',
+       '%d%s%%',
+       '%%d%s%%',
+       '%%%d%s%%',     
+       '%%%d%%s%%',
+       '%%d%%s%',
+       'percentage stupid or %stupid is the question',
+       'percentage stupid or %%stupid is the question',        
+       'SELECT FROM t1 WHERE a LIKE (%s)',
+       'SELECT FROM t1 WHERE a = %s',
+       "SELECT 1 WHERE table.row LIKE '%stupid' AND othertable.row = %s",
+       "SELECT 1 WHERE table.row LIKE '%stupid' AND othertable.row = %s",
+       "SELECT 1 WHERE table.row LIKE '%%stupid' AND othertable.row = %s",
+       "SELECT 1 WHERE table.row LIKE '%%stupidisas%%stupiddoes' AND othertable.row = %s",
+);
+
+print '<pre>';
+foreach( $tests as $query ) {
+       printf("   %-9s -> %-10s (Syntax: %s)\n", $query, $wpdb->_prepare_quote_lits( $query ), ( false === $wpdb->_prepare_quote_lits( $query, true) ? 'Error' : 'Ok' ) ) ;            
+}
+
+/*
+ * test: error message 
+ * 
+ * wpdb should report an error on a wrong query in prepare
+ */
+$wpdb->suppress_errors(false);
+$wpdb->show_errors(true);
+$wpdb->prepare( $query = '% wrong query' );
+
+/*
+ * test: show what's wrong with the function
+ * 
+ * NOTE: only for old, broken routine
+ */
+$wpdb->prepare( $query = '% wrong query', '' );
+
+die();
\ No newline at end of file