[
https://issues.apache.org/jira/browse/ASTERIXDB-3125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17702042#comment-17702042
]
ASF subversion and git services commented on ASTERIXDB-3125:
------------------------------------------------------------
Commit db2d76a27c9531ba60c97caa30ee634be2218eee in asterixdb's branch
refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=db2d76a27c ]
[ASTERIXDB-3125][COMP] Select operator has zero cost and cardinality
[ASTERIXDB-3126][COMP] CBO: hint productivity NPE if missing cardinality
estimate on collection
- user model changes: no
- storage format changes: no
- interface changes: no
Change-Id: I7cbff25b14346ca8eca5baa7e0fe8fb1da72f270
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17408
Reviewed-by: Ali Alsuliman <[email protected]>
Tested-by: Ali Alsuliman <[email protected]>
Tested-by: Jenkins <[email protected]>
Integration-Tests: Ali Alsuliman <[email protected]>
> Select operator has zero cost and cardinality
> ---------------------------------------------
>
> Key: ASTERIXDB-3125
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3125
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Vijay Sarathy
> Assignee: Vijay Sarathy
> Priority: Major
> Fix For: 0.9.9
>
> Attachments: Screenshot 2023-03-01 at 6.39.50 PM.png
>
>
> Query:
> select count (1) from R, S where int64_default_null (R.rand) /{*}+
> productivity R 1.0 */ /{*}+ indexnl {*}/ = int64_default_null (S.rand) and
> R.rand /{*}+ selectivity 0.000244 {*}/ <= 1024 and S.rand /{*}+ selectivity
> 0.000244 */ <= 1024;
> One of the select operators in the query plan has zero cost and cardinality.
> h4.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
