search

capacitor-community / sqlite

Community plugin for native & electron SQLite databases
MIT License
426 stars 104 forks source link

Multiple Row Statement Values case insensitive #536

Closed lasher23 closed 3 weeks ago

lasher23 commented 1 month ago

Describe the bug The Multiple Row Statement only matches if "VALUES" is written in caps. The SQL is also valid if it is written in lowercase.

To Reproduce

  1. use executeSet method
  2. pass a two dimensional array as paramter to trigger multi row statement
  3. pass SQL statement with values written in lower case.

Expected behavior Behaves exactly the same as if it would be written in upper case

Desktop (please complete the following information):

jepiqueau commented 1 month ago

@lasher23 please give a full example of your statement

jepiqueau commented 3 weeks ago

@lasher23 fix in v5.7.3-2

lasher23 commented 3 weeks ago

@jepiqueau thank you for fixing this