Istvan Toth created PHOENIX-6340:
------------------------------------
Summary: Infinitely looping ResultSet.next()
Key: PHOENIX-6340
URL: https://issues.apache.org/jira/browse/PHOENIX-6340
Project: Phoenix
Issue Type: Bug
Components: core
Affects Versions: 5.1.0
Reporter: Istvan Toth
Assignee: Istvan Toth
Attachments: create_table.sql
Under certain conditions, ResultSet.next() will loop the results indefinitely.
Unfortunately, I haven't been able to replicate this in a unit test.
Steps for manual replication:
1. Add the following to bin/hbase-site.xml, then do issue *mvn clean package*
{noformat}
<property>
<name>hbase.client.scanner.caching</name>
<value>100</value>
</property>
{noformat}
2. run *bin/phoenix_sandbox.py*
3. connect to sandbox with sqlline, create test table (see create_table.sql)
4. load the test data (data.csv) into the table
{noformat}
bin/psql.py -s -a ";" -t LARGE_TABLE localhost:<sandbox_port> /data.csv
{noformat}
5. connect to sandbox with sqlline, run the following command
{noformat}
select * from large_table where id>100 and id<200 limit 300;
{noformat}
Instead of returning 99 rows, it will return 297 rows. If you omit the limit
clause, the result will loop indefinitely.
If you switch sqlline to incremental mode (*!set incremental true*), then the
bug won't trigger, and the query will return 99 rows correctly.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
