id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
364	SQL returned type is not readable	Víctor de Buen Remiro	Jorge	"Hello,

When you run this TOL code with SQL embebed code

Matrix DBMatrix(""
  select 
    case 
       when 'any thing' is null                             then 0
       when locate('another thing', 'any thing')=0 then 0
                                                                     else 1
    end
"");

a 0x0 matrix is created and a TOL warning is sended to the user

Warning: [1] (Funcion DBMatrix) La consulta debería devolver un Real en el campo 
1

My DB server is MySQL. Using MySql Browser with the query 

  select 
    case 
       when 'any thing' is null                             then 0
       when locate('another thing', 'any thing')=0 then 0
                                                                     else 1
    end

I obtain a data set with just one row and one field containing the number 0.

Thanks"	defect	closed	highest		DataBase	head	blocker	fixed