problems with Gist when migrating from 7.1.3 -> 7.3.x

Поиск
Список
Период
Сортировка
От Hans-Jürgen Schönig
Тема problems with Gist when migrating from 7.1.3 -> 7.3.x
Дата
Msg-id 3E5318F0.4070606@cybertec.at
обсуждение исходный текст
Ответы Re: problems with Gist when migrating from 7.1.3 -> 7.3.x
Список pgsql-general
Hallo ...

We have a problem with Gist fields when migrating from 7.1.3 to 7.3. Our
queries lead to different results. Actually data is lost somehow.

The problem occurs when running queries like that:

where (( key2img @ '{44756,44809}' or key2img && '{49582}' ) and not key2img
&& '{47343}' )

7.1.3 seems to return the correct result. 7.3 is much faster but returns
nothing.
Is it a bug? Is it a conceptual change? What went wrong? Did anybody
encount similour problems?

    Regards,

        Hans
<http://kernel.cybertec.at>


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

Предыдущее
От: Tim Stump
Дата:
Сообщение: Re: nodeRead: did not find '}' at end of plan node
Следующее
От: cnliou9@fastmail.fm (CN)
Дата:
Сообщение: Re: BLOB or BYTEA field