diff options
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/prepare.out | 7 | ||||
| -rw-r--r-- | src/test/regress/sql/prepare.sql | 4 |
2 files changed, 10 insertions, 1 deletions
diff --git a/src/test/regress/expected/prepare.out b/src/test/regress/expected/prepare.out index faf07f620bd..5815e17b39c 100644 --- a/src/test/regress/expected/prepare.out +++ b/src/test/regress/expected/prepare.out @@ -159,6 +159,9 @@ PREPARE q6 AS SELECT * FROM tenk1 WHERE unique1 = $1 AND stringu1 = $2; PREPARE q7(unknown) AS SELECT * FROM road WHERE thepath = $1; +-- DML statements +PREPARE q8 AS + UPDATE tenk1 SET stringu1 = $2 WHERE unique1 = $1; SELECT name, statement, parameter_types, result_types FROM pg_prepared_statements ORDER BY name; name | statement | parameter_types | result_types @@ -177,7 +180,9 @@ SELECT name, statement, parameter_types, result_types FROM pg_prepared_statement | SELECT * FROM tenk1 WHERE unique1 = $1 AND stringu1 = $2; | | q7 | PREPARE q7(unknown) AS +| {path} | {text,path} | SELECT * FROM road WHERE thepath = $1; | | -(5 rows) + q8 | PREPARE q8 AS +| {integer,name} | + | UPDATE tenk1 SET stringu1 = $2 WHERE unique1 = $1; | | +(6 rows) -- test DEALLOCATE ALL; DEALLOCATE ALL; diff --git a/src/test/regress/sql/prepare.sql b/src/test/regress/sql/prepare.sql index 55eef91d2af..c6098dc95ce 100644 --- a/src/test/regress/sql/prepare.sql +++ b/src/test/regress/sql/prepare.sql @@ -71,6 +71,10 @@ PREPARE q6 AS PREPARE q7(unknown) AS SELECT * FROM road WHERE thepath = $1; +-- DML statements +PREPARE q8 AS + UPDATE tenk1 SET stringu1 = $2 WHERE unique1 = $1; + SELECT name, statement, parameter_types, result_types FROM pg_prepared_statements ORDER BY name; |