Closed Joe1962 closed 11 months ago
Hello and thank you for the report! This looks like a problem with our default index.sql that displays the "it works" page. Which database server and version are you using?
Thanks for the quick reply! MariaDB 10.4.12 on CentOS-7.
The latest version of MariaDB works, but indeed, I get this message with old versions too. I'll see what I can do.
The problem can be reduced to the following sql statement:
WITH nums(x) AS (SELECT 1 UNION SELECT 2) SELECT a.x, b.x FROM nums a, nums b
It works in Microsoft SQL server, SQLite, Postgres, recent versions of MySQL and MariaDB, but fails in MariaDB 10.4.12.
I think I'll just remove this example from the "it works" default page.
On running sqlpage.bin it gives this 'WARN' message on the terminal. None of this is related to the index.sql or other sql files used in this instance. The site works as intended though:
There appears to be a "somewhat" similar closed issue, but this had a very different message: https://github.com/lovasoa/SQLpage/issues/23
EDIT: sorry, forgot to add that this was detected on version 0.10.0 and just confirmed on 0.10.2.