[jira] [Updated] (PHOENIX-6340) Infinitely looping ResultSet.next()

["Istvan Toth (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-6340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Istvan Toth updated PHOENIX-6340:
---------------------------------
    Attachment: create_table.sql

> 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
>            Priority: Blocker
>         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)