(Sorry for the empty reply, wrong button clicked ...)
Adding the line to oci.def helped, DBD::Oracle 1.28 compiles fine with
the patch on W2K / Strawberry 5.12 / Oracle 10.2g.
The test t/26exe_array.t failes due to a bad plan, 406 test planned, but
407 tests run, see 26.txt and 128-test-fail.txt.
Alexander
On 03/24/2011 08:32 PM, John Scoles wrote:
Ok I think I know what it is looks like I forgot to put
OCIServerRelease
in the
oci.def
Add the word in there and see what happens
Silly mistake really but hard to catch unless you have the right test system
handy
We would of caught this if we had a broader test page for the Release
Cadidates, hint hint nudge nudge ;) ;)
Cheers
John Scoles
Date: Thu, 24 Mar 2011 13:27:20 +0100
From: alexan...@foken.de
To: dbi-users@perl.org
CC: jason.thurs...@gmail.com
Subject: Re: Fwd: Error 'making DBD:Oracle 1.28 on Cygwin W
DBD::Oracle 1.27 compiled, tested and installed without any problems.
The changes in
<URL:http://search.cpan.org/~pythian/DBD-Oracle-1.28/Changes#Changes_in_DBD-Oracle_1.28_%28svn_rev_14765%29>
don't look relevant to my environment. I can live with that.
Now it is clear that some change from 1.27 to 1.28 broke compatibilty
with Oracle 10.2g.
Alexander
On 03/24/2011 12:18 PM, Alexander Foken wrote:
Hmmm, on my other system, DBD::Oracle 1.23 and Oracle 10.2g work
perfectly. So, what's the difference?
XP vs. 2000 -- unlikely
Much older DBD::Oracle
Looking at the DBD::Oracle diffs available at search.cpan.org, I see
that OCIServerRelease exists in the diffs from 1.27 to 1.28 (in
Oracle.xs, condition added to avoid calling OCIServerVersion on
servers< 10.2), and in the diffs from 1.24b to 1.25 (don't quite
understand what happens there). But I see no change containing
OCIServerVersion in the diffs from 1.24b to 1.25.
I will try compiling 1.27, then 1.23 after lunch ...
Alexander
On 03/24/2011 11:59 AM, Alexander Foken wrote:
Hello,
sorry, just a "me too" posting. I was just about to ask for nearly(?)
the same problem.
I'm trying with Strawberry Perl 5.12.2.0 and 5.10.0.4, Oracle 10g,
DBD::Oracle 1.28, Windows 2000 Professional.
Final problem after tons of warnings: oci8.o: oci8.c: undefined
reference to 'OCIServerRelease'
See attached logfile of running perl Makefile.PL and dmake (with Perl
5.12, same messages with 5.10).
I would guess that there is a problem with DBD::Oracle, because we
get the same missing symbol for different OS versions, different
Perl ports, different Perl versions, different DBI versions,
different Oracle versions.
Alexander
On 03/24/2011 12:15 AM, Jason Thurston wrote:
Hello,
Does anyone have any ideas where to go from here?
I think "perl Makefile.PL" is successful but I get an error when
trying the next step "make".
The Error I get when trying to "make" is
"/home/foo/DBD-Oracle-1.28/oci8.c:4619: undefined reference to
`_OCIServerRelease'". See Below for details.
I originally tried with the cygwin cpan tool but then downloaded the
packaged and tried manually but got the exact same error.
DETAILS:
OS:
Windows 2003 Enterprise X64 Edition
$ uname -a
CYGWIN_NT-5.2-WOW64 mck-rnmwv4-ip42 1.7.8(0.236/5/3) 2011-03-01 09:36
i686 Cygwin
$ env|grep -i ora|two
ORACLE_USER=foo1/foo1@foo
ORACLE_SID=foo
ORACLE_USERID=foo1/foo1@foo
TWO_TASK=foo
TNS_ADMIN=E:\oracle\instantclient_11_2
PATH=/usr/local/bin:/usr/bin:/cygdrive/e/oracle/instantclient_11_2:/cygdrive/c/WINDOWS/system32:/cygdrive/c/WINDOWS:/cygdrive/c/WINDOWS/System32/Wbem:/cygdrive/c/WINDOWS/system32/WindowsPowerShell/v1.0:/cygdrive/e/PROGRA~1/BMCSOF~1/Patrol3/bin:/cygdrive/e/PROGRA~1/BMCSOF~1/MASTER~1/server/bin:/cygdrive/c/WINDOWS/system32/WindowsPowerShell/v1.0:/opt/java/bin
CLASSPATH=.;E:\oracle\instantclient_11_2/ojdbc6.jar
ORACLE_HOME=E:\oracle\instantclient_11_2
$ pwd
/home/foo/DBD-Oracle-1.28
$ perl -v
This is perl, v5.10.1 (*) built for i686-cygwin-thread-multi-64int
$ sqlplus foo1/foo1@foo
SQL*Plus: Release 11.2.0.2.0 Production on Wed Mar 23 19:02:30 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
se
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for HPUX: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 -
64bit Production
With the Partitioning and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
$ perl Makefile.PL
Using DBI 1.616 (for perl 5.010001 on i686-cygwin-thread-multi-64int)
installed in /usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI/
Configuring DBD::Oracle for perl 5.010001 on cygwin
(i686-cygwin-thread-multi-64int)
Remember to actually *READ* the README file! Especially if you have
any problems.
Installing on a cygwin, Ver#1.7
Using Oracle in E:/oracle/instantclient_11_2
DEFINE _SQLPLUS_RELEASE = "1102000200" (CHAR)
Oracle version 11.2.0.2 (11.2)
Using OCI directory 'sdk'
client_version=11.2
DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT
-DORA_OCI_VERSION=\"11.2.0.2\" -DORA_OCI_102 -DORA_OCI_112
Checking for functioning wait.ph
System: perl5.010001 cygwin_nt-5.1 reini 1.7.5(0.22553) 2010-04-12
19:07 i686 cygwin
Compiler: gcc-4 -O3 -DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -g3
-fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include
Linker: /usr/bin/ld
Sysliblist:
WARNING: If you have problems you may need to rebuild perl with
-Uusemymalloc.
Checking if your kit is complete...
Looks good
LD_RUN_PATH=E:/oracle/instantclient_11_2/lib:E:/oracle/instantclient_11_2/rdbms/lib
Using DBD::Oracle 1.28.
Using DBD::Oracle 1.28.
Using DBI 1.616 (for perl 5.010001 on i686-cygwin-thread-multi-64int)
installed in /usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI/
Writing Makefile for DBD::Oracle
*** If you have problems...
read all the log printed above, and the README and
README.help.txt files.
(Of course, you have read README by now anyway, haven't you?)
$ make
cp Oracle.pm blib/lib/DBD/Oracle.pm
cp oraperl.ph blib/lib/oraperl.ph
cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h
cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h
cp Oraperl.pm blib/lib/Oraperl.pm
cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h
cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.pm
cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm
cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm
/usr/bin/perl.exe -p -e "s/~DRIVER~/Oracle/g"
/usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI/Driver.xst>
Oracle.xsi
/usr/bin/perl.exe /usr/lib/perl5/5.10/ExtUtils/xsubpp -typemap
/usr/lib/perl5/5.10/ExtUtils/typemap -typemap typemap Oracle.xs>
Oracle.xsc&& mv Oracle.xsc Oracle.c
gcc-4 -c -IE:/oracle/instantclient_11_2/sdk/include
-IE:/oracle/instantclient_11_2/rdbms/demo
-I/usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI
-DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -g3 -fno-strict-aliasing
-pipe -fstack-protector -I/usr/local/include -DUSEIMPORTLIB -O3
-DVERSION=\"1.28\" -DXS_VERSION=\"1.28\"
"-I/usr/lib/perl5/5.10/i686-cygwin/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.2\" -DORA_OCI_102
-DORA_OCI_112 Oracle.c
gcc-4 -c -IE:/oracle/instantclient_11_2/sdk/include
-IE:/oracle/instantclient_11_2/rdbms/demo
-I/usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI
-DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -g3 -fno-strict-aliasing
-pipe -fstack-protector -I/usr/local/include -DUSEIMPORTLIB -O3
-DVERSION=\"1.28\" -DXS_VERSION=\"1.28\"
"-I/usr/lib/perl5/5.10/i686-cygwin/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.2\" -DORA_OCI_102
-DORA_OCI_112 dbdimp.c
dbdimp.c: In function ‘dbd_rebind_ph_char’:
dbdimp.c:2666: warning: cast from pointer to integer of different size
dbdimp.c: In function ‘dbd_rebind_ph_xml’:
dbdimp.c:2864: warning: cast to pointer from integer of different size
dbdimp.c: In function ‘ora_bind_ph’:
dbdimp.c:3157: warning: format ‘%ld’ expects type ‘long int’,
but argument 2 has type ‘IV’
dbdimp.c:3166: warning: format ‘%ld’ expects type ‘long int’,
but argument 2 has type ‘IV’
dbdimp.c:3200: warning: format ‘%ld’ expects type ‘long int’,
but argument 3 has type ‘IV’
dbdimp.c: At top level:
dbdimp.c:288: warning: ‘oratype_rebind_ok’ defined but not used
gcc-4 -c -IE:/oracle/instantclient_11_2/sdk/include
-IE:/oracle/instantclient_11_2/rdbms/demo
-I/usr/lib/perl5/site_perl/5.10/i686-cygwin/auto/DBI
-DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -g3 -fno-strict-aliasing
-pipe -fstack-protector -I/usr/local/include -DUSEIMPORTLIB -O3
-DVERSION=\"1.28\" -DXS_VERSION=\"1.28\"
"-I/usr/lib/perl5/5.10/i686-cygwin/CORE" -Wall -Wno-comment
-DUTF8_SUPPORT -DORA_OCI_VERSION=\"11.2.0.2\" -DORA_OCI_102
-DORA_OCI_112 oci8.c
oci8.c: In function ‘ora_blob_read_mb_piece’:
oci8.c:1737: warning: format ‘%lu’ expects type ‘long unsigned
int’, but argument 6 has type ‘ub4’
oci8.c: In function ‘ora_st_fetch’:
oci8.c:3895: warning: format ‘%d’ expects type ‘int’, but
argument 4 has type ‘IV’
oci8.c:3895: warning: format ‘%d’ expects type ‘int’, but
argument 4 has type ‘IV’
oci8.c:3903: warning: format ‘%d’ expects type ‘int’, but
argument 3 has type ‘IV’
oci8.c:3903: warning: format ‘%d’ expects type ‘int’, but
argument 3 has type ‘IV’
rm -f blib/arch/auto/DBD/Oracle/Oracle.dll
LD_RUN_PATH="E:/oracle/instantclient_11_2/lib:E:/oracle/instantclient_11_2/rdbms/lib"
g++-4 --shared -Wl,--enable-auto-import -Wl,--export-all-symbols
-Wl,--stack,8388608 -Wl,--enable-auto-image-base -L/usr/local/lib
-fstack-protector Oracle.o dbdimp.o oci8.o -o
blib/arch/auto/DBD/Oracle/Oracle.dll \
/usr/lib/perl5/5.10/i686-cygwin/CORE/cygperl5_10.dll
-L/home/e8hqxdh/DBD-Oracle-1.28 -loci \
oci8.o: In function `ora_db_version':
/home/foo/DBD-Oracle-1.28/oci8.c:4619: undefined reference to
`_OCIServerRelease'
collect2: ld returned 1 exit status
make: *** [blib/arch/auto/DBD/Oracle/Oracle.dll] Error 1
C:\strawberry\manual\DBD-Oracle-1.28>dmake test
C:\strawberry\perl\bin\perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib\lib', 'blib\arch')" t/*.t
t/01base.t .............. # Test loading DBI, DBD::Oracle and version
t/01base.t .............. ok
t/10general.t ........... ok
t/12impdata.t ........... ok
t/14threads.t ........... ok
t/15nls.t ............... ok
t/20select.t ............ ok
t/21nchar.t ............. ok
t/22nchar_al32utf8.t .... ok
t/22nchar_utf8.t ........ ok
t/23wide_db.t ........... skipped: Database character set is not Unicode
t/23wide_db_8bit.t ...... skipped: Database character set is not Unicode
t/23wide_db_al32utf8.t .. skipped: Database character set is not Unicode
t/24implicit_utf8.t ..... ok
t/25plsql.t ............. ok
t/26exe_array.t ......... Dubious, test returned 255 (wstat 65280, 0xff00)
All 406 subtests passed
t/28array_bind.t ........ ok
t/30long.t .............. ok
t/31lob.t ............... ok
t/31lob_extended.t ...... ok
t/32xmltype.t ........... ok
t/34pres_lobs.t ......... ok
t/40ph_type.t ........... 1/19 Placeholder behaviour for ora_type=1 VARCHAR2 (t
he default) varies with Oracle version.
Oracle 7 didn't strip trailing spaces, Oracle 8 did, until 9.2.x
Your system doesn't. If that seems odd, let us know.
t/40ph_type.t ........... ok
t/50cursor.t ............ Can't determine open_cursors from v$parameter, so usin
g default
t/50cursor.t ............ ok
t/51scroll.t ............ ok
t/55nested.t ............ ok
t/56embbeded.t .......... ok
t/58object.t ............ ok
t/60reauth.t ............ skipped: ORACLE_USERID_2 not defined.
t/70meta.t .............. ok
t/80ora_charset.t ....... ok
Test Summary Report
-------------------
t/26exe_array.t (Wstat: 65280 Tests: 407 Failed: 1)
Failed test: 407
Non-zero exit status: 255
Parse errors: Bad plan. You planned 406 tests but ran 407.
Files=30, Tests=1555, 131 wallclock secs ( 0.45 usr + 0.50 sys = 0.95 CPU)
Result: FAIL
Failed 1/30 test programs. 1/1555 subtests failed.
dmake: Error code 255, while making 'test_dynamic'
C:\strawberry\manual\DBD-Oracle-1.28>
--- oci.def-old Wed Dec 15 01:41:56 2010
+++ oci.def Fri Mar 25 10:08:24 2011
@@ -225,6 +225,7 @@
OCISecurity_PKEncrypt
OCIServerAttach
OCIServerDetach
+OCIServerRelease
OCIServerVersion
OCISessionBegin
OCISessionEnd
1..406
ok 1 - use Data::Dumper;
ok 2 - create test table
ok 3 - no error in execute_array eval
ok 4 - execute_array returned 5 rows executed
ok 5 - total affected 5
ok 6 - no error captured
ok 7 - 5 rows in tuple_status
ok 8 - row 0 tuple status unknown
ok 9 - row 1 tuple status unknown
ok 10 - row 2 tuple status unknown
ok 11 - row 3 tuple status unknown
ok 12 - row 4 tuple status unknown
ok 13 - row 0 p1 data
ok 14 - row 0 p2 data
ok 15 - row 1 p1 data
ok 16 - row 1 p2 data
ok 17 - row 2 p1 data
ok 18 - row 2 p2 data
ok 19 - row 3 p1 data
ok 20 - row 3 p2 data
ok 21 - row 4 p1 data
ok 22 - row 4 p2 data
ok 23 - no error in execute_array eval
ok 24 - execute_array returned 5 rows executed
ok 25 - total affected 5
ok 26 - no error captured
ok 27 - 5 rows in tuple_status
ok 28 - row 0 tuple status unknown
ok 29 - row 1 tuple status unknown
ok 30 - row 2 tuple status unknown
ok 31 - row 3 tuple status unknown
ok 32 - row 4 tuple status unknown
ok 33 - row 0 p1 data
ok 34 - row 0 p2 data
ok 35 - row 1 p1 data
ok 36 - row 1 p2 data
ok 37 - row 2 p1 data
ok 38 - row 2 p2 data
ok 39 - row 3 p1 data
ok 40 - row 3 p2 data
ok 41 - row 4 p1 data
ok 42 - row 4 p2 data
ok 43 - no error in execute_array eval
ok 44 - execute_array returned 5 rows executed
ok 45 - total affected 5
ok 46 - no error captured
ok 47 - 5 rows in tuple_status
ok 48 - row 0 tuple status unknown
ok 49 - row 1 tuple status unknown
ok 50 - row 2 tuple status unknown
ok 51 - row 3 tuple status unknown
ok 52 - row 4 tuple status unknown
ok 53 - row 0 p1 data
ok 54 - row 0 p2 data
ok 55 - row 1 p1 data
ok 56 - row 1 p2 data
ok 57 - row 2 p1 data
ok 58 - row 2 p2 data
ok 59 - row 3 p1 data
ok 60 - row 3 p2 data
ok 61 - row 4 p1 data
ok 62 - row 4 p2 data
ok 63 - no error in execute_array eval
ok 64 - execute_array returned 5 rows executed
ok 65 - total affected 5
ok 66 - no error captured
ok 67 - 5 rows in tuple_status
ok 68 - row 0 tuple status unknown
ok 69 - row 1 tuple status unknown
ok 70 - row 2 tuple status unknown
ok 71 - row 3 tuple status unknown
ok 72 - row 4 tuple status unknown
ok 73 - row 0 p1 data
ok 74 - row 0 p2 data
ok 75 - row 1 p1 data
ok 76 - row 1 p2 data
ok 77 - row 2 p1 data
ok 78 - row 2 p2 data
ok 79 - row 3 p1 data
ok 80 - row 3 p2 data
ok 81 - row 4 p1 data
ok 82 - row 4 p2 data
ok 83 - no error in execute_array eval
ok 84 - execute_array returned '0E0' rows executed
ok 85 - total affected 0
ok 86 - no error captured
ok 87 - 0E0 rows in tuple_status
ok 88 - no error in execute_array eval
ok 89 - execute_array returned 5 rows executed
ok 90 - no error captured
ok 91 - 5 rows in tuple_status
ok 92 - row 0 tuple status unknown
ok 93 - row 1 tuple status unknown
ok 94 - row 2 tuple status unknown
ok 95 - row 3 tuple status unknown
ok 96 - row 4 tuple status unknown
ok 97 - row 0 p1 data
ok 98 - row 0 p2 data
ok 99 - row 1 p1 data
ok 100 - row 1 p2 data
ok 101 - row 2 p1 data
ok 102 - row 2 p2 data
ok 103 - row 3 p1 data
ok 104 - row 3 p2 data
ok 105 - row 4 p1 data
ok 106 - row 4 p2 data
ok 107 - no error in execute_array eval
ok 108 - execute_array returned 5 rows executed
ok 109 - no error captured
ok 110 - 5 rows in tuple_status
ok 111 - row 0 tuple status unknown
ok 112 - row 1 tuple status unknown
ok 113 - row 2 tuple status unknown
ok 114 - row 3 tuple status unknown
ok 115 - row 4 tuple status unknown
ok 116 - row 0 p1 data
ok 117 - row 0 p2 data
ok 118 - row 1 p1 data
ok 119 - row 1 p2 data
ok 120 - row 2 p1 data
ok 121 - row 2 p2 data
ok 122 - row 3 p1 data
ok 123 - row 3 p2 data
ok 124 - row 4 p1 data
ok 125 - row 4 p2 data
ok 126 - no error in execute_array eval
ok 127 - execute_array returned 5 rows executed
ok 128 - no error captured
ok 129 - 5 rows in tuple_status
ok 130 - row 0 tuple status unknown
ok 131 - row 1 tuple status unknown
ok 132 - row 2 tuple status unknown
ok 133 - row 3 tuple status unknown
ok 134 - row 4 tuple status unknown
ok 135 - row 0 p1 data
ok 136 - row 0 p2 data
ok 137 - row 1 p1 data
ok 138 - row 1 p2 data
ok 139 - row 2 p1 data
ok 140 - row 2 p2 data
ok 141 - row 3 p1 data
ok 142 - row 3 p2 data
ok 143 - row 4 p1 data
ok 144 - row 4 p2 data
ok 145 - no error in execute_array eval
ok 146 - execute_array returned 5 rows executed
ok 147 - no error captured
ok 148 - 5 rows in tuple_status
ok 149 - row 0 tuple status unknown
ok 150 - row 1 tuple status unknown
ok 151 - row 2 tuple status unknown
ok 152 - row 3 tuple status unknown
ok 153 - row 4 tuple status unknown
ok 154 - row 0 p1 data
ok 155 - row 0 p2 data
ok 156 - row 1 p1 data
ok 157 - row 1 p2 data
ok 158 - row 2 p1 data
ok 159 - row 2 p2 data
ok 160 - row 3 p1 data
ok 161 - row 3 p2 data
ok 162 - row 4 p1 data
ok 163 - row 4 p2 data
ok 164 - no error in execute_array eval
ok 165 - execute_array returned '0E0' rows executed
ok 166 - no error captured
ok 167 - 0E0 rows in tuple_status
ok 168 - error in execute_array eval
ok 169 - error captured
ok 170 - row 0 tuple status unknown
ok 171 - row 1 tuple status unknown
ok 172 - row 2 tuple status unknown
ok 173 - row 3 tuple status unknown
ok 174 - array in array tuple status
ok 175 - 3 elements in array tuple status error
ok 176 - row 0 p1 data
ok 177 - row 0 p2 data
ok 178 - row 1 p1 data
ok 179 - row 1 p2 data
ok 180 - row 2 p1 data
ok 181 - row 2 p2 data
ok 182 - row 3 p1 data
ok 183 - row 3 p2 data
ok 184 - error in execute_array eval
ok 185 - error captured
ok 186 - row 0 tuple status unknown
ok 187 - row 1 tuple status unknown
ok 188 - row 2 tuple status unknown
ok 189 - array in array tuple status
ok 190 - 3 elements in array tuple status error
ok 191 - row 4 tuple status unknown
ok 192 - row 0 p1 data
ok 193 - row 0 p2 data
ok 194 - row 1 p1 data
ok 195 - row 1 p2 data
ok 196 - row 2 p1 data
ok 197 - row 2 p2 data
ok 198 - row 3 p1 data
ok 199 - row 3 p2 data
ok 200 - error in execute_array eval
ok 201 - error captured
ok 202 - row 0 tuple status unknown
ok 203 - row 1 tuple status unknown
ok 204 - row 2 tuple status unknown
ok 205 - row 3 tuple status unknown
ok 206 - array in array tuple status
ok 207 - 3 elements in array tuple status error
ok 208 - row 0 p1 data
ok 209 - row 0 p2 data
ok 210 - row 1 p1 data
ok 211 - row 1 p2 data
ok 212 - row 2 p1 data
ok 213 - row 2 p2 data
ok 214 - row 3 p1 data
ok 215 - row 3 p2 data
ok 216 - error in execute_array eval
ok 217 - error captured
ok 218 - row 0 tuple status unknown
ok 219 - row 1 tuple status unknown
ok 220 - row 2 tuple status unknown
ok 221 - array in array tuple status
ok 222 - 3 elements in array tuple status error
ok 223 - row 4 tuple status unknown
ok 224 - row 0 p1 data
ok 225 - row 0 p2 data
ok 226 - row 1 p1 data
ok 227 - row 1 p2 data
ok 228 - row 2 p1 data
ok 229 - row 2 p2 data
ok 230 - row 3 p1 data
ok 231 - row 3 p2 data
ok 232 - no error in execute_array eval
ok 233 - execute_array returned undef rows executed
ok 234 - total affected undef
ok 235 - row 0 tuple status unknown
ok 236 - row 1 tuple status unknown
ok 237 - row 2 tuple status unknown
ok 238 - row 3 tuple status unknown
ok 239 - array in array tuple status
ok 240 - 3 elements in array tuple status error
ok 241 - row 0 p1 data
ok 242 - row 0 p2 data
ok 243 - row 1 p1 data
ok 244 - row 1 p2 data
ok 245 - row 2 p1 data
ok 246 - row 2 p2 data
ok 247 - row 3 p1 data
ok 248 - row 3 p2 data
ok 249 - no error in execute_array eval
ok 250 - execute_array returned undef rows executed
ok 251 - total affected undef
ok 252 - row 0 tuple status unknown
ok 253 - row 1 tuple status unknown
ok 254 - row 2 tuple status unknown
ok 255 - array in array tuple status
ok 256 - 3 elements in array tuple status error
ok 257 - row 4 tuple status unknown
ok 258 - row 0 p1 data
ok 259 - row 0 p2 data
ok 260 - row 1 p1 data
ok 261 - row 1 p2 data
ok 262 - row 2 p1 data
ok 263 - row 2 p2 data
ok 264 - row 3 p1 data
ok 265 - row 3 p2 data
ok 266 - no error in execute_array eval
ok 267 - execute_array returned undef rows executed
ok 268 - row 0 tuple status unknown
ok 269 - row 1 tuple status unknown
ok 270 - row 2 tuple status unknown
ok 271 - row 3 tuple status unknown
ok 272 - array in array tuple status
ok 273 - 3 elements in array tuple status error
ok 274 - row 0 p1 data
ok 275 - row 0 p2 data
ok 276 - row 1 p1 data
ok 277 - row 1 p2 data
ok 278 - row 2 p1 data
ok 279 - row 2 p2 data
ok 280 - row 3 p1 data
ok 281 - row 3 p2 data
ok 282 - no error in execute_array eval
ok 283 - execute_array returned undef rows executed
ok 284 - row 0 tuple status unknown
ok 285 - row 1 tuple status unknown
ok 286 - row 2 tuple status unknown
ok 287 - array in array tuple status
ok 288 - 3 elements in array tuple status error
ok 289 - row 4 tuple status unknown
ok 290 - row 0 p1 data
ok 291 - row 0 p2 data
ok 292 - row 1 p1 data
ok 293 - row 1 p2 data
ok 294 - row 2 p1 data
ok 295 - row 2 p2 data
ok 296 - row 3 p1 data
ok 297 - row 3 p2 data
ok 298 - no error in execute_array eval
ok 299 - execute_array returned 5 rows executed
ok 300 - total affected 5
ok 301 - no error captured
ok 302 - 5 rows in tuple_status
ok 303 - row 0 tuple status unknown
ok 304 - row 1 tuple status unknown
ok 305 - row 2 tuple status unknown
ok 306 - row 3 tuple status unknown
ok 307 - row 4 tuple status unknown
ok 308 - execute on second table
ok 309 - second statement is in executed state
ok 310 - no error in execute_array eval
ok 311 - execute_array returned 5 rows executed
ok 312 - total affected 5
ok 313 - no error captured
ok 314 - 5 rows in tuple_status
ok 315 - row 0 tuple status unknown
ok 316 - row 1 tuple status unknown
ok 317 - row 2 tuple status unknown
ok 318 - row 3 tuple status unknown
ok 319 - row 4 tuple status unknown
ok 320 - row 0 p1 data
ok 321 - row 0 p2 data
ok 322 - row 1 p1 data
ok 323 - row 1 p2 data
ok 324 - row 2 p1 data
ok 325 - row 2 p2 data
ok 326 - row 3 p1 data
ok 327 - row 3 p2 data
ok 328 - row 4 p1 data
ok 329 - row 4 p2 data
ok 330 - no error in execute_array eval
ok 331 - execute_array returned 5 rows executed
ok 332 - total affected 5
ok 333 - no error captured
ok 334 - 5 rows in tuple_status
ok 335 - row 0 tuple status unknown
ok 336 - row 1 tuple status unknown
ok 337 - row 2 tuple status unknown
ok 338 - row 3 tuple status unknown
ok 339 - row 4 tuple status unknown
ok 340 - row 0 p1 data
ok 341 - row 0 p2 data
ok 342 - row 1 p1 data
ok 343 - row 1 p2 data
ok 344 - row 2 p1 data
ok 345 - row 2 p2 data
ok 346 - row 3 p1 data
ok 347 - row 3 p2 data
ok 348 - row 4 p1 data
ok 349 - row 4 p2 data
ok 350 - no error in execute_array eval
ok 351 - execute_array returned 5 rows executed
ok 352 - total affected 5
ok 353 - no error captured
ok 354 - 5 rows in tuple_status
ok 355 - row 0 tuple status unknown
ok 356 - row 1 tuple status unknown
ok 357 - row 2 tuple status unknown
ok 358 - row 3 tuple status unknown
ok 359 - row 4 tuple status unknown
ok 360 - row 0 p1 data
ok 361 - row 0 p2 data
ok 362 - row 1 p1 data
ok 363 - row 1 p2 data
ok 364 - row 2 p1 data
ok 365 - row 2 p2 data
ok 366 - row 3 p1 data
ok 367 - row 3 p2 data
ok 368 - row 4 p1 data
ok 369 - row 4 p2 data
ok 370 - no error in execute_array eval
ok 371 - execute_array returned 5 rows executed
ok 372 - total affected 4
ok 373 - no error captured
ok 374 - 5 rows in tuple_status
ok 375 - row 0 tuple status unknown
ok 376 - row 1 tuple status unknown
ok 377 - row 2 tuple status unknown
ok 378 - row 3 tuple status unknown
ok 379 - row 4 tuple status unknown
ok 380 - row 0 p1 data
ok 381 - row 0 p2 data
ok 382 - row 1 p1 data
ok 383 - row 1 p2 data
ok 384 - row 2 p1 data
ok 385 - row 2 p2 data
ok 386 - row 3 p1 data
ok 387 - row 3 p2 data
ok 388 - row 4 p1 data
ok 389 - row 4 p2 data
ok 390 - no error in execute_array eval
ok 391 - execute_array returned 2 rows executed
ok 392 - total affected 5
ok 393 - no error captured
ok 394 - 2 rows in tuple_status
ok 395 - row 0 tuple status unknown
ok 396 - row 1 tuple status unknown
ok 397 - row 0 p1 data
ok 398 - row 0 p2 data
ok 399 - row 1 p1 data
ok 400 - row 1 p2 data
ok 401 - row 2 p1 data
ok 402 - row 2 p2 data
ok 403 - row 3 p1 data
ok 404 - row 3 p2 data
ok 405 - row 4 p1 data
ok 406 - row 4 p2 data
ok 407 - no warnings
