I can actually save the view when I choose to run SQL directly even in 4.2.8.2. But open opening the view in 4.2.8.2 produces an error of "The content could not be loaded - Wrong datatype: java.lang.illegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff] in statement [SELECT * FROM "VIEW1"]
The UNION SELECT opens fine even as a view in 4.4.5, so this problem is indeed fixed in the latest release. Thanks.
I can actually save the view when I choose to run SQL directly even in 4.2.8.2. But open opening the view in 4.2.8.2 produces an error of "The content could not be loaded - Wrong datatype: java.lang. illegalArgument Exception: Timestamp format must be yyyy-mm-dd hh:mm:ss[ .fffffffff] in statement [SELECT * FROM "VIEW1"]
The UNION SELECT opens fine even as a view in 4.4.5, so this problem is indeed fixed in the latest release. Thanks.