cvs: pear /XML_Query2XML/tests/XML_Query2XML/AllDBLayers/getXML caching_cached_offset.phpt

lukasfeiler		Mon Apr 21 08:08:57 2008 UTC

  Modified files:              
    /pear/XML_Query2XML/tests/XML_Query2XML/AllDBLayers/getXML	
                                                              	caching_cached_offset.phpt 
  Log:
  adjusted to make unit test work with PostgreSQL
  
http://cvs.php.net/viewvc.cgi/pear/XML_Query2XML/tests/XML_Query2XML/AllDBLayers/getXML/caching_cached_offset.phpt?r1=1.1&r2=1.2&diff_format=u
Index: pear/XML_Query2XML/tests/XML_Query2XML/AllDBLayers/getXML/caching_cached_offset.phpt
diff -u pear/XML_Query2XML/tests/XML_Query2XML/AllDBLayers/getXML/caching_cached_offset.phpt:1.1 pear/XML_Query2XML/tests/XML_Query2XML/AllDBLayers/getXML/caching_cached_offset.phpt:1.2
--- pear/XML_Query2XML/tests/XML_Query2XML/AllDBLayers/getXML/caching_cached_offset.phpt:1.1	Fri Apr 18 23:50:26 2008
+++ pear/XML_Query2XML/tests/XML_Query2XML/AllDBLayers/getXML/caching_cached_offset.phpt	Mon Apr 21 08:08:57 2008
@@ -34,9 +34,9 @@
                     'sql' => array(
                         'data' => array(
                             'artistid',
-                            ':test'
+                            ':2000'
                         ),
-                        'query' => 'SELECT * FROM album WHERE artist_id = ? AND "test" = ?',
+                        'query' => 'SELECT * FROM album WHERE artist_id = ? AND NOT albumid = ?',
                         'limit' => 1,
                         'offset' => 2
                     ),
@@ -62,15 +62,15 @@
 --EXPECT--
 QUERY: SELECT * FROM artist UNION ALL SELECT * FROM artist
 DONE
-CACHING: SELECT * FROM album WHERE artist_id = ? AND "test" = ?; LIMIT:1; OFFSET:2; DATA:1,test
-QUERY: SELECT * FROM album WHERE artist_id = ? AND "test" = ?; LIMIT:1; OFFSET:2; DATA:1,test
+CACHING: SELECT * FROM album WHERE artist_id = ? AND NOT albumid = ?; LIMIT:1; OFFSET:2; DATA:1,2000
+QUERY: SELECT * FROM album WHERE artist_id = ? AND NOT albumid = ?; LIMIT:1; OFFSET:2; DATA:1,2000
 DONE
-CACHING: SELECT * FROM album WHERE artist_id = ? AND "test" = ?; LIMIT:1; OFFSET:2; DATA:2,test
-QUERY: SELECT * FROM album WHERE artist_id = ? AND "test" = ?; LIMIT:1; OFFSET:2; DATA:2,test
+CACHING: SELECT * FROM album WHERE artist_id = ? AND NOT albumid = ?; LIMIT:1; OFFSET:2; DATA:2,2000
+QUERY: SELECT * FROM album WHERE artist_id = ? AND NOT albumid = ?; LIMIT:1; OFFSET:2; DATA:2,2000
 DONE
-CACHING: SELECT * FROM album WHERE artist_id = ? AND "test" = ?; LIMIT:1; OFFSET:2; DATA:3,test
-QUERY: SELECT * FROM album WHERE artist_id = ? AND "test" = ?; LIMIT:1; OFFSET:2; DATA:3,test
+CACHING: SELECT * FROM album WHERE artist_id = ? AND NOT albumid = ?; LIMIT:1; OFFSET:2; DATA:3,2000
+QUERY: SELECT * FROM album WHERE artist_id = ? AND NOT albumid = ?; LIMIT:1; OFFSET:2; DATA:3,2000
 DONE
-CACHED: SELECT * FROM album WHERE artist_id = ? AND "test" = ?; LIMIT:1; OFFSET:2; DATA:1,test
-CACHED: SELECT * FROM album WHERE artist_id = ? AND "test" = ?; LIMIT:1; OFFSET:2; DATA:2,test
-CACHED: SELECT * FROM album WHERE artist_id = ? AND "test" = ?; LIMIT:1; OFFSET:2; DATA:3,test
\ No newline at end of file
+CACHED: SELECT * FROM album WHERE artist_id = ? AND NOT albumid = ?; LIMIT:1; OFFSET:2; DATA:1,2000
+CACHED: SELECT * FROM album WHERE artist_id = ? AND NOT albumid = ?; LIMIT:1; OFFSET:2; DATA:2,2000
+CACHED: SELECT * FROM album WHERE artist_id = ? AND NOT albumid = ?; LIMIT:1; OFFSET:2; DATA:3,2000
\ No newline at end of file