Regression tests on intel for 6.5.2
От | Lamar Owen |
---|---|
Тема | Regression tests on intel for 6.5.2 |
Дата | |
Msg-id | 37EF9512.C4F67DFE@wgcr.org обсуждение исходный текст |
Ответы |
Re: [HACKERS] Regression tests on intel for 6.5.2
|
Список | pgsql-hackers |
In the course of building and testing the rpm's for 6.5.2, unexpected results were found in the regression testing. I am curious as to what the results for 'float8' mean (geometry also failed, but it's obvious as to why): > *** expected/float8.out Sat Jan 23 19:12:59 1999 > --- results/float8.out Mon Sep 27 11:01:13 1999 > *************** > *** 189,201 **** > QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f; > ERROR: Bad float8 input format -- overflow > QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f; > ! ERROR: pow() result is out of range > QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ; > ERROR: can't take log of zero > QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ; > ERROR: can't take log of a negative number > QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f; > ! ERROR: exp() result is out of range > QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f; > ERROR: float8div: divide by zero error > QUERY: SELECT '' AS five, FLOAT8_TBL.*; > --- 189,217 ---- > QUERY: SELECT '' AS bad, f.f1 * '1e200' from FLOAT8_TBL f; > ERROR: Bad float8 input format -- overflow > QUERY: SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f; > ! bad|?column? > ! ---+-------- > ! |0 > ! |NaN > ! |NaN > ! |NaN > ! |NaN > ! (5 rows) > ! > QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 = '0.0' ; > ERROR: can't take log of zero > QUERY: SELECT '' AS bad, (; (f.f1)) from FLOAT8_TBL f where f.f1 < '0.0' ; > ERROR: can't take log of a negative number > QUERY: SELECT '' AS bad, : (f.f1) from FLOAT8_TBL f; > ! bad| ?column? > ! ---+-------------------- > ! | 1 > ! |7.39912306090513e-16 > ! | 0 > ! | 0 > ! | 1 > ! (5 rows) > ! > QUERY: SELECT '' AS bad, f.f1 / '0.0' from FLOAT8_TBL f; > ERROR: float8div: divide by zero error > QUERY: SELECT '' AS five, FLOAT8_TBL.*; > > ---------------------- TIA Lamar Owen WGCR Internet Radio
В списке pgsql-hackers по дате отправления: