Message Title

Vlad Mihalcea created an issue

Issue Type:	Improvement
Affects Versions:	5.4.7
Assignee:	Unassigned
Components:	hibernate-core
Created:	24/Oct/2019 02:02 AM
Priority:	Major
Reporter:	Vlad Mihalcea

While the hibernate.query.in_clause_parameter_padding optimization works fine for JPQL and Criteria API, if we use a multiLoad request:

 
                                                                List<Book> books = entityManager
.unwrap(Session.class)
.byMultipleIds(Book.class)
.multiLoad(
    "978-9730228236",
    "978-1934356555",
    "978-3950307825"
);
 
                                                            

Hibernate will still use 3 arguments instead of the closest upper power-of-two integer:

 
                                                                Query:["
    SELECT
        b.isbn AS isbn1_0_,
        b.author AS author2_0_,
        b.title AS title3_0_
    FROM
        book b
    WHERE
        b.isbn IN (
            ?,
            ?,
            ?
        )
 "],
Params:[(
    978-9730228236,
    978-1934356555,
    978-3950307825
)]
 
                                                            

For more details, check out this article as well.

A replicating test case is available in my High-Performance Java Persistence GitHub repository.

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira