On Wed, 08 May 2013 23:15:25 +0300, Damyan Ivanov wrote: > > > This package FTBTS with perl 5.16 from experimental: > > > > > > DBD::FirebirdEmbedded::db do failed: Incompatible column/host variable > > > data type > > > -Dynamic SQL Error > > > -SQL error code = -303 > > > -Malformed string at t/embed-75-utf8.t line 136. > > > # Looks like you planned 37 tests but ran 23. > > > # Looks like your test exited with 255 just after 23. > > > t/embed-75-utf8.t ............... > > > Dubious, test returned 255 (wstat 65280, 0xff00)
Good news, I can reproduce the failure.
(After rebuilding libdbi-perl against perl 5.16 ...)
> > Dam, any news on this?
> Not really. I had no time to look into this and it slipped off radar.
[..]
> From the error message above, it seems that the firebird engine
> refuses the supplied string as invalid UTF-8. Why this happens with
> 5.16 is a mystery. I took a glance at perl5160delta, but nothing
> obvious stroke out.
>
> Sorry for not having a real answer.
No worries :)
> What would help further is a log of the failing test with e.g.
> DBI_TRACE=2=trace.log make test TEST_FILES=t/embed-75-utf8.t
# DBI_TRACE=2=trace.log make test TEST_FILES=t/embed-75-utf8.t
make[1]: Entering directory `/tmp/buildd/libdbd-firebird-perl-1.11/embed'
make[1]: Leaving directory `/tmp/buildd/libdbd-firebird-perl-1.11/embed'
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/embed-75-utf8.t
t/embed-75-utf8.t .. DBI
connect('db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=ASCII','',...)
failed: Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements
-I/O error during "open" operation for file "dbd-firebird-test.fdb"
-Error while trying to open file
-No such file or directory at t/embed-75-utf8.t line 37.
# Looks like your test exited with 2 before it could output anything.
t/embed-75-utf8.t .. Dubious, test returned 2 (wstat 512, 0x200)
Failed 37/37 subtests
Test Summary Report
-------------------
t/embed-75-utf8.t (Wstat: 512 Tests: 0 Failed: 0)
Non-zero exit status: 2
Parse errors: Bad plan. You planned 37 tests but ran 0.
Files=1, Tests=0, 0 wallclock secs ( 0.02 usr 0.01 sys + 0.06 cusr 0.01
csys = 0.10 CPU)
Result: FAIL
Failed 1/1 test programs. 0/0 subtests failed.
make: *** [test_dynamic] Error 2
# cat trace.log
DBI 1.622-ithread default trace level set to 0x0/2 (pid 25870 pi 1de5040)
at DBI.pm line 276 via TestFirebirdEmbedded.pm line 10
->
DBI->connect(dbi:FirebirdEmbedded:db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=ASCII,
, ****, HASH(0x24a3e30))
-> DBI->install_driver(FirebirdEmbedded) for linux perl=5.016003 pid=25870
ruid=0 euid=0
install_driver: DBD::FirebirdEmbedded version 1.11 loaded from
/tmp/buildd/libdbd-firebird-perl-1.11/blib/lib/DBD/FirebirdEmbedded.pm
<- install_driver= DBI::dr=HASH(0x24da1f8)
!! warn: 0 CLEARED by call to default_user method
-> default_user in DBD::_::dr for DBD::FirebirdEmbedded::dr
(DBI::dr=HASH(0x24da1f8)~0x24da2a0 undef undef HASH(0x202ebb0)) thr#1de5040
<- default_user= ( undef undef ) [2 items] at DBI.pm line 646
-> connect for DBD::FirebirdEmbedded::dr (DBI::dr=HASH(0x24da1f8)~0x24da2a0
'db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=ASCII' undef ****
HASH(0x202ebb0)) thr#1de5040
dbd_db_login6
Unsuccessful execution caused by a system error that precludes successful
execution of subsequent statements
-I/O error during "open" operation for file "dbd-firebird-test.fdb"
-Error while trying to open file
-No such file or directory error -902 recorded: Unsuccessful execution caused
by a system error that precludes successful execution of subsequent statements
-I/O error during "open" operation for file "dbd-firebird-test.fdb"
-Error while trying to open file
-No such file or directory
DESTROY for DBI::db=HASH(0x24daa98) ignored - handle not initialised
!! ERROR: -902 'Unsuccessful execution caused by a system error that
precludes successful execution of subsequent statements
-I/O error during "open" operation for file "dbd-firebird-test.fdb"
-Error while trying to open file
-No such file or directory' (err#0)
<- connect= ( undef ) [1 items] at DBI.pm line 658
-> $DBI::errstr (&) FETCH from lasth=HASH
<- $DBI::errstr= 'Unsuccessful execution caused by a system error that
precludes successful execution of subsequent statements
-I/O error during "open" operation for file "dbd-firebird-test.fdb"
-Error while trying to open file
-No such file or directory'
DBI
connect('db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=ASCII','',...)
failed: Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements
-I/O error during "open" operation for file "dbd-firebird-test.fdb"
-Error while trying to open file
-No such file or directory
-- DBI::END ($@: , $!: )
!! ERROR: -902 CLEARED by call to disconnect_all method
-> disconnect_all for DBD::FirebirdEmbedded::dr
(DBI::dr=HASH(0x24da1f8)~0x24da2a0) thr#1de5040
<- disconnect_all= ( '' ) [1 items] at DBI.pm line 737
! -> DESTROY in DBD::_::common for DBD::FirebirdEmbedded::dr
(DBI::dr=HASH(0x24da2a0)~INNER) thr#1de5040
! <- DESTROY= ( undef ) [1 items] during global destruction
So far, the problem is in t/TestFirebirdEmbedded.pm, where
check_mark() returns
-f $self->get_path;
and get_path is
sub get_path { 'dbd-firebird-test.fdb' }
and this file doesn't exist.
Ok, running all test I see:
t/embed-01-connect.t ............ # Creating test database at
dbd-firebird-test.fdb
But it gets removed again:
t/embed-zz-cleanup.t ............ 1/2 # Test database dropped
Good so we need the two tests at least ...
# DBI_TRACE=2=trace.log make test TEST_FILES="t/embed-01-connect.t
t/embed-75-utf8.t"
make[1]: Entering directory `/tmp/buildd/libdbd-firebird-perl-1.11/embed'
make[1]: Leaving directory `/tmp/buildd/libdbd-firebird-perl-1.11/embed'
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,
'blib/lib', 'blib/arch')" t/embed-01-connect.t t/embed-75-utf8.t
t/embed-01-connect.t .. # Creating test database at dbd-firebird-test.fdb
t/embed-01-connect.t .. ok
t/embed-75-utf8.t ..... 1/37 DBD::FirebirdEmbedded::db do failed: Incompatible
column/host variable data type
-Dynamic SQL Error
-SQL error code = -303
-Malformed string at t/embed-75-utf8.t line 136.
# Looks like you planned 37 tests but ran 23.
# Looks like your test exited with 255 just after 23.
t/embed-75-utf8.t ..... Dubious, test returned 255 (wstat 65280, 0xff00)
Failed 14/37 subtests
Test Summary Report
-------------------
t/embed-75-utf8.t (Wstat: 65280 Tests: 23 Failed: 0)
Non-zero exit status: 255
Parse errors: Bad plan. You planned 37 tests but ran 23.
Files=2, Tests=25, 1 wallclock secs ( 0.03 usr 0.00 sys + 0.19 cusr 0.05
csys = 0.27 CPU)
Result: FAIL
Failed 1/2 test programs. 0/25 subtests failed.
make: *** [test_dynamic] Error 255
# cat trace.log
DBI 1.622-ithread default trace level set to 0x0/2 (pid 15923 pi 1b3f040)
at DBI.pm line 276 via TestFirebirdEmbedded.pm line 10
->
DBI->connect(dbi:FirebirdEmbedded:db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=UTF8,
, ****, HASH(0x1ce5070))
-> DBI->install_driver(FirebirdEmbedded) for linux perl=5.016003 pid=15923
ruid=0 euid=0
install_driver: DBD::FirebirdEmbedded version 1.11 loaded from
/tmp/buildd/libdbd-firebird-perl-1.11/blib/lib/DBD/FirebirdEmbedded.pm
<- install_driver= DBI::dr=HASH(0x20a73e0)
!! warn: 0 CLEARED by call to default_user method
-> default_user in DBD::_::dr for DBD::FirebirdEmbedded::dr
(DBI::dr=HASH(0x20a73e0)~0x20a7338 undef undef HASH(0x1d8fe28)) thr#1b3f040
<- default_user= ( undef undef ) [2 items] at DBI.pm line 646
-> connect for DBD::FirebirdEmbedded::dr (DBI::dr=HASH(0x20a73e0)~0x20a7338
'db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=UTF8' undef ****
HASH(0x1d8fe28)) thr#1b3f040
dbd_db_login6
<- connect= ( DBI::db=HASH(0x20a1d50) ) [1 items] at DBI.pm line 658
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x20a1cd8)~INNER
'RaiseError' 1) thr#1b3f040
dbd_db_STORE - RaiseError
<- STORE= ( 1 ) [1 items] at DBI.pm line 710
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x20a1cd8)~INNER
'PrintError' 0) thr#1b3f040
dbd_db_STORE - PrintError
<- STORE= ( 1 ) [1 items] at DBI.pm line 710
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x20a1cd8)~INNER
'AutoCommit' 1) thr#1b3f040
dbd_db_STORE - AutoCommit
<- STORE= ( 1 ) [1 items] at DBI.pm line 710
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x20a1cd8)~INNER
'ib_enable_utf8' 1) thr#1b3f040
dbd_db_STORE - ib_enable_utf8
<- STORE= ( 1 ) [1 items] at DBI.pm line 713
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x20a1cd8)~INNER
'Username' undef) thr#1b3f040
dbd_db_STORE - Username
<- STORE= ( 1 ) [1 items] at DBI.pm line 713
-> connected in DBD::_::db for DBD::FirebirdEmbedded::db
(DBI::db=HASH(0x20a1d50)~0x20a1cd8
'dbi:FirebirdEmbedded:db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=UTF8'
undef **** HASH(0x1ce5070)) thr#1b3f040
<- connected= ( undef ) [1 items] at DBI.pm line 720
<- connect= DBI::db=HASH(0x20a1d50)
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x20a1cd8)~INNER
'dbi_connect_closure' CODE(0x20a8010)) thr#1b3f040
dbd_db_STORE - dbi_connect_closure
<- STORE= ( 1 ) [1 items] at DBI.pm line 729
-> disconnect for DBD::FirebirdEmbedded::db
(DBI::db=HASH(0x20a1d50)~0x20a1cd8) thr#1b3f040
dbd_db_disconnect
<- disconnect= ( 1 ) [1 items] at embed-01-connect.t line 38
-> DESTROY for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x20a1cd8)~INNER)
thr#1b3f040
dbd_db_destroy
<- DESTROY= ( undef ) [1 items]
-- DBI::END ($@: , $!: )
-> disconnect_all for DBD::FirebirdEmbedded::dr
(DBI::dr=HASH(0x20a73e0)~0x20a7338) thr#1b3f040
<- disconnect_all= ( '' ) [1 items] at DBI.pm line 737
! -> DESTROY in DBD::_::common for DBD::FirebirdEmbedded::dr
(DBI::dr=HASH(0x20a7338)~INNER) thr#1b3f040
! <- DESTROY= ( undef ) [1 items] during global destruction
DBI 1.622-ithread default trace level set to 0x0/2 (pid 15928 pi e47040) at
DBI.pm line 276 via TestFirebirdEmbedded.pm line 10
->
DBI->connect(dbi:FirebirdEmbedded:db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=ASCII,
, ****, HASH(0x1505f00))
-> DBI->install_driver(FirebirdEmbedded) for linux perl=5.016003 pid=15928
ruid=0 euid=0
install_driver: DBD::FirebirdEmbedded version 1.11 loaded from
/tmp/buildd/libdbd-firebird-perl-1.11/blib/lib/DBD/FirebirdEmbedded.pm
<- install_driver= DBI::dr=HASH(0x153c2d8)
!! warn: 0 CLEARED by call to default_user method
-> default_user in DBD::_::dr for DBD::FirebirdEmbedded::dr
(DBI::dr=HASH(0x153c2d8)~0x153c380 undef undef HASH(0x1090c40)) thr#e47040
<- default_user= ( undef undef ) [2 items] at DBI.pm line 646
-> connect for DBD::FirebirdEmbedded::dr (DBI::dr=HASH(0x153c2d8)~0x153c380
'db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=ASCII' undef ****
HASH(0x1090c40)) thr#e47040
dbd_db_login6
<- connect= ( DBI::db=HASH(0x153cb00) ) [1 items] at DBI.pm line 658
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x153cb78)~INNER
'RaiseError' 1) thr#e47040
dbd_db_STORE - RaiseError
<- STORE= ( 1 ) [1 items] at DBI.pm line 710
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x153cb78)~INNER
'PrintError' 0) thr#e47040
dbd_db_STORE - PrintError
<- STORE= ( 1 ) [1 items] at DBI.pm line 710
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x153cb78)~INNER
'AutoCommit' 1) thr#e47040
dbd_db_STORE - AutoCommit
<- STORE= ( 1 ) [1 items] at DBI.pm line 710
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x153cb78)~INNER
'Username' undef) thr#e47040
dbd_db_STORE - Username
<- STORE= ( 1 ) [1 items] at DBI.pm line 713
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x153cb78)~INNER
'ChopBlanks' 1) thr#e47040
dbd_db_STORE - ChopBlanks
<- STORE= ( 1 ) [1 items] at DBI.pm line 713
-> connected in DBD::_::db for DBD::FirebirdEmbedded::db
(DBI::db=HASH(0x153cb00)~0x153cb78
'dbi:FirebirdEmbedded:db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=ASCII'
undef **** HASH(0x1505f00)) thr#e47040
<- connected= ( undef ) [1 items] at DBI.pm line 720
<- connect= DBI::db=HASH(0x153cb00)
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x153cb78)~INNER
'dbi_connect_closure' CODE(0x15332f0)) thr#e47040
dbd_db_STORE - dbi_connect_closure
<- STORE= ( 1 ) [1 items] at DBI.pm line 729
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x153cb78)~INNER
'ib_enable_utf8' 1) thr#e47040
dbd_db_STORE - ib_enable_utf8
-> disconnect for DBD::FirebirdEmbedded::db
(DBI::db=HASH(0x153cb00)~0x153cb78) thr#e47040
dbd_db_disconnect
<- disconnect= ( 1 ) [1 items] at embed-75-utf8.t line 45
->
DBI->connect(dbi:FirebirdEmbedded:db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=UTF8,
, ****, HASH(0x1505f00))
-> default_user in DBD::_::dr for DBD::FirebirdEmbedded::dr
(DBI::dr=HASH(0x153c2d8)~0x153c380 undef undef HASH(0x153cda0)) thr#e47040
<- default_user= ( undef undef ) [2 items] at DBI.pm line 646
-> connect for DBD::FirebirdEmbedded::dr (DBI::dr=HASH(0x153c2d8)~0x153c380
'db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=UTF8' undef ****
HASH(0x153cda0)) thr#e47040
dbd_db_login6
<- connect= ( DBI::db=HASH(0x1544ca8) ) [1 items] at DBI.pm line 658
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544d38)~INNER
'RaiseError' 1) thr#e47040
dbd_db_STORE - RaiseError
<- STORE= ( 1 ) [1 items] at DBI.pm line 710
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544d38)~INNER
'PrintError' 0) thr#e47040
dbd_db_STORE - PrintError
<- STORE= ( 1 ) [1 items] at DBI.pm line 710
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544d38)~INNER
'AutoCommit' 1) thr#e47040
dbd_db_STORE - AutoCommit
<- STORE= ( 1 ) [1 items] at DBI.pm line 710
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544d38)~INNER
'Username' undef) thr#e47040
dbd_db_STORE - Username
<- STORE= ( 1 ) [1 items] at DBI.pm line 713
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544d38)~INNER
'ChopBlanks' 1) thr#e47040
dbd_db_STORE - ChopBlanks
<- STORE= ( 1 ) [1 items] at DBI.pm line 713
-> connected in DBD::_::db for DBD::FirebirdEmbedded::db
(DBI::db=HASH(0x1544ca8)~0x1544d38
'dbi:FirebirdEmbedded:db=dbd-firebird-test.fdb;ib_dialect=3;ib_charset=UTF8'
undef **** HASH(0x1505f00)) thr#e47040
<- connected= ( undef ) [1 items] at DBI.pm line 720
<- connect= DBI::db=HASH(0x1544ca8)
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544d38)~INNER
'dbi_connect_closure' CODE(0x153ce48)) thr#e47040
dbd_db_STORE - dbi_connect_closure
<- STORE= ( 1 ) [1 items] at DBI.pm line 729
-> DESTROY for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x153cb78)~INNER)
thr#e47040
dbd_db_destroy
<- DESTROY= ( undef ) [1 items] at embed-75-utf8.t line 52
-> STORE for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544d38)~INNER
'ib_enable_utf8' 1) thr#e47040
dbd_db_STORE - ib_enable_utf8
<- STORE= ( 1 ) [1 items] at embed-75-utf8.t line 52
-> FETCH for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544d38)~INNER
'ib_enable_utf8') thr#e47040
dbd_db_FETCH - ib_enable_utf8
<- FETCH= ( 1 ) [1 items] at More.pm line 292
-> FETCH for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544d38)~INNER
'ib_enable_utf8') thr#e47040
dbd_db_FETCH - ib_enable_utf8
<- FETCH= ( 1 ) [1 items] at More.pm line 292
-> quote_identifier in DBD::_::db for DBD::FirebirdEmbedded::db
(DBI::db=HASH(0x1544ca8)~0x1544d38 'TESTAA') thr#e47040
<- quote_identifier= ( '"TESTAA"' ) [1 items] at TestFirebird.pm line 327
-> tables in DBD::_::db for DBD::FirebirdEmbedded::db
(DBI::db=HASH(0x1544ca8)~0x1544d38) thr#e47040
TableInfo factory(DBI::db=HASH(0x1544d38) [LI-V6.3.2.26508 Firebird 2.5])Enter
dbd_st_prepare
Enter dbd_preparse
dbd_st_STORE - ChopBlanks
dbd_st_execute
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
dbd_st_fetch
try isc_commit_transaction
ib_commit_transaction succeed.
dbd_st_destroy
<- tables= ( '"RDB$PAGES"' '"RDB$DATABASE"' '"RDB$FIELDS"'
'"RDB$INDEX_SEGMENTS"' '"RDB$INDICES"' '"RDB$RELATION_FIELDS"'
'"RDB$RELATIONS"' '"RDB$VIEW_RELATIONS"' '"RDB$FORMATS"'
'"RDB$SECURITY_CLASSES"' '"RDB$FILES"' '"RDB$TYPES"' '"RDB$TRIGGERS"'
'"RDB$DEPENDENCIES"' '"RDB$FUNCTIONS"' '"RDB$FUNCTION_ARGUMENTS"'
'"RDB$FILTERS"' '"RDB$TRIGGER_MESSAGES"' '"RDB$USER_PRIVILEGES"'
'"RDB$TRANSACTIONS"' '"RDB$GENERATORS"' '"RDB$FIELD_DIMENSIONS"'
'"RDB$RELATION_CONSTRAINTS"' '"RDB$REF_CONSTRAINTS"' '"RDB$CHECK_CONSTRAINTS"'
'"RDB$LOG_FILES"' '"RDB$PROCEDURES"' '"RDB$PROCEDURE_PARAMETERS"'
'"RDB$CHARACTER_SETS"' '"RDB$COLLATIONS"' '"RDB$EXCEPTIONS"' '"RDB$ROLES"'
'"RDB$BACKUP_HISTORY"' '"MON$DATABASE"' '"MON$ATTACHMENTS"'
'"MON$TRANSACTIONS"' '"MON$STATEMENTS"' '"MON$CALL_STACK"' '"MON$IO_STATS"'
'"MON$RECORD_STATS"' '"MON$CONTEXT_VARIABLES"' '"MON$MEMORY_USAGE"' '"TESTAA"'
'"TESTAB"' ) [44 items] at TestFirebird.pm line 329
-> quote_identifier in DBD::_::db for DBD::FirebirdEmbedded::db
(DBI::db=HASH(0x1544ca8)~0x1544d38 'TESTAA') thr#e47040
<- quote_identifier= ( '"TESTAA"' ) [1 items] at TestFirebird.pm line 331
-> quote_identifier in DBD::_::db for DBD::FirebirdEmbedded::db
(DBI::db=HASH(0x1544ca8)~0x1544d38 'TESTAB') thr#e47040
<- quote_identifier= ( '"TESTAB"' ) [1 items] at TestFirebird.pm line 332
-> quote_identifier in DBD::_::db for DBD::FirebirdEmbedded::db
(DBI::db=HASH(0x1544ca8)~0x1544d38 'TESTAC') thr#e47040
<- quote_identifier= ( '"TESTAC"' ) [1 items] at TestFirebird.pm line 332
-> do for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544ca8)~0x1544d38
'CREATE TABLE TESTAC (
id INTEGER PRIMARY KEY,
varchr VARCHAR(20) CHARACTER SET UTF8,
chr CHAR(20) CHARACTER SET UTF8,
blb BLOB SUB_TYPE TEXT CHARACTER SET UTF8
)
') thr#e47040
db::_do
Executing : CREATE TABLE TESTAC (
id INTEGER PRIMARY KEY,
varchr VARCHAR(20) CHARACTER SET UTF8,
chr CHAR(20) CHARACTER SET UTF8,
blb BLOB SUB_TYPE TEXT CHARACTER SET UTF8
)
starting new transaction..
new transaction started.
try isc_commit_transaction
ib_commit_transaction succeed.
<- do= ( -1 ) [1 items] at embed-75-utf8.t line 75
-> do for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544ca8)~0x1544d38
'INSERT INTO TESTAC VALUES (1, 'ASCII varchar', 'ASCII char', 'ASCII blob')')
thr#e47040
db::_do
Executing : INSERT INTO TESTAC VALUES (1, 'ASCII varchar', 'ASCII char', 'ASCII
blob')
starting new transaction..
new transaction started.
try isc_commit_transaction
ib_commit_transaction succeed.
<- do= ( 1 ) [1 items] at embed-75-utf8.t line 80
-> prepare for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544ca8)~0x1544d38
'SELECT * FROM TESTAC WHERE id = ?') thr#e47040
Enter dbd_st_prepare
Enter dbd_preparse
<- prepare= ( DBI::st=HASH(0x1588910) ) [1 items] at embed-75-utf8.t line 86
-> execute for DBD::FirebirdEmbedded::st (DBI::st=HASH(0x1588910)~0x1588898
1) thr#e47040
dbd_bind_ph
enter ib_fill_isqlda. processing 1 XSQLVAR Type 0 ivar->sqltype=496
ib_fill_isqlda: SQL_SHORT/SQL_LONG
dbd_st_execute
<- execute= ( '0E0' ) [1 items] at embed-75-utf8.t line 88
-> fetchrow_arrayref for DBD::FirebirdEmbedded::st
(DBI::st=HASH(0x1588910)~0x1588898) thr#e47040
dbd_st_fetch
<- fetchrow_arrayref= ( [ 1 'ASCII varchar' 'ASCII char' 'ASCII blob' ] )
[1 items] row1 at embed-75-utf8.t line 90
-> finish for DBD::FirebirdEmbedded::st (DBI::st=HASH(0x1588910)~0x1588898)
thr#e47040
dbd_st_finish
try isc_commit_transaction
ib_commit_transaction succeed.
<- finish= ( 1 ) [1 items] at embed-75-utf8.t line 91
-> do for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544ca8)~0x1544d38
'INSERT INTO TESTAC VALUES (2, ?, ?, ?)' HASH(0x1579778) 'Still plain varchar'
'Still plain char' 'Still plain blob') thr#e47040
Enter dbd_st_prepare
Enter dbd_preparse
dbd_bind_ph
enter ib_fill_isqlda. processing 1 XSQLVAR Type 0 ivar->sqltype=449
ib_fill_isqlda: SQL_VARYING
dbd_bind_ph
enter ib_fill_isqlda. processing 2 XSQLVAR Type 0 ivar->sqltype=453
ib_fill_isqlda: SQL_TEXT
dbd_bind_ph
enter ib_fill_isqlda. processing 3 XSQLVAR Type 0 ivar->sqltype=521
ib_fill_isqlda: SQL_BLOB
ib_blob_write
dbd_st_execute
try isc_commit_transaction
ib_commit_transaction succeed.
dbd_st_destroy
<- do= ( 1 ) [1 items] at embed-75-utf8.t line 100
-> execute for DBD::FirebirdEmbedded::st (DBI::st=HASH(0x1588910)~0x1588898
2) thr#e47040
dbd_bind_ph
enter ib_fill_isqlda. processing 1 XSQLVAR Type 0 ivar->sqltype=496
ib_fill_isqlda: SQL_SHORT/SQL_LONG
dbd_st_execute
<- execute= ( '0E0' ) [1 items] at embed-75-utf8.t line 109
-> fetchrow_arrayref for DBD::FirebirdEmbedded::st
(DBI::st=HASH(0x1588910)~0x1588898) thr#e47040
dbd_st_fetch
<- fetchrow_arrayref= ( [ 2 'Still plain varchar' 'Still plain char' 'Still
plain blob' ] ) [1 items] row1 at embed-75-utf8.t line 110
-> finish for DBD::FirebirdEmbedded::st (DBI::st=HASH(0x1588910)~0x1588898)
thr#e47040
dbd_st_finish
try isc_commit_transaction
ib_commit_transaction succeed.
<- finish= ( 1 ) [1 items] at embed-75-utf8.t line 111
-> do for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544ca8)~0x1544d38
"INSERT INTO TESTAC VALUES(3, 'Værчàr', 'Tæst', '€÷∞')") thr#e47040
db::_do
Executing : INSERT INTO TESTAC VALUES(3, 'Værчàr', 'Tæst', '€÷∞')
starting new transaction..
new transaction started.
try isc_commit_transaction
ib_commit_transaction succeed.
<- do= ( 1 ) [1 items] at embed-75-utf8.t line 121
-> execute for DBD::FirebirdEmbedded::st (DBI::st=HASH(0x1588910)~0x1588898
3) thr#e47040
dbd_bind_ph
enter ib_fill_isqlda. processing 1 XSQLVAR Type 0 ivar->sqltype=496
ib_fill_isqlda: SQL_SHORT/SQL_LONG
dbd_st_execute
<- execute= ( '0E0' ) [1 items] at embed-75-utf8.t line 124
-> fetchrow_arrayref for DBD::FirebirdEmbedded::st
(DBI::st=HASH(0x1588910)~0x1588898) thr#e47040
dbd_st_fetch
<- fetchrow_arrayref= ( [ 3 "Værчàr" "Tæst" "€÷∞" ] ) [1 items] row1 at
embed-75-utf8.t line 125
-> finish for DBD::FirebirdEmbedded::st (DBI::st=HASH(0x1588910)~0x1588898)
thr#e47040
dbd_st_finish
try isc_commit_transaction
ib_commit_transaction succeed.
<- finish= ( 1 ) [1 items] at embed-75-utf8.t line 126
-> do for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544ca8)~0x1544d38
'INSERT INTO TESTAC VALUES(4, ?, ?, ?)' HASH(0x1574d98) "Værчàr" "Tæst" "€÷∞")
thr#e47040
Enter dbd_st_prepare
Enter dbd_preparse
dbd_bind_ph
enter ib_fill_isqlda. processing 1 XSQLVAR Type 0 ivar->sqltype=449
ib_fill_isqlda: SQL_VARYING
dbd_bind_ph
enter ib_fill_isqlda. processing 2 XSQLVAR Type 0 ivar->sqltype=453
ib_fill_isqlda: SQL_TEXT
dbd_bind_ph
enter ib_fill_isqlda. processing 3 XSQLVAR Type 0 ivar->sqltype=521
ib_fill_isqlda: SQL_BLOB
ib_blob_write
dbd_st_execute
Incompatible column/host variable data type
-Dynamic SQL Error
-SQL error code = -303
-Malformed string error -303 recorded: Incompatible column/host variable data
type
-Dynamic SQL Error
-SQL error code = -303
-Malformed string
try isc_commit_transaction
ib_commit_transaction succeed.
dbd_st_destroy
!! ERROR: -303 'Incompatible column/host variable data type
-Dynamic SQL Error
-SQL error code = -303
-Malformed string' (err#0)
<- do= ( undef ) [1 items] at embed-75-utf8.t line 136
-> DESTROY for DBD::FirebirdEmbedded::st (DBI::st=HASH(0x1588898)~INNER)
thr#e47040
dbd_st_destroy
ERROR: -303 'Incompatible column/host variable data type
-Dynamic SQL Error
-SQL error code = -303
-Malformed string' (err#0)
<- DESTROY= ( undef ) [1 items] at embed-75-utf8.t line 136
-> DESTROY for DBD::FirebirdEmbedded::db (DBI::db=HASH(0x1544d38)~INNER)
thr#e47040
dbd_db_disconnect
dbd_db_destroy
ERROR: -303 'Incompatible column/host variable data type
-Dynamic SQL Error
-SQL error code = -303
-Malformed string' (err#0)
<- DESTROY= ( undef ) [1 items] at embed-75-utf8.t line 136
-- DBI::END ($@: , $!: )
!! ERROR: -303 CLEARED by call to disconnect_all method
-> disconnect_all for DBD::FirebirdEmbedded::dr
(DBI::dr=HASH(0x153c2d8)~0x153c380) thr#e47040
<- disconnect_all= ( '' ) [1 items] at DBI.pm line 737
! -> DESTROY in DBD::_::common for DBD::FirebirdEmbedded::dr
(DBI::dr=HASH(0x153c380)~INNER) thr#e47040
! <- DESTROY= ( undef ) [1 items] during global destruction
Cheers,
gregor
--
.''`. Homepage: http://info.comodo.priv.at/ - OpenPGP key 0xBB3A68018649AA06
: :' : Debian GNU/Linux user, admin, and developer - http://www.debian.org/
`. `' Member of VIBE!AT & SPI, fellow of the Free Software Foundation Europe
`- NP: Peter, Paul and Mary: Too Much Of Nothing
signature.asc
Description: Digital signature
