diff options
Diffstat (limited to 'test')
| -rwxr-xr-x | test/it_dbi.t | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/test/it_dbi.t b/test/it_dbi.t index a257105..6214716 100755 --- a/test/it_dbi.t +++ b/test/it_dbi.t @@ -377,6 +377,8 @@ is($r->select(['-key1 IS NOT' => 'NULL']), 0, 'no entry should have a value for is($r->_where(['FROM' => 'it_dbi_test AS a, it_dbi_test AS b', '-a.ID' => 'b.ID']), 'WHERE a.ID = b.ID', "don't do JSON_EXTRACT when we have multiple tables in FROM"); is($r->_where(['JOIN' => 'it_dbi_test AS b', '-a.ID' => 'b.ID']), 'WHERE a.ID = b.ID', "don't do JSON_EXTRACT when we JOIN"); +is($r->_where(['LOWER(a)' => 'x']), "WHERE LOWER(a) = 'x'", "don't do JSON_EXTRACT when we use SQL functions"); + # # Test tracked update # |