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 )