Lines Matching refs:test
91 printf("[002] Unable to switch to emulated prepared statements, test will fail\n");
103 prepex(5, $db, 'DROP TABLE IF EXISTS test');
104 …prepex(6, $db, sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENGI…
105 prepex(7, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')");
106 $stmt = prepex(8, $db, 'SELECT label FROM test');
109 prepex(9, $db, 'DELETE FROM test');
110 prepex(10, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')",
112 $stmt = prepex(11, $db, 'SELECT label FROM test');
115 prepex(12, $db, 'DELETE FROM test');
116 prepex(13, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
118 prepex(14, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
120 $stmt = prepex(15, $db, 'SELECT label FROM test');
124 prepex(16, $db, 'SELECT label FROM test WHERE :placeholder > 1',
126 prepex(17, $db, 'SELECT :placeholder FROM test WHERE id > 1',
128 prepex(18, $db, 'SELECT :placeholder FROM test WHERE :placeholder > :placeholder',
129 array(':placeholder' => 'test'));
136 prepex(19, $db, 'SELECT id, label FROM test WHERE label > :placeholder',
140 prepex(20, $db, 'DELETE FROM test');
141 prepex(21, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder), (2, :placeholder)',
143 $stmt = prepex(22, $db, 'SELECT id, label FROM test');
146 $stmt = prepex(23, $db, 'SELECT id, label FROM test WHERE :placeholder IS NOT NULL',
151 $stmt = prepex(25, $db, 'SELECT id, label FROM test WHERE :placeholder IS NULL',
156 prepex(27, $db, 'DROP TABLE IF EXISTS test');
157 prepex(28, $db, 'CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
158 if (is_object(prepex(29, $db, 'CREATE FULLTEXT INDEX idx1 ON test(label)'))) {
159 prepex(30, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
161 prepex(31, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
163 … $stmt = prepex(32, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)',
171 prepex(34, $db, 'DELETE FROM test');
172 prepex(35, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder), (2, :placeholder)',
175 … $stmt = prepex(36, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (:placeholder)',
179 … $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
183 $stmt = prepex(38, $db, 'SELECT id, label AS "label" FROM test WHERE label = :placeholder',
186 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
193 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
199 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
205 prepex(45, $db, 'DROP TABLE IF EXISTS test');
206 …prepex(46, $db, sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENG…
207 prepex(47, $db, "INSERT INTO test(id, label) VALUES(1, '?')");
208 $stmt = prepex(48, $db, 'SELECT label FROM test');
211 prepex(49, $db, 'DELETE FROM test');
212 prepex(50, $db, "INSERT INTO test(id, label) VALUES(1, '?')",
214 $stmt = prepex(51, $db, 'SELECT label FROM test');
217 prepex(52, $db, 'DELETE FROM test');
218 prepex(53, $db, 'INSERT INTO test(id, label) VALUES(1, ?)',
220 prepex(54, $db, 'INSERT INTO test(id, label) VALUES(2, ?)',
222 $stmt = prepex(55, $db, 'SELECT label FROM test');
226 prepex(56, $db, 'SELECT label FROM test WHERE ? > 1',
228 prepex(57, $db, 'SELECT ? FROM test WHERE id > 1',
230 prepex(58, $db, 'SELECT ? FROM test WHERE ? > ?',
231 array('test'), array('execute' => array('sqlstate' => 'HY093')));
233 prepex(59, $db, 'SELECT ? FROM test WHERE ? > ?',
241 prepex(60, $db, 'SELECT id, label FROM test WHERE label > ?',
245 prepex(61, $db, 'DELETE FROM test');
246 prepex(62, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
248 $stmt = prepex(63, $db, 'SELECT id, label FROM test');
251 $stmt = prepex(64, $db, 'SELECT id, label FROM test WHERE ? IS NOT NULL',
256 $stmt = prepex(66, $db, 'SELECT id, label FROM test WHERE ? IS NULL',
261 prepex(68, $db, 'DROP TABLE IF EXISTS test');
262 prepex(69, $db, 'CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
263 if (is_object(prepex(70, $db, 'CREATE FULLTEXT INDEX idx1 ON test(label)'))) {
264 prepex(71, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
266 prepex(72, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
268 $stmt = prepex(73, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (?)',
277 prepex(74, $db, 'DELETE FROM test');
278 prepex(75, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
281 $stmt = prepex(76, $db, 'SELECT id, label FROM "test WHERE MATCH label AGAINST (?)',
287 … $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
292 $stmt = prepex(78, $db, 'SELECT id, label AS "label" FROM test WHERE label = ?',
295 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = ?)",
302 $sql = sprintf("SELECT id, label FROM test WHERE (id = ?) OR (label LIKE %s)",
308 …$sql = "SELECT id, label FROM test WHERE id = ? AND label = (SELECT label AS 'SELECT' FROM test WH…
313 …$sql = "SELECT id, label FROM test WHERE id = :placeholder AND label = (SELECT label AS 'SELECT' F…
329 $db->exec('DROP TABLE IF EXISTS test');
