| Commit message (Collapse) | Author | Age | Files | Lines |
| |
|
|
|
|
|
|
|
| |
Conversion of NOT IN predicates into NOT IN subqueries did not work
correctly: the predicates actually were converted into IN subqueries.
As a result if the conversion was applied for the query with
a NOT IN predicate the query could return a wrong result set.
|
|
|
|
|
| |
TVC can be used in IN subquery and in PARTITION BY struct now.
Special variable to control working of optimization added.
|
| |
|
| |
|
|
TVCs can be used separately, with UNION/UNION ALL, in derived tables,
in views and in common table expressions.
Tests corrected.
Test results added.
|