jan created EMPIREDB-250:
----------------------------
Summary: DBDDLGenerator generates wrong SQL for Views with
DBCombinedCmd
Key: EMPIREDB-250
URL: https://issues.apache.org/jira/browse/EMPIREDB-250
Project: Empire-DB
Issue Type: Bug
Components: Core
Affects Versions: empire-db-2.4.5
Reporter: jan
Assignee: jan
Priority: Critical
Fix For: empire-db-2.4.6
When you declare a view like
@Override
public DBCommandExpr createCommand() {
TTable1 T1 = db.T_ONE;
TTable2 T2 = db.T_TWO;
DBCommand c1 = db.createCommand();
c1.select(T1.ID);
DBCommand c2 = db.createCommand();
c2.select(T2.ID);
return t1.union(t2);
}
which results in
CREATE VIEW v1 (ID)
AS
((SELECT t3.ID
FROM TABLE1 t3)
UNION
(SELECT t4.ID
FROM TABLE2 t4));
if you run this command on MySQL (or MariaDB) you get ERROR 1064, because its
not valid.
Whyever MySQL/MariaDB does not like the double (( )). Running that statement
without creating the view works.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
