mirror of
https://github.com/php/php-src.git
synced 2026-10-28 17:56:50 +08:00
NickSdot
1da3a6398b
* ext/bz2: applied fixers to improve test robustness * ext/calendar: applied fixers to improve test robustness * ext/exif: applied fixers to improve test robustness * ext/fileinfo: applied fixers to improve test robustness * ext/filter: applied fixers to improve test robustness * ext/ftp: applied fixers to improve test robustness * ext/hash: applied fixers to improve test robustness * ext/iconv: applied fixers to improve test robustness * ext/ldap: applied fixers to improve test robustness * ext/pcre: applied fixers to improve test robustness * ext/posix: applied fixers to improve test robustness * ext/readline: applied fixers to improve test robustness * ext/shmop: applied fixers to improve test robustness * ext/snmp: applied fixers to improve test robustness * ext/sodium: applied fixers to improve test robustness * ext/sqlite3: applied fixers to improve test robustness * ext/sysvmsg: applied fixers to improve test robustness * ext/sysvsem: applied fixers to improve test robustness * ext/sysvshm: applied fixers to improve test robustness * ext/tidy: applied fixers to improve test robustness * ext/tokenizer: applied fixers to improve test robustness * ext/zend_test: applied fixers to improve test robustness * ext/zlib: applied fixers to improve test robustness
36 lines
1.0 KiB
PHP
36 lines
1.0 KiB
PHP
--TEST--
|
|
SQLite3 extended error code Function
|
|
--EXTENSIONS--
|
|
sqlite3
|
|
--FILE--
|
|
<?php
|
|
|
|
require_once(__DIR__ . '/new_db.inc');
|
|
|
|
$db->query("CREATE TABLE dog ( id INTEGER PRIMARY KEY, name TEXT, annoying INTEGER )");
|
|
|
|
echo "Inserting first time which should succeed" . PHP_EOL;
|
|
$result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
|
|
echo "First Error Code: " . $db->lastErrorCode() . PHP_EOL;
|
|
|
|
echo "Inserting second time which should fail" . PHP_EOL;
|
|
$result = $db->query("INSERT INTO dog VALUES (1, 'Annoying Dog', 1)");
|
|
echo "Second Error Code: " . $db->lastErrorCode() . PHP_EOL;
|
|
echo "Second Extended Error Code: " . $db->lastExtendedErrorCode() . PHP_EOL;
|
|
|
|
echo "Closing database\n";
|
|
var_dump($db->close());
|
|
echo "Done" . PHP_EOL;
|
|
?>
|
|
--EXPECTF--
|
|
Inserting first time which should succeed
|
|
First Error Code: 0
|
|
Inserting second time which should fail
|
|
|
|
Warning: SQLite3::query(): Unable to execute statement: UNIQUE constraint failed: dog.id in %s on line %d
|
|
Second Error Code: 19
|
|
Second Extended Error Code: 1555
|
|
Closing database
|
|
bool(true)
|
|
Done
|