xref: /PHP-8.2/ext/oci8/tests/null_byte_2.phpt (revision b5a14e6c)
1--TEST--
2Null bytes in SQL statements
3--EXTENSIONS--
4oci8
5--SKIPIF--
6<?php
7$target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
8require(__DIR__.'/skipif.inc');
9?>
10--INI--
11display_errors = On
12error_reporting = E_WARNING
13--FILE--
14<?php
15
16require(__DIR__.'/connect.inc');
17
18// Run Test
19
20echo "Test 1: Valid use of a null byte\n";
21
22$s = oci_parse($c, "select * \0from dual");
23oci_execute($s);
24oci_fetch_all($s, $res);
25var_dump($res);
26
27echo "Test 3: Using a null byte in a bind variable name\n";
28
29$s = oci_parse($c, "select * from dual where :bv = 1");
30$bv = 1;
31oci_bind_by_name($s, ":bv\0:bv", $bv);
32oci_execute($s);
33
34
35?>
36--EXPECTF--
37Test 1: Valid use of a null byte
38array(1) {
39  ["DUMMY"]=>
40  array(1) {
41    [0]=>
42    string(1) "X"
43  }
44}
45Test 3: Using a null byte in a bind variable name
46
47Warning: oci_bind_by_name(): ORA-01036: %s in %snull_byte_2.php on line %d
48
49Warning: oci_execute(): ORA-01008: %s in %snull_byte_2.php on line %d
50