diff options
Diffstat (limited to 'src/test/regress/sql/subselect.sql')
| -rw-r--r-- | src/test/regress/sql/subselect.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/src/test/regress/sql/subselect.sql b/src/test/regress/sql/subselect.sql index 0d117c878fa..3cecbc1d41b 100644 --- a/src/test/regress/sql/subselect.sql +++ b/src/test/regress/sql/subselect.sql @@ -136,7 +136,7 @@ SELECT * FROM foo WHERE id IN CREATE TABLE orderstest ( approver_ref integer, po_ref integer, - ordercancelled boolean + ordercanceled boolean ); INSERT INTO orderstest VALUES (1, 1, false); @@ -157,8 +157,8 @@ SELECT *, WHEN ord.approver_ref=1 THEN '---' ELSE 'Approved' END) AS "Approved", (SELECT CASE - WHEN ord.ordercancelled - THEN 'Cancelled' + WHEN ord.ordercanceled + THEN 'Canceled' ELSE (SELECT CASE WHEN ord.po_ref=1 @@ -172,8 +172,8 @@ SELECT *, END) END) AS "Status", (CASE - WHEN ord.ordercancelled - THEN 'Cancelled' + WHEN ord.ordercanceled + THEN 'Canceled' ELSE (CASE WHEN ord.po_ref=1 |