rowId field does not seem to have toString()

10 views
Skip to first unread message

Manuel Rossetti

unread,
Jul 24, 2021, 8:15:16 PMJul 24
to jOOQ User Group
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.

Lukas Eder

unread,
Jul 26, 2021, 4:51:24 AMJul 26
to jOOQ User Group
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:

Thanks,
Lukas

--
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 jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/273e0daf-a254-49aa-b86c-4eb1639402e4n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages