/PHP-8.2/ext/pdo/tests/ |
H A D | bug_60665.phpt | 22 $statement = $db->prepare("SELECT NULL AS null_value, 0 AS zero, 1 AS one $from");
|
/PHP-8.2/ext/mysqli/tests/ |
H A D | mysqli_change_user_locks_temporary.phpt | 23 if ($res = mysqli_query($link2, 'SELECT COUNT(*) AS _num FROM test')) { 33 if (!$res = mysqli_query($link2, 'SELECT COUNT(*) AS _num FROM test')) 54 if (!$res = mysqli_query($link, 'SELECT COUNT(*) AS _num FROM test')) 68 if ($res = mysqli_query($link, 'SELECT COUNT(*) AS _num FROM test')) { 74 if (!$res = mysqli_query($link, 'SELECT GET_LOCK("phptest", 2) AS _ok')) 88 if (!$res = mysqli_query($link, 'SELECT IS_FREE_LOCK("phptest") AS _ok'))
|
H A D | mysqli_connect_oo_defaults.phpt | 34 if (!$res = $mysqli->query("SELECT 'mysqli.default_socket' AS testing")) 57 if (!$res = $mysqli->query("SELECT 'mysqli.default_port' AS testing")) 75 if (!$res = $mysqli->query("SELECT 'mysqli.default_pw' AS testing")) 93 if (!$res = $mysqli->query("SELECT 'mysqli.default_user' AS testing")) 115 if (!$res = $mysqli->query("SELECT SUBSTRING_INDEX(USER(),'@',1) AS username")) 133 if (!$res = mysqli_query($link, "SELECT 'have been set' AS all_defaults")) 146 if (!$res = mysqli_query($link, "SELECT 'have been set' AS all_defaults"))
|
H A D | mysqli_change_user.phpt | 35 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var')) 45 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user')) 80 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user')) 103 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var')) 113 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user')) 123 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var'))
|
H A D | mysqli_explain_metadata.phpt | 13 if (!$res = mysqli_query($link, 'EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2')) 64 … if ($stmt->prepare('EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2') && $stmt->execute()) { 99 $stmt->prepare('EXPLAIN SELECT t1.*, t2.* FROM test AS t1, test AS t2') &&
|
H A D | mysqli_query_unicode.phpt | 30 if (!$res = mysqli_query($link, "SELECT 'това ескюел, но с точка и запетая' AS правилен ; ")) 36 …if (false !== ($res = mysqli_query($link, "SELECT 'това ескюел, но с точка и запетая' AS правилен … 44 $res = mysqli_query($link, 'SELECT @version AS п_версия'); 59 $res = mysqli_query($link, 'SELECT функцийка(VERSION()) AS ф_версия');
|
H A D | mysqli_stmt_bind_result_format.phpt | 2 Playing with SELECT FORMAT(...) AS _format - see also bugs.php.net/42378 60 $sql = sprintf('SELECT %s AS _format FROM %s ORDER BY %s', $format, $from, $order_by); 62 $sql = sprintf('SELECT %s AS _format FROM %s', $format, $from); 168 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 100); 173 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 120); 178 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 140); 183 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 160); 188 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 180); 193 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 200); 198 test_format($link, 'id AS order_by_col, FORMAT(col1, 0)', 'test', 'id', $expected, 220); [all …]
|
H A D | mysqli_change_user_old.phpt | 47 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var')) 57 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user')) 67 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var')) 96 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user'))
|
H A D | mysqli_field_count.phpt | 30 if (!$res = mysqli_query($link, "SELECT NULL as _null, '' AS '', 'three' AS 'drei'"))
|
H A D | mysqli_change_user_rollback.phpt | 23 if (!$res = mysqli_query($link, 'SELECT COUNT(*) AS _num FROM test')) 36 if (!$res = mysqli_query($link, 'SELECT COUNT(*) AS _num FROM test')) 49 if (!$res = mysqli_query($link, 'SELECT COUNT(*) AS _num FROM test'))
|
H A D | mysqli_change_user_oo.phpt | 42 if (!$res = $mysqli->query('SELECT @mysqli_change_user_test_var AS test_var')) 52 if (!$res = $mysqli->query('SELECT database() AS dbname, user() AS user')) 62 if (!$res = $mysqli->query('SELECT @mysqli_change_user_test_var AS test_var'))
|
H A D | mysqli_query.phpt | 30 if (!$res = mysqli_query($link, "SELECT 'this is sql but with semicolon' AS valid ; ")) 36 if (!$res = mysqli_query($link, "SELECT 'a' AS ''")) 43 …if (false !== ($res = mysqli_query($link, 'SELECT "this is sql but with semicolon" AS valid ; SHOW… 51 $res = mysqli_query($link, 'SELECT @version AS p_version'); 66 $res = mysqli_query($link, 'SELECT f(VERSION()) AS f_version');
|
H A D | mysqli_character_set_name.phpt | 18 if (!$res = mysqli_query($link, 'SELECT version() AS server_version')) 29 … = mysqli_query($link, 'SELECT @@character_set_connection AS charset, @@collation_connection AS co…
|
/PHP-8.2/ext/oci8/tests/ |
H A D | bug71422.phpt | 18 $stmt = oci_parse($c, 'SELECT LABEL AS RAW_QUERY FROM BUG71422_TEST WHERE TEST_ID=1'); 24 $stmt = oci_parse($c, 'SELECT LABEL AS NUMERIC_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:tes… 32 $stmt = oci_parse($c, 'SELECT LABEL AS STRING_BIND_PARAMETER FROM BUG71422_TEST WHERE TEST_ID=:test…
|
H A D | bug74625.phpt | 13 "CREATE OR REPLACE PACKAGE PKG74625 AS 17 "CREATE OR REPLACE PACKAGE BODY PKG74625 AS
|
H A D | coll_019.phpt | 23 $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF BLOB"; 36 $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF NUMBER"; 52 $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF VARCHAR2(1)"; 64 $ora_sql = "CREATE TYPE ".$type_name." AS TABLE OF DATE";
|
H A D | bug40078.phpt | 16 CREATE OR REPLACE PACKAGE BUG40078_PKG AS 24 CREATE OR REPLACE PACKAGE BODY BUG40078_PKG AS
|
/PHP-8.2/ext/pdo_mysql/tests/ |
H A D | bug44327.phpt | 17 $stmt = $db->prepare("SELECT 1 AS \"one\""); 48 string(17) "SELECT 1 AS "one"" 54 string(17) "SELECT 1 AS "one""
|
H A D | pdo_mysql_stmt_variable_columncount.phpt | 52 …EDURE p(IN cols INT) BEGIN IF cols < 2 THEN SELECT cols AS "one"; ELSE SELECT 1 AS "one", cols AS … 83 …IF cols < 2 THEN SET @numcols = 2; SELECT cols AS "one"; ELSE SET @numcols = 1; SELECT 1 AS "one",…
|
H A D | pdo_mysql_rollback.phpt | 21 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC); 26 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC); 32 $row = $db->query('SELECT COUNT(*) AS _num FROM test')->fetch(PDO::FETCH_ASSOC); 56 $row = $db->query('SELECT COUNT(*) AS _num FROM test2')->fetch(PDO::FETCH_ASSOC);
|
/PHP-8.2/ext/pdo_sqlite/tests/ |
H A D | gh9032.phpt | 11 $db->exec('attach database \':memory:\' AS "db1"'); 15 $st = $db->prepare('attach database :a AS "db2"');
|
/PHP-8.2/ext/sqlite3/tests/ |
H A D | gh9032.phpt | 12 $db->exec('attach database \':memory:\' AS "db1"'); 16 $st = $db->prepare('attach database :a AS "db2"');
|
/PHP-8.2/ext/pdo_pgsql/tests/ |
H A D | bug69344.phpt | 26 $stmt = $pdo->prepare("SELECT (?)::text AS a, (?)::text AS b");
|
/PHP-8.2/Zend/tests/ |
H A D | bug68215.phpt | 29 foreach ($child AS $key => $fruit) 42 foreach ($arr AS $key => $fruit)
|
/PHP-8.2/ext/pdo_firebird/tests/ |
H A D | gh10908.phpt | 49 query_and_dump($dbh, "SELECT CAST(NUM AS NUMERIC(9, 3)) FROM gh10908"); // works fine 50 query_and_dump($dbh, "SELECT CAST(ID AS INTEGER) FROM gh10908"); // works fine 51 query_and_dump($dbh, "SELECT CAST(ID AS BIGINT) FROM gh10908"); // Used to "bus error"
|