AnsweredAssumed Answered

Bug in 'Table exists'step from Pentaho 8.2

Question asked by Eric Tonissen on Dec 12, 2018
Latest reply on Dec 20, 2018 by Dan Keeley

We upgraded to Pentaho 8.2.

 

We use the 'Table exists' step to DB2 and Postgress databases.

 

In version 8.1 this was case-insensitive for the DB2 database.

So it doesn't matter whether we use lower- or uppercase, for schemaname c.q. tablename.

 

In version 8.2 does is it matter.

With DB2 only if the schemaname/tablename are uppercase it results=Y, otherwise it results=N.

 

We have now an problem, because we use the same transformation to Postgress, which supports only the lowercase schema- and tablename.

 

Somebody any suggestions how to fix or work-around this ?

Outcomes