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

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-6340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17299577#comment-17299577 ] 

ASF GitHub Bot commented on PHOENIX-6340:
-----------------------------------------

stoty closed pull request #1112:
URL: https://github.com/apache/phoenix/pull/1112


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> 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: Major
>         Attachments: create_table.sql, make_csv.py
>
>
> 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. Download and run make_csv.py
> {noformat}
> python3 make_csv.py > data.csv
> {noformat}
> 2. 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}
> 3. run *bin/phoenix_sandbox.py*
> 4. connect to sandbox with sqlline, create test table (see create_table.sql)
> 5. load the test data (data.csv) into the table
> {noformat}
> bin/psql.py -s -a ";"  -t LARGE_TABLE localhost:<sandbox_port>  /data.csv
> {noformat}
> 6. 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)