4.1.3 => 4.1.5 DB Builder adding db prefix to table alias

After updating form CI 4.1.3 to 4.1.5 the query builder is adding the database prefix ( 'tbl' ) to an aliased table ( 'Profiles p' ) in the where statement of this query.
The previous version of CI did not add the database prefix in the orLike method.

Example:

PHP Code:

$searchString = 'test'

$builder = $this->db->table('Profiles p')
        ->select('p.ProfileID, p.FName, p.LName, p.EMail, p.SecondaryEMail')
        ->groupStart()
            ->orLike('p.FName', $searchString)
            ->orLike('p.LName', $searchString)
            ->orLike('p.Email', $searchString)
            ->orLike('p.SecondaryEMail', $searchString)
        ->groupEnd()
        ->limit(10); 


This produces the SQL string of:

Code:

SELECT `p`.`ProfileID`, `p`.`FName`, `p`.`LName`, `p`.`EMail`, `p`.`SecondaryEMail`
FROM `tblProfiles` `p`
WHERE  (`tbl``p`.`FName` LIKE '%test%' ESCAPE '!'OR  `tbl``p`.`LName` LIKE '%test%' ESCAPE '!'OR  `tbl``p`.`Email` LIKE '%test%' ESCAPE '!'OR  `tbl``p`.`SecondaryEMail` LIKE '%test%' ESCAPE '!' )
LIMIT 10

Thank you for reporting.
I created an issue:
https://github.com/codeigniter4/CodeIgni...ssues/5360

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

I think am the only one having this issue. My app is broken immediately I upgraded.

---

Also in the WHERE CLAUSE

I sentt a PR: https://github.com/codeigniter4/CodeIgniter4/pull/5361

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

I sentt a PR: https://github.com/codeigniter4/CodeIgniter4/pull/5361

Hello bro any temporary fix because i have been force to remove prefix from my db before my app started working again.

Please fix system/Database/BaseConnection.php
https://github.com/codeigniter4/CodeIgni...1015-R1016

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper