SqlParserQueryEnhancer errors with Merge statements

[gderemetz]

Hello

similar to #2593

With spring boot >= 2.7, the application failed to start because of merge statement (oracle syntax)

class net.sf.jsqlparser.statement.merge.Merge cannot be cast to class net.sf.jsqlparser.statement.select.Select (net.sf.jsqlparser.statement.merge.Merge and net.sf.jsqlparser.statement.select.Select are in unnamed module of loader 'app')

for exemple in a JPA repository

@Modifying
@Query(value = "merge into ...", nativeQuery = true)
void mergeStatement();

detectParsedType() in JSqlParserQueryEnhancer appears to neglect the Merge statement which is supported by Jsqlparser

[gregturn]

@DiegoKrupitza Is this a scenario you're familiar with?

[DiegoKrupitza]

@DiegoKrupitza Is this a scenario you're familiar with?

I will take a look at this! I have seen that @xercasy has already proposed a PR for this (#2642).

[DiegoKrupitza]

@gregturn As realized thanks to the issue #2593 I did not implement all the possible Statements JSqlParser can handle. In #2595 I added support for INSERT. Thanks to @xercasy the PR #2642 will fix it with MERGE.

I already reviewed the PR #2642 and as far as I can see it should fix the problem.

[gregturn]

Thanks to @xercasy and @DiegoKrupitza, this additional support for native MERGE operations is now merged to main.

[gderemetz]

@gregturn Can you backport this issue and #2593 to 2.7.x ? Thanks

[gregturn]

Backported to 2.7.x.