rowId field does not seem to have toString()

[Manuel Rossetti]

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]

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

--
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.