Re: Failing tests on Fedora

On 05/28/2014 02:00 AM, Pavel Raiskup wrote:
> On Tuesday 27 of May 2014 21:54:07 Heikki Linnakangas wrote:
>> On 05/23/2014 08:32 AM, Pavel Raiskup wrote:
>>> Attached files (regression.out, regression.diffs).
>>> *** /home/praiskup/rh/projects/psqlodbc/test/expected/deprecated.out    2014-04-02 08:37:57.065266936 +0200
>>> --- /home/praiskup/rh/projects/psqlodbc/test/results/deprecated.out    2014-05-22 19:01:21.702283366 +0200
>>> ***************
>>> *** 6,12 ****
>>>    Check for SQLGetConnectOption
>>>    Access type is: read-write
>>>    Check for SQLError
>>> ! Error check: ERROR: relation "table_not_here" does not exist;
>>>    Error while executing the query
>>>    Check for SQLSetParam
>>>    Result set:
>>> --- 6,12 ----
>>>    Check for SQLGetConnectOption
>>>    Access type is: read-write
>>>    Check for SQLError
>>> ! Error check: ERROR:  relation "table_not_here" does not exist at character 13;
>>>    Error while executing the query
>>>    Check for SQLSetParam
>>>    Result set:
>>
>> Hmm, you get that "at character" appendix in the error message if you
>> connect using the FE/BE protocol version 2. Is there some middleware or
>> something else in your test environment that you didn't mention?
>
> No, I had just improperly configured testsuite.  Thanks for pointer -- I
> should use 7.4 (v.3 protocol) rather than 6.4 (set in odbc.ini in git
> master).
>
> After that change, only two failures seem to occur:  First is relevant
> to mail thread discussing the commit 56b18326 && ad2a4aecb4.  The second
> one is relevant to 'prepare' test:
>
>      @@ -109,8 +109,8 @@
>       4098   4098
>       4099   4099
>       Result set:
>      -1      @ 1 day one day
>      -2      @ 10 secs       ten secs
>      +1      1 day   one day
>      +2      00:00:10        ten secs
>       # of result cols: 2
>       Result set:
>       2      bar
>
> Even when I see this was here before, it is pretty unlucky we are unable
> to run testsuite against older PostgreSQL servers than 9.4;  it is common
> practice (I would not say that if the current git branch was supposed to
> be run strictly against 9.4).

It works for me, down to 9.0 server.

> To make the testing little bit easier, test/odbc.ini could enforce V3
> protocol by default.  But it is OK for me from now :)

Hmm, I see that odbc.ini says "Protocol = 6.4", but it nevertheless
works fine for me. Not sure what's going on there..

- Heikki