`JSqlParserQueryEnhancer` fails with `ClassCastException` during query introspection

[thmasker]

I have a repository which includes a method to call a PostgreSQL function:

public interface ARepository extends JpaRepository<A, Long> {

  @Query(value = "SELECT is_contained_in(:innerId, :outerId)", nativeQuery = true)
  boolean isContainedIn(@Param("innerId") long innerId, @Param("outerId") long outerId);

}

This compiles and works without problem. However, tests fail due to:

Caused by: java.lang.ClassCastException: class net.sf.jsqlparser.statement.select.Select cannot be cast to class net.sf.jsqlparser.statement.select.PlainSelect (net.sf.jsqlparser.statement.select.Select and net.sf.jsqlparser.statement.select.PlainSelect are in unnamed module of loader 'app')

I found out that the casting failure is produced in class JSqlParserQueryEnhancer, line 240:

for (SelectItem<?> selectItem : ((PlainSelect) selectBody).getSelectItems()) {

And I think it could be fixed by updating it to:

for (SelectItem<?> selectItem : selectBody.getPlainSelect().getSelectItems()) {

[schauder]

Are you can actually run this method and it works without a problem, but only fails in test?
If that is the case it sounds like there are different versions of JSqlParser in the test class path and the normal class path. Because, if I remember correctly the change you describe (or the opposite) became necessary after a version change in JSqlParser. Could you verify the versions of JSqlParser in testing and for normal execution?

[thmasker]

@schauder Thanks for the reply. Could you help me how to verify that? I can tell you the error occurs the same even if I explicitly establish the JSqlParser dependency:

<dependency>
    <groupId>com.github.jsqlparser</groupId>
    <artifactId>jsqlparser</artifactId>
    <version>5.1</version>
</dependency>

[schauder]

mvn dependency:tree with different scopes should do the trick: https://maven.apache.org/plugins/maven-dependency-plugin/tree-mojo.html

[thmasker]

Thanks. No difference at all (between runtime and test). Same jsqlparser version is used at all times

[schauder]

Sorry, I'm confused about what exception is thrown in which scenario. Could you please provide a reproducer? Preferable in form of a GitHub repository?

[thmasker]

Sorry, I've updated the comment. Just forget about what I wrote before, I mixed it with other problem

[schauder]

In order to understand why we get a failure in test but not in main, I'd like to see a reproducer.

[thmasker]

I'm trying to build one, it is a difficult task because I'm getting this error in a big project... trying to extract only the required parts