MysqlDriver retrieved the wrong count row

linq2db / linq2db.LINQPad

linq2db.LINQPad is a driver for LINQPad.

MIT License

74 stars 23 forks source link

MysqlDriver retrieved the wrong count row #60

Closed HillCat closed 2 years ago

HillCat commented 2 years ago

actually, the truth row is 13 but LinqPad always retrieved 10-row data. in the end, I try to delete one row, It is 12 rows, but that retrieved 10 rows again. TheTestMysqlDataDemo.zip

MysqlDataBase info: Server: MySQL (127.0.0.1 via TCP/IP) Server type: MySQL Server version: 5.7.30 - MySQL Community Server (GPL) Protocol version: 10 User: root@localhost Server charset: UTF-8 Unicode (utf8)

window 10 64bit Pro 21H1

MaceWindu commented 2 years ago

Not sure how to handle it. It works fine for me in both linqpad 5 and 6, but I don't have mysql 5.7 so used v8 for test

MaceWindu commented 2 years ago

If query (on SQL tab) is correct, then I don't think this is our fault - we just display data, received from provider. If you can reproduce issue with raw ADO.NET using MySqlConnector - you should report issue there https://github.com/mysql-net/MySqlConnector/issues

MaceWindu commented 2 years ago

I will close it.

Tried provided script with mysql 5.5 and 8.0 without success. Probably there is an issue with user's database or MySqlConnector provider. We display all data we received from provider, which means query returned only 10 records for some unknown reason.