fetch() method returns wrong data

[tonymaa]

Observed vs. expected behavior

Using the fetch method, two pieces of data are returned

But using the .tream().toList() method, four pieces of data are returned

I looked at the mysql query log and ran it through with navicat, returning 4 pieces of data

Steps to reproduce

Environment

Querydsl version:
5.0.0
Querydsl module:

<java.version>17</java.version>
<querydsl.version>5.0.0</querydsl.version>




com.querydsl
querydsl-core
${querydsl.version}


com.querydsl
querydsl-jpa
${querydsl.version}
jakarta


com.querydsl
querydsl-sql
${querydsl.version}


com.querydsl
querydsl-sql-spring
${querydsl.version}


com.querydsl
querydsl-apt
${querydsl.version}
jakarta

Database:
5.7.23-log MySQL Community Server (GPL)
JDK:
17

Additional details