Teiid 8.3 metadata getPrimaryKeys problem

[kchen007]

We have one dynamic vdb that will fail to getPrimaryKeys(vdbName, modelName, tableName) for 2 tables. The exception is :

Caused by: java.lang.IllegalArgumentException: fromKey > toKey

     at java.util.TreeMap$NavigableSubMap.<init>(TreeMap.java:1240)

     at java.util.TreeMap$AscendingSubMap.<init>(TreeMap.java:1677)

     at java.util.TreeMap.subMap(TreeMap.java:862)

     at org.teiid.dqp.internal.process.RecordTable.processQuery(RecordTable.java:189)

     at org.teiid.dqp.internal.process.SchemaChildRecordTable$1.getChildIterator(SchemaRecordTable.java:81)

     at org.teiid.dqp.internal.process.SchemaChildRecordTable$1.getChildIterator(SchemaRecordTable.java:77)

     at org.teiid.dqp.internal.process.RecordTable$ExpandingSimpleIterator.next(RecordTable.java:111)

     at org.teiid.dqp.internal.process.RecordTable$ExpandingSimpleIterator.next(RecordTable.java:107)

the fromKey value is "EZ", the toKey value is "E[". But the TreeMap is created with case insensitive string comparator, so it will compare "ez" and "e[" instead, since '[' has a lower value than 'z' in ASCII table, the TreeMap will throw the above exception.

The same vdb and code works fine with Teiid 8.1.  It is very important for us.

thanks

Kevin

[shawkins]

This was addressed with https://issues.jboss.org/browse/TEIID-2450

More than likely we'll issue a fix patch for 8.3 that includes TEIID-2450 and TEIID-2457 by the end of the week as those issues do not have workarounds.

Steve

[kchen007]

Thanks!

[kchen007]

Steven:

Please let us know if you have decided to patch 8.3 and where to download it.

thanks,

Kevin

[shawkins]

Yes a patch is still pending.

[shawkins]

A patch was posted to the downloads - http://www.jboss.org/teiid/downloads

Steve

[kchen007]

thanks, we will give it a try.