I am executing the query similar to the following:
SELECT DB.Address, DB.City, count(*) as Count FROM "Emp"."persons" as DB
GROUP BY DB.Address, DB.City
ORDER BY DB.City
This query is executed for a table in DB2. When I ran the query I get the exception:
java.lang.AssertionError: Assertion failed.
I debugged Teiid. To do sorting, Teiid is checking if the column name to be sorted is existing in the set of columns in the query. For some reason, it is not finding the column name in the list of columns.
Below was the list of columns Teiid found in the query:
[DB.Address As Address, DB.City As City, count(*) as Count]
Teiid was looking for the column ‘anon_grp0.gcol0 AS City’. It could not find this column in the above list and it threw Assertion error.
Can you tell me why Teiid is throwing this error for DB2?
Teiid version used 7.7.0 CR1
Jboss version: 5.1.0 GA
JDK version: 1.7.0_02