[ https://issues.apache.org/jira/browse/ASTERIXDB-1354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15407847#comment-15407847 ]
ASF subversion and git services commented on ASTERIXDB-1354: ------------------------------------------------------------ Commit b762457537a6ba163714beb2e43b11b5e8b97c7d in asterixdb's branch refs/heads/master from [~buyingyi] [ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=b762457 ] Support UNION ALL. - support heterogenous input types for UNION ALL and the output is resolved to a mimimally generalized type; - fix the partitioning property inference for UnionAllPOperator; - fix for ASTERIXDB-1354, a bug in IsomorphismVariableMappingVisitor. Change-Id: Ifadf1707bb2b6bed22f8fc5792c635e87291a468 Reviewed-on: https://asterix-gerrit.ics.uci.edu/1035 Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu> Reviewed-by: Yingyi Bu <buyin...@gmail.com> > Foreign key select error of UNION > --------------------------------- > > Key: ASTERIXDB-1354 > URL: https://issues.apache.org/jira/browse/ASTERIXDB-1354 > Project: Apache AsterixDB > Issue Type: Bug > Components: AsterixDB > Environment: General Environment. > Reporter: Wenhai > Assignee: Yingyi Bu > Priority: Critical > Labels: patch > > If we set up a composite primary key (i.e. LineItem(l_orderkey, > l_linenumber)) referring to another table (i.e. Orders(o_orderkey)), the same > selection condition will introduce a readCount error. > Schemas > {noformat} > use dataverse tpch; > create type LineItemType as closed { > l_orderkey: int32, > l_partkey: int32, > l_suppkey: int32, > l_linenumber: int32, > l_quantity: int32, > l_extendedprice: double, > l_discount: double, > l_tax: double, > l_returnflag: string, > l_linestatus: string, > l_shipdate: string, > l_commitdate: string, > l_receiptdate: string, > l_shipinstruct: string, > l_shipmode: string, > l_comment: string > } > create type OrderType as closed { > o_orderkey: int32, > o_custkey: int32, > o_orderstatus: string, > o_totalprice: double, > o_orderdate: string, > o_orderpriority: string, > o_clerk: string, > o_shippriority: int32, > o_comment: string > } > create dataset LineItem(LineItemType) primary key l_orderkey, l_linenumber; > create dataset Orders(OrderType) primary key o_orderkey; > use dataverse tpch; > load dataset LineItem > using localfs > (("path"="asterix_nc1://data/tpch0.001/lineitem.tbl"),("format"="delimited-text"),("delimiter"="|")); > load dataset Orders > using localfs > (("path"="asterix_nc2://data/tpch0.001/orders.tbl"),("format"="delimited-text"),("delimiter"="|")); > {noformat} > Query: > {noformat} > use dataverse tpch; > let $l := for $r in dataset LineItem where $r.l_orderkey = 2 > return $r.l_linenumber > let $o := for $s in dataset Orders where $s.o_orderkey =2 > return $s.o_custkey > let $c := $l union $o > return $c > {noformat} > Error: > {noformat} > Invalid LSM disk component readerCount: -1 [IllegalStateException] > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)