Session.Iterate with BufferSize uses the wrong sql from the second loop #1468

New Issue

hancj116 · 2019-10-24T08:27:16Z

hancj116 commented

2019-10-24 08:27:16 +00:00

// create a xom session
session.BufferSize(10).Iterate(....)

if the result is more than 10 rows, it will call session.find(...) multi times within function Iterate. But the function, find, resets the session.statement when it exits. this cause the session generates wrong sql statement from the second loop

``` // create a xom session session.BufferSize(10).Iterate(....) ``` if the result is more than 10 rows, it will call session.find(...) multi times within function Iterate. But the function, find, resets the session.statement when it exits. this cause the session generates wrong sql statement from the second loop

lunny added the

duplicate

label 2019-10-24 08:33:46 +00:00

lunny commented

2019-10-24 08:33:50 +00:00

This should be a duplicated with #939 and should be fixed by #941

lunny closed this issue

2019-11-13 11:20:18 +00:00

Sign in to join this conversation.

No Milestone

No Assignees

2 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: xorm/xorm#1468