Lines Matching refs:test
123 prepex(5, $db, 'DROP TABLE IF EXISTS test');
124 …prepex(6, $db, sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENGI…
125 prepex(7, $db, "INSERT INTO test(id, label) VALUES(1, ':placeholder')");
126 $stmt = prepex(8, $db, 'SELECT label FROM test ORDER BY id ASC');
129 prepex(9, $db, 'DELETE FROM test');
130 prepex(10, $db, 'INSERT INTO test(id, label) VALUES(1, :placeholder)',
132 prepex(11, $db, 'INSERT INTO test(id, label) VALUES(2, :placeholder)',
134 $stmt = prepex(12, $db, 'SELECT label FROM test ORDER BY id ASC');
138 $stmt = prepex(13, $db, 'SELECT label FROM test WHERE :placeholder > 1',
147 prepex(16, $db, 'SELECT id, label FROM test WHERE label > :placeholder',
151 $stmt = prepex(16, $db, 'SELECT id, label FROM test WHERE :placeholder IS NOT NULL',
156 $stmt = prepex(18, $db, 'SELECT id, label FROM test WHERE :placeholder IS NULL',
161 prepex(20, $db, 'DROP TABLE IF EXISTS test');
162 prepex(21, $db, 'CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
164 … if (is_object(prepex(22, $db, 'CREATE FULLTEXT INDEX idx1 ON test(label)', null, null, true))) {
165 prepex(23, $db, 'INSERT INTO test(id, label) VALUES (1, :placeholder)',
167 prepex(24, $db, 'INSERT INTO test(id, label) VALUES (2, :placeholder)',
169 … $stmt = prepex(25, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)',
177 $stmt = prepex(26, $db, 'SELECT id, label FROM test ORDER BY id ASC');
188 $db->exec('DELETE FROM test');
189 $db->exec("INSERT INTO test(id, label) VALUES (1, 'row1')");
190 $db->exec("INSERT INTO test(id, label) VALUES (2, 'row2')");
192 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = :placeholder)",
198 $sql = sprintf("SELECT id, label FROM test WHERE (id = :placeholder) OR (label LIKE %s)",
205 prepex(33, $db, 'DROP TABLE IF EXISTS test');
206 …prepex(34, $db, sprintf('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=%s', PDO_MYSQL_TEST_ENG…
207 prepex(35, $db, "INSERT INTO test(id, label) VALUES(1, '?')");
208 $stmt = prepex(36, $db, 'SELECT label FROM test');
211 prepex(37, $db, 'DELETE FROM test');
212 prepex(38, $db, 'INSERT INTO test(id, label) VALUES(1, ?)',
214 prepex(39, $db, 'INSERT INTO test(id, label) VALUES(2, ?)',
216 $stmt = prepex(40, $db, 'SELECT label FROM test');
220 prepex(40, $db, 'SELECT label FROM test WHERE ? > 1',
222 prepex(41, $db, 'SELECT ? FROM test WHERE id > 1',
224 prepex(42, $db, 'SELECT ? FROM test WHERE ? > ?',
232 prepex(43, $db, 'SELECT id, label FROM test WHERE label > ?',
236 prepex(44, $db, 'DELETE FROM test');
237 prepex(45, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
239 $stmt = prepex(46, $db, 'SELECT id, label FROM test ORDER BY id');
263 $stmt = prepex(47, $db, 'SELECT id, label FROM test WHERE ? IS NOT NULL',
268 $stmt = prepex(49, $db, 'SELECT id, label FROM test WHERE ? IS NULL',
273 prepex(51, $db, 'DROP TABLE IF EXISTS test');
274 prepex(52, $db, 'CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
275 … if (is_object(prepex(53, $db, 'CREATE FULLTEXT INDEX idx1 ON test(label)', null, null, true))) {
276 prepex(54, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
278 prepex(55, $db, 'INSERT INTO test(id, label) VALUES (1, ?)',
280 $stmt = prepex(56, $db, 'SELECT id, label FROM test WHERE MATCH label AGAINST (?)',
289 prepex(57, $db, 'DELETE FROM test');
290 prepex(58, $db, 'INSERT INTO test(id, label) VALUES (1, ?), (2, ?)',
295 … $stmt = prepex(37, $db, 'SELECT id, label FROM \'test WHERE MATCH label AGAINST (:placeholder)',
300 $stmt = prepex(59, $db, 'SELECT id, label AS "label" FROM test WHERE label = ?',
317 $sql = sprintf("SELECT id, label FROM test WHERE (label LIKE %s) AND (id = ?)",
323 $sql = sprintf("SELECT id, label FROM test WHERE (id = ?) OR (label LIKE %s)",
329 …$sql = "SELECT id, label FROM test WHERE id = ? AND label = (SELECT label AS 'SELECT' FROM test WH…
345 $db->exec('DROP TABLE IF EXISTS test');
