bug: codeigniter3 db->or_where_not_in(...)

[973432436]

<?php
class Test{

    public function abc(){
        $errLinks = $this->db
                    ->where( 'article_id', 240105 )
                    ->group_start()
                        ->where_not_in( 'link_url', [ 'https://test.com/battery/' ] )
                        ->or_where_not_in( 'link_keyword', [ 'difference between test abc and lithium battery', 'difference between test cde and lithium battery' ] )
                    ->group_end()
                    ->get( 'TestDB' )->result_array();
        print_r( [ $errLinks, $this->db->last_query() ] );
    }

}
?>

[jamieburchell]

This is due to the automatic escaping. You'd need to turn it off and escape the values manually.

->or_where_not_in( 'link_keyword', [ '\'difference between test abc and lithium battery\'', '\'difference between test cde and lithium battery\'' ], FALSE )