BUG #14969: Delta in 9.6 and 10

Поиск
Список
Период
Сортировка
От mohanpatil048@gmail.com
Тема BUG #14969: Delta in 9.6 and 10
Дата
Msg-id 20171212160921.20160.94349@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14969: Delta in 9.6 and 10  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14969
Logged by:          Mohan Patil
Email address:      mohanpatil048@gmail.com
PostgreSQL version: 10.1
Operating system:   ubuntu 14.04
Description:

When I execute the below query in 9.6 version,I get the result.

But when I execute it on 10.1, it is giving the error,

********** Error **********

ERROR: set-returning functions are not allowed in CASE
SQL state: 0A000
Hint: You might be able to move the set-returning function into a LATERAL
FROM item.

QUERY::
 SELECT t.id, t.name
FROM (SELECT ( CASE
             WHEN CARDINALITY(tier_ids) > 1 THEN UNNEST(tier_ids)
             ELSE NULL
             END ) AS tier_id
      FROM   relation
      WHERE  id = 1001) AS d
 INNER JOIN tier t ON t.id = d.tier_id ;





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

Предыдущее
От: Jan Schulz
Дата:
Сообщение: Re: BUG #14948: cost overflow
Следующее
От: Devrim Gündüz
Дата:
Сообщение: Re: BUG #14968: packagepostgresql93-server-9.3.20-3PGDG.rhel7.x86_64 fails to start