09.03.0200 test failures

Re: To Heikki Linnakangas 2014-02-24 <20140224115931(dot)GD12457(at)msgid(dot)df7cb(dot)de>
> Re: Heikki Linnakangas 2014-02-19 <5304ADB1(dot)6090306(at)vmware(dot)com>
> > diff --git a/test/expected/lfconversion.out b/test/expected/lfconversion.out
> > new file mode 100644
> > index 0000000..ca4776c
> > --- /dev/null
> > +++ b/test/expected/lfconversion.out
>
> Hi Heikki,
>
> I'm afraid you forgot to update Makefile.am to include that file so it
> didn't make it into the 09.03.0200 tarball, rendering the testsuite
> unusable.

After importing the two files into the 09.03.0200 tarball, I'm getting
regression test failures:

gcc -Wno-pointer-sign src/lfconversion-test.c src/common.o -o src/lfconversion-test -lodbc
echo "\! ./src/lfconversion-test" > sql/lfconversion.sql
/usr/lib/postgresql/9.3/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress --inputdir=./ --psqldir='/usr/lib/postgresql/9.3/bin' --launcher=./launcher --dbname=contrib_regression sampletables connect stmthandles select commands multistmt getresult prepare params notice arraybinding insertreturning dataatexecution boolsaschar cvtnulldate alter quotes cursors positioned-update catalogfunctions bindcol lfconversion
(using postmaster on localhost, port 5432)
============== dropping database "contrib_regression" ==============
HINWEIS: Datenbank „contrib_regression“ existiert nicht, wird übersprungen
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries ==============
test sampletables ... ok
test connect ... ok
test stmthandles ... FAILED
test select ... ok
test commands ... FAILED
test multistmt ... ok
test getresult ... ok
test prepare ... ok
test params ... FAILED
test notice ... ok
test arraybinding ... ok
test insertreturning ... ok
test dataatexecution ... FAILED
test boolsaschar ... ok
test cvtnulldate ... ok
test alter ... ok
test quotes ... ok
test cursors ... ok
test positioned-update ... ok
test catalogfunctions ... ok
test bindcol ... ok
test lfconversion ... ok

=======================
4 of 22 tests failed.
=======================

The differences that caused some tests to fail can be viewed in the
file "/home/cbe/projects/postgresql/psqlodbc/psqlodbc/test/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/cbe/projects/postgresql/psqlodbc/psqlodbc/test/regression.out".

make[1]: *** [installcheck] Fehler 1
make[1]: Leaving directory `/home/cbe/projects/postgresql/psqlodbc/psqlodbc/test'
regression.diffs:
*** /home/cbe/projects/postgresql/psqlodbc/psqlodbc/test/expected/stmthandles.out 2014-02-23 06:00:03.000000000 +0100
--- /home/cbe/projects/postgresql/psqlodbc/psqlodbc/test/results/stmthandles.out 2014-02-24 13:04:56.783860379 +0100
***************
*** 40,70 ****
stmt no 81
Result set:
stmt no 91
!
! Testing interleaving operations on multiple prepared statements
! # of result cols: 1
! # of result cols: 2
! # of result cols: 3
! # of result cols: 4
! # of result cols: 5
! Result set:
! stmt no 0
! stmt no 0
! stmt no 0
! Result set:
! stmt no 1 col 0
! stmt no 1 col 0
! stmt no 1 col 0
! Result set:
! stmt no 2 col 0 col 1
! stmt no 2 col 0 col 1
! stmt no 2 col 0 col 1
! Result set:
! stmt no 3 col 0 col 1 col 2
! stmt no 3 col 0 col 1 col 2
! stmt no 3 col 0 col 1 col 2
! Result set:
! stmt no 4 col 0 col 1 col 2 col 3
! stmt no 4 col 0 col 1 col 2 col 3
! stmt no 4 col 0 col 1 col 2 col 3
! disconnecting
--- 40,43 ----
stmt no 81
Result set:
stmt no 91
! Segmentation fault (core dumped)

======================================================================

*** /home/cbe/projects/postgresql/psqlodbc/psqlodbc/test/expected/commands.out 2014-02-23 06:00:03.000000000 +0100
--- /home/cbe/projects/postgresql/psqlodbc/psqlodbc/test/results/commands.out 2014-02-24 13:04:56.899860042 +0100
***************
*** 1,8 ****
\! ./src/commands-test
! connected
! Testing VACUUM with SQLExecDirect...
! Testing VACUUM with SQLPrepare/SQLExecute...
! Disabling autocommit...
! Testing VACUUM with SQLExecDirect...
! Testing VACUUM with SQLPrepare/SQLExecute...
! disconnecting
--- 1,2 ----
\! ./src/commands-test
! Segmentation fault (core dumped)

======================================================================

*** /home/cbe/projects/postgresql/psqlodbc/psqlodbc/test/expected/params.out 2014-02-23 06:00:03.000000000 +0100
--- /home/cbe/projects/postgresql/psqlodbc/psqlodbc/test/results/params.out 2014-02-24 13:04:56.995859763 +0100
***************
*** 1,17 ****
\! ./src/params-test
! connected
! # of result cols: 2
! Result set:
! 1 0102030405060708
!
! Testing SQLBindParameter with SQLExecDirect...
! Result set:
! foo
! bar
!
! Testing SQLDescribeParam...
! Param 1: type INTEGER; size 10; dec digits -1; nullable
! # of result cols: 2
! Result set:
! 3 foobar
! disconnecting
--- 1,2 ----
\! ./src/params-test
! Segmentation fault (core dumped)

======================================================================

*** /home/cbe/projects/postgresql/psqlodbc/psqlodbc/test/expected/dataatexecution.out 2014-02-23 06:00:03.000000000 +0100
--- /home/cbe/projects/postgresql/psqlodbc/psqlodbc/test/results/dataatexecution.out 2014-02-24 13:04:58.295855989 +0100
***************
*** 1,12 ****
\! ./src/dataatexecution-test
! connected
! Result set:
! 2
! 3
! Parameter Status
! Fetching result sets for array bound (2 results expected)
! 1: Result set:
! 4
! 2: Result set:
! 5
! disconnecting
--- 1,2 ----
\! ./src/dataatexecution-test
! Segmentation fault (core dumped)

======================================================================

/home/cbe/tmp/pg_virtualenv.VPPkly/log/postgresql-9.3-regress.log:
2014-02-24 13:04:52 CET LOG: Datenbanksystem wurde am 2014-02-24 13:04:52 CET heruntergefahren
2014-02-24 13:04:53 CET LOG: Datenbanksystem ist bereit, um Verbindungen anzunehmen
2014-02-24 13:04:53 CET LOG: Autovacuum-Launcher startet
2014-02-24 13:04:53 CET LOG: unvollständiges Startpaket

Christoph
--
cb(at)df7cb(dot)de | http://www.df7cb.de/