BUG #7550: NULL result when coercing a subquery result into an array

Поиск
Список
Период
Сортировка
От tom@tomforb.es
Тема BUG #7550: NULL result when coercing a subquery result into an array
Дата
Msg-id E1TDh3W-0004tQ-F9@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7550: NULL result when coercing a subquery result into an array  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7550
Logged by:          Tom Forbes
Email address:      tom@tomforb.es
PostgreSQL version: 9.2.0
Operating system:   Windows 8
Description:        =


Hello,
I wasn't sure how to title this report so apologies if it is incorrect or
misleading.

I have two queries:
http://pgsql.privatepaste.com/7d1473defa
http://pgsql.privatepaste.com/85e1d43b7a

The first query returns NULL and the second one returns an int[] with 623
elements in it. The only difference between the two queries is the last
string - 'J. P. Bickella' returns NULL and 'J. P. Bickell' returns an
int[].

The base query with no values can be found here:
http://pgsql.privatepaste.com/1ebe2d7646
And the EXPLAIN ANALYZE VERBOSE of the queries can be found here:
http://pgsql.privatepaste.com/a4b8b622c5 <-- Returns int[]
http://pgsql.privatepaste.com/525fda6340 <-- Returns NULL

In summary: Changing the last (or second to last) element of the second IN
clause causes the query to return an array as expected, whereas setting it
to 'J. P. Bickella' causes it to return NULL.

Executing the query without wrapping it in an array() returns the expected
results.

If needed I can host the database this query is executing on for people to
download upon request, but it is 1.2gb in size.

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

Предыдущее
От: petsku@petteriraty.eu
Дата:
Сообщение: BUG #7549: max_connections check should query master when starting standby
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #7550: NULL result when coercing a subquery result into an array