Details
-
Bug
-
Resolution: Done
-
Major
-
8.12.3
-
None
-
- Map the rowid column as integer in your source model
- Query the rowid column
- Examine that results are compared as strings.
Description
When in SOURCE model user specifies the required rowid column as integer:
CREATE FOREIGN TABLE "SmallA" ( rowid integer OPTIONS (UPDATABLE FALSE, SEARCHABLE 'All_Except_Like'), . . .
and performs similar query:
Select rowid, StringKey From accumulo.SmallA WHERE rowid >= 15 ORDER BY rowid
following results are returned:
rowid | StringKey |
---|---|
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
6 | 6 |
7 | 7 |
8 | 8 |
9 | 9 |
15 | 15 |
... | ... |
and given the fact, that rowid is modelled as integer, values 2,3,4,5,6,7,8,9 shouldn't appear in the result set. Interesting to note is that the resultset is then ordered by rowid, but this time correctly as expected.
Other integer columns, mapped from accumulo's Column Family: Column Qualifier pairs works as expected and are being compared as corresponding types.
Attachments
Issue Links
- is caused by
-
TEIID-3942 Accumulo translators should use LexiCoders to preserve the native ordering
- Closed