-
Notifications
You must be signed in to change notification settings - Fork 146
Closed
Description
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:
WARN sqlpage::webserver::database::sql] Failed to prepare "WITH nums (x) AS (SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9 UNION SELECT 10) SELECT a.x || ' times ' || b.x AS title, CASE a.x % 4 WHEN 0 THEN 'red' WHEN 1 THEN 'green' WHEN 3 THEN 'yellow' ELSE 'blue' END AS color, a.x || ' x ' || b.x || ' = ' || (a.x * b.x) AS description, 'This is basic math' AS footer, '?x=' || a.x AS link FROM nums AS a, nums AS b WHERE CAST(? AS CHAR) IS NULL OR b.x = CAST(CAST(? AS CHAR) AS DECIMAL) ORDER BY a.x, b.x": Failed to prepare SQL statement: 'WITH nums (x) AS (SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9 UNION SELECT 10) SELECT a.x || ' times ' || b.x AS title, CASE a.x % 4 WHEN 0 THEN 'red' WHEN 1 THEN 'green' WHEN 3 THEN 'yellow' ELSE 'blue' END AS color, a.x || ' x ' || b.x || ' = ' || (a.x * b.x) AS description, 'This is basic math' AS footer, '?x=' || a.x AS link FROM nums AS a, nums AS b WHERE CAST(? AS CHAR) IS NULL OR b.x = CAST(CAST(? AS CHAR) AS DECIMAL) ORDER BY a.x, b.x': error returned from database: 1054 (42S22): Unknown column 'b.x' in 'field list': 1054 (42S22): Unknown column 'b.x' in 'field list'
There appears to be a "somewhat" similar closed issue, but this had a very different message: #23
EDIT: sorry, forgot to add that this was detected on version 0.10.0 and just confirmed on 0.10.2.
Metadata
Metadata
Assignees
Labels
No labels