[ https://issues.apache.org/jira/browse/ASTERIXDB-3608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ian Maxon reassigned ASTERIXDB-3608: ------------------------------------ Assignee: murali krishna > Some unnest Queries were not going thru CBO because of a missing annotation > --------------------------------------------------------------------------- > > Key: ASTERIXDB-3608 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-3608 > Project: Apache AsterixDB > Issue Type: Bug > Components: *DB - AsterixDB > Reporter: murali krishna > Assignee: murali krishna > Priority: Minor > > Consider these two identical queries. > select count (*) from KS1 x, x.uarr_i, KS2 y where x.rand_n = y.rand_n; > select count (*) from KS1 x unnest x.uarr_i, KS2 y where x.rand_n = y.rand_n; > The second query has an explicit UNNEST while the first one does not but the > queries are identical. > The first query was going thru CBO while the second one is not because of a > missing annotation. -- This message was sent by Atlassian Jira (v8.20.10#820010)