Error when using MySql functions to calculate columns in DBQuery

VictorUlloa, Sat Jun 05 2021, 09:45PM

I can't use a sentence using MySQL functions to calculate some column in a DBQuery.

Environment:
PHsPeed V1.3.0 B7 - x64, PHP 7.4.5

Steps to reproduce:
Just add a DBQuery and set the SQL property to

select concat('This is','a sample') as mycolumn

Then generate code and try to run the form.  The field name ignores the alias, and is set to "concat('This is".  I tried a variety of functions, like "if" or "curdate", with same results.

Workaround:
Of course I could create a VIEW with the aliased column, but is not always feasible

Re: Error when using MySql functions to calculate columns in DBQuery
administrator, Sun Jun 06 2021, 08:42AM

Reproduced and acknowledged! Progress can be followed on
https://www.phspeed.com/bt/index.php?do=details&task_id=325

The issue is fixed and you have received a link with the corrected IDE. Please verify. If ok we will deploy in the next release.
Aducom Support