You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{
code: 'ER_PARSE_ERROR',
errno: 1064,
sql: '-- name: FindManyByAccountId :many\nSELECT\n account_transaction_id,\n account_id,\n point_saas_account_transaction_category_id,\n tenant_account_transaction_category_id,\n history_type,\n amount,\n expired_at,\n balance,\n title,\n content,\n created_at\nFROM\n account_transactions\nWHERE\n account_id = 1\nORDER BY\n created_at DESC\nLIMIT\n \'0\', \'20\'',
sqlState: '42000',
sqlMessage: 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'\'20\', \'0\'\' at line 21'
}
I've set both supportBigNumbers and bigNumberStrings to true, so I'm guessing those 2 options are not respected for LIMIT and OFFSET(both can be a BIGINT value).
BTW if I provide number value, it works as expected.
I have a following SQL query.
When I execute it, I get the error below.
I've set both
supportBigNumbers
andbigNumberStrings
to true, so I'm guessing those 2 options are not respected for LIMIT and OFFSET(both can be a BIGINT value).BTW if I provide number value, it works as expected.
The text was updated successfully, but these errors were encountered: