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: [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
