insertGet return null if MySQL table contains JSON type field

[RGBvision]

insertGet('table', ['text_field' => 'text', 'json_field' => json_encode([1,2,3])], 'id') will not return 'id'

[paragonie-security]

Does your table have an id field? The JSON is likely a red herring.

[RGBvision]

Does your table have an id field? The JSON is likely a red herring.

Yep. id - INT (autoincrement) and primary key. insertGet work as expected if I change JSON data type to TEXT. But in this case I can't use benefits of JSON fields.

[paragonie-security]

Oh, interesting.

easydb/src/EasyDB.php

Lines 691 to 709 in 7976058

	// We want the latest value:
	$limiter = match ($this->dbEngine) {
	'mysql' => ' ORDER BY ' .
	$this->escapeIdentifier($field) .
	' DESC LIMIT 0, 1 ',
	'pgsql' => ' ORDER BY ' .
	$this->escapeIdentifier($field) .
	' DESC OFFSET 0 LIMIT 1 ',
	default => '',
	};
	/** @psalm-taint-escape sql */
	$query = 'SELECT ' .
	$this->escapeIdentifier($field) .
	' FROM ' .
	$this->escapeIdentifier($table) .
	' WHERE ' .
	$conditions .
	$limiter;
	return $this->single($query, $params);

This logic might be invalid for a JSON field.