search

logstash-plugins / logstash-integration-jdbc

Logstash Integration Plugin for JDBC, including Logstash Input and Filter Plugins
Apache License 2.0
53 stars 55 forks source link

SQL statement parameter casting is wrong when `IN (..)` operator is used. #162

Open az-joss opened 7 months ago

az-joss commented 7 months ago

Logstash information:

  1. Logstash version: 7.17
  2. Logstash installation source: docker (logstash 7.17.18)
  3. How is Logstash being run: docker
  4. How was the Logstash: OOTB
  5. JDBC: mariadb-java-client-3.3.3.jar

Steps to reproduce:

  1. create a pipeline with jdbc_steaming filter
  2. have prepared statement with in (1,2,3 ..) operator in where clause.
  3. define parameter(s) via prepared_statement_bind_values

Extra (if relevant)

More description in the discuss portal: https://discuss.elastic.co/t/jdbc-streaming-filter-with-sql-in-condition/354429