Several “Internal Error” conditions were reported using c-treeACE SQL. “Internal Errors” are reported when an inconsistency within the SQL engine is generated and further processing cannot be determined. Reported issues included the following:
A query with multiple (>2) UNIONs in the WHERE clause failed with error -20000 (SQL internal error). It caused a panic situation reported as follows:
An internal error (or panic) was seen when executing a query with a subquery containing both left and right joins.
A SQL query sometimes failed with error ‑20000 due to an unexpected situation while searching a dynamic index. The logic has been modified to correct this.
A query failed with an internal error when no N[VAR]CHAR field was involved in the query. This was due to a problem with the internal technology to handle sorting and temporary tables performing string conversions that were failing. The problem was resolved.
