tree 3ab0207016314603b6dadda6199bcc5e4f854eed
parent 4a3e99bb7b9e80558a482a23699d82716856af28
author ajantha-bhat <ajanthabhat@gmail.com> 1577104441 +0800
committer Jacky Li <jacky.likun@qq.com> 1578152312 +0800

[CARBONDATA-3630] update should support limit 1 sub query and empty result subquery

currently update has two flows, update by value and update by join.
a. update by join should be used only if subquery join present with maintable, now in non-join maintable sceneario also join is used. Fixed this.
b. currently subquery with limit 1 cannot support as it goes to join with main table, supported this
c. If subquery with limit 1 with join with main table is present, current design cannot handle it. so throwing exception
d. Supporting sub query with 0 results to update as null (behavior is same as mysql)

This closes #3528