tidb: Limit and Offset not work
Please answer these questions before submitting your issue. Thanks!
- What did you do? If possible, provide a recipe for reproducing the error.
using go mysql driver github.com/go-sql-driver/mysql
sql: select id from x LIMIT 10 OFFSET 5
or
sql: select id from x LIMIT 5,10
- What did you expect to see?
10 results returns
- What did you see instead?
15 results returns (But I run that command in mysql client, it works. Did I missing something?)
- What version of Go are you using (
go version
)?
go 1.7.4
About this issue
- Original URL
- State: closed
- Created 8 years ago
- Comments: 17 (12 by maintainers)
@zet4 It is a bug about limit/offset with prepare statement. I will fix it.