Bug: insertBatch generates an incorrect SQL query if the fields differ only in number at the end

[ZlPredator]

Example:

CREATE TABLE `ip_list` (`ip` VARCHAR(100),`ip2` VARCHAR(100))

Code:

$data = [
  [ 'ip' => '1.1.1.0', 'ip2' => '1.1.1.2' ],
  [ 'ip' => '2.2.2.0', 'ip2' => '2.2.2.2' ],
  [ 'ip' => '3.3.3.0', 'ip2' => '3.3.3.2' ],
  [ 'ip' => '4.4.4.0', 'ip2' => '4.4.4.2' ]
];
$db->table('ip_list')->insertBatch($data);

Generating incorrect SQL query:

INSERT INTO `ip_list` (`ip`,`ip2`) VALUES ('1.1.1.0','4.4.4.0'), ('2.2.2.0','2.2.2.2'), ('3.3.3.0','3.3.3.2'), ('4.4.4.0','4.4.4.2')

Seems error in setBind $this->binds[$key . $count] ...

Context

• CodeIgniter: 4.0.4
• PHP: 7.2.24

[paulbalandan]

Can you try the latest release version or the latest develop branch if this is still an issue?

[paulbalandan]

Confirming this issue on latest develop.