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.