[dusk]

Why does cache_get_field_contente_int fail on converted types?

Table:

Code:

CREATE TABLE IF NOT EXISTS graffiti_colours 
	(
		id INT AUTO_INCREMENT NOT NULL,
		name VARCHAR(32) NOT NULL,
		argb VARCHAR(8) NOT NULL,
		PRIMARY KEY(id)
	) ENGINE=INNODB DEFAULT CHARSET cp1257 COLLATE=cp1257_bin;

Query:

Code:

SELECT id, CONVERT(CONV(argb, 16, 10), SIGNED) AS argb FROM graffiti_colours WHERE name = '%e'

Code:

pawn Code:

cache_get_field_content_int(0, "argb");

Log:

Code:

20:47:45	cache_get_field_content_int	OK	row: 0, field_name: "argb", connection: 1
20:47:45	CMySQLResult::GetRowDataByName	OK	row: '0', field: "argb", data: "4294901760"
20:47:45	cache_get_field_content_int	ERROR	invalid datatype