This is an automated email from the ASF dual-hosted git repository. mhubail pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/asterixdb.git
commit 47233309aee761eca36a9afa6a8a5c36a14afba0 Merge: 4dc60abf2e f232e2d8ec Author: Shahrzad Shirazi <[email protected]> AuthorDate: Mon Jul 7 14:19:31 2025 -0700 Merge branch 'gerrit/trinity' into 'gerrit/ionic' Ext-ref: MB-67347 Change-Id: I725e3ba6407acaccc13dfdbdb2f5eb9104286696 .../index-leftouterjoin-example.1.ddl.sqlpp | 36 ++++++++++++++++++++++ .../index-leftouterjoin-example.2.update.sqlpp | 25 +++++++++++++++ .../index-leftouterjoin-example.3.query.sqlpp | 23 ++++++++++++++ .../index-leftouterjoin-example.4.query.sqlpp | 23 ++++++++++++++ .../index-leftouterjoin-example.5.query.sqlpp | 23 ++++++++++++++ .../index-leftouterjoin-example.1.adm | 2 ++ .../index-leftouterjoin-example.2.adm | 3 ++ .../index-leftouterjoin-example.3.adm | 2 ++ .../src/test/resources/runtimets/sqlpp_queries.xml | 5 +++ ...MBTreeBatchPointSearchOperatorNodePushable.java | 5 +++ 10 files changed, 147 insertions(+) diff --cc asterixdb/asterix-app/src/test/resources/runtimets/sqlpp_queries.xml index c1cb43c2ad,42aac70424..a44bd44fdf --- a/asterixdb/asterix-app/src/test/resources/runtimets/sqlpp_queries.xml +++ b/asterixdb/asterix-app/src/test/resources/runtimets/sqlpp_queries.xml @@@ -14719,13 -14376,13 +14719,18 @@@ <output-dir compare="Text">right_branch_opt_1</output-dir> </compilation-unit> </test-case> + <test-case FilePath="leftouterjoin"> + <compilation-unit name="index-only-leftouterjoin"> + <output-dir compare="Text">index-only-leftouterjoin</output-dir> + </compilation-unit> + </test-case> </test-group> <test-group name="index-leftouterjoin"> + <test-case FilePath="index-leftouterjoin"> + <compilation-unit name="index-leftouterjoin-example"> + <output-dir compare="Text">index-leftouterjoin-example</output-dir> + </compilation-unit> + </test-case> <test-case FilePath="index-leftouterjoin"> <compilation-unit name="probe-pidx-with-join-btree-sidx1"> <output-dir compare="Text">probe-pidx-with-join-btree-sidx1</output-dir> diff --cc hyracks-fullstack/hyracks/hyracks-storage-am-lsm-btree/src/main/java/org/apache/hyracks/storage/am/lsm/btree/dataflow/LSMBTreeBatchPointSearchOperatorNodePushable.java index de4c4a91d6,d2b2c1b073..66dbcf5b89 --- a/hyracks-fullstack/hyracks/hyracks-storage-am-lsm-btree/src/main/java/org/apache/hyracks/storage/am/lsm/btree/dataflow/LSMBTreeBatchPointSearchOperatorNodePushable.java +++ b/hyracks-fullstack/hyracks/hyracks-storage-am-lsm-btree/src/main/java/org/apache/hyracks/storage/am/lsm/btree/dataflow/LSMBTreeBatchPointSearchOperatorNodePushable.java @@@ -131,7 -126,13 +131,12 @@@ public class LSMBTreeBatchPointSearchOp break; } } + + if (matchingTupleCount == 0 && retainInput && retainMissing) { + int end = accessor.getTupleCount(); + appendMissingTuple(0, end); + } stats.getInputTupleCounter().update(matchingTupleCount); - } private void appendMissingTuple(int start, int end) throws HyracksDataException {
