AndroidCompiledStatement appends duplicate LIMIT

[andrew-bowley]

The error is in com.j256.ormlite.android.AndroidCompiledStatement method getCursor(). An example error report:

Problems executing Android query: SELECT * FROM categories WHERE node_id = ? LIMIT 1 LIMIT 1

The error occurs when setMaxRows() has set the max field to non-null. A subsequent getCursor() call appends a LIMIT statement regardless of whether one is already appended to the original statement passed in the constructor.

One simple fix would be to ignore the max field when a limit is already appended to the statement.

[SSvistunov]

Confirm this bug in version 5.0, need to check previous limit statement before adding new in sql string.

[j256]

Can someone generate a unit test for me to show how the code fails?