public function getSthByDomainId($domain_id) {
$this->[WITH or WITHOUT builder() HERE]->select('sth_id')
->where('sth1_sth_id', "(SELECT `aaa_bbb_id` FROM `t_abc` WHERE `aaa_id` = " . $this->db->escapeString($domain_id) .")", FALSE)
->get()
->getResult();
d($this->db->getLastQuery());
produces escaped query instead of FALSE passing as a third parameter of ->where method.
SELECT sth_idFROMt_sth_sthWHERE sth1_sth_id = '\(SELECTaaa_bbb_idFROMt_abcWHEREaaa_id \= 1\)'
Edit after a minute:
OK everything is ok when as second parameter we will pass NULL as is in docs, but anyway will be more useful if we would be able to pass field name as first parameter, subquery as second and false as third.
produces escaped query instead of FALSE passing as a third parameter of ->where method.
SELECTsth_idFROMt_sth_sthWHERE sth1_sth_id = '\(SELECTaaa_bbb_idFROMt_abcWHEREaaa_id\= 1\)'Edit after a minute:
OK everything is ok when as second parameter we will pass NULL as is in docs, but anyway will be more useful if we would be able to pass field name as first parameter, subquery as second and false as third.