Description
Steps to reproduce this issue are as follows:
1. Create a table:
create table test ( id varchar primary key, ts varchar );
2. Upsert a row into the table created in the step 1:
upsert into test values ('id', '1596067200000');
3. The following query should always return the upserted row in the step 2, but sometimes it returns nothing:
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)
Attachments
Issue Links
- links to