Compound index search fix by kiss034 · Pull Request #3947 · h2database/h2database

Hi,

There is an error related to my previous change (#3915). A ClassCastException happens in the IndexCondition.cloneWithIndexColumns() method, if

  1. the query contains a compound in condition, but the columns are in a wrong order according to the indexes on the table
  2. the query contains ? placeholders and the values are passed as prepared statement parameters.

This pull request introduces new tests and fixes the issue.