aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/expected/float8-i386-netbsd.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/expected/float8-i386-netbsd.out')
-rw-r--r--src/test/regress/expected/float8-i386-netbsd.out232
1 files changed, 0 insertions, 232 deletions
diff --git a/src/test/regress/expected/float8-i386-netbsd.out b/src/test/regress/expected/float8-i386-netbsd.out
deleted file mode 100644
index e88538b65e7..00000000000
--- a/src/test/regress/expected/float8-i386-netbsd.out
+++ /dev/null
@@ -1,232 +0,0 @@
-QUERY: CREATE TABLE FLOAT8_TBL(f1 float8);
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('0.0');
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('1004.30');
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-34.84');
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e+200');
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('1.2345678901234e-200');
-QUERY: SELECT '' AS five, FLOAT8_TBL.*;
-five|f1
-----+--------------------
- |0
- |1004.3
- |-34.84
- |1.2345678901234e+200
- |1.2345678901234e-200
-(5 rows)
-
-QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <> '1004.3';
-four|f1
-----+--------------------
- |0
- |-34.84
- |1.2345678901234e+200
- |1.2345678901234e-200
-(4 rows)
-
-QUERY: SELECT '' AS one, f.* FROM FLOAT8_TBL f WHERE f.f1 = '1004.3';
-one| f1
----+------
- |1004.3
-(1 row)
-
-QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE '1004.3' > f.f1;
-three| f1
------+--------------------
- | 0
- | -34.84
- |1.2345678901234e-200
-(3 rows)
-
-QUERY: SELECT '' AS three, f.* FROM FLOAT8_TBL f WHERE f.f1 < '1004.3';
-three| f1
------+--------------------
- | 0
- | -34.84
- |1.2345678901234e-200
-(3 rows)
-
-QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE '1004.3' >= f.f1;
-four| f1
-----+--------------------
- | 0
- | 1004.3
- | -34.84
- |1.2345678901234e-200
-(4 rows)
-
-QUERY: SELECT '' AS four, f.* FROM FLOAT8_TBL f WHERE f.f1 <= '1004.3';
-four| f1
-----+--------------------
- | 0
- | 1004.3
- | -34.84
- |1.2345678901234e-200
-(4 rows)
-
-QUERY: SELECT '' AS three, f.f1, f.f1 * '-10' AS x
- FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
-three|f1 |x
------+--------------------+---------------------
- |1004.3 |-10043
- |1.2345678901234e+200|-1.2345678901234e+201
- |1.2345678901234e-200|-1.2345678901234e-199
-(3 rows)
-
-QUERY: SELECT '' AS three, f.f1, f.f1 + '-10' AS x
- FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
-three|f1 |x
------+--------------------+--------------------
- |1004.3 |994.3
- |1.2345678901234e+200|1.2345678901234e+200
- |1.2345678901234e-200|-10
-(3 rows)
-
-QUERY: SELECT '' AS three, f.f1, f.f1 / '-10' AS x
- FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
-three|f1 |x
------+--------------------+---------------------
- |1004.3 |-100.43
- |1.2345678901234e+200|-1.2345678901234e+199
- |1.2345678901234e-200|-1.2345678901234e-201
-(3 rows)
-
-QUERY: SELECT '' AS three, f.f1, f.f1 - '-10' AS x
- FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
-three|f1 |x
------+--------------------+--------------------
- |1004.3 |1014.3
- |1.2345678901234e+200|1.2345678901234e+200
- |1.2345678901234e-200|10
-(3 rows)
-
-QUERY: SELECT '' AS one, f.f1 ^ '2.0' AS square_f1
- FROM FLOAT8_TBL f where f.f1 = '1004.3';
-one| square_f1
----+----------
- |1008618.49
-(1 row)
-
-QUERY: SELECT '' AS five, f.f1, @f.f1 AS abs_f1
- FROM FLOAT8_TBL f;
-five|f1 |abs_f1
-----+--------------------+--------------------
- |0 |0
- |1004.3 |1004.3
- |-34.84 |34.84
- |1.2345678901234e+200|1.2345678901234e+200
- |1.2345678901234e-200|1.2345678901234e-200
-(5 rows)
-
-QUERY: SELECT '' AS five, f.f1, %f.f1 AS trunc_f1
- FROM FLOAT8_TBL f;
-five|f1 |trunc_f1
-----+--------------------+--------------------
- |0 |0
- |1004.3 |1004
- |-34.84 |-34
- |1.2345678901234e+200|1.2345678901234e+200
- |1.2345678901234e-200|0
-(5 rows)
-
-QUERY: SELECT '' AS five, f.f1, f.f1 % AS round_f1
- FROM FLOAT8_TBL f;
-five|f1 |round_f1
-----+--------------------+--------------------
- |0 |0
- |1004.3 |1004
- |-34.84 |-35
- |1.2345678901234e+200|1.2345678901234e+200
- |1.2345678901234e-200|0
-(5 rows)
-
-QUERY: SELECT '' AS three, f.f1, |/f.f1 AS sqrt_f1
- FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
-three|f1 |sqrt_f1
------+--------------------+---------------------
- |1004.3 |31.6906926399535
- |1.2345678901234e+200|1.11111110611109e+100
- |1.2345678901234e-200|1.11111110611109e-100
-(3 rows)
-
-QUERY: SELECT '' AS three, f.f1, : ( ; f.f1) AS exp_ln_f1
- FROM FLOAT8_TBL f
- WHERE f.f1 > '0.0';
-three|f1 |exp_ln_f1
------+--------------------+---------------------
- |1004.3 |1004.3
- |1.2345678901234e+200|1.23456789012338e+200
- |1.2345678901234e-200|1.23456789012339e-200
-(3 rows)
-
-QUERY: SELECT '' AS five, f.f1, ||/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f;
-five|f1 |cbrt_f1
-----+--------------------+--------------------
- |0 |0
- |1004.3 |10.014312837827
- |-34.84 |-3.26607421344208
- |1.2345678901234e+200|4.97933859234765e+66
- |1.2345678901234e-200|2.3112042409018e-67
-(5 rows)
-
-QUERY: SELECT '' AS five, FLOAT8_TBL.*;
-five|f1
-----+--------------------
- |0
- |1004.3
- |-34.84
- |1.2345678901234e+200
- |1.2345678901234e-200
-(5 rows)
-
-QUERY: UPDATE FLOAT8_TBL
- SET f1 = FLOAT8_TBL.f1 * '-1'
- WHERE FLOAT8_TBL.f1 > '0.0';
-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.*;
-five|f1
-----+---------------------
- |0
- |-34.84
- |-1004.3
- |-1.2345678901234e+200
- |-1.2345678901234e-200
-(5 rows)
-
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');
-ERROR: Input '10e400' is out of range for float8
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');
-ERROR: Input '-10e400' is out of range for float8
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('10e-400');
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e-400');
-QUERY: DELETE FROM FLOAT8_TBL;
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('0.0');
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-34.84');
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-1004.30');
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-1.2345678901234e+200');
-QUERY: INSERT INTO FLOAT8_TBL(f1) VALUES ('-1.2345678901234e-200');
-QUERY: SELECT '' AS five, FLOAT8_TBL.*;
-five|f1
-----+---------------------
- |0
- |-34.84
- |-1004.3
- |-1.2345678901234e+200
- |-1.2345678901234e-200
-(5 rows)
-
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 13:01:53 +0000