Additional spaces added to SQL Sentences that includes "greater than equal" sign or functions names.

VictorUlloa, Mon Jun 14 2021, 10:35PM

Hi,

I'm using PHsPeed 1.3.0 B9 - x64, PHP 7.4.5, standard included XAMPP server.

When I set the SQL property of a cDBQuery or a cDBSimpleQuery to a query that contains the "<=" sign, a space is introduced between the "<" and the "=".  If the query includes some function names like "trim", a space is added between the function name and the first parenthesis.

STEPS TO REPRODUCE:

Set the sql property of a cDBQuery or a cDBSimpleQuery to any of the following queries:

select if(1 <= 2,'this universe','a parallel one') as valor

select trim( 'my string' ) as hilera

Save it and then edit it again.  A space is now between "<" and "=" or between "trim" and the "(".  That leads to runtime errors.

Re: Additional spaces added to SQL Sentences that includes "greater than equal" sign or functions names.
administrator, Tue Jun 15 2021, 10:39AM

Acknowleged. Progress can be followed here