--
mathematics: the science of quantity, shape, and arrangement
computersci: the science of information description and transformation
liberalarts: essential study for adequate education and civic participation.
--- Begin Message ---Dear Terrence, I'm trying to get DBIx-Recordset-0.25a to build and test on an SGI ALTIX. It's failing right after the "Select with sub table..." test. Diagnostic output follows. If you need more information to suggest a solution, please let me know. Thanks. --BobHere's the output of perl -V: horta root 28 # /stf/sys/bin/perl -V Summary of my perl5 (revision 5 version 8 subversion 4) configuration: Platform: osname=linux, osvers=2.4.21-sgi240rp04032500_10054, archname=ia64-linux-multi-stdio uname='linux horta 2.4.21-sgi240rp04021313_10046 #1 smp fri feb 13 14:02:27 pst 2004 ia64 unknown ' config_args='-e -d -f config.sh.safe.altix.5' hint=previous, useposix=true, d_sigaction=define usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=define useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef use64bitint=define use64bitall=define uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='icc -g', ccflags ='-w0 -ansi_alias- -I/stf/altix/sys/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm', optimize='-O2', cppflags='-w0 -ansi_alias- -I/stf/altix/sys/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -w0 -ansi_alias- -I/stf/altix/sys/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -w0 -ansi_alias- -I/stf/altix/sys/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -w0 -ansi_alias- -I/stf/altix/sys/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm' ccversion='', gccversion='Intel(R) C++ gcc 3.0 mode', gccosandvers='' intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8 alignbytes=8, prototype=define Linker and Libraries: ld='icc -g', ldflags ='-L/stf/altix/sys/lib -Wl,-rpath,/stf/altix/sys/lib' libpth=/stf/altix/sys/lib /lib /usr/lib libs=-lmalloc -ldb -lnsl -lndbm -lgdbm -ldl -lm -lc -lcrypt -lutil perllibs=-lmalloc -lnsl -ldl -lm -lc -lcrypt -lutil libc=, so=so, useshrplib=false, libperl=libperl.a gnulibc_version='2.2.4' Dynamic Linking: dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic' cccdlflags='-fpic', lddlflags='-shared -L/stf/altix/sys/lib -Wl,-rpath,/stf/altix/sys/lib' Characteristics of this binary (from libperl): Compile-time options: MULTIPLICITY USE_64_BIT_INT USE_64_BIT_ALL USE_LARGE_FILES PERL_IMPLICIT_CONTEXT Built under linux Compiled at Jun 14 2004 19:26:04 @INC: /stf/altix/sys/perl/lib/5.8/ia64-linux-multi /stf/altix/sys/perl/lib/5.8 /stf/altix/sys/perl/lib/site_perl/5.8/ia64-linux-multi /stf/altix/sys/perl/lib/site_perl/5.8 /stf/altix/sys/perl/lib/site_perl/5.8 /perl/lib/site_perl/5.005 Here's the output of perl Makefile.PL: Found DBI version 1.42 Use previous configuration for tests(y/n) [y]Checking if your kit is complete... Looks good Writing Makefile for DBIx::Recordset Here's the output of make test: + /stf/altix/sys/bin/perl test.pl Pg dbi:Pg:dbname=pgtest;port=6542 root root Loading... ok Using the following parameters for testing: DBD-Driver: Pg Database: dbi:Pg:dbname=pgtest;port=6542 User: root Password: root Table: dbixrs1 Table: dbixrs2 Table: dbixrs3 Table: dbixrs4 Table: dbix_rs5 Table: dbix_rs6 Table: dbixseq Table: dbixrsdel DBI-Version: 1.42 DBD-Version: 1.32 Creating the testtables... ok Setup Object for dbixrs1... ok SQLSelect All... ok Setup Object for dbixrs2... ok SQLSelect All... ok Setup Object for dbixrs1, dbixrs2... ok SQLSelect All... ok Setup Object for dbixrs1, dbixrs3... ok SQLSelect All... ok Setup Object for dbixrs1, dbixrs4... ok SQLSelect All... ok Setup Object for dbixrs1... ok Select id (where as hash)... ok Select id (where as string)... ok Select name... ok Select dbixrs1.name... ok Select dbixrs2.name2 id=id... ok Select dbixrs2.value2 id=id... ok Select multiply values... ok Select multiply values array ref... ok Select multiply values & operators... ok Select $valuesplit... ok Select multiply fields 1... ok Select multiply fields 2... ok Select multiply fields & values... ok MoreRecords yes... ok Search... ok Search... ok MoreRecords no... ok Search with subexpr... ok Search first two... ok MoreRecords with $max... ok MoreRecords(1) with $max ... ok MoreRecords with $max 2... ok New Search for more... ok MoreRecords(1) with $max no... ok New Search for more 2... ok MoreRecords(1) with $max no 2... ok Search next ones... ok Search prevs one... ok Search last ones... ok Search goto last... ok Select NULL values... ok Select NOT NULL values... ok Select empty values... ok Select 0... ok Select NULL values Ig-1... ok Select empty values Ig-1... ok Select 0 Ig-1... ok Select NULL values Ig-2... ok Select empty values Ig-2... ok Select 0 Ig-2... ok New Search... ok Search cont... ok Search $operator <... ok Search *id *name... ok Search $conj or... ok Search multfield *<field>... ok Search $compconj... ok Order, Group, Append... ok Search with JOIN... ok New Search id_typ... ok !LongNames with !Fields... ok !LongNames without !Fields... ok New Setup... ok SQLInsert... ok New Insert... ok Insert without quoting... ok Update... ok Update without quoting... ok Update to NULL... ok New Update... ok New Delete... ok New Execute Search (default)... ok Execute =search... ok Execute =insert... ok Execute =update... ok Execute =insert... ok Execute =delete... ok DeleteWithLinks... ok - 2 ... ok Array Update/Insert... ok - 2 ... ok - 3 ... ok Array Update/Insert -> Flush... ok Dirty... ok - 2 ... ok Array Update/Insert -> Flush 2... ok Array Insert Hashref... ok Array Add Record... ok Array Add Empty Record (Ndx)... ok Array Add Empty Record (CurrRec)... ok Select id (Hash)... ok Select name (Hash)... ok Iterate over ::Hash... ok - 2 ... ok - 3 ... ok - 4 ... ok - 5 ... ok - 6 ... ok - 7 ... ok Select name (PreFetch Hash)... ok Iterate over ::Hash PreFetch... ok - 2 ... ok - 3 ... ok - 4 ... ok - 5 ... ok - 6 ... ok PreFetch Hash with merge... ok Hash with merge... ok Select id (HashAsRowKey)... ok Select name (Hash) with setup... ok Modify Hash... ok Add To Hash... ok Add Hashref To Hash ... ok Modify PrimKey in Hash... ok Add undef as PrimKey to Hash... ok - 2 ... ok Test Syntax error... ok Test error within setup... ok MoreRecords on empty set... ok First on empty set... ok Next on empty set... ok Use First to get first record... ok Use First/Next to get all records... ok Use Next to get all records... ok Use Reset/Next to get all records... ok Update via assigning array ref... ok - 2 ... ok Update via assigning array ref 2... ok - 2 ... ok Select with sub table... ok - 2 ... Test terminated with fatal error! Look at test.log Here's the first and last 500 lines of test.log: Using the following parameters for testing: DBD-Driver: Pg Database: dbi:Pg:dbname=pgtest;port=6542 User: root Password: root Table: dbixrs1 Table: dbixrs2 Table: dbixrs3 Table: dbixrs4 Table: dbix_rs5 Table: dbix_rs6 Table: dbixseq Table: dbixrsdel DBI-Version: 1.42 DBD-Version: 1.32 Creating the testtables... -------------------- TEST-DAT: Table dbixrs1 $TestCheck{1}{addon} = Is TEST-DAT: Table dbixrs1 $TestCheck{1}{value1} = 9991 TEST-DAT: Table dbixrs1 $TestCheck{1}{name} = First Name TEST-DAT: Table dbixrs1 $TestCheck{1}{id} = 1 TEST-DAT: Table dbixrs1 $TestCheck{2}{addon} = it TEST-DAT: Table dbixrs1 $TestCheck{2}{value1} = 9992 TEST-DAT: Table dbixrs1 $TestCheck{2}{name} = Second Name TEST-DAT: Table dbixrs1 $TestCheck{2}{id} = 2 TEST-DAT: Table dbixrs1 $TestCheck{3}{addon} = it ok? TEST-DAT: Table dbixrs1 $TestCheck{3}{value1} = 9993 TEST-DAT: Table dbixrs1 $TestCheck{3}{name} = Third Name TEST-DAT: Table dbixrs1 $TestCheck{3}{id} = 3 TEST-DAT: Table dbixrs1 $TestCheck{4}{addon} = Or not?? TEST-DAT: Table dbixrs1 $TestCheck{4}{value1} = 9994 TEST-DAT: Table dbixrs1 $TestCheck{4}{name} = Fourth Name TEST-DAT: Table dbixrs1 $TestCheck{4}{id} = 4 TEST-DAT: Table dbixrs1 $TestCheck{5}{addon} = Is TEST-DAT: Table dbixrs1 $TestCheck{5}{value1} = 9995 TEST-DAT: Table dbixrs1 $TestCheck{5}{name} = Fivth Name TEST-DAT: Table dbixrs1 $TestCheck{5}{id} = 5 TEST-DAT: Table dbixrs1 $TestCheck{6}{addon} = it TEST-DAT: Table dbixrs1 $TestCheck{6}{value1} = 9996 TEST-DAT: Table dbixrs1 $TestCheck{6}{name} = Sixth Name TEST-DAT: Table dbixrs1 $TestCheck{6}{id} = 6 TEST-DAT: Table dbixrs1 $TestCheck{7}{addon} = it ok? TEST-DAT: Table dbixrs1 $TestCheck{7}{value1} = 9997 TEST-DAT: Table dbixrs1 $TestCheck{7}{name} = Seventh Name TEST-DAT: Table dbixrs1 $TestCheck{7}{id} = 7 TEST-DAT: Table dbixrs1 $TestCheck{8}{addon} = Or not?? TEST-DAT: Table dbixrs1 $TestCheck{8}{value1} = 9998 TEST-DAT: Table dbixrs1 $TestCheck{8}{name} = Eighth Name TEST-DAT: Table dbixrs1 $TestCheck{8}{id} = 8 TEST-DAT: Table dbixrs1 $TestCheck{9}{addon} = Is TEST-DAT: Table dbixrs1 $TestCheck{9}{value1} = 9999 TEST-DAT: Table dbixrs1 $TestCheck{9}{name} = Ninth Name TEST-DAT: Table dbixrs1 $TestCheck{9}{id} = 9 TEST-DAT: Table dbixrs1 $TestCheck{10}{addon} = it TEST-DAT: Table dbixrs1 $TestCheck{10}{value1} = 99910 TEST-DAT: Table dbixrs1 $TestCheck{10}{name} = Tenth Name TEST-DAT: Table dbixrs1 $TestCheck{10}{id} = 10 TEST-DAT: Table dbixrs1 $TestCheck{11}{addon} = it ok? TEST-DAT: Table dbixrs1 $TestCheck{11}{value1} = 99911 TEST-DAT: Table dbixrs1 $TestCheck{11}{name} = Eleventh Name TEST-DAT: Table dbixrs1 $TestCheck{11}{id} = 11 TEST-DAT: Table dbixrs1 $TestCheck{12}{addon} = TEST-DAT: Table dbixrs1 $TestCheck{12}{value1} = 99912 TEST-DAT: Table dbixrs1 $TestCheck{12}{name} = Twelvth Name TEST-DAT: Table dbixrs1 $TestCheck{12}{id} = 12 TEST-DAT: Table dbixrs1 $TestCheck{13}{addon} = TEST-DAT: Table dbixrs1 $TestCheck{13}{value1} = TEST-DAT: Table dbixrs1 $TestCheck{13}{name} = Thirdteenth Name TEST-DAT: Table dbixrs1 $TestCheck{13}{id} = 13 TEST-DAT: Table dbixrs1 $TestCheck{14}{addon} = TEST-DAT: Table dbixrs1 $TestCheck{14}{value1} = TEST-DAT: Table dbixrs1 $TestCheck{14}{name} = Fourteenth Name TEST-DAT: Table dbixrs1 $TestCheck{14}{id} = 14 TEST-DAT: Table dbixrs1 $TestCheck{15}{addon} = TEST-DAT: Table dbixrs1 $TestCheck{15}{value1} = 15 TEST-DAT: Table dbixrs1 $TestCheck{15}{name} = 15 TEST-DAT: Table dbixrs1 $TestCheck{15}{id} = 15 TEST-DAT: Table dbixrs1 $TestCheck{16}{addon} = TEST-DAT: Table dbixrs1 $TestCheck{16}{value1} = 15 TEST-DAT: Table dbixrs1 $TestCheck{16}{name} = 15 TEST-DAT: Table dbixrs1 $TestCheck{16}{id} = 16 TEST-DAT: Table dbixrs1 $TestCheck{17}{addon} = TEST-DAT: Table dbixrs1 $TestCheck{17}{value1} = 2 TEST-DAT: Table dbixrs1 $TestCheck{17}{name} = 1 TEST-DAT: Table dbixrs1 $TestCheck{17}{id} = 17 TEST-DAT: Table dbixrs1 $TestCheck{18}{addon} = 42 TEST-DAT: Table dbixrs1 $TestCheck{18}{value1} = 42 TEST-DAT: Table dbixrs1 $TestCheck{18}{name} = 3 TEST-DAT: Table dbixrs1 $TestCheck{18}{id} = 18 TEST-DAT: Table dbixrs1 $TestCheck{19}{addon} = 42 TEST-DAT: Table dbixrs1 $TestCheck{19}{value1} = 42 TEST-DAT: Table dbixrs1 $TestCheck{19}{name} = 2 TEST-DAT: Table dbixrs1 $TestCheck{19}{id} = 19 TEST-DAT: Table dbixrs1 $TestCheck{20}{addon} = 42 TEST-DAT: Table dbixrs1 $TestCheck{20}{value1} = 3 TEST-DAT: Table dbixrs1 $TestCheck{20}{name} = 2 TEST-DAT: Table dbixrs1 $TestCheck{20}{id} = 20 TEST-DAT: Table dbixrs2 $TestCheck{1}{name2} = First Name in Tab2 TEST-DAT: Table dbixrs2 $TestCheck{1}{dbixrs4_id} = 1 TEST-DAT: Table dbixrs2 $TestCheck{1}{id} = 1 TEST-DAT: Table dbixrs2 $TestCheck{1}{value2} = 29991 TEST-DAT: Table dbixrs2 $TestCheck{2}{name2} = Second Name in Tab2 TEST-DAT: Table dbixrs2 $TestCheck{2}{dbixrs4_id} = 2 TEST-DAT: Table dbixrs2 $TestCheck{2}{id} = 2 TEST-DAT: Table dbixrs2 $TestCheck{2}{value2} = 29992 TEST-DAT: Table dbixrs2 $TestCheck{3}{name2} = Third Name in Tab2 TEST-DAT: Table dbixrs2 $TestCheck{3}{dbixrs4_id} = 3 TEST-DAT: Table dbixrs2 $TestCheck{3}{id} = 3 TEST-DAT: Table dbixrs2 $TestCheck{3}{value2} = 29993 TEST-DAT: Table dbixrs2 $TestCheck{4}{name2} = Fourth Name in Tab2 TEST-DAT: Table dbixrs2 $TestCheck{4}{dbixrs4_id} = 4 TEST-DAT: Table dbixrs2 $TestCheck{4}{id} = 4 TEST-DAT: Table dbixrs2 $TestCheck{4}{value2} = 29994 TEST-DAT: Table dbixrs3 $TestCheck{1}{value1} = 9991 TEST-DAT: Table dbixrs3 $TestCheck{1}{*id} = 1 TEST-DAT: Table dbixrs3 $TestCheck{1}{txt} = First Item (9991 ) TEST-DAT: Table dbixrs3 $TestCheck{2}{value1} = 9992 TEST-DAT: Table dbixrs3 $TestCheck{2}{*id} = 2 TEST-DAT: Table dbixrs3 $TestCheck{2}{txt} = Second Item (9992 ) TEST-DAT: Table dbixrs3 $TestCheck{3}{value1} = 9993 TEST-DAT: Table dbixrs3 $TestCheck{3}{*id} = 3 TEST-DAT: Table dbixrs3 $TestCheck{3}{txt} = Third Item (9993 ) TEST-DAT: Table dbixrs3 $TestCheck{4}{value1} = 9994 TEST-DAT: Table dbixrs3 $TestCheck{4}{*id} = 4 TEST-DAT: Table dbixrs3 $TestCheck{4}{txt} = Fourth Item (9994 ) TEST-DAT: Table dbixrs3 $TestCheck{5}{value1} = 9995 TEST-DAT: Table dbixrs3 $TestCheck{5}{*id} = 5 TEST-DAT: Table dbixrs3 $TestCheck{5}{txt} = Fivth Item (9995 ) TEST-DAT: Table dbixrs3 $TestCheck{6}{value1} = 9996 TEST-DAT: Table dbixrs3 $TestCheck{6}{*id} = 6 TEST-DAT: Table dbixrs3 $TestCheck{6}{txt} = Sixth Item (9996 ) TEST-DAT: Table dbixrs3 $TestCheck{7}{value1} = 9997 TEST-DAT: Table dbixrs3 $TestCheck{7}{*id} = 7 TEST-DAT: Table dbixrs3 $TestCheck{7}{txt} = Seventh Item (9997 ) TEST-DAT: Table dbixrs3 $TestCheck{8}{value1} = 9998 TEST-DAT: Table dbixrs3 $TestCheck{8}{*id} = 8 TEST-DAT: Table dbixrs3 $TestCheck{8}{txt} = Eighth Item (9998 ) TEST-DAT: Table dbixrs3 $TestCheck{9}{value1} = 9999 TEST-DAT: Table dbixrs3 $TestCheck{9}{*id} = 9 TEST-DAT: Table dbixrs3 $TestCheck{9}{txt} = Ninth Item (9999 ) TEST-DAT: Table dbixrs3 $TestCheck{10}{value1} = 99910 TEST-DAT: Table dbixrs3 $TestCheck{10}{*id} = 10 TEST-DAT: Table dbixrs3 $TestCheck{10}{txt} = Tenth Item (99910) TEST-DAT: Table dbixrs3 $TestCheck{11}{value1} = 99911 TEST-DAT: Table dbixrs3 $TestCheck{11}{*id} = 11 TEST-DAT: Table dbixrs3 $TestCheck{11}{txt} = Eleventh Item(99911) TEST-DAT: Table dbixrs3 $TestCheck{12}{value1} = 99912 TEST-DAT: Table dbixrs3 $TestCheck{12}{*id} = 12 TEST-DAT: Table dbixrs3 $TestCheck{12}{txt} = Twelvth Item (99912) TEST-DAT: Table dbix_rs5 $TestCheck{1}{a__rs6_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{1}{txt5} = 1 in Tab5 TEST-DAT: Table dbix_rs5 $TestCheck{1}{id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{1}{b__rs6_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{1}{up__rs5_id} = TEST-DAT: Table dbix_rs5 $TestCheck{2}{a__rs6_id} = 2 TEST-DAT: Table dbix_rs5 $TestCheck{2}{txt5} = 2 in Tab5 TEST-DAT: Table dbix_rs5 $TestCheck{2}{id} = 2 TEST-DAT: Table dbix_rs5 $TestCheck{2}{b__rs6_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{2}{up__rs5_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{3}{a__rs6_id} = 3 TEST-DAT: Table dbix_rs5 $TestCheck{3}{txt5} = 3 in Tab5 TEST-DAT: Table dbix_rs5 $TestCheck{3}{id} = 3 TEST-DAT: Table dbix_rs5 $TestCheck{3}{b__rs6_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{3}{up__rs5_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{4}{a__rs6_id} = 4 TEST-DAT: Table dbix_rs5 $TestCheck{4}{txt5} = 4 in Tab5 TEST-DAT: Table dbix_rs5 $TestCheck{4}{id} = 4 TEST-DAT: Table dbix_rs5 $TestCheck{4}{b__rs6_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{4}{up__rs5_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{5}{a__rs6_id} = 5 TEST-DAT: Table dbix_rs5 $TestCheck{5}{txt5} = 5 in Tab5 TEST-DAT: Table dbix_rs5 $TestCheck{5}{id} = 5 TEST-DAT: Table dbix_rs5 $TestCheck{5}{b__rs6_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{5}{up__rs5_id} = 2 TEST-DAT: Table dbix_rs5 $TestCheck{6}{a__rs6_id} = 6 TEST-DAT: Table dbix_rs5 $TestCheck{6}{txt5} = 6 in Tab5 TEST-DAT: Table dbix_rs5 $TestCheck{6}{id} = 6 TEST-DAT: Table dbix_rs5 $TestCheck{6}{b__rs6_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{6}{up__rs5_id} = 2 TEST-DAT: Table dbix_rs5 $TestCheck{7}{a__rs6_id} = 7 TEST-DAT: Table dbix_rs5 $TestCheck{7}{txt5} = 7 in Tab5 TEST-DAT: Table dbix_rs5 $TestCheck{7}{id} = 7 TEST-DAT: Table dbix_rs5 $TestCheck{7}{b__rs6_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{7}{up__rs5_id} = 3 TEST-DAT: Table dbix_rs5 $TestCheck{8}{a__rs6_id} = 8 TEST-DAT: Table dbix_rs5 $TestCheck{8}{txt5} = 8 in Tab5 TEST-DAT: Table dbix_rs5 $TestCheck{8}{id} = 8 TEST-DAT: Table dbix_rs5 $TestCheck{8}{b__rs6_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{8}{up__rs5_id} = 4 TEST-DAT: Table dbix_rs5 $TestCheck{9}{a__rs6_id} = 9 TEST-DAT: Table dbix_rs5 $TestCheck{9}{txt5} = 9 in Tab5 TEST-DAT: Table dbix_rs5 $TestCheck{9}{id} = 9 TEST-DAT: Table dbix_rs5 $TestCheck{9}{b__rs6_id} = 1 TEST-DAT: Table dbix_rs5 $TestCheck{9}{up__rs5_id} = 4 TEST-DAT: Table dbix_rs6 $TestCheck{1}{txt6} = 1 in Tab6 TEST-DAT: Table dbix_rs6 $TestCheck{1}{id} = 1 TEST-DAT: Table dbix_rs6 $TestCheck{2}{txt6} = 2 in Tab6 TEST-DAT: Table dbix_rs6 $TestCheck{2}{id} = 2 TEST-DAT: Table dbix_rs6 $TestCheck{3}{txt6} = 3 in Tab6 TEST-DAT: Table dbix_rs6 $TestCheck{3}{id} = 3 TEST-DAT: Table dbix_rs6 $TestCheck{4}{txt6} = 4 in Tab6 TEST-DAT: Table dbix_rs6 $TestCheck{4}{id} = 4 TEST-DAT: Table dbix_rs6 $TestCheck{5}{txt6} = 5 in Tab6 TEST-DAT: Table dbix_rs6 $TestCheck{5}{id} = 5 TEST-DAT: Table dbix_rs6 $TestCheck{6}{txt6} = 6 in Tab6 TEST-DAT: Table dbix_rs6 $TestCheck{6}{id} = 6 TEST-DAT: Table dbix_rs6 $TestCheck{7}{txt6} = 7 in Tab6 TEST-DAT: Table dbix_rs6 $TestCheck{7}{id} = 7 TEST-DAT: Table dbix_rs6 $TestCheck{8}{txt6} = 8 in Tab6 TEST-DAT: Table dbix_rs6 $TestCheck{8}{id} = 8 TEST-DAT: Table dbix_rs6 $TestCheck{9}{txt6} = 9 in Tab6 TEST-DAT: Table dbix_rs6 $TestCheck{9}{id} = 9 TEST-DAT: Table dbixrsdel $TestCheck{1}{dbixrsdel_id} = 2 TEST-DAT: Table dbixrsdel $TestCheck{1}{id} = 1 TEST-DAT: Table dbixrsdel $TestCheck{2}{dbixrsdel_id} = 3 TEST-DAT: Table dbixrsdel $TestCheck{2}{id} = 2 TEST-DAT: Table dbixrsdel $TestCheck{3}{dbixrsdel_id} = 4 TEST-DAT: Table dbixrsdel $TestCheck{3}{id} = 3 TEST-DAT: Table dbixrsdel $TestCheck{4}{dbixrsdel_id} = 1 TEST-DAT: Table dbixrsdel $TestCheck{4}{id} = 4 TEST-DAT: Table dbixrs4 $TestCheck{First item Type 1}{typ} = First item Type 1 TEST-DAT: Table dbixrs4 $TestCheck{First item Type 1}{id} = 1 TEST-DAT: Table dbixrs4 $TestCheck{First item Type 2}{typ} = First item Type 2 TEST-DAT: Table dbixrs4 $TestCheck{First item Type 2}{id} = 1 TEST-DAT: Table dbixrs4 $TestCheck{First item Type 3}{typ} = First item Type 3 TEST-DAT: Table dbixrs4 $TestCheck{First item Type 3}{id} = 1 TEST-DAT: Table dbixrs4 $TestCheck{Second item Type 1}{typ} = Second item Type 1 TEST-DAT: Table dbixrs4 $TestCheck{Second item Type 1}{id} = 2 TEST-DAT: Table dbixrs4 $TestCheck{Second item Type 2}{typ} = Second item Type 2 TEST-DAT: Table dbixrs4 $TestCheck{Second item Type 2}{id} = 2 TEST-DAT: Table dbixrs4 $TestCheck{Second item Type 3}{typ} = Second item Type 3 TEST-DAT: Table dbixrs4 $TestCheck{Second item Type 3}{id} = 2 TEST-DAT: Table dbixrs4 $TestCheck{Second item Type 4}{typ} = Second item Type 4 TEST-DAT: Table dbixrs4 $TestCheck{Second item Type 4}{id} = 2 TEST-DAT: Table dbixrs4 $TestCheck{Third item Type 1}{typ} = Third item Type 1 TEST-DAT: Table dbixrs4 $TestCheck{Third item Type 1}{id} = 3 --- "Table does not exist" warnings may appear here. Please ignore. -- Dropped dbixrs1, dbixrs2, dbixrs3, dbixrs4, dbix_rs5, dbix_rs6, dbixseq, dbixrsdel CREATE TABLE dbixrs1 ( id INT , name CHAR (20) , value1 INT , addon CHAR(20) ) ->(-1) CREATE TABLE dbixrs2 ( id INTEGER , name2 VARCHAR(20) , value2 INTEGER , dbixrs4_id INTEGER ) ->(-1) CREATE TABLE dbixrs3 ( value1 INTEGER , txt CHAR(20) ) ->(-1) CREATE TABLE dbixrs4 ( id INTEGER , typ CHAR(20) ) ->(-1) CREATE TABLE dbix_rs5 ( id INTEGER , txt5 CHAR(20) , up__rs5_id INTEGER , a__rs6_id INTEGER , b__rs6_id INTEGER ) ->(-1) CREATE TABLE dbix_rs6 ( id INTEGER , txt6 CHAR(20) ) ->(-1) CREATE TABLE dbixseq ( name varchar (32) , cnt INTEGER , maxcnt integer) ->(-1) CREATE TABLE dbixrsdel ( id integer, dbixrsdel_id integer) ->(-1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES ('Is',9991,'First Name',1) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES ('it',9992,'Second Name',2) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES ('it ok?',9993,'Third Name',3) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES ('Or not??',9994,'Fourth Name',4) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES ('Is',9995,'Fivth Name',5) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES ('it',9996,'Sixth Name',6) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES ('it ok?',9997,'Seventh Name',7) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES ('Or not??',9998,'Eighth Name',8) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES ('Is',9999,'Ninth Name',9) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES ('it',99910,'Tenth Name',10) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES ('it ok?',99911,'Eleventh Name',11) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES ('',99912,'Twelvth Name',12) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES (NULL,NULL,'Thirdteenth Name',13) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES (NULL,0,'Fourteenth Name',14) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES (NULL,15,15,15) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES (NULL,15,15,16) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES (NULL,2,1,17) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES (42,42,3,18) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES (42,42,2,19) ->(1) INSERT INTO dbixrs1 (addon,value1,name,id) VALUES (42,3,2,20) ->(1) INSERT INTO dbixrs2 (name2,dbixrs4_id,id,value2) VALUES ('First Name in Tab2',1,1,29991) ->(1) INSERT INTO dbixrs2 (name2,dbixrs4_id,id,value2) VALUES ('Second Name in Tab2',2,2,29992) ->(1) INSERT INTO dbixrs2 (name2,dbixrs4_id,id,value2) VALUES ('Third Name in Tab2',3,3,29993) ->(1) INSERT INTO dbixrs2 (name2,dbixrs4_id,id,value2) VALUES ('Fourth Name in Tab2',4,4,29994) ->(1) INSERT INTO dbixrs3 (value1,txt) VALUES (9991,'First Item (9991 )') ->(1) INSERT INTO dbixrs3 (value1,txt) VALUES (9992,'Second Item (9992 )') ->(1) INSERT INTO dbixrs3 (value1,txt) VALUES (9993,'Third Item (9993 )') ->(1) INSERT INTO dbixrs3 (value1,txt) VALUES (9994,'Fourth Item (9994 )') ->(1) INSERT INTO dbixrs3 (value1,txt) VALUES (9995,'Fivth Item (9995 )') ->(1) INSERT INTO dbixrs3 (value1,txt) VALUES (9996,'Sixth Item (9996 )') ->(1) INSERT INTO dbixrs3 (value1,txt) VALUES (9997,'Seventh Item (9997 )') ->(1) INSERT INTO dbixrs3 (value1,txt) VALUES (9998,'Eighth Item (9998 )') ->(1) INSERT INTO dbixrs3 (value1,txt) VALUES (9999,'Ninth Item (9999 )') ->(1) INSERT INTO dbixrs3 (value1,txt) VALUES (99910,'Tenth Item (99910)') ->(1) INSERT INTO dbixrs3 (value1,txt) VALUES (99911,'Eleventh Item(99911)') ->(1) INSERT INTO dbixrs3 (value1,txt) VALUES (99912,'Twelvth Item (99912)') ->(1) INSERT INTO dbix_rs5 (a__rs6_id,txt5,id,b__rs6_id,up__rs5_id) VALUES (1,'1 in Tab5',1,1,NULL) ->(1) INSERT INTO dbix_rs5 (a__rs6_id,txt5,id,b__rs6_id,up__rs5_id) VALUES (2,'2 in Tab5',2,1,1) ->(1) INSERT INTO dbix_rs5 (a__rs6_id,txt5,id,b__rs6_id,up__rs5_id) VALUES (3,'3 in Tab5',3,1,1) ->(1) INSERT INTO dbix_rs5 (a__rs6_id,txt5,id,b__rs6_id,up__rs5_id) VALUES (4,'4 in Tab5',4,1,1) ->(1) INSERT INTO dbix_rs5 (a__rs6_id,txt5,id,b__rs6_id,up__rs5_id) VALUES (5,'5 in Tab5',5,1,2) ->(1) INSERT INTO dbix_rs5 (a__rs6_id,txt5,id,b__rs6_id,up__rs5_id) VALUES (6,'6 in Tab5',6,1,2) ->(1) INSERT INTO dbix_rs5 (a__rs6_id,txt5,id,b__rs6_id,up__rs5_id) VALUES (7,'7 in Tab5',7,1,3) ->(1) INSERT INTO dbix_rs5 (a__rs6_id,txt5,id,b__rs6_id,up__rs5_id) VALUES (8,'8 in Tab5',8,1,4) ->(1) INSERT INTO dbix_rs5 (a__rs6_id,txt5,id,b__rs6_id,up__rs5_id) VALUES (9,'9 in Tab5',9,1,4) ->(1) INSERT INTO dbix_rs6 (txt6,id) VALUES ('1 in Tab6',1) ->(1) INSERT INTO dbix_rs6 (txt6,id) VALUES ('2 in Tab6',2) ->(1) INSERT INTO dbix_rs6 (txt6,id) VALUES ('3 in Tab6',3) ->(1) INSERT INTO dbix_rs6 (txt6,id) VALUES ('4 in Tab6',4) ->(1) INSERT INTO dbix_rs6 (txt6,id) VALUES ('5 in Tab6',5) ->(1) INSERT INTO dbix_rs6 (txt6,id) VALUES ('6 in Tab6',6) ->(1) INSERT INTO dbix_rs6 (txt6,id) VALUES ('7 in Tab6',7) ->(1) INSERT INTO dbix_rs6 (txt6,id) VALUES ('8 in Tab6',8) ->(1) INSERT INTO dbix_rs6 (txt6,id) VALUES ('9 in Tab6',9) ->(1) INSERT INTO dbixrsdel (dbixrsdel_id,id) VALUES (2,1) ->(1) INSERT INTO dbixrsdel (dbixrsdel_id,id) VALUES (3,2) ->(1) INSERT INTO dbixrsdel (dbixrsdel_id,id) VALUES (4,3) ->(1) INSERT INTO dbixrsdel (dbixrsdel_id,id) VALUES (1,4) ->(1) INSERT INTO dbixrs4 (typ,id) VALUES ('First item Type 1',1) ->(1) INSERT INTO dbixrs4 (typ,id) VALUES ('First item Type 2',1) ->(1) INSERT INTO dbixrs4 (typ,id) VALUES ('First item Type 3',1) ->(1) INSERT INTO dbixrs4 (typ,id) VALUES ('Second item Type 1',2) ->(1) INSERT INTO dbixrs4 (typ,id) VALUES ('Second item Type 2',2) ->(1) INSERT INTO dbixrs4 (typ,id) VALUES ('Second item Type 3',2) ->(1) INSERT INTO dbixrs4 (typ,id) VALUES ('Second item Type 4',2) ->(1) INSERT INTO dbixrs4 (typ,id) VALUES ('Third item Type 1',3) ->(1) ok Setup Object for dbixrs1... -------------------- DB: Use already open dbh for pgtest (id=1, numOpen = 0) DB: TAB = dbixrs1, COL = 0, NAME = id, TYPE = 4 DB: TAB = dbixrs1, COL = 1, NAME = name, TYPE = 1 DB: TAB = dbixrs1, COL = 2, NAME = value1, TYPE = 4 DB: TAB = dbixrs1, COL = 3, NAME = addon, TYPE = 1 DB: Found table pg_statio_user_tables => pg_catalog.pg_statio_user_tables DB: Found table pg_locks => pg_catalog.pg_locks DB: Found table pg_amproc => pg_catalog.pg_amproc DB: Found table pg_statio_user_indexes => pg_catalog.pg_statio_user_indexes DB: Found table pg_conversion => pg_catalog.pg_conversion DB: Found table triggers => information_schema.triggers DB: Found table pg_proc => pg_catalog.pg_proc DB: Found table tables => information_schema.tables DB: Found table pg_stat_sys_indexes => pg_catalog.pg_stat_sys_indexes DB: Found table pg_stat_all_indexes => pg_catalog.pg_stat_all_indexes DB: Found table pg_largeobject => pg_catalog.pg_largeobject DB: Found table role_routine_grants => information_schema.role_routine_grants DB: Found table pg_statio_user_sequences => pg_catalog.pg_statio_user_sequences DB: Found table sql_sizing_profiles => information_schema.sql_sizing_profiles DB: Found table constraint_table_usage => information_schema.constraint_table_usage DB: Found table sql_packages => information_schema.sql_packages DB: Found table triggered_update_columns => information_schema.triggered_update_columns DB: Found table sql_languages => information_schema.sql_languages DB: Found table pg_constraint => pg_catalog.pg_constraint DB: Found table key_column_usage => information_schema.key_column_usage DB: Found table dbix_rs5 => public.dbix_rs5 DB: Found table pg_stat_user_tables => pg_catalog.pg_stat_user_tables DB: Found table pg_cast => pg_catalog.pg_cast DB: Found table element_types => information_schema.element_types DB: Found table pg_stat_activity => pg_catalog.pg_stat_activity DB: Found table pg_class => pg_catalog.pg_class DB: Found table column_domain_usage => information_schema.column_domain_usage DB: Found table pg_statio_all_sequences => pg_catalog.pg_statio_all_sequences DB: Found table constraint_column_usage => information_schema.constraint_column_usage DB: Found table role_table_grants => information_schema.role_table_grants DB: Found table views => information_schema.views DB: Found table data_type_privileges => information_schema.data_type_privileges DB: Found table pg_stat_sys_tables => pg_catalog.pg_stat_sys_tables DB: Found table pg_opclass => pg_catalog.pg_opclass DB: Found table dbixrs3 => public.dbixrs3 DB: Found table pg_group => pg_catalog.pg_group DB: Found table pg_namespace => pg_catalog.pg_namespace DB: Found table view_column_usage => information_schema.view_column_usage DB: Found table usage_privileges => information_schema.usage_privileges DB: Found table sql_implementation_info => information_schema.sql_implementation_info DB: Found table pg_indexes => pg_catalog.pg_indexes DB: Found table dbd_pg_test => public.dbd_pg_test DB: Found table pg_user => pg_catalog.pg_user DB: Found table pg_statistic => pg_catalog.pg_statistic DB: Found table pg_stat_all_tables => pg_catalog.pg_stat_all_tables DB: Found table domains => information_schema.domains DB: Found table pg_views => pg_catalog.pg_views DB: Found table dbd_pg_test3 => public.dbd_pg_test3 DB: Found table pg_am => pg_catalog.pg_am DB: Found table pg_stat_database => pg_catalog.pg_stat_database DB: Found table pg_amop => pg_catalog.pg_amop DB: Found table referential_constraints => information_schema.referential_constraints DB: Found table routine_privileges => information_schema.routine_privileges DB: Found table dbixrs4 => public.dbixrs4 DB: Found table sql_features => information_schema.sql_features DB: Found table routines => information_schema.routines DB: Found table dbixrs2 => public.dbixrs2 DB: Found table pg_operator => pg_catalog.pg_operator DB: Found table table_privileges => information_schema.table_privileges DB: Found table schemata => information_schema.schemata DB: Found table role_column_grants => information_schema.role_column_grants DB: Found table pg_tables => pg_catalog.pg_tables DB: Found table pg_trigger => pg_catalog.pg_trigger DB: Found table pg_shadow => pg_catalog.pg_shadow DB: Found table pg_settings => pg_catalog.pg_settings DB: Found table dbd_pg_test2 => public.dbd_pg_test2 DB: Found table dbd_pg_test1 => public.dbd_pg_test1 DB: Found table information_schema_catalog_name => information_schema.information_schema_catalog_name DB: Found table pg_inherits => pg_catalog.pg_inherits DB: Found table pg_database => pg_catalog.pg_database DB: Found table pg_attribute => pg_catalog.pg_attribute DB: Found table parameters => information_schema.parameters DB: Found table pg_aggregate => pg_catalog.pg_aggregate DB: Found table pg_statio_sys_tables => pg_catalog.pg_statio_sys_tables DB: Found table columns => information_schema.columns DB: Found table dbix_rs6 => public.dbix_rs6 DB: Found table pg_listener => pg_catalog.pg_listener DB: Found table view_table_usage => information_schema.view_table_usage DB: Found table role_usage_grants => information_schema.role_usage_grants DB: Found table column_udt_usage => information_schema.column_udt_usage DB: Found table column_privileges => information_schema.column_privileges DB: Found table check_constraints => information_schema.check_constraints DB: Found table pg_statio_sys_sequences => pg_catalog.pg_statio_sys_sequences DB: Found table pg_rules => pg_catalog.pg_rules DB: Found table domain_constraints => information_schema.domain_constraints DB: Found table pg_attrdef => pg_catalog.pg_attrdef DB: Found table pg_description => pg_catalog.pg_description DB: Found table pg_language => pg_catalog.pg_language DB: Found table sql_sizing => information_schema.sql_sizing DB: Found table domain_udt_usage => information_schema.domain_udt_usage DB: Found table dbixrsdel => public.dbixrsdel DB: Found table pg_depend => pg_catalog.pg_depend DB: Found table pg_stat_user_indexes => pg_catalog.pg_stat_user_indexes DB: Found table table_constraints => information_schema.table_constraints DB: Found table dbixseq => public.dbixseq DB: Found table pg_statio_all_indexes => pg_catalog.pg_statio_all_indexes DB: Found table pg_type => pg_catalog.pg_type DB: Found table applicable_roles => information_schema.applicable_roles DB: Found table pg_statio_all_tables => pg_catalog.pg_statio_all_tables DB: Found table dbixrs1 => public.dbixrs1 DB: Found table pg_stats => pg_catalog.pg_stats DB: Found table pg_statio_sys_indexes => pg_catalog.pg_statio_sys_indexes DB: Found table enabled_roles => information_schema.enabled_roles DB: Found table pg_index => pg_catalog.pg_index DB: Found table pg_rewrite => pg_catalog.pg_rewrite DB: New Recordset driver=Pg placeholders NOT supported ok SQLSelect All... -------------------- DB: FLUSH Recordset id = 1 DBIx::Recordset=HASH(0x6000000000400680) DB: 'SELECT * FROM dbixrs1 ' bind_values=<> bind_types=<> IDS EXPECTED: 11 7 17 2 1 18 16 13 6 3 9 12 20 14 15 8 4 19 10 5 DB: FETCH [0] DB: FETCH return HASH(0x6000000000a238a0) Check Hash id = 1 : 1 Field: addon Array: Is Hash: Is Field: value1 Array: 9991 Hash: 9991 Field: name Array: First Name Hash: First Name Field: id Array: 1 Hash: 1 DB: FETCH [0] idfield =id;1;0; CHK-DAT:addon=Is ; value1=9991; name=First Name ; id=1; DB: FETCH [1] DB: FETCH return HASH(0x6000000000a22560) DB: Row::FETCH id = <2> idfield =id;2;1; CHK-DAT:DB: Row::FETCH addon = <it > addon=it ; DB: Row::FETCH value1 = <9992> value1=9992; DB: Row::FETCH name = <Second Name > name=Second Name ; DB: Row::FETCH id = <2> id=2; DB: FETCH [2] DB: FETCH return HASH(0x6000000000a223d0) DB: Row::FETCH id = <3> idfield =id;3;2; CHK-DAT:DB: Row::FETCH addon = <it ok? > addon=it ok? ; DB: Row::FETCH value1 = <9993> value1=9993; DB: Row::FETCH name = <Third Name > name=Third Name ; DB: Row::FETCH id = <3> id=3; DB: FETCH [3] DB: FETCH return HASH(0x6000000000a14950) DB: Row::FETCH id = <4> idfield =id;4;3; CHK-DAT:DB: Row::FETCH addon = <Or not?? > addon=Or not?? ; DB: Row::FETCH value1 = <9994> value1=9994; DB: Row::FETCH name = <Fourth Name > name=Fourth Name ; DB: Row::FETCH id = <4> id=4; DB: FETCH [4] DB: FETCH return HASH(0x6000000000a15900) DB: Row::FETCH id = <5> idfield =id;5;4; CHK-DAT:DB: Row::FETCH addon = <Is > addon=Is ; DB: Row::FETCH value1 = <9995> value1=9995; DB: Row::FETCH name = <Fivth Name > name=Fivth Name ; DB: Row::FETCH id = <5> id=5; DB: FETCH [5] DB: FETCH return HASH(0x6000000000a15a50) DB: Row::FETCH id = <6> idfield =id;6;5; CHK-DAT:DB: Row::FETCH addon = <it > addon=it ; DB: Row::FETCH value1 = <9996> value1=9996; DB: Row::FETCH name = <Sixth Name > name=Sixth Name ; DB: Row::FETCH id = <6> id=6; DB: FETCH [6] DB: FETCH return HASH(0x6000000000a15ba0) DB: Row::FETCH id = <7> idfield =id;7;6; CHK-DAT:DB: Row::FETCH addon = <it ok? > addon=it ok? ; DB: Row::FETCH value1 = <9997> value1=9997; DB: Row::FETCH name = <Seventh Name > name=Seventh Name ; DB: Row::FETCH id = <7> id=7; DB: FETCH [7] ... DB: FLUSH Recordset id = 57 DBIx::Recordset=HASH(0x6000000000a42810) DB: Disconnect (id=57, numOpen = 0) DB: FLUSH Recordset id = 57 DBIx::Recordset=HASH(0x6000000000a42810) DB: Disconnect (id=57, numOpen = 0) DB: DESTROY (id=57, numOpen = 0) Update via assigning array ref 2... -------------------- DB: Use already open dbh for pgtest (id=58, numOpen = 0) DB: use cached meta data for dbixrs2 DB: New Recordset driver=Pg placeholders NOT supported DB: Setup: !Debug = 5 DB: Setup: !Fields = <undef> DB: Setup: !TabRelation = <undef> DB: Setup: !TabJoin = <undef> DB: Setup: !PrimKey = <undef> DB: Setup: !Serial = <undef> DB: Setup: !Sequence = <undef> DB: Setup: !SeqClass = <undef> DB: Setup: !StoreAll = <undef> DB: Setup: !Default = <undef> DB: Setup: !IgnoreEmpty = 0 DB: Setup: !WriteMode = 7 DB: Setup: !TieRow = 1 DB: Setup: !LongNames = 0 DB: Setup: !KeepFirst = 0 DB: Setup: !LinkName = 0 DB: Setup: !NameField = <undef> DB: Setup: !Order = <undef> DB: Setup: !TableFilter = <undef> DB: Setup: !DoOnConnect = <undef> DB: Setup: !Query = <undef> DB: SelectWhere <!Password>=<root> type = ! DB: SelectWhere <!Table>=<dbixrs2> type = ! DB: SelectWhere <!Username>=<root> type = ! DB: SelectWhere <!Filter>=<<undef>> type = ! DB: SelectWhere <id>=<9753> type = i DB: Single Field id DB: Single Field gives id = ? DB: Key id gives (id = ?) bind_values = <9753> bind_types=<4> DB: expr is ( (id = ?)) DB: SelectWhere <!DataSource>=<DBI::db=HASH(0x6000000000762f80)> type = ! DB: FLUSH Recordset id = 58 DBIx::Recordset=HASH(0x6000000000a40db0) DB: 'SELECT * FROM dbixrs2 WHERE ( (id = ?)) ' bind_values=<9753> bind_types=<4> IDS EXPECTED: DB: FETCH [0] DB: Call DBI finish (id=58, Last = SELECT * FROM dbixrs2 WHERE ( (id = ?)) ) DB: FETCH return <undef> DB: FETCH [0] DB: FETCH return <undef> DB: FETCH [0] DB: FETCH return <undef> DB: STORE [0] = <undef> DB: Row::STORE id = 9753 DB: FETCH [1] DB: FETCH return <undef> DB: STORE [1] = <undef> DB: Row::STORE id = 9754 DB: FETCH [2] DB: FETCH return <undef> DB: STORE [2] = <undef> DB: Row::STORE id = 9755 DB: FETCH [3] DB: FETCH return <undef> DB: STORE [3] = <undef> DB: Row::STORE id = 9756 DB: FETCH [0] DB: FETCH return HASH(0x6000000000a3ab70) DB: Row::STORE name2 = a DB: FETCH [1] DB: FETCH return HASH(0x6000000000711140) DB: Row::STORE name2 = b DB: FETCH [2] DB: FETCH return HASH(0x6000000000a46160) DB: Row::STORE name2 = c DB: FETCH [3] DB: FETCH return HASH(0x6000000000a20dc0) DB: Row::STORE name2 = d DB: FETCH [0] DB: FETCH return HASH(0x6000000000a3ab70) DB: Row::STORE value2 = 12340 DB: FETCH [1] DB: FETCH return HASH(0x6000000000711140) DB: Row::STORE value2 = 23450 DB: FETCH [2] DB: FETCH return HASH(0x6000000000a46160) DB: Row::STORE value2 = 34560 DB: FETCH [3] DB: FETCH return HASH(0x6000000000a20dc0) DB: Row::STORE value2 = 45670 DB: FLUSH Recordset id = 58 DBIx::Recordset=HASH(0x6000000000a40db0) DB: Row::Flush id=58 DBIx::Recordset::Row=HASH(0x6000000000a39a90) DB: do 'INSERT INTO dbixrs2 (name2,id,value2) VALUES (?,?,?)' bind_values=<a 9753 12340> bind_types=<12 4 4> DB: do returned 1 DB: Row::Flush id=58 DBIx::Recordset::Row=HASH(0x6000000000a3f590) DB: do 'INSERT INTO dbixrs2 (name2,id,value2) VALUES (?,?,?)' bind_values=<b 9754 23450> bind_types=<12 4 4> DB: do returned 1 DB: Row::Flush id=58 DBIx::Recordset::Row=HASH(0x6000000000a39c70) DB: do 'INSERT INTO dbixrs2 (name2,id,value2) VALUES (?,?,?)' bind_values=<c 9755 34560> bind_types=<12 4 4> DB: do returned 1 DB: Row::Flush id=58 DBIx::Recordset::Row=HASH(0x600000000084ec30) DB: do 'INSERT INTO dbixrs2 (name2,id,value2) VALUES (?,?,?)' bind_values=<d 9756 45670> bind_types=<12 4 4> DB: do returned 1 TEST-DAT: Table dbixrs2 $TestCheck{9753}{name2} = a TEST-DAT: Table dbixrs2 $TestCheck{9753}{id} = 9753 TEST-DAT: Table dbixrs2 $TestCheck{9753}{value2} = 12340 TEST-DAT: Table dbixrs2 $TestCheck{9754}{name2} = b TEST-DAT: Table dbixrs2 $TestCheck{9754}{id} = 9754 TEST-DAT: Table dbixrs2 $TestCheck{9754}{value2} = 23450 TEST-DAT: Table dbixrs2 $TestCheck{9755}{name2} = c TEST-DAT: Table dbixrs2 $TestCheck{9755}{id} = 9755 TEST-DAT: Table dbixrs2 $TestCheck{9755}{value2} = 34560 TEST-DAT: Table dbixrs2 $TestCheck{9756}{name2} = d TEST-DAT: Table dbixrs2 $TestCheck{9756}{id} = 9756 TEST-DAT: Table dbixrs2 $TestCheck{9756}{value2} = 45670 DB: Undef main::set1 DB: FLUSH Recordset id = 58 DBIx::Recordset=HASH(0x6000000000a40db0) DB: Row::DESTROY DB: Row::DESTROY DB: Row::DESTROY DB: Row::DESTROY DB: FLUSH Recordset id = 58 DBIx::Recordset=HASH(0x6000000000a40db0) DB: Disconnect (id=58, numOpen = 0) DB: FLUSH Recordset id = 58 DBIx::Recordset=HASH(0x6000000000a40db0) DB: Disconnect (id=58, numOpen = 0) DB: DESTROY (id=58, numOpen = 0) DB: Use already open dbh for pgtest (id=59, numOpen = 0) DB: use cached meta data for dbixrs2 DB: New Recordset driver=Pg placeholders NOT supported DB: Setup: !Debug = 5 DB: Setup: !Fields = <undef> DB: Setup: !TabRelation = <undef> DB: Setup: !TabJoin = <undef> DB: Setup: !PrimKey = <undef> DB: Setup: !Serial = <undef> DB: Setup: !Sequence = <undef> DB: Setup: !SeqClass = <undef> DB: Setup: !StoreAll = <undef> DB: Setup: !Default = <undef> DB: Setup: !IgnoreEmpty = 0 DB: Setup: !WriteMode = 7 DB: Setup: !TieRow = 1 DB: Setup: !LongNames = 0 DB: Setup: !KeepFirst = 0 DB: Setup: !LinkName = 0 DB: Setup: !NameField = <undef> DB: Setup: !Order = <undef> DB: Setup: !TableFilter = <undef> DB: Setup: !DoOnConnect = <undef> DB: Setup: !Query = <undef> DB: SelectWhere <!Password>=<root> type = ! DB: SelectWhere <!Table>=<dbixrs2> type = ! DB: SelectWhere <!Username>=<root> type = ! DB: SelectWhere <!Filter>=<<undef>> type = ! DB: SelectWhere <id>=<9753 9754 9755 9756> type = i DB: Single Field id DB: Single Field gives id = ? DB: Key id gives id IN (?,?,?,?) bind_values = <9753 9754 9755 9756> bind_types=<4 4 4 4> DB: expr is (id IN (?,?,?,?)) DB: SelectWhere <!DataSource>=<DBI::db=HASH(0x6000000000762f80)> type = ! DB: FLUSH Recordset id = 59 DBIx::Recordset=HASH(0x6000000000a1ed60) DB: 'SELECT * FROM dbixrs2 WHERE (id IN (?,?,?,?)) ' bind_values=<9753 9754 9755 9756> bind_types=<4 4 4 4> - 2 ... IDS EXPECTED: 9753 9754 9755 9756 DB: FETCH [0] DB: FETCH return HASH(0x6000000000a4a260) DB: FETCH [0] DB: Row::FETCH id = <9753> idfield =id;9753;0; CHK-DAT:DB: Row::FETCH name2 = <a> name2=a; DB: Row::FETCH dbixrs4_id = <<undef>> dbixrs4_id=; DB: Row::FETCH id = <9753> id=9753; DB: Row::FETCH value2 = <12340> value2=12340; DB: FETCH [1] DB: FETCH return HASH(0x6000000000a4a1c0) DB: Row::FETCH id = <9754> idfield =id;9754;1; CHK-DAT:DB: Row::FETCH name2 = <b> name2=b; DB: Row::FETCH dbixrs4_id = <<undef>> dbixrs4_id=; DB: Row::FETCH id = <9754> id=9754; DB: Row::FETCH value2 = <23450> value2=23450; DB: FETCH [2] DB: FETCH return HASH(0x6000000000a4a280) DB: Row::FETCH id = <9755> idfield =id;9755;2; CHK-DAT:DB: Row::FETCH name2 = <c> name2=c; DB: Row::FETCH dbixrs4_id = <<undef>> dbixrs4_id=; DB: Row::FETCH id = <9755> id=9755; DB: Row::FETCH value2 = <34560> value2=34560; DB: FETCH [3] DB: Call DBI finish (id=59, LastRow = 4, Last = SELECT * FROM dbixrs2 WHERE (id IN (?,?,?,?)) ) DB: FETCH return HASH(0x6000000000a2c470) DB: Row::FETCH id = <9756> idfield =id;9756;3; CHK-DAT:DB: Row::FETCH name2 = <d> name2=d; DB: Row::FETCH dbixrs4_id = <<undef>> dbixrs4_id=; DB: Row::FETCH id = <9756> id=9756; DB: Row::FETCH value2 = <45670> value2=45670; DB: FETCH [4] DB: FETCH return <undef> DB: FETCH [0] DB: FETCH return HASH(0x6000000000a4a260) DB: Row::FETCH name2 = <a> DB: Row::FETCH dbixrs4_id = <<undef>> DB: Row::FETCH id = <9753> DB: Row::FETCH value2 = <12340> id =9753;0;dat = $VAR1 = { 'name2' => 'a', 'dbixrs4_id' => undef, 'id' => '9753', 'value2' => '12340' }; should-bound-a via 9753 and name2 DB: Row::FETCH name2 = <a> DB: Row::FETCH name2 = <a> DB: Row::FETCH name2 = <a> $is = a because $dat->{name2} = a CHK-OK-a?: id = 9753; name2 = <a>; Should = <a> should-bound-b should-bound-c DB: Row::FETCH dbixrs4_id = <<undef>> CHK-OK-a?: id = 9753; dbixrs4_id = <NULL>; Should = <NULL> should-bound-a via 9753 and id DB: Row::FETCH id = <9753> DB: Row::FETCH id = <9753> DB: Row::FETCH id = <9753> $is = 9753 because $dat->{id} = 9753 CHK-OK-a?: id = 9753; id = <9753>; Should = <9753> should-bound-a via 9753 and value2 DB: Row::FETCH value2 = <12340> DB: Row::FETCH value2 = <12340> DB: Row::FETCH value2 = <12340> $is = 12340 because $dat->{value2} = 12340 CHK-OK-a?: id = 9753; value2 = <12340>; Should = <12340> DB: FETCH [1] DB: FETCH return HASH(0x6000000000a4a1c0) DB: Row::FETCH name2 = <b> DB: Row::FETCH dbixrs4_id = <<undef>> DB: Row::FETCH id = <9754> DB: Row::FETCH value2 = <23450> id =9754;1;dat = $VAR1 = { 'name2' => 'b', 'dbixrs4_id' => undef, 'id' => '9754', 'value2' => '23450' }; should-bound-a via 9754 and name2 DB: Row::FETCH name2 = <b> DB: Row::FETCH name2 = <b> DB: Row::FETCH name2 = <b> $is = b because $dat->{name2} = b CHK-OK-a?: id = 9754; name2 = <b>; Should = <b> should-bound-b should-bound-c DB: Row::FETCH dbixrs4_id = <<undef>> CHK-OK-a?: id = 9754; dbixrs4_id = <NULL>; Should = <NULL> should-bound-a via 9754 and id DB: Row::FETCH id = <9754> DB: Row::FETCH id = <9754> DB: Row::FETCH id = <9754> $is = 9754 because $dat->{id} = 9754 CHK-OK-a?: id = 9754; id = <9754>; Should = <9754> should-bound-a via 9754 and value2 DB: Row::FETCH value2 = <23450> DB: Row::FETCH value2 = <23450> DB: Row::FETCH value2 = <23450> $is = 23450 because $dat->{value2} = 23450 CHK-OK-a?: id = 9754; value2 = <23450>; Should = <23450> DB: FETCH [2] DB: FETCH return HASH(0x6000000000a4a280) DB: Row::FETCH name2 = <c> DB: Row::FETCH dbixrs4_id = <<undef>> DB: Row::FETCH id = <9755> DB: Row::FETCH value2 = <34560> id =9755;2;dat = $VAR1 = { 'name2' => 'c', 'dbixrs4_id' => undef, 'id' => '9755', 'value2' => '34560' }; should-bound-a via 9755 and name2 DB: Row::FETCH name2 = <c> DB: Row::FETCH name2 = <c> DB: Row::FETCH name2 = <c> $is = c because $dat->{name2} = c CHK-OK-a?: id = 9755; name2 = <c>; Should = <c> should-bound-b should-bound-c DB: Row::FETCH dbixrs4_id = <<undef>> CHK-OK-a?: id = 9755; dbixrs4_id = <NULL>; Should = <NULL> should-bound-a via 9755 and id DB: Row::FETCH id = <9755> DB: Row::FETCH id = <9755> DB: Row::FETCH id = <9755> $is = 9755 because $dat->{id} = 9755 CHK-OK-a?: id = 9755; id = <9755>; Should = <9755> should-bound-a via 9755 and value2 DB: Row::FETCH value2 = <34560> DB: Row::FETCH value2 = <34560> DB: Row::FETCH value2 = <34560> $is = 34560 because $dat->{value2} = 34560 CHK-OK-a?: id = 9755; value2 = <34560>; Should = <34560> DB: FETCH [3] DB: FETCH return HASH(0x6000000000a2c470) DB: Row::FETCH name2 = <d> DB: Row::FETCH dbixrs4_id = <<undef>> DB: Row::FETCH id = <9756> DB: Row::FETCH value2 = <45670> id =9756;3;dat = $VAR1 = { 'name2' => 'd', 'dbixrs4_id' => undef, 'id' => '9756', 'value2' => '45670' }; should-bound-a via 9756 and name2 DB: Row::FETCH name2 = <d> DB: Row::FETCH name2 = <d> DB: Row::FETCH name2 = <d> $is = d because $dat->{name2} = d CHK-OK-a?: id = 9756; name2 = <d>; Should = <d> should-bound-b should-bound-c DB: Row::FETCH dbixrs4_id = <<undef>> CHK-OK-a?: id = 9756; dbixrs4_id = <NULL>; Should = <NULL> should-bound-a via 9756 and id DB: Row::FETCH id = <9756> DB: Row::FETCH id = <9756> DB: Row::FETCH id = <9756> $is = 9756 because $dat->{id} = 9756 CHK-OK-a?: id = 9756; id = <9756>; Should = <9756> should-bound-a via 9756 and value2 DB: Row::FETCH value2 = <45670> DB: Row::FETCH value2 = <45670> DB: Row::FETCH value2 = <45670> $is = 45670 because $dat->{value2} = 45670 CHK-OK-a?: id = 9756; value2 = <45670>; Should = <45670> DB: Undef main::set1_ DB: FLUSH Recordset id = 59 DBIx::Recordset=HASH(0x6000000000a1ed60) DB: Row::DESTROY DB: Row::DESTROY DB: Row::DESTROY DB: Row::DESTROY DB: FLUSH Recordset id = 59 DBIx::Recordset=HASH(0x6000000000a1ed60) DB: Disconnect (id=59, numOpen = 0) DB: FLUSH Recordset id = 59 DBIx::Recordset=HASH(0x6000000000a1ed60) DB: Disconnect (id=59, numOpen = 0) DB: DESTROY (id=59, numOpen = 0) Select with sub table... -------------------- DB: Use already open dbh for pgtest (id=60, numOpen = 0) DB: use cached meta data for dbixrs1 DB: New Recordset driver=Pg placeholders NOT supported DB: Setup: !Debug = 5 DB: Setup: !Fields = <undef> DB: Setup: !TabRelation = <undef> DB: Setup: !TabJoin = <undef> DB: Setup: !PrimKey = <undef> DB: Setup: !Serial = <undef> DB: Setup: !Sequence = <undef> DB: Setup: !SeqClass = <undef> DB: Setup: !StoreAll = <undef> DB: Setup: !Default = <undef> DB: Setup: !IgnoreEmpty = 0 DB: Setup: !WriteMode = 7 DB: Setup: !TieRow = 1 DB: Setup: !LongNames = 0 DB: Setup: !KeepFirst = 0 DB: Setup: !LinkName = 0 DB: Setup: !NameField = <undef> DB: Setup: !Order = <undef> DB: Setup: !TableFilter = <undef> DB: Setup: !DoOnConnect = <undef> DB: Setup: !Query = <undef> DB: SelectWhere <!Password>=<root> type = ! DB: SelectWhere <!Links>=<HASH(0x6000000000a424d0)> type = ! DB: SelectWhere <!Table>=<dbixrs1> type = ! DB: SelectWhere <!Username>=<root> type = ! DB: SelectWhere <!Filter>=<<undef>> type = ! DB: SelectWhere <id>=<2> type = i DB: Single Field id DB: Single Field gives id = ? DB: Key id gives (id = ?) bind_values = <2> bind_types=<4> DB: expr is ( (id = ?)) DB: SelectWhere <!DataSource>=<DBI::db=HASH(0x6000000000762f80)> type = ! DB: FLUSH Recordset id = 60 DBIx::Recordset=HASH(0x6000000000a39d70) DB: 'SELECT * FROM dbixrs1 WHERE ( (id = ?)) ' bind_values=<2> bind_types=<4> IDS EXPECTED: 2 DB: FETCH [0] DB: Call DBI finish (id=60, LastRow = 1, Last = SELECT * FROM dbixrs1 WHERE ( (id = ?)) ) DB: FETCH return HASH(0x6000000000a3b070) DB: FETCH [0] DB: Row::FETCH id = <2> idfield =id;2;0; CHK-DAT:DB: Row::FETCH addon = <it > addon=it ; DB: Row::FETCH value1 = <9992> value1=9992; DB: Row::FETCH name = <Second Name > name=Second Name ; DB: Row::FETCH id = <2> id=2; DB: FETCH [1] DB: FETCH return <undef> DB: FETCH [0] DB: FETCH return HASH(0x6000000000a3b070) DB: Row::FETCH addon = <it > DB: Row::FETCH value1 = <9992> DB: Row::FETCH name = <Second Name > DB: Row::FETCH id = <2> id =2;0;dat = $VAR1 = { 'addon' => 'it ', 'value1' => '9992', 'name' => 'Second Name ', 'id' => '2' }; should-bound-a via 2 and addon DB: Row::FETCH addon = <it > DB: Row::FETCH addon = <it > DB: Row::FETCH addon = <it > $is = it because $dat->{addon} = it CHK-OK-a?: id = 2; addon = <it>; Should = <it> should-bound-a via 2 and value1 DB: Row::FETCH value1 = <9992> DB: Row::FETCH value1 = <9992> DB: Row::FETCH value1 = <9992> $is = 9992 because $dat->{value1} = 9992 CHK-OK-a?: id = 2; value1 = <9992>; Should = <9992> should-bound-a via 2 and name DB: Row::FETCH name = <Second Name > DB: Row::FETCH name = <Second Name > DB: Row::FETCH name = <Second Name > $is = Second Name because $dat->{name} = Second Name CHK-OK-a?: id = 2; name = <Second Name>; Should = <Second Name> should-bound-a via 2 and id DB: Row::FETCH id = <2> DB: Row::FETCH id = <2> DB: Row::FETCH id = <2> $is = 2 because $dat->{id} = 2 CHK-OK-a?: id = 2; id = <2>; Should = <2> - 2 ... DB: Row::FETCH subid = Setup New Recordset for table dbixrs4, id = 2 DB: Use already open dbh for pgtest (id=61, numOpen = 0) DB: use cached meta data for dbixrs4 DB: New Recordset driver=Pg placeholders NOT supported DB: Setup: !Debug = 5 DB: Setup: !Fields = <undef> DB: Setup: !TabRelation = <undef> DB: Setup: !TabJoin = <undef> DB: Setup: !PrimKey = typ DB: Setup: !Serial = <undef> DB: Setup: !Sequence = <undef> DB: Setup: !SeqClass = <undef> DB: Setup: !StoreAll = <undef> DB: Setup: !Default = HASH(0x6000000000a4c240) DB: Setup: !IgnoreEmpty = 0 DB: Setup: !WriteMode = 7 DB: Setup: !TieRow = 1 DB: Setup: !LongNames = 0 DB: Setup: !KeepFirst = 0 DB: Setup: !LinkName = 0 DB: Setup: !NameField = <undef> DB: Setup: !Order = <undef> DB: Setup: !TableFilter = <undef> DB: Setup: !DoOnConnect = <undef> DB: Setup: !Query = <undef> DB: SelectWhere <!MainField>=<id> type = ! DB: SelectWhere <!Default>=<HASH(0x6000000000a4c240)> type = ! DB: SelectWhere <!Table>=<dbixrs4> type = ! DB: SelectWhere <!LinkedField>=<id> type = ! DB: SelectWhere <!Filter>=<<undef>> type = ! DB: SelectWhere <!PrimKey>=<typ> type = ! DB: SelectWhere <id>=<2> type = i DB: Single Field id DB: Single Field gives id = ? DB: Key id gives (id = ?) bind_values = <2> bind_types=<4> DB: expr is ( (id = ?)) DB: SelectWhere <!DataSource>=<DBIx::Recordset=HASH(0x6000000000a39d70)> type = ! DB: FLUSH Recordset id = 61 DBIx::Recordset=HASH(0x6000000000a4a2d0) DB: 'SELECT * FROM dbixrs4 WHERE ( (id = ?)) ' bind_values=<2> bind_types=<4> DB: Row::FETCH subid = <*DBIx::Recordset::newself> Can't upgrade that kind of scalar at test.pl line 87. DB: Row::DESTROY DB: Row::DESTROY DB: Row::DESTROY DB: Row::DESTROY DB: FLUSH Recordset id = 61 DBIx::Recordset=HASH(0x6000000000a4a2d0) DB: Call DBI finish (id=61, Last = SELECT * FROM dbixrs4 WHERE ( (id = ?)) ) DB: FLUSH Recordset id = 61 DBIx::Recordset=HASH(0x6000000000a4a2d0) DB: ::CurrRow::DESTROY DB: FLUSH Recordset id = 61 DBIx::Recordset=HASH(0x6000000000a4a2d0) DB: Disconnect (id=61, numOpen = 0) DB: DESTROY (id=61, numOpen = 0) DB: Row::DESTROY DB: FLUSH Recordset id = 60 DBIx::Recordset=HASH(0x6000000000a39d70) DB: Disconnect (id=60, numOpen = 0) DB: DESTROY (id=60, numOpen = 0) DB: Row::DESTROY +-------------------------------+--------------------------------+ | Robert E. Bruccoleri, Ph.D. | Phone: 609 818 7251 | | Research Fellow | Fax: 609 818 3100 | | Applied Genomics | email: [EMAIL PROTECTED] | | Bristol-Myers Squibb Company | Ship: Room 3A-023, | | Mail: HW3-0.03, P.O. Box 5400 | 311 Pennington-Rocky Hill Rd | | Princeton, NJ 08543-5400 | Pennington NJ 08534 | +-------------------------------+--------------------------------+
--- End Message ---
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
