summaryrefslogtreecommitdiff
path: root/ext/pdo_firebird/tests
diff options
context:
space:
mode:
authorArd Biesheuvel <abies@php.net>2004-06-12 16:07:52 (GMT)
committerArd Biesheuvel <abies@php.net>2004-06-12 16:07:52 (GMT)
commitc8c0ddb73dd0dd0439124249401cfc08ef369c60 (patch)
treea656199a6a8fc7ed90ba3c965178b68f4e1cab77 /ext/pdo_firebird/tests
parent1fb48b50918a4460a653351e36f6b669c522e9ad (diff)
downloadphp-c8c0ddb73dd0dd0439124249401cfc08ef369c60.tar.gz
Removed dependency on regular interbase extension
Added support for all datatypes except BLOBs
Diffstat (limited to 'ext/pdo_firebird/tests')
-rw-r--r--ext/pdo_firebird/tests/execute.phpt13
1 files changed, 9 insertions, 4 deletions
diff --git a/ext/pdo_firebird/tests/execute.phpt b/ext/pdo_firebird/tests/execute.phpt
index 6f9794c..1ab33e2 100644
--- a/ext/pdo_firebird/tests/execute.phpt
+++ b/ext/pdo_firebird/tests/execute.phpt
@@ -10,13 +10,14 @@ PDO_Firebird: prepare/execute/binding
$db = new PDO("firebird:dbname=$test_base",$user,$password) or die;
$db->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_WARNING);
- $db->exec("CREATE TABLE ddl (id SMALLINT NOT NULL PRIMARY KEY, text VARCHAR(32))");
- $db->exec("INSERT INTO ddl VALUES (1,'bla')");
+ $db->exec("CREATE TABLE ddl (id SMALLINT NOT NULL PRIMARY KEY, text VARCHAR(32),
+ datetime TIMESTAMP DEFAULT '2000-02-12' NOT NULL)");
+ $db->exec("INSERT INTO ddl (id,text) VALUES (1,'bla')");
$s = $db->prepare("SELECT * FROM ddl WHERE id=? FOR UPDATE");
$s->bindParam(1,$id = 0);
- $s->bindColumn(2,$var = null);
+ $s->bindColumn("TEXT",$var = null);
$id = 1;
$s->execute();
$s->setAttribute(PDO_ATTR_CURSOR_NAME, "c");
@@ -38,7 +39,7 @@ PDO_Firebird: prepare/execute/binding
?>
--EXPECT--
int(1)
-array(4) {
+array(6) {
["ID"]=>
int(1)
[0]=>
@@ -47,6 +48,10 @@ array(4) {
string(3) "bla"
[1]=>
string(3) "bla"
+ ["DATETIME"]=>
+ string(19) "2000-02-12 00:00:00"
+ [2]=>
+ string(19) "2000-02-12 00:00:00"
}
string(3) "bla"
int(1)