In the class CreateViewGeneratorInformix in the generateSql method there is the statement
- String createClause = "CREATE VIEW " + viewName + " AS SELECT * FROM (" + statement.getSelectQuery() + ") AS v";
The problem is that the select query is inserted within the ". So that first the hole table is loaded to execute the view.
Can anyone confirm this? Or am I wrong?