Test: /ext/odbc/tests/bug47803.phpt - Version 7.3.13        

Bug #47803 Executing prepared statements is succesfull only for the first two statements
Submitted: 2009-03-27 09:10:43 Modified: 2014-12-31 02:13:04
From: egil Assigned:
Status: Closed Package: ODBC related
PHP Version: 5.2.9 OS: Windows XP SP 3

There is 1 diff reported by users for this test.

Count Diff
1 (100%)
001+ Warning: odbc_exec(): SQL error: Specified database name 'ODBCTEST' does not match parameter database name in tip file 'tibero'.
002+ at line 1, column 17 of null:
003+ CREATE DATABASE odbcTEST
004+ ^^^^^^^^, SQL state 72000 in SQLExecDirect in %s/bug47803.php on line 33
005+
006+ Warning: odbc_exec(): SQL error: Invalid identifier.
007+ at line 2, column 3 of null:
008+ [PAR_ID] [int] NOT NULL,
009+ ^, SQL state ERRPA in SQLExecDirect in %s/bug47803.php on line 34
010+
011+ Warning: odbc_exec(): SQL error: Specified schema object was not found.
012+ at line 1, column 14 of null:
013+ INSERT INTO FOO
014+ ^, SQL state 42S02 in SQLExecDirect in %s/bug47803.php on line 35
015+
016+ Warning: odbc_execute(): SQL error: Wrong parameter number given. , SQL state 07001 in SQLExecute in %s/bug47803.php on line 58
017+ [sql] exec: array(test 1, 1)==DONE==
001- array(3) {
002- ["PAR_ID"]=>
003- string(1) "1"
004- ["PAR_INT"]=>
005- string(2) "14"
006- ["PAR_CHR"]=>
007- string(6) "test 1"
008- }
009- array(3) {
010- ["PAR_ID"]=>
011- string(1) "2"
012- ["PAR_INT"]=>
013- string(2) "30"
014- ["PAR_CHR"]=>
015- string(6) "test 2"
016- }
017- array(3) {
018- ["PAR_ID"]=>
019- string(1) "3"
020- ["PAR_INT"]=>
021- string(1) "7"
022- ["PAR_CHR"]=>
023- string(6) "test 3"
024- }
025- array(3) {
026- ["PAR_ID"]=>
027- string(1) "4"
028- ["PAR_INT"]=>
029- string(1) "7"
030- ["PAR_CHR"]=>
031- string(6) "test 4"
032- }
033- array(3) {
034- ["PAR_ID"]=>
035- string(1) "5"
036- ["PAR_INT"]=>
037- string(1) "0"
038- ["PAR_CHR"]=>
039- string(6) "test 5"
040- }
041- array(3) {
042- ["PAR_ID"]=>
043- string(2) "10"
044- ["PAR_INT"]=>
045- string(8) "20140620"
046- ["PAR_CHR"]=>
047- string(7) "test 10"
048- }
049- array(3) {
050- ["PAR_ID"]=>
051- string(1) "9"
052- ["PAR_INT"]=>
053- string(8) "20140201"
054- ["PAR_CHR"]=>
055- string(6) "test 9"
056- }
057- array(3) {
058- ["PAR_ID"]=>
059- string(1) "8"
060- ["PAR_INT"]=>
061- string(8) "20140201"
062- ["PAR_CHR"]=>
063- string(6) "test 8"
064- }
065- array(3) {
066- ["PAR_ID"]=>
067- string(1) "7"
068- ["PAR_INT"]=>
069- string(8) "20130901"
070- ["PAR_CHR"]=>
071- string(6) "test 7"
072- }
073- array(3) {
074- ["PAR_ID"]=>
075- string(1) "7"
076- ["PAR_INT"]=>
077- string(8) "20130901"
078- ["PAR_CHR"]=>
079- string(6) "test 7"
080- }
081- ==DONE==