[ASTERIXDB-3340] Incorrect assignment of runtime partition when mixing external-internal data scans with UNION ALL

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: EXT - External data
• Labels: triaged
• Assignee: Ali Alsuliman
• Reporter: Ali Alsuliman
• Created: 17/Jan/24 01:34
• Updated: 27/Jan/24 18:05

Description

To reproduce:
1- Create an external link
2- Create an external dataset: ext_dataset
3- Create an internal dataset: int_dataset
4- Create the following view:

CREATE OR REPLACE VIEW `view1` (`city` STRING, `country` STRING, `lat` DOUBLE, `lon` DOUBLE, `name` STRING, `type` STRING)
DEFAULT NULL PRIMARY KEY ( `name` ) NOT ENFORCED AS 
SELECT name, city, country, geo.lat, geo.lon
FROM ext_dataset
WHERE `type` = "br" and geo.lat IS NOT NULL and geo.lon IS NOT NULL
UNION ALL
SELECT name, city, country, geo.lat, geo.lon
FROM int_dataset

5- run the following query:

SELECT *
FROM view1 m, int_dataset h
WHERE m.x /*+hash-bcast*/ = h.x

The query will fail with an internal error.