Re: Feedback about Drupal SQL debugging

Jean-Michel Pouré wrote:
>   
>> BTW, why don't we have a multi-argument version of CONCAT()?  In 8.4,
>> it
>> would be possible ... I should add it to mysqlcompat library.
>>     
>
> yes. In PostgreSQL core ...
>   

No.  That is exactly where it shouldn't go. And frankly, Drupal 
developers should stop writing non-portable code. Isn't there a Mysql 
mode that is supposed to conform to the standard, at least more than 
their default mode?

> PostgreSQL requires all non-aggregated fields to be present in the GROUP
> BY clause (I fixed 10 such issues in Drupal code).
> http://drupal.org/node/555530
>
> Why can't PostgreSQL add the required field automatically? Could this be
> added to PostgreSQL to-do-list?
>
>
>   

Isn't that contrary to the standard?

cheers

andrew