[jira] [Created] (EMPIREDB-250) DBDDLGenerator generates wrong SQL for Views with DBCombinedCmd

["jan (JIRA)" <em...@incubator.apache.org>]

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)