GutoVeronezi commented on pull request #4699: URL: https://github.com/apache/cloudstack/pull/4699#issuecomment-897157261
@nvazquez as we discussed offline, the environment where I ran the tests and the environment where the tests ran in the CI are different. Mine uses: ``` mysql Ver 14.14 Distrib 5.7.35, for Linux (x86_64) using EditLine wrapper ``` Tests uses: ``` mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1 ``` I did some tests with MariaDB and found the following situation: MySQL (which I was using) doesn't requires a `from` clause with a dummy table, even if we are using a `where` clause [MySQL doc](https://dev.mysql.com/doc/refman/5.7/en/select.html). MariaDB (that the CI tests were using), although its [doc](https://mariadb.com/kb/en/dual/) says `FROM DUAL could be used...`, which would indicate that it is not mandatory, in reality requires a dummy table when we use a `where` clause. Therefore, I added the `FROM DUAL` clause to allow it to run in MariaDB. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
