Thank you, very helpful. Cheers, Dan On 3/21/2019 6:59 AM, Sergei Golubchik wrote:
Hi!
On Mar 18, mariadb@biblestuph.com wrote:
Is there anywhere a MariaDB specific version of the document here:
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
Or can someone just tell me which functions are affected by IGNORE_SPACE for MariaDB 10.3? I'm guessing that at least DATE_FORMAT has been added to that list at some point though it doesn't appear as such in any of the MySQL docs. (On a test version of 10.3 I'm getting a DATE_FORMAT error that I didn't have on 5.5). I can correct my spacey statements easily enough, but it would be helpful to know what functions I'm looking for.
I guess DATE_FORMAT was changed in https://jira.mariadb.org/browse/MDEV-11553
The list of functions *not* affected for 10.3 would be here: https://github.com/MariaDB/server/blob/10.3/sql/item_create.cc#L6988
And this should be a list of functions affected by IGNORE_SPACE: https://github.com/MariaDB/server/blob/10.3/sql/lex.h#L729
Regards, Sergei Chief Architect MariaDB and security@mariadb.org