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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: leejw(at)k4m(dot)com
Subject: BUG #15194: Strange results were displayed for select query.
Date: 2018-05-14 02:02:38
Message-ID: 152626335824.27211.722540239963093540@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15194
Logged by: Kenneth Lee
Email address: leejw(at)k4m(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2018-05-14 02:08:47 Re: BUG #15194: Strange results were displayed for select query.
Previous Message Alexey Bashtanov 2018-05-13 23:44:01 Cannot create an aggregate function with variadic parameters and enabled for parallel execution