diff options
Diffstat (limited to 'src/test/regress/sql')
| -rw-r--r-- | src/test/regress/sql/alter_generic.sql | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/json.sql | 18 | ||||
| -rw-r--r-- | src/test/regress/sql/plpgsql.sql | 5 | ||||
| -rw-r--r-- | src/test/regress/sql/select_views.sql | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/uuid.sql | 4 |
5 files changed, 15 insertions, 16 deletions
diff --git a/src/test/regress/sql/alter_generic.sql b/src/test/regress/sql/alter_generic.sql index d62f64fb4be..f46cbc828a6 100644 --- a/src/test/regress/sql/alter_generic.sql +++ b/src/test/regress/sql/alter_generic.sql @@ -382,7 +382,7 @@ ALTER OPERATOR FAMILY alt_opf15 USING hash ADD FUNCTION 1 fn_opf15(int4, int2); DROP OPERATOR FAMILY alt_opf15 USING hash; ROLLBACK; --- Should fail. In gist throw an error when giving different data types for function argument +-- Should fail. In gist throw an error when giving different data types for function argument -- without defining left / right type in ALTER OPERATOR FAMILY ... ADD FUNCTION CREATE OPERATOR FAMILY alt_opf16 USING gist; ALTER OPERATOR FAMILY alt_opf16 USING gist ADD FUNCTION 1 btint42cmp(int4, int2); diff --git a/src/test/regress/sql/json.sql b/src/test/regress/sql/json.sql index ff7675fad0d..cd7782c3b03 100644 --- a/src/test/regress/sql/json.sql +++ b/src/test/regress/sql/json.sql @@ -313,15 +313,15 @@ select json '{ "a": "null \u0000 escape" }' ->> 'a' as not_unescaped; --json_typeof() function select value, json_typeof(value) - from (values (json '123.4'), - (json '-1'), - (json '"foo"'), - (json 'true'), - (json 'false'), + from (values (json '123.4'), + (json '-1'), + (json '"foo"'), + (json 'true'), + (json 'false'), (json 'null'), - (json '[1, 2, 3]'), - (json '[]'), - (json '{"x":"foo", "y":123}'), - (json '{}'), + (json '[1, 2, 3]'), + (json '[]'), + (json '{"x":"foo", "y":123}'), + (json '{}'), (NULL::json)) as data(value); diff --git a/src/test/regress/sql/plpgsql.sql b/src/test/regress/sql/plpgsql.sql index 068b072c901..a685fa246e3 100644 --- a/src/test/regress/sql/plpgsql.sql +++ b/src/test/regress/sql/plpgsql.sql @@ -2215,7 +2215,7 @@ create function excpt_test2() returns void as $$ begin begin begin - raise notice '% %', sqlstate, sqlerrm; + raise notice '% %', sqlstate, sqlerrm; end; end; end; $$ language plpgsql; @@ -2225,7 +2225,7 @@ select excpt_test2(); create function excpt_test3() returns void as $$ begin begin - raise exception 'user exception'; + raise exception 'user exception'; exception when others then raise notice 'caught exception % %', sqlstate, sqlerrm; begin @@ -4084,4 +4084,3 @@ select outer_outer_func(20); drop function outer_outer_func(int); drop function outer_func(int); drop function inner_func(int); - diff --git a/src/test/regress/sql/select_views.sql b/src/test/regress/sql/select_views.sql index e37fb7b3880..da356237eba 100644 --- a/src/test/regress/sql/select_views.sql +++ b/src/test/regress/sql/select_views.sql @@ -47,7 +47,7 @@ INSERT INTO credit_card (103, '9801-2345-6789-0123', 2000); INSERT INTO credit_usage VALUES (101, '2011-09-15', 120), - (101, '2011-10-05', 90), + (101, '2011-10-05', 90), (101, '2011-10-18', 110), (101, '2011-10-21', 200), (101, '2011-11-10', 80), diff --git a/src/test/regress/sql/uuid.sql b/src/test/regress/sql/uuid.sql index 48fe7e71108..518d2b75c00 100644 --- a/src/test/regress/sql/uuid.sql +++ b/src/test/regress/sql/uuid.sql @@ -2,12 +2,12 @@ -- creating test tables CREATE TABLE guid1 ( - guid_field UUID, + guid_field UUID, text_field TEXT DEFAULT(now()) ); CREATE TABLE guid2 ( - guid_field UUID, + guid_field UUID, text_field TEXT DEFAULT(now()) ); |