BUG #17101: Inconsistent behaviour when querying with anonymous composite types
От | PG Bug reporting form |
---|---|
Тема | BUG #17101: Inconsistent behaviour when querying with anonymous composite types |
Дата | |
Msg-id | 17101-a6faa1f74b35062d@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #17101: Inconsistent behaviour when querying with anonymous composite types
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 17101 Logged by: Andrew Kiellor Email address: akiellor@gmail.com PostgreSQL version: 13.3 Operating system: Debian (docker) Description: I've observed some inconsistent behaviour when querying with anonymous composite types. The following queries illustrate the observations: -- cleanup DROP TABLE IF EXISTS table1; DROP TYPE IF EXISTS type1; -- scenario CREATE TYPE type1 AS (x int); CREATE TABLE table1 (column1 type1); INSERT INTO table1 (column1) VALUES ('(0)'); -- passing scenario - equality with typed composite type SELECT * FROM table1 WHERE column1 = '(0)'::type1; -- failing scenario - equality with anonymous composite type SELECT * FROM table1 WHERE column1 = '(0)'; -- passing scenario - IN query with multiple anonymous composite types SELECT * FROM table1 WHERE column1 IN ('(0)', '(0)'); -- failing scenario - IN query with single anonymous composite type SELECT * FROM table1 WHERE column1 IN ('(0)');
В списке pgsql-bugs по дате отправления: