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.
Re: BUG #15194: Strange results were displayed for select query. |
Список | 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 по дате отправления: