/php-src/ext/pdo_mysql/tests/ |
H A D | last_insert_id.phpt | 15 print_r($db->query("CREATE TABLE test_last_insert_id (id INT AUTO_INCREMENT PRIMARY KEY, num INT)")… 32 [queryString] => CREATE TABLE test_last_insert_id (id INT AUTO_INCREMENT PRIMARY KEY, num INT)
|
H A D | bug_44454.phpt | 18 $db->exec('CREATE TABLE test_44454(a INT, b INT, UNIQUE KEY idx_ab (a, b))'); 34 $db->exec('CREATE TABLE test_44454(a INT, b INT, UNIQUE KEY idx_ab (a, b))');
|
H A D | pdo_mysql_attr_init_command.phpt | 23 $create = sprintf('CREATE TABLE %s(id INT)', $table); 44 string(48) "CREATE TABLE pdo_mysql_attr_init_command(id INT)"
|
H A D | pdo_mysql_stmt_getcolumnmeta.phpt | 16 $db->exec('CREATE TABLE test_stmt_getcolumnmeta(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=Inno… 61 …$sql = sprintf('CREATE TABLE test_stmt_getcolumnmeta(id INT, label %s) ENGINE=%s', $sql_type, MySQ… 149 test_meta($db, 100, 'INT', -2147483648, 'LONG', PDO::PARAM_INT); 150 test_meta($db, 110, 'INT UNSIGNED', 4294967295, 'LONG', PDO::PARAM_INT); 224 …$sql = sprintf('CREATE TABLE test_stmt_getcolumnmeta(id INT, label INT UNIQUE) ENGINE = %s', MySQL… 245 …$sql = sprintf('CREATE TABLE test_stmt_getcolumnmeta(id INT PRIMARY KEY NOT NULL AUTO_INCREMENT) E… 266 …$sql = sprintf('CREATE TABLE test_stmt_getcolumnmeta(id INT, label1 INT, label2 INT, INDEX idx1(la…
|
H A D | bug_44707.phpt | 17 $db->exec('CREATE TABLE test_44707(id INT, mybool TINYINT)'); 36 // INT and integer work well together
|
/php-src/ext/mysqli/tests/ |
H A D | mysqli_stmt_bind_param_type_juggling.phpt | 88 bind_twice($link, $engine, 'INT', 'INT', 'i', 'i', 1, 2, 20); 94 bind_twice($link, $engine, 'INT', 'INT', 'i', 'i', '1', '2', 50); 101 1) col1 INT, col2 CHAR(1) 107 col1 INT, col2 INT 114 col1 INT, COL2 CHAR(1) 117 bind_twice($link, $engine, 'INT', 'CHAR(1)', 'i', 's', 1, 'a', 70);
|
H A D | mysqli_fetch_field_flags.phpt | 51 'INT DEFAULT NULL' => 'NUM', 52 'INT NOT NULL' => 'NOT_NULL NO_DEFAULT_VALUE NUM', 53 'INT NOT NULL DEFAULT 1' => 'NOT_NULL NUM', 54 'INT UNSIGNED DEFAULT NULL' => 'UNSIGNED NUM', 55 'INT UNSIGNED NOT NULL' => 'NOT_NULL UNSIGNED NO_DEFAULT_VALUE NUM', 56 'INT UNSIGNED NOT NULL DEFAULT 1' => 'NOT_NULL UNSIGNED NUM', 57 'INT UNSIGNED ZEROFILL DEFAULT NULL' => 'UNSIGNED ZEROFILL NUM', 113 $create = sprintf('CREATE TABLE test(id INT, col1 %s)', $column_def); 143 case 'INT UNSIGNED NOT NULL': 144 case 'INT NOT NULL': [all …]
|
H A D | bug35103.phpt | 31 echo "BIG INT SIGNED, TEST\n"; 44 echo "BIG INT UNSIGNED TEST\n"; 67 BIG INT SIGNED, TEST 77 BIG INT UNSIGNED TEST
|
H A D | mysqli_stmt_insert_id.phpt | 41 (!mysqli_stmt_prepare($stmt, "ALTER TABLE test MODIFY id INT NOT NULL AUTO_INCREMENT") || 45 mysqli_query($link, "ALTER TABLE test MODIFY id INT NOT NULL AUTO_INCREMENT");
|
/php-src/ext/odbc/tests/ |
H A D | odbc_num_fields_001.phpt | 14 odbc_exec($conn, 'CREATE TABLE num_fields (foo INT, bar INT, baz INT)');
|
H A D | odbc_field_name_001.phpt | 14 odbc_exec($conn, 'CREATE TABLE field_name (foo INT, bar INT, baz INT)');
|
/php-src/ext/pgsql/tests/ |
H A D | pg_update_001.phpt | 18 pg_query($conn, "CREATE TABLE {$table_name} (id INT, id2 INT)"); 19 pg_query($conn, "CREATE TABLE {$schema_name}.{$table_name} (id INT, id2 INT)");
|
H A D | pg_select_001.phpt | 17 pg_query($conn, "CREATE TABLE {$schema_name}.foo (id INT, id2 INT)"); 21 pg_query($conn, "CREATE TABLE {$schema_name}.bar (id4 INT, id3 INT)");
|
H A D | pg_delete_001.phpt | 18 pg_query($conn, "CREATE TABLE {$table_name} (id INT, id2 INT)"); 19 pg_query($conn, "CREATE TABLE {$schema_name}.{$table_name} (id INT, id2 INT)");
|
H A D | pg_meta_data_001.phpt | 18 pg_query($conn, "CREATE TABLE {$schema_name}.{$table_name} (id INT, id2 INT)"); 20 pg_query($conn, "CREATE TABLE {$table_name} (id INT, id3 INT)");
|
H A D | pg_insert_001.phpt | 17 pg_query($conn, "CREATE TABLE {$schema_name}.{$table_name} (id INT, id2 INT)");
|
H A D | bug47199.phpt | 16 pg_query($dbh, "CREATE TABLE $tbl_name (null_field INT, not_null_field INT NOT NULL)");
|
/php-src/ext/pdo_sqlite/tests/ |
H A D | pdo_sqlite_empty_filename.phpt | 11 var_dump($db->exec('CREATE TABLE test_sqlite_empty_filename (id INT);')); 16 var_dump($db->exec('CREATE TABLE test_sqlite_empty_filename (id INT);'));
|
H A D | pdo_sqlite_filename_uri.phpt | 11 var_dump($db->exec('CREATE TABLE test_sqlite_filename_uri (id INT);')); 23 var_dump($db->exec('CREATE TABLE test_sqlite_filename_uri (id INT);')); 30 var_dump($db->exec('CREATE TABLE test_sqlite_filename_uri_2 (id INT);'));
|
H A D | pdo_sqlite_open_flags.phpt | 13 var_dump($db->exec('CREATE TABLE test_sqlite_open_flags (id INT);')); 17 var_dump($db->exec('CREATE TABLE test_sqlite_open_flags_2 (id INT);'));
|
/php-src/ext/pdo/tests/ |
H A D | bug_38394.phpt | 19 $db->exec("CREATE TABLE test38394 (a INT, b INT, c INT)");
|
H A D | bug_73234.phpt | 28 $sql = 'CREATE TABLE test73234(id INT NULL)'; 31 $sql = 'CREATE TABLE test73234(id INT)';
|
/php-src/ext/sqlite3/tests/ |
H A D | bug73068.phpt | 15 $db->exec("CREATE TABLE IF NOT EXISTS t1(a INT UNIQUE, b INT)");
|
/php-src/ext/pdo_odbc/tests/ |
H A D | max_columns.phpt | 16 if (false === $db->exec('CREATE TABLE test_max_columns (id INT NOT NULL PRIMARY KEY, data varchar(m… 17 …if (false === $db->exec('CREATE TABLE test_max_columns (id INT NOT NULL PRIMARY KEY, data longtext… 18 …if (false === $db->exec('CREATE TABLE test_max_columns (id INT NOT NULL PRIMARY KEY, data CLOB)'))…
|
/php-src/Zend/tests/type_declarations/union_types/redundant_types/ |
H A D | duplicate_type.phpt | 6 function test(): int|INT {
|