Re: ecpg test suite - Mailing list pgsql-hackers

On Fri, Aug 04, 2006 at 12:59:35PM -0400, Tom Lane wrote:
> *** expected/complex-test4.stdout    Wed Aug  2 10:14:02 2006
> --- results//complex-test4.stdout    Fri Aug  4 12:56:13 2006
> ***************
> *** 1,4 ****
> ! Found f=14,070000 text=0123456789 b=1
>   Found a[0] = 9
>   Found a[1] = 8
>   Found a[2] = 7
> --- 1,4 ----
> ! Found f=14.070000 text=0123456789 b=1
>   Found a[0] = 9
>   Found a[1] = 8
>   Found a[2] = 7

Locale problem. Fixed by setting locale to C.

> *** expected/pgtypeslib-dt_test.stderr    Thu Aug  3 09:24:58 2006
> --- results//pgtypeslib-dt_test.stderr    Fri Aug  4 12:56:14 2006
> ***************
> *** 22,28 ****
>   [NO_PID]: sqlca: code: 0, state: 00000
>   [NO_PID]: ECPGget_data line 37: RESULT: 2000-07-12 17:34:29 offset: 8 array: Yes
>   [NO_PID]: sqlca: code: 0, state: 00000
> ! [NO_PID]: ECPGget_data line 37: RESULT: 13556 days 12:34:00 offset: 12 array: Yes
>   [NO_PID]: sqlca: code: 0, state: 00000
>   [NO_PID]: ECPGtrans line 354 action = rollback connection = regress1
>   [NO_PID]: sqlca: code: 0, state: 00000
> --- 22,28 ----

Some types have different internal sizes on different systems. I wonder
what we do with these difference as a log file usually prints this info
which is important for debugging sometimes.

> *** expected/pgtypeslib-dt_test.stdout    Wed Aug  2 10:14:03 2006
> --- results//pgtypeslib-dt_test.stdout    Fri Aug  4 12:56:14 2006
> ***************
> *** 41,47 ****
>      18 October %34 17:28:44 CEST 80, abc%n %C %B %%%d %H:%M:%S %Z %y) = 1880-10-31 15:28:44, error (should be
error!):1
 
>   timestamp_defmt_asc(abc
>      18 October %34 17:28:44 CEST 80, ) = 1880-10-31 15:28:44, error (should be error!): 1
> ! timestamp_defmt_asc(1980-04-12 3:49:44      , (null)) = 1980-04-12 03:49:44, error: 0
>   timestamp_defmt_asc(July 14, 1988. Time: 9:15am, %B %d, %Y. Time: %I:%M%p) = 1988-07-14 09:15:00, error: 0
>   timestamp_defmt_asc(September 6 at 01:30 pm in the year 1983, %B %d at %I:%M %p in the year %Y) = 1983-09-06
13:30:00,error: 0
 
>   timestamp_defmt_asc(  1976, July 14. Time: 9:15am, %Y,   %B %d. Time: %I:%M %p) = 1976-07-14 09:15:00, error: 0
> --- 41,47 ----
>      18 October %34 17:28:44 CEST 80, abc%n %C %B %%%d %H:%M:%S %Z %y) = 1880-10-31 15:28:44, error (should be
error!):1
 
>   timestamp_defmt_asc(abc
>      18 October %34 17:28:44 CEST 80, ) = 1880-10-31 15:28:44, error (should be error!): 1
> ! timestamp_defmt_asc(1980-04-12 3:49:44      , ) = 1980-04-12 03:49:44, error: 0
>   timestamp_defmt_asc(July 14, 1988. Time: 9:15am, %B %d, %Y. Time: %I:%M%p) = 1988-07-14 09:15:00, error: 0
>   timestamp_defmt_asc(September 6 at 01:30 pm in the year 1983, %B %d at %I:%M %p in the year %Y) = 1983-09-06
13:30:00,error: 0
 
>   timestamp_defmt_asc(  1976, July 14. Time: 9:15am, %Y,   %B %d. Time: %I:%M %p) = 1976-07-14 09:15:00, error: 0

Different compiler gets different output for NULL value. Fixed.

Michael

-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!