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.
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 |