BUG #15194: Strange results were displayed for select query.

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15194: Strange results were displayed for select query.
Дата
Msg-id 152626335824.27211.722540239963093540@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15194: Strange results were displayed for select query.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: BUG #15194: Strange results were displayed for select query.  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15194
Logged by:          Kenneth Lee
Email address:      leejw@k4m.com
PostgreSQL version: 9.5.5
Operating system:   Linux Redhat 6.5 [2.6.32-431.el6.x86_64]
Description:

Dear PostgreSQL Community member,

I had a strange experience. During the select query strange results were
displayed.

The contents were as follows.
--------------------------------------------------------------------------------------------------
                                                   Query
--------------------------------------------------------------------------------------------------
SELECT * 
  FROM some_table
 WHERE fld_id = 'PRE_INF'
       AND state_id = 'ERR0010001'
;
--------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------
                                                   Result
--------------------------------------------------------------------------------------------------
postgres=# select * from some_table;
 fld_id  |  state_id  | f_ver | seq | fld_dvsn_1 | fld_dvsn_2 
---------+------------+-------+-----+------------+------------
 PRE_INF | ERR0010001 |       |     |            | 
 APT_INF | ERR0010002 |       |     |            | 
(2 row)
--------------------------------------------------------------------------------------------------

The second line of the result should not appear. but strange result
displayed for select query.

However, after delete and insert the row, the results were normal.

Do you have any problems like this?

If not, what should I do?

I look forward to a good reply.

Thanks.


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

Предыдущее
От: Alexey Bashtanov
Дата:
Сообщение: Cannot create an aggregate function with variadic parameters andenabled for parallel execution
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #15194: Strange results were displayed for select query.