You can translate the question and the replies:

Error on generated SQL query

Hello, I'm using Denodo Express against a MariaDB database. When I execute the view, the have a syntax error because the SQL statement is not well generated. Expected SQL : SELECT id, Order_Id, Client_Id, Product_Id, Date, Qty, amount FROM test.orders Generate SQL : SELECT t0.id, t0."Order_Id", t0."Client_Id", t0."Product_Id", t0."Date", t0."Qty", t0.amount FROM test.orders t0 It seems the double quotes are not supported by MariaDB. Thank you,
user
12-07-2018 11:37:42 -0400

2 Answers

Hi, I’d check that you have selected "MySQL 5" in the "Database adapter" instead of "Generic" as the MariaDB is based on MySQL. I hope that helps!
Denodo Team
18-07-2018 04:26:14 -0400
https://stackoverflow.com/questions/214309/do-different-databases-use-different-name-quote This can help.
user
17-05-2019 15:44:03 -0400
You must sign in to add an answer. If you do not have an account, you can register here