id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
296	non-recognized types of fields in a query to MySql	imendez	danirus	"TOL doesn´t recognize a ""count"" operation as a real type data.
If you compile:

Text qry =""
select count(*)
from
(
select 'hola'
) t"";
Set s = DBTable(qry);
Real r = s[1][1];
Text t = s[1][1];

You find the following error message:

Warning: (Funcion DBTable) La consulta debería devolver un texto, una fecha o un
número en el campo 1
ERROR: Tipos incompatibles en Element (ó [ ] ):  es de tipo Text, pero no de
tipo Real.
ERROR: r no se pudo crear."	defect	closed	highest		DataBase	head	critical	fixed