Calling ResultSet's setFetchSize method gives unexpected results

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Run the attached unit test.

What is the expected output? What do you see instead?
The test should pass but ResultSet.setFetchSize() behaves like
PreparedStatement.setMaxRows(). All rows should be returned but only the
first fetchSize - 1 are.

ResultSet.setFetchSize() should probably throw an exception since AFAIK
SQLite doesn't support such a concept.

What version of the product are you using? On what operating system?
3.6.20.1. Win XP.

Please provide any additional information below.

Original issue reported on code.google.com by dus...@gmail.com on 19 Jan 2010 at 4:34

Attachments:

• FetchSizeTest.java

[GoogleCodeExporter]

Original comment by taroleo on 11 Mar 2010 at 12:12

• Changed state: Accepted
• Added labels: Milestone-sqlite-jdbc-3.6.20, OpSys-All, Version-3.6.20
• Removed labels: Milestone-xerial-core-1.1, OpSys-Windows, Version-1.0

[GoogleCodeExporter]

Thanks for the JUnit test case, I appreciate your detailed report. 

I fixed this problem, and the change will be integrated to the newer version. 
http://code.google.com/p/xerial/source/detail?
r=dfbace29e59f4647c6ed84665b08ee81e764078a&repo=sqlite

Original comment by taroleo on 11 Mar 2010 at 6:48

[GoogleCodeExporter]

Original comment by taroleo on 11 Mar 2010 at 6:48

• Changed state: Fixed

[GoogleCodeExporter]

Original comment by taroleo on 12 Mar 2010 at 9:16

• Added labels: Milestone-sqlite-jdbc-3.6.22