Skip to content

List Support for SQL IN Clause #434

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
wants to merge 4 commits into
base: master
Choose a base branch
from

Conversation

Sung-Heon
Copy link
Contributor

Description

This PR adds support for List encoding and resolves mapping issues when using ArrayList with SQL IN clauses.

Key Changes

Added ListEncoder Support in BinaryRowEncoder - Enables conversion of List types to MySQL length-encoded comma-separated strings
Created ListEncoder Tests - Comprehensive test suite verifying various list encoding scenarios (empty lists, single/multiple items, null filtering, etc.)
Implemented ArrayListInClause Tests - Demonstrates the issue with ArrayList in SQL IN clauses and provides two solutions:
Using correct SQL placeholders

Related Issue

#289

@Sung-Heon
Copy link
Contributor Author

@oshai can you help me with this?

Run gradle/wrapper-validation-action@e6e38bacfdf1a337459f332974bb2327a31aaf4b
  with:
    min-wrapper-count: 1
    allow-snapshots: false
  env:
    JAVA_HOME: /opt/hostedtoolcache/Java_Adopt_jdk/8.0.45[2](https://github.com/jasync-sql/jasync-sql/actions/runs/15515837938/job/43682601835#step:4:2)-9/x64

What do I have to fix?

@oshai
Copy link
Contributor

oshai commented Jun 8, 2025

@oshai can you help me with this?

Run gradle/wrapper-validation-action@e6e38bacfdf1a337459f332974bb2327a31aaf4b
  with:
    min-wrapper-count: 1
    allow-snapshots: false
  env:
    JAVA_HOME: /opt/hostedtoolcache/Java_Adopt_jdk/8.0.45[2](https://github.com/jasync-sql/jasync-sql/actions/runs/15515837938/job/43682601835#step:4:2)-9/x64

What do I have to fix?

I just rerun it, hth.

@Sung-Heon
Copy link
Contributor Author

@oshai Thx. Please review my code then.😃

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants