erleans / pgo

Erlang Postgres client and connection pool
Apache License 2.0
80 stars 16 forks source link

Test is sensitive to timezone set on Postgresql server #88

Closed chiroptical closed 4 days ago

chiroptical commented 2 months ago

I had this issue on my OSX machine which was set to timezone = 'America/New_York'

%%% pgo_datetime_SUITE ==> erl_datetime.select: FAILED
%%% pgo_datetime_SUITE ==>
Failure/Error: ?assertMatch(# { command := select , rows := [ { { { 2012 , 1 , 17 } , { 10 , 54 , 3.45 } } } ] }, pgo : query ( "select '2012-01-17 10:54:03.45'::timestamptz" ))
  expected: = # { command := select , rows := [ { { { 2012 , 1 , 17 } , { 10 , 54 , 3.45 } } } ] }
       got: #{command => select,num_rows => 1,
              rows => [{{{2012,1,17},{15,54,3.45}}}]}
      line: 87
tsloughter commented 4 days ago

Oh yea, we can close this right @chiroptical ?

chiroptical commented 4 days ago

Absolutely!