Hi!
Please find the attached database. Doing a simple query with casting
SELECT COUNT(DISTINCT $1) FROM com.quasado.foundation.contact.individual.IndividualContact $1 WHERE UPPER(((com.quasado.foundation.warehouse.api.model.account.contact.IndividualContactDebitorAccountFragment) $1.qubletFRAGMENTMAP.get('com.quasado.foundation.warehouse.api.model.account.contact.IndividualContactDebitorAccountFragment')).debitorAccount.bankAccounts.routingNumber) LIKE UPPER('%28%')
results in the error
Query Execution Error ===================== Unexpected query token 'com.quasado.foundation.warehouse.api.model.account.contact.IndividualContactDebitorAccountFragment': Identifier is expected SELECT COUNT(DISTINCT $1) FROM com.quasado.foundation.contact.individual.IndividualContact $1 WHERE UPPER(( ==> (com.quasado.foundation.warehouse.api.model.account.contact.IndividualContactDebitorAccountFragment) <== $1.qubletFRAGMENTMAP.get('com.quasado.foundation.warehouse.api.model.account.contact.IndividualContactDebitorAccountFragment')).debitorAccount.bankAccounts.routingNumber) LIKE UPPER('%28%')
.. I'd be so happy to get this stuff finally running :)
Note: Removing the UPPER on both sides stills results in the same error so it's not because of the upper like I've again initially thought ;)
thanks!!
Alex