src/test/feature/query/sql/prepare-uniqueness.sql

SELECT name, statement, parameter_types FROM pg_prepared_statements ORDER BY 1,2,3;

PREPARE q1 AS SELECT 1 AS a;
EXECUTE q1;

PREPARE q1 AS SELECT 2;

DEALLOCATE q1;
PREPARE q1 AS SELECT 2;
EXECUTE q1;
PREPARE q2 AS SELECT 2 AS b;

SELECT name, statement, parameter_types FROM pg_prepared_statements ORDER BY 1,2,3;

DEALLOCATE PREPARE q1;
DEALLOCATE PREPARE q2;

SELECT name, statement, parameter_types FROM pg_prepared_statements ORDER BY 1,2,3;