Toshihiro Suzuki created PHOENIX-6130:
-----------------------------------------
Summary: StatementContext.subqueryResults should be thread safe
Key: PHOENIX-6130
URL: https://issues.apache.org/jira/browse/PHOENIX-6130
Project: Phoenix
Issue Type: Bug
Reporter: Toshihiro Suzuki
Assignee: Toshihiro Suzuki
Steps to reproduce this issue are as follows:
1. Create a table:
{code:java}
create table test (
id varchar primary key,
ts varchar
);
{code}
2. Upsert a row into the table created in the step 1:
{code:java}
upsert into test values ('id', '1596067200000');
{code}
3. The following query should always return the upserted row in the step 2, but
sometimes it returns nothing:
{code:java}
0: jdbc:phoenix:> select ts from test where ts <= (select
to_char(cast(to_number(to_date('2020-07-30 00:00:00')) as BIGINT),
'#############')) and ts >= (select to_char(cast(to_number(to_date('2020-07-29
00:00:00')) as BIGINT), '#############'));
+-----+
| TS |
+-----+
+-----+
No rows selected (0.015 seconds)
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
