| Subject: | ILIKE is not supported in Oracle |
I'm using CPAC against an Oracle instance, and when I tried to apply filters to varchar2 columns, I would get the popup box stating 'Failed to load records'. I traced the SQL statements and noticed that the SQL command that was running was using the 'ILIKE' statement. Oracle does not accept 'ILIKE' and was reporting an error (see - http://forums.databasejournal.com/showthread.php?40786-equivalent-of-ilike-operator). Looking at Catalyst::Plugin::AutoCRUD::Model::StorageEngine::DBIC::CRUD, if you add "Oracle => '-like'," to 'sub _likeop_for' it corrects the issue.