search

biner88 / mysql_utils

Flutter mysql_client plugin helper, Use mysql_client easily.
BSD 3-Clause "New" or "Revised" License
13 stars 2 forks source link

[Bug] #3

Closed igotfr closed 3 years ago

igotfr commented 3 years ago

table Product:

id description quantity price
1 Bean 3 4.7
2 Rice 5 15
3 Flour 15 2.5

Query

await conn.getAll(table: 'Product', fields: '*', where: {'id': ['>', 1]});

Exepected

id description quantity price
2 Rice 5 15
3 Flour 15 2.5

Getted

id description quantity price
1 Bean 3 4.7
biner88 commented 3 years ago

Yes, I'll verify it further!

biner88 commented 3 years ago

Hi,@cindRoberta This bug has been fixed, thanks for your feedback.

igotfr commented 3 years ago

@biner88 other query not running

table Product:

id description quantity price
1 Bean 3 4.7
2 Rice 5 15
3 Flour 15 2.5
4 Axe 3 18.6
5 Broom 8 7.3

Query

await conn.getAll(table: 'Product', fields: '*', where: {'id': ['between', '2,4']});

Exepected

id description quantity price
2 Rice 5 15
3 Flour 15 2.5
4 Axe 3 18.6

Getted

Internal Server Error RangeError (index): Invalid value: Not in inclusive range 0..1: 2

biner88 commented 3 years ago

This is a document error, the correct one should be

await conn.getAll(table: 'Product', fields: '*', where: {'id': ['between', 2,4]});

@cindRoberta