Add collation-mismatch DILJ testing to lookup-equijoin_semantics_lib.js

    • Type: Task
    • Resolution: Unresolved
    • Priority: Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      lookup_equijoin_semantics_lib.js currently tests NLJ, HJ, INLJ (ascending/descending), hashed INLJ, and Sparse_Asc. There is no coverage for the collation-mismatch DILJ path, which is the other reason DILJ can be chosen. A new JoinAlgorithm entry (e.g. DILJ_CollationMismatch) should be added and a corresponding test file should exercise the full null/missing/array/nested-path semantics matrix against an index with an incompatible collation, matching the coverage level of lookup_equijoin_semantics_sparse.js

            Assignee:
            Unassigned
            Reporter:
            Prabhas Penumatsa
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: