diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2022-04-02 10:00:10 -0400 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2022-04-02 10:00:10 -0400 |
| commit | c6dc6a0124fa130e1c083a870156c32ab4cf0ae2 (patch) | |
| tree | 1d2461b42459d5f340ffbf7bfe5f08ee574efa60 /src/test/regress/sql/jsonb_sqljson.sql | |
| parent | 6974924347c908335607a4a2f252213d58e21b7c (diff) | |
Use ORDER BY in catalog results in SQL/JSON tests
The buildfarm has revealed some instability in results from catalog
queries in tests from commit 1a36bc9dba8. Cure this by adding ORDER BY
to such queries.
Diffstat (limited to 'src/test/regress/sql/jsonb_sqljson.sql')
| -rw-r--r-- | src/test/regress/sql/jsonb_sqljson.sql | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/src/test/regress/sql/jsonb_sqljson.sql b/src/test/regress/sql/jsonb_sqljson.sql index 00a067a06a4..697b8ed1267 100644 --- a/src/test/regress/sql/jsonb_sqljson.sql +++ b/src/test/regress/sql/jsonb_sqljson.sql @@ -280,9 +280,13 @@ CREATE TABLE test_jsonb_constraints ( SELECT check_clause FROM information_schema.check_constraints -WHERE constraint_name LIKE 'test_jsonb_constraint%'; +WHERE constraint_name LIKE 'test_jsonb_constraint%' +ORDER BY 1; -SELECT pg_get_expr(adbin, adrelid) FROM pg_attrdef WHERE adrelid = 'test_jsonb_constraints'::regclass; +SELECT pg_get_expr(adbin, adrelid) +FROM pg_attrdef +WHERE adrelid = 'test_jsonb_constraints'::regclass +ORDER BY 1; INSERT INTO test_jsonb_constraints VALUES ('', 1); INSERT INTO test_jsonb_constraints VALUES ('1', 1); |