tree a2bfe176cdcadeb1a3a38bb8e76e08f15c2b9794
parent 8abcf84df9e1dcb94abf978589204de1ca0684da
author Dmitry Lychagin <dmitry.lychagin@couchbase.com> 1638231940 -0800
committer Dmitry Lychagin <dmitry.lychagin@couchbase.com> 1638466978 +0000

[NO ISSUE][COMP] Make LeftOuterJoin produce NULL in SQL-compat mode

- user model changes: no
- storage format changes: no
- interface changes: no

Details:
- SQL-compat mode: make Left Outer Join emit NULL instead of
  MISSING for non-matching values
- SQL-compat mode: make Left Outer Unnest emit NULL instead of
  MISSING if there are no items in the input list
- Fix comparison of AsterixConstantValue with
  IAlgebricksConstantValue which is NULL/MISSING or BOOLEAN
- Add testcases

Change-Id: Ib39bd4e704015bbd38a2bf0b8d3a54bdbd7cd7e1
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/14244
Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Reviewed-by: Ali Alsuliman <ali.al.solaiman@gmail.com>