aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/expected/boolean.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/expected/boolean.out')
-rw-r--r--src/test/regress/expected/boolean.out379
1 files changed, 219 insertions, 160 deletions
diff --git a/src/test/regress/expected/boolean.out b/src/test/regress/expected/boolean.out
index b40f48234eb..8cf3764319c 100644
--- a/src/test/regress/expected/boolean.out
+++ b/src/test/regress/expected/boolean.out
@@ -1,220 +1,279 @@
-QUERY: SELECT 1 AS one;
-one
----
- 1
+--
+-- BOOLEAN
+--
+--
+-- sanity check - if this fails go insane!
+--
+SELECT 1 AS one;
+ one
+-----
+ 1
(1 row)
-QUERY: SELECT 't'::bool AS true;
-true
-----
-t
+-- ******************testing built-in type bool********************
+-- check bool type-casting as well as and, or, not in qualifications--
+SELECT bool 't' AS true;
+ true
+------
+ t
(1 row)
-QUERY: SELECT 'f'::bool AS false;
-false
------
-f
+SELECT bool 'f' AS false;
+ false
+-------
+ f
(1 row)
-QUERY: SELECT 't'::bool or 'f'::bool AS true;
-true
-----
-t
+SELECT bool 't' or bool 'f' AS true;
+ true
+------
+ t
(1 row)
-QUERY: SELECT 't'::bool and 'f'::bool AS false;
-false
------
-f
+SELECT bool 't' and bool 'f' AS false;
+ false
+-------
+ f
(1 row)
-QUERY: SELECT not 'f'::bool AS true;
-true
-----
-t
+SELECT not bool 'f' AS true;
+ true
+------
+ t
(1 row)
-QUERY: SELECT 't'::bool = 'f'::bool AS false;
-false
------
-f
+SELECT bool 't' = bool 'f' AS false;
+ false
+-------
+ f
(1 row)
-QUERY: SELECT 't'::bool <> 'f'::bool AS true;
-true
-----
-t
+SELECT bool 't' <> bool 'f' AS true;
+ true
+------
+ t
(1 row)
-QUERY: CREATE TABLE BOOLTBL1 (f1 bool);
-QUERY: INSERT INTO BOOLTBL1 (f1) VALUES ('t'::bool);
-QUERY: INSERT INTO BOOLTBL1 (f1) VALUES ('True'::bool);
-QUERY: INSERT INTO BOOLTBL1 (f1) VALUES ('true'::bool);
-QUERY: SELECT '' AS t_3, BOOLTBL1.*;
-t_3|f1
----+--
- |t
- |t
- |t
+CREATE TABLE BOOLTBL1 (f1 bool);
+INSERT INTO BOOLTBL1 (f1) VALUES (bool 't');
+INSERT INTO BOOLTBL1 (f1) VALUES (bool 'True');
+INSERT INTO BOOLTBL1 (f1) VALUES (bool 'true');
+-- BOOLTBL1 should be full of true's at this point
+SELECT '' AS t_3, BOOLTBL1.*;
+ t_3 | f1
+-----+----
+ | t
+ | t
+ | t
(3 rows)
-QUERY: SELECT '' AS t_3, BOOLTBL1.*
+SELECT '' AS t_3, BOOLTBL1.*
FROM BOOLTBL1
- WHERE f1 = 'true'::bool;
-t_3|f1
----+--
- |t
- |t
- |t
+ WHERE f1 = bool 'true';
+ t_3 | f1
+-----+----
+ | t
+ | t
+ | t
(3 rows)
-QUERY: SELECT '' AS t_3, BOOLTBL1.*
+SELECT '' AS t_3, BOOLTBL1.*
FROM BOOLTBL1
- WHERE f1 <> 'false'::bool;
-t_3|f1
----+--
- |t
- |t
- |t
+ WHERE f1 <> bool 'false';
+ t_3 | f1
+-----+----
+ | t
+ | t
+ | t
(3 rows)
-QUERY: SELECT '' AS zero, BOOLTBL1.*
+SELECT '' AS zero, BOOLTBL1.*
FROM BOOLTBL1
- WHERE booleq('false'::bool, f1);
-zero|f1
-----+--
+ WHERE booleq(bool 'false', f1);
+ zero | f1
+------+----
(0 rows)
-QUERY: INSERT INTO BOOLTBL1 (f1) VALUES ('f'::bool);
-QUERY: SELECT '' AS f_1, BOOLTBL1.*
+INSERT INTO BOOLTBL1 (f1) VALUES (bool 'f');
+SELECT '' AS f_1, BOOLTBL1.*
FROM BOOLTBL1
- WHERE f1 = 'false'::bool;
-f_1|f1
----+--
- |f
+ WHERE f1 = bool 'false';
+ f_1 | f1
+-----+----
+ | f
(1 row)
-QUERY: CREATE TABLE BOOLTBL2 (f1 bool);
-QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('f'::bool);
-QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('false'::bool);
-QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('False'::bool);
-QUERY: INSERT INTO BOOLTBL2 (f1) VALUES ('FALSE'::bool);
-QUERY: INSERT INTO BOOLTBL2 (f1)
- VALUES ('XXX'::bool);
+CREATE TABLE BOOLTBL2 (f1 bool);
+INSERT INTO BOOLTBL2 (f1) VALUES (bool 'f');
+INSERT INTO BOOLTBL2 (f1) VALUES (bool 'false');
+INSERT INTO BOOLTBL2 (f1) VALUES (bool 'False');
+INSERT INTO BOOLTBL2 (f1) VALUES (bool 'FALSE');
+-- This is now an invalid expression
+-- For pre-v6.3 this evaluated to false - thomas 1997-10-23
+INSERT INTO BOOLTBL2 (f1)
+ VALUES (bool 'XXX');
ERROR: Bad boolean external representation 'XXX'
-QUERY: SELECT '' AS f_4, BOOLTBL2.*;
-f_4|f1
----+--
- |f
- |f
- |f
- |f
+-- BOOLTBL2 should be full of false's at this point
+SELECT '' AS f_4, BOOLTBL2.*;
+ f_4 | f1
+-----+----
+ | f
+ | f
+ | f
+ | f
(4 rows)
-QUERY: SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.*
+SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.*
WHERE BOOLTBL2.f1 <> BOOLTBL1.f1;
-tf_12|f1|f1
------+--+--
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
+ tf_12 | f1 | f1
+-------+----+----
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
(12 rows)
-QUERY: SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.*
+SELECT '' AS tf_12, BOOLTBL1.*, BOOLTBL2.*
WHERE boolne(BOOLTBL2.f1,BOOLTBL1.f1);
-tf_12|f1|f1
------+--+--
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
+ tf_12 | f1 | f1
+-------+----+----
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
(12 rows)
-QUERY: SELECT '' AS ff_4, BOOLTBL1.*, BOOLTBL2.*
- WHERE BOOLTBL2.f1 = BOOLTBL1.f1 and BOOLTBL1.f1 = 'false'::bool;
-ff_4|f1|f1
-----+--+--
- |f |f
- |f |f
- |f |f
- |f |f
+SELECT '' AS ff_4, BOOLTBL1.*, BOOLTBL2.*
+ WHERE BOOLTBL2.f1 = BOOLTBL1.f1 and BOOLTBL1.f1 = bool 'false';
+ ff_4 | f1 | f1
+------+----+----
+ | f | f
+ | f | f
+ | f | f
+ | f | f
(4 rows)
-QUERY: SELECT '' AS tf_12_ff_4, BOOLTBL1.*, BOOLTBL2.*
- WHERE BOOLTBL2.f1 = BOOLTBL1.f1 or BOOLTBL1.f1 = 'true'::bool
+SELECT '' AS tf_12_ff_4, BOOLTBL1.*, BOOLTBL2.*
+ WHERE BOOLTBL2.f1 = BOOLTBL1.f1 or BOOLTBL1.f1 = bool 'true'
ORDER BY BOOLTBL1.f1, BOOLTBL2.f1;
-tf_12_ff_4|f1|f1
-----------+--+--
- |f |f
- |f |f
- |f |f
- |f |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
- |t |f
+ tf_12_ff_4 | f1 | f1
+------------+----+----
+ | f | f
+ | f | f
+ | f | f
+ | f | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
+ | t | f
(16 rows)
-QUERY: SELECT '' AS "True", BOOLTBL1.*
+--
+-- SQL92 syntax
+-- Try all combinations to ensure that we get nothing when we expect nothing
+-- - thomas 2000-01-04
+--
+SELECT '' AS "True", f1
FROM BOOLTBL1
WHERE f1 IS TRUE;
-True|f1
-----+--
- |t
- |t
- |t
+ True | f1
+------+----
+ | t
+ | t
+ | t
(3 rows)
-QUERY: SELECT '' AS "Not False", BOOLTBL1.*
+SELECT '' AS "Not False", f1
FROM BOOLTBL1
WHERE f1 IS NOT FALSE;
-Not False|f1
----------+--
- |t
- |t
- |t
+ Not False | f1
+-----------+----
+ | t
+ | t
+ | t
(3 rows)
-QUERY: SELECT '' AS "False", BOOLTBL1.*
+SELECT '' AS "False", f1
FROM BOOLTBL1
WHERE f1 IS FALSE;
-False|f1
------+--
- |f
+ False | f1
+-------+----
+ | f
(1 row)
-QUERY: SELECT '' AS "Not True", BOOLTBL1.*
+SELECT '' AS "Not True", f1
FROM BOOLTBL1
WHERE f1 IS NOT TRUE;
-Not True|f1
---------+--
- |f
+ Not True | f1
+----------+----
+ | f
(1 row)
-QUERY: DROP TABLE BOOLTBL1;
-QUERY: DROP TABLE BOOLTBL2;
+SELECT '' AS "True", f1
+ FROM BOOLTBL2
+ WHERE f1 IS TRUE;
+ True | f1
+------+----
+(0 rows)
+
+SELECT '' AS "Not False", f1
+ FROM BOOLTBL2
+ WHERE f1 IS NOT FALSE;
+ Not False | f1
+-----------+----
+(0 rows)
+
+SELECT '' AS "False", f1
+ FROM BOOLTBL2
+ WHERE f1 IS FALSE;
+ False | f1
+-------+----
+ | f
+ | f
+ | f
+ | f
+(4 rows)
+
+SELECT '' AS "Not True", f1
+ FROM BOOLTBL2
+ WHERE f1 IS NOT TRUE;
+ Not True | f1
+----------+----
+ | f
+ | f
+ | f
+ | f
+(4 rows)
+
+--
+-- Clean up
+-- Many tables are retained by the regression test, but these do not seem
+-- particularly useful so just get rid of them for now.
+-- - thomas 1997-11-30
+--
+DROP TABLE BOOLTBL1;
+DROP TABLE BOOLTBL2;
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 13:56:50 +0000