admin/store/transaction view errors out with ?erid parameter set

Hello,

With the URL example of:
admin/store/transaction?erid=4

Errors with mysql error:

User warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INT) AND ec_receipt_allocation.type = 'transaction' LEFT JOIN ec_workflow_statu' at line 6 query: SELECT COUNT(*) FROM (SELECT ec_transaction.txnid AS txnid FROM ec_transaction ec_transaction INNER JOIN ec_customer ec_customer ON ec_transaction.ecid = ec_customer.ecid LEFT JOIN users users_ec_customer ON ec_customer.uid = users_ec_customer.uid LEFT JOIN ec_transaction_address ec_transaction_address ON ec_transaction.txnid = ec_transaction_address.txnid LEFT JOIN ec_receipt_allocation ec_receipt_allocation ON ec_transaction.txnid = CAST(ec_receipt_allocation.etid AS INT) AND ec_receipt_allocation.type = 'transaction' LEFT JOIN ec_workflow_statuses ec_workflow_statuses ON ec_transaction.workflow = ec_workflow_statuses.workflow WHERE (ec_transaction_address.type IN ('billing') OR ec_transaction_address.type IS NULL) AND (ec_receipt_allocation.erid = 4) ) count_alias in /home/httpd/dev/drupal6/sites/all/modules/views/includes/view.inc on line 729.

It appears to be a problem with the mysql CAST function.

Thanks,
Dave