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
The following commit(s) were added to refs/heads/master by this push:
new 2dfa8d78f7 [NO ISSUE][COMP] Updateing the Index-only plan
configuration parameter.
2dfa8d78f7 is described below
commit 2dfa8d78f7e9392672b94f9be4e00b23be46f4b0
Author: Shahrzad Shirazi <[email protected]>
AuthorDate: Wed Oct 8 11:40:05 2025 -0700
[NO ISSUE][COMP] Updateing the Index-only plan configuration parameter.
Changing the Index-only plan configuration parameter from
"compiler.indexonly" to "compiler.index.covering".
Change-Id: Ib9703e1cc9c49d0624c9a0b27bec7030b53ac06c
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/20472
Tested-by: Jenkins <[email protected]>
Integration-Tests: Jenkins <[email protected]>
Reviewed-by: Murtadha Hubail <[email protected]>
---
...eftouterjoin-probe-pidx-with-join-btree-sidx_03-index-only.sqlpp | 2 +-
.../leftouterjoin-probe-pidx-with-join-btree-sidx_03.sqlpp | 2 +-
.../queries/btree-index/btree-sidx-idxonly-01-disable-idxonly.sqlpp | 4 ++--
.../btree-index/btree-sidx-idxonly-01-disable-idxonly_ps.sqlpp | 4 ++--
.../queries/rtree-index/rtree-sidx-idxonly-01-disable-idxonly.sqlpp | 4 ++--
.../probe-pidx-with-join-btree-sidx1.4.query.sqlpp | 2 +-
.../probe-pidx-with-join-btree-sidx1.5.query.sqlpp | 2 +-
.../heterogeneous-index-Leftouterjoin.3.query.sqlpp | 2 +-
.../heterogeneous-index-Leftouterjoin.4.query.sqlpp | 2 +-
.../index-only-leftouterjoin.003.query.sqlpp | 2 +-
.../index-only-leftouterjoin.004.query.sqlpp | 2 +-
.../index-only-leftouterjoin.005.query.sqlpp | 2 +-
.../index-only-leftouterjoin.006.query.sqlpp | 2 +-
.../index-only-leftouterjoin.007.query.sqlpp | 2 +-
.../index-only-leftouterjoin.008.query.sqlpp | 2 +-
.../index-only-leftouterjoin.009.query.sqlpp | 2 +-
.../index-only-leftouterjoin.010.query.sqlpp | 2 +-
.../index-only-leftouterjoin.011.query.sqlpp | 2 +-
.../metrics/secondary-index/secondary-index.3.metrics.sqlpp | 2 +-
.../results/api/cluster_state_1/cluster_state_1.1.regexadm | 2 +-
.../api/cluster_state_1_full/cluster_state_1_full.1.regexadm | 2 +-
.../api/cluster_state_1_less/cluster_state_1_less.1.regexadm | 2 +-
.../probe-pidx-with-join-btree-sidx1.4.ast | 2 +-
.../probe-pidx-with-join-btree-sidx1.5.ast | 2 +-
.../java/org/apache/asterix/common/config/CompilerProperties.java | 6 +++---
.../asterix-doc/src/main/markdown/sqlpp/appendix_2_index_only.md | 4 ++--
26 files changed, 32 insertions(+), 32 deletions(-)
diff --git
a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_03-index-only.sqlpp
b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_03-index-only.sqlpp
index bae0d738fe..5bc5af2fc4 100644
---
a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_03-index-only.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_03-index-only.sqlpp
@@ -61,7 +61,7 @@ create index msgCountBIx on TweetMessages (countB) type
btree include unknown
create index msgTextIx on TweetMessages (`message-text`) type keyword;
-set `compiler.indexonly` "true";
+SET `compiler.index.covering` 'true';
select t1.tweetid as tweetid1, t1.countA as count1, t2.tweetid as tweetid2,
t2.countB as count2
from TweetMessages as t1 left outer join TweetMessages as t2 on t1.countA /*+
indexnl */ = t2.countB
diff --git
a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_03.sqlpp
b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_03.sqlpp
index 6e972e6647..ee13edc277 100644
---
a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_03.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index-join/leftouterjoin-probe-pidx-with-join-btree-sidx_03.sqlpp
@@ -61,7 +61,7 @@ create index msgCountBIx on TweetMessages (countB) type
btree;
create index msgTextIx on TweetMessages (`message-text`) type keyword;
-set `compiler.indexonly` "false";
+SET `compiler.index.covering` "false";
select t1.tweetid as tweetid1, t1.countA as count1, t2.tweetid as tweetid2,
t2.countB as count2
from TweetMessages as t1 left outer join TweetMessages as t2 on t1.countA /*+
indexnl */ = t2.countB
diff --git
a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index/btree-sidx-idxonly-01-disable-idxonly.sqlpp
b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index/btree-sidx-idxonly-01-disable-idxonly.sqlpp
index d45a7eb1cb..2108881115 100644
---
a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index/btree-sidx-idxonly-01-disable-idxonly.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index/btree-sidx-idxonly-01-disable-idxonly.sqlpp
@@ -26,7 +26,7 @@
* ... -> unnest-map (sidx) -> split -> unnest-map (pidx)
-> select -> union -> ...
* : The right path:
* ... -> unnest-map (sidx) -> split ->
-> union -> ...
- * : However, we set the `compiler.indexonly` option to
false. So, the index-only plan should not be triggered.
+ * : However, we set the `compiler.index.covering` option to
false. So, the index-only plan should not be triggered.
* Expected Result : Success
*
*/
@@ -59,7 +59,7 @@ create index rtree_index_rec on MyData(rec) type rtree;
create index ngram_index_title on MyData(title) type ngram(3);
create index keyword_index_title on MyData(title) type keyword;
-set `compiler.indexonly` "false";
+SET `compiler.index.covering` "false";
select element {"pk":o.id, "sk":o.docid}
from MyData o
diff --git
a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index/btree-sidx-idxonly-01-disable-idxonly_ps.sqlpp
b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index/btree-sidx-idxonly-01-disable-idxonly_ps.sqlpp
index f7644cbad3..dbbbc2ecdc 100644
---
a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index/btree-sidx-idxonly-01-disable-idxonly_ps.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/btree-index/btree-sidx-idxonly-01-disable-idxonly_ps.sqlpp
@@ -26,7 +26,7 @@
* ... -> unnest-map (sidx) -> split -> unnest-map (pidx)
-> select -> union -> ...
* : The right path:
* ... -> unnest-map (sidx) -> split ->
-> union -> ...
- * : However, we set the `compiler.indexonly` option to
false. So, the index-only plan should not be triggered.
+ * : However, we set the `compiler.index.covering` option to
false. So, the index-only plan should not be triggered.
* Expected Result : Success
*
*/
@@ -59,7 +59,7 @@ create index rtree_index_rec on MyData(rec) type rtree;
create index ngram_index_title on MyData(title) type ngram(3);
create index keyword_index_title on MyData(title) type keyword;
-set `compiler.indexonly` "false";
+SET `compiler.index.covering` "false";
set `compiler.sort.parallel` "true";
select element {"pk":o.id, "sk":o.docid}
diff --git
a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/rtree-index/rtree-sidx-idxonly-01-disable-idxonly.sqlpp
b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/rtree-index/rtree-sidx-idxonly-01-disable-idxonly.sqlpp
index 878ac9c1a0..0b674d91c9 100644
---
a/asterixdb/asterix-app/src/test/resources/optimizerts/queries/rtree-index/rtree-sidx-idxonly-01-disable-idxonly.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/optimizerts/queries/rtree-index/rtree-sidx-idxonly-01-disable-idxonly.sqlpp
@@ -26,7 +26,7 @@
* ... -> unnest-map (sidx) -> split -> unnest-map (pidx)
-> select -> union -> ...
* : The right path:
* ... -> unnest-map (sidx) -> split ->
union -> ...
- * : However, we set the `compiler.indexonly` option to
false. So, the index-only plan should not be triggered.
+ * : However, we set the `compiler.index.covering` option to
false. So, the index-only plan should not be triggered.
* Expected Result : Success
*
*/
@@ -105,7 +105,7 @@ create index rtree_index_rec on MyData(rec) type rtree;
create index ngram_index_title on MyData(title) type ngram(3);
create index keyword_index_title on MyData(title) type keyword;
-set `compiler.indexonly` "false";
+SET `compiler.index.covering` "false";
select count(*) from (
select x.location
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.4.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.4.query.sqlpp
index 0a84a67923..7508b23742 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.4.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.4.query.sqlpp
@@ -24,7 +24,7 @@
use test;
-set `compiler.indexonly` "false";
+SET `compiler.index.covering` "false";
select t1.tweetid as tweetid1, t1.countA as count1, t2.tweetid as tweetid2,
t2.countB as count2
from TweetMessages as t1 left outer join TweetMessages as t2 on t1.countA /*+
indexnl */ = t2.countB
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.5.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.5.query.sqlpp
index a312fe1cf2..a5ff2cfe1a 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.5.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.5.query.sqlpp
@@ -24,7 +24,7 @@
use test;
-set `compiler.indexonly` "false";
+SET `compiler.index.covering` "false";
select t1.tweetid as tweetid1, t1.countA as count1, t2.tweetid as tweetid2,
t2.countB as count2
from TweetMessages as t1 left outer join TweetMessages as t2 on t1.countA /*+
indexnl */ = t2.countB
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-selection/heterogeneous-index-Leftouterjoin/heterogeneous-index-Leftouterjoin.3.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-selection/heterogeneous-index-Leftouterjoin/heterogeneous-index-Leftouterjoin.3.query.sqlpp
index 25d7c9d10e..c82c96e67b 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-selection/heterogeneous-index-Leftouterjoin/heterogeneous-index-Leftouterjoin.3.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-selection/heterogeneous-index-Leftouterjoin/heterogeneous-index-Leftouterjoin.3.query.sqlpp
@@ -20,6 +20,6 @@
USE test;
SET `compiler.sort.parallel` 'false';
-SET `compiler.indexonly` 'true';
+SET `compiler.index.covering` 'true';
SELECT t1.id AS t1_id, t2.id AS t2_id
FROM ds_outer_untyped t1 LEFT JOIN ds_inner_typed t2 ON int32(t1.c_int32) /*
+indexnl */ = (t2.c_int32) ;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-selection/heterogeneous-index-Leftouterjoin/heterogeneous-index-Leftouterjoin.4.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-selection/heterogeneous-index-Leftouterjoin/heterogeneous-index-Leftouterjoin.4.query.sqlpp
index 065273cadd..edf6efb765 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-selection/heterogeneous-index-Leftouterjoin/heterogeneous-index-Leftouterjoin.4.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/index-selection/heterogeneous-index-Leftouterjoin/heterogeneous-index-Leftouterjoin.4.query.sqlpp
@@ -20,6 +20,6 @@
USE test;
SET `compiler.sort.parallel` 'false';
-SET `compiler.indexonly` 'false';
+SET `compiler.index.covering` 'false';
SELECT t1.id AS t1_id, t2.id AS t2_id
FROM ds_outer_untyped t1 LEFT JOIN ds_inner_typed t2 ON int32(t1.c_int32) /*
+indexnl */ = (t2.c_int32);
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.003.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.003.query.sqlpp
index 27a4019b87..3aef0d9f33 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.003.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.003.query.sqlpp
@@ -20,6 +20,6 @@
USE test;
SET `compiler.sort.parallel` 'false';
-SET `compiler.indexonly` 'true';
+SET `compiler.index.covering` 'true';
SELECT t1.id AS t1_id, t2.id AS t2_id
FROM ds_outer_untyped t1 LEFT JOIN ds_inner_untyped t2 ON int32(t1.c_int32) /*
+indexnl */ =(t2.c_int32) ORDER BY t1_id, t2_id;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.004.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.004.query.sqlpp
index 6bff38deb0..790784aeac 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.004.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.004.query.sqlpp
@@ -20,6 +20,6 @@
USE test;
SET `compiler.sort.parallel` 'false';
-SET `compiler.indexonly` 'true';
+SET `compiler.index.covering` 'true';
SELECT t1.id AS t1_id, t2.id AS t2_id
FROM ds_outer_untyped t1 LEFT JOIN ds_inner_typed t2 ON int32(t1.c_int32) /*
+indexnl */ = (t2.c_int32) ORDER BY t1_id, t2_id;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.005.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.005.query.sqlpp
index 1ac4c6b1f7..eb4aea6a8b 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.005.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.005.query.sqlpp
@@ -20,6 +20,6 @@
USE test;
SET `compiler.sort.parallel` 'false';
-SET `compiler.indexonly` 'true';
+SET `compiler.index.covering` 'true';
SELECT t1.id AS t1_id, t2.id AS t2_id
FROM ds_outer_typed t1 LEFT JOIN ds_inner_untyped t2 ON int32(t1.c_int32) /*
+indexnl */ =(t2.c_int32) ORDER BY t1_id, t2_id;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.006.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.006.query.sqlpp
index 6e0740fa67..bebd87560a 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.006.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.006.query.sqlpp
@@ -20,6 +20,6 @@
USE test;
SET `compiler.sort.parallel` 'false';
-SET `compiler.indexonly` 'true';
+SET `compiler.index.covering` 'true';
SELECT t1.id AS t1_id, t2.id AS t2_id
FROM ds_outer_typed t1 LEFT JOIN ds_inner_typed t2 ON int32(t1.c_int32) /*
+indexnl */ = (t2.c_int32) ORDER BY t1_id, t2_id;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.007.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.007.query.sqlpp
index b78ca994df..9e5d42bbe1 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.007.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.007.query.sqlpp
@@ -20,6 +20,6 @@
USE test;
SET `compiler.sort.parallel` 'false';
-SET `compiler.indexonly` 'true';
+SET `compiler.index.covering` 'true';
EXPLAIN SELECT t1.id AS t1_id, t2.id AS t2_id
FROM ds_outer_untyped t1 LEFT JOIN ds_inner_untyped t2 ON int32(t1.c_int32) /*
+indexnl */ = (t2.c_int32) ORDER BY t1_id, t2_id;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.008.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.008.query.sqlpp
index 9ca5ca6502..94b7de577b 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.008.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.008.query.sqlpp
@@ -20,6 +20,6 @@
USE test;
SET `compiler.sort.parallel` 'false';
-SET `compiler.indexonly` 'true';
+SET `compiler.index.covering` 'true';
EXPLAIN SELECT t1.id AS t1_id, t2.id AS t2_id
FROM ds_outer_untyped t1 LEFT JOIN ds_inner_typed t2 ON int32(t1.c_int32) /*
+indexnl */ = (t2.c_int32) ORDER BY t1_id, t2_id;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.009.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.009.query.sqlpp
index c3fefcb3ce..87e7acd75c 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.009.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.009.query.sqlpp
@@ -20,6 +20,6 @@
USE test;
SET `compiler.sort.parallel` 'false';
-SET `compiler.indexonly` 'true';
+SET `compiler.index.covering` 'true';
EXPLAIN SELECT t1.id AS t1_id, t2.id AS t2_id
FROM ds_outer_typed t1 LEFT JOIN ds_inner_untyped t2 ON int32(t1.c_int32) /*
+indexnl */ = (t2.c_int32) ORDER BY t1_id, t2_id;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.010.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.010.query.sqlpp
index 0c793929ca..46267776f3 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.010.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.010.query.sqlpp
@@ -20,6 +20,6 @@
USE test;
SET `compiler.sort.parallel` 'false';
-SET `compiler.indexonly` 'true';
+SET `compiler.index.covering` 'true';
EXPLAIN SELECT t1.id AS t1_id, t2.id AS t2_id
FROM ds_outer_typed t1 LEFT JOIN ds_inner_typed t2 ON int32(t1.c_int32) /*
+indexnl */ = (t2.c_int32) ORDER BY t1_id, t2_id;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.011.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.011.query.sqlpp
index c66ae86c58..9424685103 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.011.query.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/leftouterjoin/index-only-leftouterjoin/index-only-leftouterjoin.011.query.sqlpp
@@ -20,6 +20,6 @@
USE test;
SET `compiler.sort.parallel` 'false';
-SET `compiler.indexonly` 'false';
+SET `compiler.index.covering` 'false';
SELECT t1.id AS t1_id, t2.id AS t2_id
FROM ds_outer_untyped t1 LEFT JOIN ds_inner_untyped t2 ON int32(t1.c_int32) =
(t2.c_int32) ORDER BY t1_id, t2_id;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/metrics/secondary-index/secondary-index.3.metrics.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/metrics/secondary-index/secondary-index.3.metrics.sqlpp
index 49e3df2321..8f951d2daa 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/metrics/secondary-index/secondary-index.3.metrics.sqlpp
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/metrics/secondary-index/secondary-index.3.metrics.sqlpp
@@ -24,7 +24,7 @@
use test;
-set `compiler.indexonly` "false";
+SET `compiler.index.covering` 'false';
set `compiler.cbo` "false";
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/api/cluster_state_1/cluster_state_1.1.regexadm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/api/cluster_state_1/cluster_state_1.1.regexadm
index eb32737916..a99b99cf1a 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/results/api/cluster_state_1/cluster_state_1.1.regexadm
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/api/cluster_state_1/cluster_state_1.1.regexadm
@@ -47,7 +47,7 @@
"compiler.forcejoinorder" : false,
"compiler\.framesize" : 32768,
"compiler\.groupmemory" : 163840,
- "compiler\.indexonly" : true,
+ "compiler\.index.covering" : true,
"compiler\.internal\.sanitycheck" : true,
"compiler\.joinmemory" : 262144,
"compiler\.max\.variable\.occurrences\.inlining" : 128,
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/api/cluster_state_1_full/cluster_state_1_full.1.regexadm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/api/cluster_state_1_full/cluster_state_1_full.1.regexadm
index 99fcba07cf..fda99fc898 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/results/api/cluster_state_1_full/cluster_state_1_full.1.regexadm
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/api/cluster_state_1_full/cluster_state_1_full.1.regexadm
@@ -47,7 +47,7 @@
"compiler.forcejoinorder" : false,
"compiler\.framesize" : 32768,
"compiler\.groupmemory" : 163840,
- "compiler\.indexonly" : true,
+ "compiler\.index.covering" : true,
"compiler\.internal\.sanitycheck" : false,
"compiler\.joinmemory" : 262144,
"compiler\.max\.variable\.occurrences\.inlining" : 128,
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/api/cluster_state_1_less/cluster_state_1_less.1.regexadm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/api/cluster_state_1_less/cluster_state_1_less.1.regexadm
index 98d1a44bdf..861d20bc3f 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/results/api/cluster_state_1_less/cluster_state_1_less.1.regexadm
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/api/cluster_state_1_less/cluster_state_1_less.1.regexadm
@@ -47,7 +47,7 @@
"compiler.forcejoinorder" : false,
"compiler\.framesize" : 32768,
"compiler\.groupmemory" : 163840,
- "compiler\.indexonly" : true,
+ "compiler\.index.covering" : true,
"compiler\.internal\.sanitycheck" : false,
"compiler\.joinmemory" : 262144,
"compiler\.max\.variable\.occurrences\.inlining" : 128,
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.4.ast
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.4.ast
index a501d7f39b..e2e9c11138 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.4.ast
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.4.ast
@@ -1,5 +1,5 @@
DataverseUse test
-Set compiler.indexonly=false
+Set compiler.index.covering=false
Query:
SELECT [
FieldAccessor [
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.5.ast
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.5.ast
index a501d7f39b..e2e9c11138 100644
---
a/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.5.ast
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/index-leftouterjoin/probe-pidx-with-join-btree-sidx1/probe-pidx-with-join-btree-sidx1.5.ast
@@ -1,5 +1,5 @@
DataverseUse test
-Set compiler.indexonly=false
+Set compiler.index.covering=false
Query:
SELECT [
FieldAccessor [
diff --git
a/asterixdb/asterix-common/src/main/java/org/apache/asterix/common/config/CompilerProperties.java
b/asterixdb/asterix-common/src/main/java/org/apache/asterix/common/config/CompilerProperties.java
index 2adfd7d9cc..da5f39b954 100644
---
a/asterixdb/asterix-common/src/main/java/org/apache/asterix/common/config/CompilerProperties.java
+++
b/asterixdb/asterix-common/src/main/java/org/apache/asterix/common/config/CompilerProperties.java
@@ -102,7 +102,7 @@ public class CompilerProperties extends AbstractProperties {
POSITIVE_INTEGER,
AlgebricksConfig.SORT_SAMPLES_DEFAULT,
"The number of samples which parallel sorting should take from
each partition"),
- COMPILER_INDEXONLY(BOOLEAN, AlgebricksConfig.INDEX_ONLY_DEFAULT,
"Enabling/disabling index-only plans"),
+ COMPILER_INDEX_COVERING(BOOLEAN, AlgebricksConfig.INDEX_ONLY_DEFAULT,
"Enabling/disabling index-only plans"),
COMPILER_INTERNAL_SANITYCHECK(
BOOLEAN,
AlgebricksConfig.SANITYCHECK_DEFAULT,
@@ -212,7 +212,7 @@ public class CompilerProperties extends AbstractProperties {
public static final String COMPILER_SORT_SAMPLES_KEY =
Option.COMPILER_SORT_SAMPLES.ini();
- public static final String COMPILER_INDEXONLY_KEY =
Option.COMPILER_INDEXONLY.ini();
+ public static final String COMPILER_INDEXONLY_KEY =
Option.COMPILER_INDEX_COVERING.ini();
public static final String COMPILER_INTERNAL_SANITYCHECK_KEY =
Option.COMPILER_INTERNAL_SANITYCHECK.ini();
@@ -309,7 +309,7 @@ public class CompilerProperties extends AbstractProperties {
}
public boolean isIndexOnly() {
- return accessor.getBoolean(Option.COMPILER_INDEXONLY);
+ return accessor.getBoolean(Option.COMPILER_INDEX_COVERING);
}
public boolean isSanityCheck() {
diff --git
a/asterixdb/asterix-doc/src/main/markdown/sqlpp/appendix_2_index_only.md
b/asterixdb/asterix-doc/src/main/markdown/sqlpp/appendix_2_index_only.md
index ad0ec2224c..e5ceadbbbb 100644
--- a/asterixdb/asterix-doc/src/main/markdown/sqlpp/appendix_2_index_only.md
+++ b/asterixdb/asterix-doc/src/main/markdown/sqlpp/appendix_2_index_only.md
@@ -27,11 +27,11 @@ Since an index-only plan only searches a secondary-index to
answer a query, it i
a non-index-only plan that needs to search the primary index.
However, this index-only plan can be turned off per query by setting the
following parameter.
-* **compiler.indexonly**: if this is set to false, the index-only-plan will
not be applied; the default value is true.
+* **compiler.index.covering**: if this is set to false, the index-only-plan
will not be applied; the default value is true.
##### Example
- set `compiler.indexonly` "false";
+ SET `compiler.index.covering` "false";
SELECT o.order_date AS orderdate
FROM orders o where o.order_date = "2020-05-01";
