@DisableSameSelectTypesWithDifferentParamValues

Verifies that the code doesn't produce the same SELECT statements with different parameter values (see the example below).

This annotation can reveal some N+1 selects. We recommend to configure it with a global scope. You can disable the annotation at method level with EnableSameSelectTypesWithDifferentParamValues annotation.

🔎 Example

A test using the DisableSameSelectTypesWithDifferentParamValues annotation and generating the statements below will fail.

    select
        team0_.id as id1_1_0_,
        team0_.name as name2_1_0_ 
    from
        Team team0_ 
    where team0_.id=?
    
    Params:[(1)]

    select
        team0_.id as id1_1_0_,
        team0_.name as name2_1_0_ 
    from
        Team team0_ 
    where
        team0_.id=?"
    
    Params:[(2)]