diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/psql.out | 11 | ||||
| -rw-r--r-- | src/test/regress/sql/psql.sql | 8 |
2 files changed, 18 insertions, 1 deletions
diff --git a/src/test/regress/expected/psql.out b/src/test/regress/expected/psql.out index 464436ab3b..420825aa56 100644 --- a/src/test/regress/expected/psql.out +++ b/src/test/regress/expected/psql.out @@ -2,6 +2,15 @@ -- Tests for psql features that aren't closely connected to any -- specific server features -- +-- \set +-- fail: invalid name +\set invalid/name foo +invalid variable name: "invalid/name" +-- fail: invalid value for special variable +\set AUTOCOMMIT foo +unrecognized value "foo" for "AUTOCOMMIT": boolean expected +\set FETCH_COUNT foo +invalid value "foo" for "FETCH_COUNT": integer expected -- \gset select 10 as test01, 20 as test02, 'Hello' as test03 \gset pref01_ \echo :pref01_test01 :pref01_test02 :pref01_test03 @@ -9,7 +18,7 @@ select 10 as test01, 20 as test02, 'Hello' as test03 \gset pref01_ -- should fail: bad variable name select 10 as "bad name" \gset -could not set variable "bad name" +invalid variable name: "bad name" -- multiple backslash commands in one line select 1 as x, 2 as y \gset pref01_ \\ \echo :pref01_x 1 diff --git a/src/test/regress/sql/psql.sql b/src/test/regress/sql/psql.sql index 900aa7ee1e..79624b9193 100644 --- a/src/test/regress/sql/psql.sql +++ b/src/test/regress/sql/psql.sql @@ -3,6 +3,14 @@ -- specific server features -- +-- \set + +-- fail: invalid name +\set invalid/name foo +-- fail: invalid value for special variable +\set AUTOCOMMIT foo +\set FETCH_COUNT foo + -- \gset select 10 as test01, 20 as test02, 'Hello' as test03 \gset pref01_ |