Re: DBD::Informix 2003.04 AIX4.3.3 SELECTIVE TEST ERRORS

From: Jonathan Leffler (jonathan.leffler_at_gmail.com)
Date: 10/08/04 

Date: Thu, 7 Oct 2004 15:01:07 -0700
To: "ODELL, TODD E (SWBT)" <to2958@sbc.com>

Dear Todd,

Thank you for using the Bug Reporting tools. It makes it so much
easier because I get to see everything I need to see!

t05dbase.t failed to create a database that already existed - not a
major problem (or, one which you could fix by removing the database).

t92rows.t and t93lvarchar.t are failing because t91udts.t is failing -
an unwarranted and undesirable inter-dependency between independent
tests.

t91udts.t is likely failing because of a 'test error' - your database
server (9.21) doesn't understand something that the test is asking it
to do (stuff which works in 9.30 and above). I'll take a heads up on
it, but you should also take a heads up on upgrading to a more recent
version of IDS.

Hmm, you're using DBI 1.45 - congratulations. I missed 1.44 (though
it was only current for one day, so I'm not too worried about that).
I'm getting some nasty failures from using 1.45.

I can't immediately see why t60unlog.t is failing on your system, but
the chances of it being a major issue are limited. The test is
related to unlogged databases.

I think you're good to go, despite the slightly uncomfortable feeling
that those tests should be passing.

On Thu, 7 Oct 2004 15:07:58 -0500, ODELL, TODD E (SWBT) <to2958@sbc.com> wrote:
> I'm having problems with a couple on tests. The bug report is below.
> Everything seems ok and most of the tests are alright but t60unlog,
> t91udts and t93lvarchar are partially failing. This is on an AIX4.3.3
> server. I haven't been able to find anything that might address this
> sort of failure for DBD::Informix make test on the maillist.
>
> Any suggestions would be very appreciated!
>
> Todd
>
> Command: BugReport D t/t60unlog.t t/t91udts.t t/t92rows.t
> t/t93lvarchar.t
> Date: Thu Oct 7 14:35:10 CDT 2004
> Machine: sbctss (AIX 3)
> User: uid=0(root) gid=0(system)
> groups=2(bin),3(sys),7(security),8(cron),10(audit)
> Directory: /usr/opt/perl5/lib/5.6.1/DBD-Informix-2003.04
> Umask: 026
> Terminal: /dev/pts/4
>
> #
> # Perl Version
> Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration:
> Platform:
> osname=aix, osvers=4.3.3.0, archname=aix
> uname='aix sbctss 3 4 000200554c00 '
> config_args=''
> hint=previous, useposix=true, d_sigaction=define
> usethreads=undef use5005threads=undef useithreads=undef
> usemultiplicity=undef
> useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef
> use64bitint=undef use64bitall=undef uselongdouble=undef
> Compiler:
> cc='cc', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
> -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32 -D_LARGE_FILES -qlonglong',
> optimize='-O',
> cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
> -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32 -D_LARGE_FILES -qlonglong'
> ccversion='4.4.0.3', gccversion='', gccosandvers=''
> intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=4321
> d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
> ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
> lseeksize=8
> alignbytes=8, usemymalloc=n, prototype=define
> Linker and Libraries:
> ld='ld', ldflags ='-brtl -b32'
> libpth=/lib /usr/lib /usr/ccs/lib
> libs=-lbind -lnsl -ldbm -ldl -lld -lm -lc -lcrypt -lbsd -lPW -liconv
> perllibs=-lbind -lnsl -ldl -lld -lm -lc -lcrypt -lbsd -lPW -liconv
> libc=/lib/libc.a, so=a, useshrplib=false, libperl=libperl.a
> Dynamic Linking:
> dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef,
> ccdlflags='-bE:/usr/opt/perl5/lib/5.6.1/aix/CORE/perl.exp
> -bE:/usr/opt/perl5/lib/5.6.1/aix/CORE/perl.exp'
> cccdlflags=' ', lddlflags='-bhalt:4 -bM:SRE -bI:$(PERL_INC)/perl.exp
> -bE:$(BASEEXT).exp -b noentry -lc'
>
> Characteristics of this binary (from libperl):
> Compile-time options: USE_LARGE_FILES
> Built under aix
> Compiled at Mar 5 2002 14:17:17
> @INC:
> /usr/opt/perl5/lib/5.6.1/aix
> /usr/opt/perl5/lib/5.6.1
> /usr/opt/perl5/lib/site_perl/5.6.1/aix
> /usr/opt/perl5/lib/site_perl/5.6.1
> /usr/opt/perl5/lib/site_perl
> .
>
> #
> # Informix Version
> INFORMIXDIR = /usr/informix
> ESQLC = esql
> Version = INFORMIX-ESQL Version 9.50.UC1
> DBMS Version = Informix Dynamic Server 2000 Version 9.21.UC4
> Informix Server Entries in sqlhosts file
>
> #
> # Sorted Environment
> AUTHSTATE=files
 [...]
> _=/usr/local/bin/perl
>
> # End of Configuration Report
>
> #
> # Redoing configuration
> + [ ! -f Makefile ] || make realclean

 [...]
> + rm -f esql esqlvrsn.h esqlinfo.h
> + perl Makefile.PL
> *** ExtUtils::AutoInstall version 0.60
> *** Checking for dependencies...
> Subroutine WriteMakefile redefined at
> /usr/opt/perl5/lib/site_perl/5.6.1/ExtUtils/AutoInstall.pm line 487.
> [Core Features]
> - DBI ...loaded. (1.45 >= 1.33)
> [High Resolution Timing]
> - Time::HiRes ...loaded. (1.65)
> *** ExtUtils::AutoInstall configuration finished.
>
> Configuring IBM Informix Database Driver for Perl Version 2003.04
> (2003-03-05) (aka DBD::Informix)
> You are using DBI version 1.45 and Perl version 5.006001
> Remember to actually read the README file!

Ancient Perl - upgrade!

> Perl: perl5.006001 aix dl_aix.xs
> System: aix sbctss 3 4 000200554c00
> Compiler: cc -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
> -qmaxmem=16384 -DUSE_NATIVE_DLOPEN -q32 -D_LARGE_FILES -qlonglong
> Loader: ld
>
> Using INFORMIX-ESQL Version 9.50.UC1 from /usr/informix
>
> Beware: DBD::Informix is not yet aware of all the new IUS data types.
>
> Assert macro will be disabled!
>
> lib/DBD/Informix/Defaults.pm written OK
> esqlvrsn.h written OK
> esqlinfo.h written OK
>
> Testing whether your Informix test environment will work...
> 1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
> options.
> 1506-173 (W) Option 32 is not valid. Enter xlc for list of valid
> options.
> ESQLTEST Program Running:
> @(#)$Id: esqltest.ec,v 100.3 2002/02/08 22:49:23 jleffler Exp $
> $INFORMIXDIR is set to '/usr/informix'.
> $INFORMIXSERVER is set to 'sbctss_s1'.
> $DBI_DBNAME set to 'adsl_results'.
> $DBD_INFORMIX_DATABASE set to 'adsl_results'.
> $DBD_INFORMIX_DATABASE2 set to 'webapp@sbctss2soc'.
> $DBD_INFORMIX_USERNAME is unset.
> $DBD_INFORMIX_USERNAME2 is set to 'root'.
> $DBD_INFORMIX_PASSWORD is unset.
> $DBD_INFORMIX_PASSWORD2 is set.
> Testing connection to adsl_results
> CONNECT TO 'adsl_results' - no user info
> Testing concurrent connection to webapp@sbctss2soc
> CONNECT TO 'webapp@sbctss2soc' with user info
> Your Informix environment is (probably) OK
>
> Fortunately, you are using a new version of ESQL/C. We could
> use 'esql -libs' to tell us which libraries to use, except that
> some versions of the esql script are very Clintonian and do not
> tell us the whole truth. So we have to do a fiddly workaround,
> editing the esql script on the fly and feeding the edited
> version to the shell and ... Oh, you really don't want to know
> what we do; it's horrid but it works, usually!
> ... Replacing reference to -lnetstub with /usr/informix/lib/netstub.a
> (override with DBD_INFORMIX_AIX_USENETSTUB)
> ... We are going to use the library list:
> -lifsql -lifasf -lifgen -lifos -lifgls /usr/informix/lib/netstub.a -lc_r
> -ldl -ltli_r -lm_r /usr/informix/lib/esql/checkapi.o -lifglx
>
> Checking if your kit is complete...
> Looks good
> Using DBI 1.45 (for perl 5.006001 on aix) installed in
> /usr/opt/perl5/lib/site_perl/5.6.1/aix/auto/DBI/
> Writing Makefile for DBD::Informix
>
> #
> # Redoing build
> + make
 [...]
> Manifying blib/man3/DBD::Informix.3
> Target "makemakerdflt" is up to date.
>
> #
> # Redoing general testing
> + make test
> PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM"
> "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/t00basic.t
> t/t01stproc.t t/t02ixtype.t t/t05dbase.t t/t07dblist.t t/t09exec.t
> t/t10sqlca.t t/t12bindval.t t/t13bindref.t t/t14bindcol.t t/t15bindtyp.t
> t/t20error.t t/t21mconn.t t/t22mconn.t t/t23mconn.t t/t24mcurs.t
> t/t25dratt.t t/t28dtlit.t t/t29update.t t/t30update.t t/t31nulls.t
> t/t32nulls.t t/t35cursor.t t/t40rows.t t/t41txacoff.t t/t42txacon.t
> t/t43trans.t t/t44txansi.t t/t46chpblk.t t/t50update.t t/t51getinfo.t
> t/t53types.t t/t54native.t t/t55mdata.t t/t56tabinfo.t t/t57tables.t
> t/t58typeinfoall.t t/t60unlog.t t/t65updcur.t t/t66insert.t t/t72blob.t
> t/t73blobupd.t t/t74blob.t t/t75blob.t t/t76blob.t t/t90ius.t
> t/t91udts.t t/t92rows.t t/t93lvarchar.t t/t94bool.t t/t99clean.t
> t/t00basic..........ok
> t/t01stproc.........ok
> t/t02ixtype.........ok
> t/t05dbase..........DBD::Informix::db do failed: SQL: -330: Cannot
> create or rename database.
> ISAM: -100: ISAM error: duplicate value for a record with unique key.
> at
> /usr/opt/perl5/lib/5.6.1/DBD-Informix-2003.04/blib/lib/DBD/Informix/Test
> Harness.pm line 336.
> DBD::Informix::db prepare failed: SQL: -349: Database not selected yet.
> at t/t05dbase.t line 39.
> Can't call method "execute" on an undefined value at t/t05dbase.t line
> 40.
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 2-13
> Failed 12/13 tests, 7.69% okay
> t/t07dblist.........ok
> t/t09exec...........ok
> t/t10sqlca..........ok
> t/t12bindval........ok
> t/t13bindref........skipped
> all skipped: bind_param_inout not supported by DBD::Informix
> t/t14bindcol........ok
> t/t15bindtyp........ok
> t/t20error..........ok
> t/t21mconn..........ok
> t/t22mconn..........ok
> t/t23mconn..........ok
> t/t24mcurs..........ok
> t/t25dratt..........ok
> t/t28dtlit..........ok
> t/t29update.........ok
> t/t30update.........ok
> t/t31nulls..........ok
> t/t32nulls..........ok
> t/t35cursor.........ok
> t/t40rows...........ok
> t/t41txacoff........ok
> t/t42txacon.........ok
> t/t43trans..........ok
> t/t44txansi.........skipped
> all skipped: MODE ANSI test - database 'adsl_results' is not
> MODE ANSI
> t/t46chpblk.........ok
> t/t50update.........ok
> t/t51getinfo........ok
> t/t53types..........ok
> t/t54native.........ok
> t/t55mdata..........ok
> t/t56tabinfo........ok
> t/t57tables.........ok
> t/t58typeinfoall....ok
> t/t60unlog..........!! Terminating Test !!
> DBD::Informix::TestHarness::stmt_fail called at t/t60unlog.t
> line 73
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 8-9
> Failed 2/9 tests, 77.78% okay
> t/t65updcur.........ok
> t/t66insert.........ok
> t/t72blob...........ok
> t/t73blobupd........ok
> t/t74blob...........ok
> t/t75blob...........ok
> t/t76blob...........ok
> t/t90ius............ok
> t/t91udts...........DBD::Informix::st execute failed: SQL: -9602:
> Illegal attempt to convert a collection type into another type. at
> t/t91udts.t line 130.
> Died at t/t91udts.t line 130.
> dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 10-16
> Failed 7/16 tests, 56.25% okay
> t/t92rows...........DBD::Informix::db do failed: SQL: -9991: Named row
> type (dbd_ix_udts_named) already exists in database. at t/t92rows.t line
> 27.
> DBD::Informix::db do failed: SQL: -9990: Cannot drop named row type
> (dbd_ix_udts_named): still in use. at t/t92rows.t line 133.
> ok
> t/t93lvarchar.......DBD::Informix::db do failed: SQL: -9996: Distinct
> type (root.dbd_ix_distoflvc) already exists in database. at
> /usr/opt/perl5/lib/5.6.1/DBD-Informix-2003.04/blib/lib/DBD/Informix/Test
> Harness.pm line 336.
> DBD::Informix::db do failed: SQL: -9630: Cannot drop type
> (dbd_ix_distoflvc): still in use. at t/t93lvarchar.t line 119.
> dubious
> Test returned status 1 (wstat 256, 0x100)
> DIED. FAILED test 1
> Failed 1/7 tests, 85.71% okay
> t/t94bool...........ok
> t/t99clean..........ok
> Failed 4/51 test scripts, 92.16% okay. 22/1226 subtests failed, 98.21%
> okay.
> Failed Test Stat Wstat Total Fail Failed List of Failed
> ------------------------------------------------------------------------
> -------
> t/t05dbase.t 255 65280 13 23 176.92% 2-13
> t/t60unlog.t 255 65280 9 3 33.33% 8-9
> t/t91udts.t 255 65280 16 14 87.50% 10-16
> t/t93lvarchar.t 1 256 7 1 14.29% 1
> 2 tests skipped.
> make: 1254-004 The error code from the last command is 11.
>
> Stop.
> failed on general testing at
> /usr/opt/perl5/lib/site_perl/5.6.1/aix/DBD/Informix/TechSupport.pm line
> 235.
>
> #
> # Doing selective testing
> + sh test.one.sh t/t60unlog.t t/t91udts.t t/t92rows.t t/t93lvarchar.t
> # Test DBI->connect('dbi:Informix:.DEFAULT.')
> 1..9
> ok 1
> # Create unlogged database dbd_ix_db
> # Test: do('create database dbd_ix_db'):
> ok 2
> ok 3
> # Passed 1 row(s) as expected with no failures
> ok 4
> # Test: do('close database'):
> ok 5
> ok 6
> # Test DBI->connect('dbi:Informix:dbd_ix_db',...,{AutoCommit=>0})
> !! Terminating Test !!
> DBD::Informix::TestHarness::stmt_fail called at t/t60unlog.t
> line 73
> # Connection failed - which is the correct response
> ok 7
> not ok 8
> # Error Message:
> # SQL: -256: Transaction not available.
> # SQLSTATE =
> # Driver Information
> # Name: Informix
> # Version: 2003.04
> # Product: INFORMIX-ESQL Version 9.50.UC1
> # Product Version: 950
> # Connect to: adsl_results
> # IUS data types can be tested!
> 1..16
> # drop table dbd_ix_udts
> # Error Message:
> # SQL: -206: The specified table (dbd_ix_udts) is not in the database.
> # ISAM: -111: ISAM error: no record found.
> # SQLSTATE = 42000
> # drop type dbd_ix_distofi8 restrict
> # drop type dbd_ix_distofbool restrict
> # drop type dbd_ix_distoflvc restrict
> # drop type dbd_ix_distofnamed restrict
> # drop row type dbd_ix_udts_named restrict
> # Test: do('create row type dbd_ix_udts_named (i int)'):
> ok 1
> # Test: do('create distinct type dbd_ix_distofi8 as int8'):
> ok 2
> # Test: do('create distinct type dbd_ix_distofbool as boolean'):
> ok 3
> # Test: do('create distinct type dbd_ix_distoflvc as lvarchar'):
> ok 4
> # Test: do('create distinct type dbd_ix_distofnamed as
> dbd_ix_udts_named'):
> ok 5
> # Test: do('
> # create table dbd_ix_udts
> # (s8 serial8,
> # i8 int8,
> # b boolean,
> # lvc lvarchar,
> # unnamed row(i int, l lvarchar),
> # named dbd_ix_udts_named,
> # sint set(int not null),
> # lunnamed list(row(i int, c char(10)) not null),
> # mnamed multiset(dbd_ix_udts_named not null),
> # di8 dbd_ix_distofi8,
> # db dbd_ix_distofbool,
> # dlvc dbd_ix_distoflvc,
> # dnamed dbd_ix_distofnamed, cl clob) put cl in (sbspace)'):
> ok 6
> # Test: do('
> # insert into dbd_ix_udts values
> # (1, 1, 't',
> '12345678901234567890123456789012345678901234567890123456789012345678901
> 234567890123456789012345678901234567890123456789012345678901234567890123
> 456789012345678901234567890123456789012345678901234567890123456789012345
> 678901234567890123456789012345678901234567890123456789012345678901234567
> 8901234567890', row(1,
> '12345678901234567890123456789012345678901234567890123456789012345678901
> 234567890123456789012345678901234567890123456789012345678901234567890123
> 456789012345678901234567890123456789012345678901234567890123456789012345
> 678901234567890123456789012345678901234567890123456789012345678901234567
> 8901234567890'), row(1)::dbd_ix_udts_named,
> # set{1, 10, 100}, list{row(1, 'one')},
> multiset{row(1)::dbd_ix_udts_named},
> # '1', 't',
> '12345678901234567890123456789012345678901234567890123456789012345678901
> 234567890123456789012345678901234567890123456789012345678901234567890123
> 456789012345678901234567890123456789012345678901234567890123456789012345
> 678901234567890123456789012345678901234567890123456789012345678901234567
> 8901234567890', row(1)::dbd_ix_distofnamed , filetoclob('t/t91udts.t',
> 'client'))
> # '):
> ok 7
> # PREPARE: insert into dbd_ix_udts values (?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?, ?, ?, ? , filetoclob(?, 'client'))
> ok 8
> ok 9
> # inserted nulls OK
> DBD::Informix::st execute failed: SQL: -9602: Illegal attempt to convert
> a collection type into another type. at t/t91udts.t line 130.
> Died at t/t91udts.t line 130.
> # Driver Information
> # Name: Informix
> # Version: 2003.04
> # Product: INFORMIX-ESQL Version 9.50.UC1
> # Product Version: 950
> # Connect to: adsl_results
> # IUS data types can be tested!
> 1..11
> # drop table dbd_ix_rows
> # Error Message:
> # SQL: -206: The specified table (dbd_ix_rows) is not in the database.
> # ISAM: -111: ISAM error: no record found.
> # SQLSTATE = 42000
> # drop row type dbd_ix_udts_named restrict
> # Error Message:
> # SQL: -9990: Cannot drop named row type (dbd_ix_udts_named): still in
> use.
> # SQLSTATE = IX000
> # create row type dbd_ix_udts_named (i int)
> DBD::Informix::db do failed: SQL: -9991: Named row type
> (dbd_ix_udts_named) already exists in database. at t/t92rows.t line 27.
> # Error Message:
> # SQL: -9991: Named row type (dbd_ix_udts_named) already exists in
> database.
> # SQLSTATE = IX000
> #
> create temp table dbd_ix_rows
> (rownum serial not null primary key,
> unnamed row(i int, l lvarchar),
> named dbd_ix_udts_named
> )
> # Test: do(' insert into dbd_ix_rows values (0, row(1,
> '12345678901234567890123456789012345678901234567890123456789012345678901
> 234567890123456789012345678901234567890123456789012345678901234567890123
> 456789012345678901234567890123456789012345678901234567890123456789012345
> 678901234567890123456789012345678901234567890123456789012345678901234567
> 8901234567890'), row(1)::dbd_ix_udts_named); '):
> ok 1
> # PREPARE: insert into dbd_ix_rows values (?, ?, ?)
> ok 2
> ok 3
> # inserted nulls OK
> # inserted 3
> # PREPARE: select rownum, unnamed, named from dbd_ix_rows
> ok 4
> # ROW-1: 1 ROW(1
> ,'1234567890123456789012345678901234567890123456789012345678901234567890
> 123456789012345678901234567890123456789012345678901234567890123456789012
> 345678901234567890123456789012345678901234567890123456789012345678901234
> 5678901234567890123456789 ROW(1 )
> # ROW-2: 2 . .
> # ROW-3: 3 ROW(3 ,'three') ROW(3 )
> # fetched 3
> # PREPARE: update dbd_ix_rows set unnamed = ?, named = ? where rownum =
> ? and unnamed = ? and named = ?
> ok 5
> # EXECUTE
> # updated 1
> ok 6
> # PREPARE: delete from dbd_ix_rows where rownum = ? and unnamed = ? and
> named = ?
> ok 7
> # EXECUTE
> ok 8
> # deleted 1
> ok 9
> DBD::Informix::db do failed: SQL: -9990: Cannot drop named row type
> (dbd_ix_udts_named): still in use. at t/t92rows.t line 133.
> ok 10
> ok 11
> # *** Testing of DBD::Informix complete ***
> # *** You appear to be normal! ***
> # Driver Information
> # Name: Informix
> # Version: 2003.04
> # Product: INFORMIX-ESQL Version 9.50.UC1
> # Product Version: 950
> # Connect to: adsl_results
> # IUS data types can be tested!
> 1..7
> # drop table dbd_ix_lvarchar
> # Error Message:
> # SQL: -206: The specified table (dbd_ix_lvarchar) is not in the
> database.
> # ISAM: -111: ISAM error: no record found.
> # SQLSTATE = 42000
> # drop type dbd_ix_distoflvc restrict
> # Error Message:
> # SQL: -9630: Cannot drop type (dbd_ix_distoflvc): still in use.
> # SQLSTATE = IX000
> # Test: do('create distinct type dbd_ix_distoflvc as lvarchar'):
> DBD::Informix::db do failed: SQL: -9996: Distinct type
> (root.dbd_ix_distoflvc) already exists in database. at
> blib/lib/DBD/Informix/TestHarness.pm line 336.
> not ok 1
> # Test: do('
> # create table dbd_ix_lvarchar (s serial, lvc lvarchar, dlvc
> dbd_ix_distoflvc)'):
> ok 2
> # Test: do('insert into dbd_ix_lvarchar values (10203040,
> '12345678901234567890123456789012345678901234567890',
> '12345678901234567890123456789012345678901234567890')'):
> ok 3
> # PREPARE: insert into dbd_ix_lvarchar values (?, ?, ?)
> ok 4
> ok 5
> # inserted nulls OK
> # PREPARE: select s, lvc from dbd_ix_lvarchar order by s
> # ROW-1: 10203040 12345678901234567890123456789012345678901234567890
> # ROW-2: 11213141 12345678901234567890123456789012345678901234567890
> # ROW-3: 12223242 .
> # fetched 3 rows
> # PREPARE: select s, lvc, dlvc from dbd_ix_lvarchar order by s
> # ROW-1: 10203040 12345678901234567890123456789012345678901234567890
> 12345678901234567890123456789012345678901234567890
> # ROW-2: 11213141 12345678901234567890123456789012345678901234567890
> 12345678901234567890123456789012345678901234567890
> # ROW-3: 12223242 . .
> # fetched 3 rows
> # PREPARE: select s, lvc, dlvc, 'abc'::lvarchar from dbd_ix_lvarchar
> order by s
> # ROW-1: 10203040 12345678901234567890123456789012345678901234567890
> 12345678901234567890123456789012345678901234567890 abc
> # ROW-2: 11213141 12345678901234567890123456789012345678901234567890
> 12345678901234567890123456789012345678901234567890 abc
> # ROW-3: 12223242 . . abc
> # fetched 3 rows
> # PREPARE: select s, lvc, dlvc, 'abc'::lvarchar, lvc as lvc_2 from
> dbd_ix_lvarchar order by s
> # ROW-1: 10203040 12345678901234567890123456789012345678901234567890
> 12345678901234567890123456789012345678901234567890 abc
> 12345678901234567890123456789012345678901234567890
> # ROW-2: 11213141 12345678901234567890123456789012345678901234567890
> 12345678901234567890123456789012345678901234567890 abc
> 12345678901234567890123456789012345678901234567890
> # ROW-3: 12223242 . . abc .
> # fetched 3 rows
> # PREPARE: select s, lvc, dlvc, 'abc'::lvarchar, lvc as lvc_2, dlvc as
> dlvc_2 from dbd_ix_lvarchar order by s
> # ROW-1: 10203040 12345678901234567890123456789012345678901234567890
> 12345678901234567890123456789012345678901234567890 abc
> 12345678901234567890123456789012345678901234567890
> 12345678901234567890123456789012345678901234567890
> # ROW-2: 11213141 12345678901234567890123456789012345678901234567890
> 12345678901234567890123456789012345678901234567890 abc
> 12345678901234567890123456789012345678901234567890
> 12345678901234567890123456789012345678901234567890
> # ROW-3: 12223242 . . abc . .
> # fetched 3 rows
> DBD::Informix::db do failed: SQL: -9630: Cannot drop type
> (dbd_ix_distoflvc): still in use. at t/t93lvarchar.t line 119.
> ok 6
> ok 7
> # *** Testing of DBD::Informix complete ***
> # *** There appear to be some problems! ***
>
> # End of Bug Report
>
> Todd E. O'Dell
> Network Services ( DATA )
> Room 1118
> 500 E. 8th
> Kansas City, MO 64106
> Office: (816)275-3626
> Alpha Page: 8162125424@archwireless.net
> to2958@sbc.com
> Rigidity and inflexibility are forever the enemy of ingenuity and
> creativity. -- Teodor Zlatanov
>
> 

-- 
Jonathan Leffler <jonathan.leffler@gmail.com>  #include <disclaimer.h>
Guardian of DBD::Informix - v2003.04 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."

Relevant Pages

  • DBD::Informix 2005.01-> t91udts.t fails
    ... Configuring IBM Informix Database Driver for Perl DBI Version 2005.01 ... # Error Message: ... # SQLSTATE = IX000 ...
    (perl.dbi.users)
  • Re: Error occurs when oninit: DBSERVERNAME sharp not in sqlhosts file.
    ... Seems that your env is incorrect when trying to start the database. ... BTW i would start the database as user informix, ... get an error message then as following, how can I do with it? ... edit the sqlhosts file manually and add an entry to correct the error? ...
    (comp.databases.informix)
  • RE: :Informix 2005.01-> t91udts.t fails
    ... It appears that you either need a smart blob space named sbspace, ... > the DBD::Informix or simply with this version of Informix ( ... > # Error Message: ...
    (perl.dbi.users)
  • Re: Module Not Found
    ... Close the database. ... Still in the code window, choose Compile from the Debug menu. ... The error message could be related to something else that is going on, ... VB and press the cancel button I receive the error message ...
    (microsoft.public.access.formscoding)
  • Re: How to access idx+dat informix files
    ... it's an Informix 7.2 database. ... It's not possible to unload those files from the original server ... There are several classes of Informix database products (CISAM; SE; ...
    (comp.databases.informix)