Hi, for special reasons i need a very long SQL-Query concatenating about 400 tables with UNION-statements. But i got an error message: "General error;-1107 POS(494) Too complicated SQL statement (too many internal commands)"
I tried the same query for about 200 UNION-Statements and everything went fine. So, there must be an internal limit, determining whether an SQL statement is too complicated or not. Now my questions is: Are there any Configuration-Parameters(General or Extended) for MaxDB 7.5 which affect the internal limit for "too many internal commands" ??? Any suggestions are welcomed. Frank -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
