Hi Manuel, Thanks for your report. Agreed, there's no good reason to omit any of toString(), equals(), or hashCode() on that class. I'll add the implementations for jOOQ 3.16.0 and 3.15.2: https://github.com/jOOQ/jOOQ/issues/12255
Thanks, Lukas On Sun, Jul 25, 2021 at 2:15 AM Manuel Rossetti <[email protected]> wrote: > Field<RowId> rowid = myTable.rowid(); > > Condition condition = rowid.between(new SQLiteRowId(1), new > SQLiteRowId(5)); > Field<?>[] fields = myTable.fields(); > List<Field<?>> baseFields = Arrays.asList(fields); > List<Field<?>> theFields = new ArrayList<>(); > theFields.add(myTable.rowid()); > theFields.addAll(baseFields); > > Result<Record> records = > dsl.select(theFields).from(myTable).where(condition).fetch(); > System.out.println(records); > String sql = "select rowid, C1, C2, C3, c4, c5 from testFile_Data where > rowid between 1 and 5"; > Result<Record> records1 = dsl.resultQuery(sql).fetch(); > System.out.println(records1); > > > +--------------------------------+------------------+------------------+------------------+------+------------------+ > |rowid | C1| > C2| C3|c4 | c5| > > +--------------------------------+------------------+------------------+------------------+------+------------------+ > |org.jooq.impl.RowIdImpl@2d83c5a5|10.608312205708812|11.819563953229215|12.66794218385106 > |Manuel| 8.79958146171531 | > |org.jooq.impl.RowIdImpl@48d7ad8b|12.357092448543806| > 9.736640688345172|10.797461508490033|Manuel| 9.56435040519036 | > |org.jooq.impl.RowIdImpl@7e053511| 9.351088769471737| 9.738166693505423| > 9.737137720605116|Manuel|11.14597662621474 | > |org.jooq.impl.RowIdImpl@60222fd8| 9.094163074400619| 9.88912380402126 > |12.003215484119126|Manuel| 9.22592986379638 | > |org.jooq.impl.RowIdImpl@53bf7094| 9.837869522611827| > 9.200597390149854|10.085601693639953|Manuel|10.466740361406583| > > +--------------------------------+------------------+------------------+------------------+------+------------------+ > > > +-----+------------------+------------------+------------------+------+------------------+ > |rowid| C1| C2| C3|c4 > | c5| > > +-----+------------------+------------------+------------------+------+------------------+ > | 1|10.608312205708812|11.819563953229215|12.66794218385106 |Manuel| > 8.79958146171531 | > | 2|12.357092448543806| 9.736640688345172|10.797461508490033|Manuel| > 9.56435040519036 | > | 3| 9.351088769471737| 9.738166693505423| > 9.737137720605116|Manuel|11.14597662621474 | > | 4| 9.094163074400619| 9.88912380402126 |12.003215484119126|Manuel| > 9.22592986379638 | > | 5| 9.837869522611827| > 9.200597390149854|10.085601693639953|Manuel|10.466740361406583| > > +-----+------------------+------------------+------------------+------+------------------+ > > It seems to me that these two queries should produce the same text output. > > Perhaps this should be submitted as an issue. Or, I'm missing something. > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/273e0daf-a254-49aa-b86c-4eb1639402e4n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/273e0daf-a254-49aa-b86c-4eb1639402e4n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO6uJBa2QX3fVncPUPXnvh7-acOsr%2BiS%3DhgDYhrdmok-UA%40mail.gmail.com.
