From f5bd0b73cf4549985c2d2f913e4b57ff88e942b7 Mon Sep 17 00:00:00 2001
From: Antony Dovgal <tony2001@php.net>
Date: Fri, 19 Dec 2003 17:03:12 +0000
Subject: [PATCH] add tests to HEAD

---
 ext/oci8/tests/bug26133.phpt    | 36 ++++++++++++++++++++++++++++++
 ext/oci8/tests/connect.inc      | 39 +++++++++++++++++++++++++++++++++
 ext/oci8/tests/create_table.inc | 12 ++++++++++
 ext/oci8/tests/drop_table.inc   | 12 ++++++++++
 ext/oci8/tests/skipif.inc       | 10 +++++++++
 5 files changed, 109 insertions(+)
 create mode 100644 ext/oci8/tests/bug26133.phpt
 create mode 100644 ext/oci8/tests/connect.inc
 create mode 100644 ext/oci8/tests/create_table.inc
 create mode 100644 ext/oci8/tests/drop_table.inc
 create mode 100644 ext/oci8/tests/skipif.inc

diff --git a/ext/oci8/tests/bug26133.phpt b/ext/oci8/tests/bug26133.phpt
new file mode 100644
index 0000000000..d3f0ed9bf3
--- /dev/null
+++ b/ext/oci8/tests/bug26133.phpt
@@ -0,0 +1,36 @@
+--TEST--
+Bug #26133 (ocifreedesc() segfault)
+--SKIPIF--
+<?php
+    require 'skipif.inc'; 
+?>
+--FILE--
+<?php
+    require 'connect.inc';
+    require 'create_table.inc';
+   
+    if ($connection) {
+        $ora_sql = "INSERT INTO 
+                               ".$schema."php_test_table (id, value) 
+                         VALUES ('1','1')
+                      RETURNING 
+                               ROWID 
+                           INTO :v_rowid ";
+                      
+        $statement = OCIParse($connection,$ora_sql);
+        $rowid = OCINewDescriptor($connection,OCI_D_ROWID);
+        OCIBindByName($statement,":v_rowid", $rowid,-1,OCI_B_ROWID);
+        if (OCIExecute($statement)) {
+            OCICommit($connection);
+        }
+        OCIFreeStatement($statement);
+        $rowid->free();
+    }
+
+    require 'drop_table.inc';
+    
+    echo "Done\n";
+?>
+--EXPECTF--
+Done
+
diff --git a/ext/oci8/tests/connect.inc b/ext/oci8/tests/connect.inc
new file mode 100644
index 0000000000..a0013e20d7
--- /dev/null
+++ b/ext/oci8/tests/connect.inc
@@ -0,0 +1,39 @@
+<?php
+
+/* 
+ * Please, change user, password and dbase to match your configuration.
+ * 
+ * */
+
+$user       = "user";
+$password   = "pass";
+$dbase      = "base";
+
+/* 
+ * You should have privileges to create tables in this schema 
+ * 
+ * */
+
+$schema     = "system"; 
+
+/*
+ * Remove the last line in skipif.inc to run tests
+ *
+ * */
+
+
+    if (!empty($dbase)) {
+        $connection = ocilogon($user,$password,$dbase);
+    }
+    else {
+        $connection = ocilogon($user,$password);
+    }
+
+    if (!empty($schema)) {
+        $schema = $schema.".";
+    }
+    else {
+        $schema = '';
+    }
+
+?>
diff --git a/ext/oci8/tests/create_table.inc b/ext/oci8/tests/create_table.inc
new file mode 100644
index 0000000000..c423ce577d
--- /dev/null
+++ b/ext/oci8/tests/create_table.inc
@@ -0,0 +1,12 @@
+<?php
+
+    if ($connection) {
+        $ora_sql = "CREATE TABLE 
+                                ".$schema."php_test_table (id NUMBER, value NUMBER) 
+                   ";
+                      
+        $statement = OCIParse($connection,$ora_sql);
+        OCIExecute($statement);
+    }
+
+?>
diff --git a/ext/oci8/tests/drop_table.inc b/ext/oci8/tests/drop_table.inc
new file mode 100644
index 0000000000..4e558f5e33
--- /dev/null
+++ b/ext/oci8/tests/drop_table.inc
@@ -0,0 +1,12 @@
+<?php
+
+    if ($connection) {
+        $ora_sql = "DROP TABLE
+                                ".$schema."php_test_table
+                   ";
+                      
+        $statement = OCIParse($connection,$ora_sql);
+        OCIExecute($statement);
+    }
+
+?>
diff --git a/ext/oci8/tests/skipif.inc b/ext/oci8/tests/skipif.inc
new file mode 100644
index 0000000000..ed0992c8d9
--- /dev/null
+++ b/ext/oci8/tests/skipif.inc
@@ -0,0 +1,10 @@
+<?php
+
+if (!extension_loaded('oci8')) die("skip oci8 extension is not available\n");
+
+/* 
+ * Remove or comment this line to run tests 
+ *
+ * */
+die("skip change default login/password\n");
+?>
-- 
2.40.0