BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy
Дата
Msg-id 18344-8d3f00bada6d09c6@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18344
Logged by:          Alexander Lakhin
Email address:      exclusion@gmail.com
PostgreSQL version: 16.2
Operating system:   Ubuntu 22.04
Description:

The following query:
CREATE TABLE t (b bool, i int) PARTITION BY RANGE (b, i);
CREATE TABLE tp PARTITION OF t FOR VALUES FROM (false, 0) TO (false, 1);
SELECT * FROM t WHERE b IS NOT true;

fails with ERROR:  invalid strategy number 0.

Reproduced on REL_12_STABLE .. master.
The first bad commit for this anomaly is e0693faf7.


В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18343: Incorrect description in postgresql.conf for max_parallel_workers_per_gather
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18345: Specifying index parameters for a PRIMARY KEY column constraint is a syntax error