[MCOL-2098] Allow Subquery with union other than FROM clause Created: 2019-01-22  Updated: 2023-07-04  Resolved: 2023-07-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.2.1, 22.08.7
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: Nilnandan Joshi Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 1
Labels: Compatibility

Epic Link: ColumnStore Compatibility Improvements

 Description   

While using subquery with union, getting below error.
ERROR 1815 (HY000): Internal error: IDB-3013: Subquery with union is currently only supported in the FROM clause.

Please allow Subquery with union other than FROM clause



 Comments   
Comment by Todd Stoffel (Inactive) [ 2020-11-09 ]

dleeyh Can you please retest this in 5.4.1?

Comment by Daniel Lee (Inactive) [ 2020-11-10 ]

Build tested: 5.4.3-1

The following two queries worked fine:

MariaDB [tpch1]> select count from (select * from tpch1.nation union all select * from tpch2.nation) t;
----------

count

----------

50

----------
1 row in set (0.062 sec)

MariaDB [tpch1]> select * from tpch1.nation union all select * from (select * from tpch2.nation where n_nationkey > 20) t;
--------------------------------------------------------------------------------------------------------------------------------------------------------+

n_nationkey n_name n_regionkey n_comment

--------------------------------------------------------------------------------------------------------------------------------------------------------+

0 ALGERIA 0 haggle. carefully final deposits detect slyly agai
1 ARGENTINA 1 al foxes promise slyly according to the regular accounts. bold requests alon
2 BRAZIL 1 y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special
3 CANADA 1 eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
4 EGYPT 4 y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
5 ETHIOPIA 0 ven packages wake quickly. regu
6 FRANCE 3 refully final requests. regular, ironi
7 GERMANY 3 l platelets. regular accounts x-ray: unusual, regular acco
8 INDIA 2 ss excuses cajole slyly across the packages. deposits print aroun
9 INDONESIA 2 slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull
10 IRAN 4 efully alongside of the slyly final dependencies.
11 IRAQ 4 nic deposits boost atop the quickly final requests? quickly regula
12 JAPAN 2 ously. final, express gifts cajole a
13 JORDAN 4 ic deposits are blithely about the carefully regular pa
14 KENYA 0 pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
15 MOROCCO 0 rns. blithely bold courts among the closely regular packages use furiously bold platelets?
16 MOZAMBIQUE 0 s. ironic, unusual asymptotes wake blithely r
17 PERU 1 platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun
18 CHINA 2 c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
19 ROMANIA 3 ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account
20 SAUDI ARABIA 4 ts. silent requests haggle. closely express packages sleep across the blithely
21 VIETNAM 2 hely enticingly express accounts. even, final
22 RUSSIA 3 requests against the platelets use never according to the quickly regular pint
23 UNITED KINGDOM 3 eans boost carefully special requests. accounts are. carefull
24 UNITED STATES 1 y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be
21 VIETNAM 2 hely enticingly express accounts. even, final
22 RUSSIA 3 requests against the platelets use never according to the quickly regular pint
23 UNITED KINGDOM 3 eans boost carefully special requests. accounts are. carefull
24 UNITED STATES 1 y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be

--------------------------------------------------------------------------------------------------------------------------------------------------------+
29 rows in set (0.025 sec)

Comment by Todd Stoffel (Inactive) [ 2023-07-02 ]

The "create date" on this ticket is pre-convergence with MariaDB server. If the issue still exists in a modern version of the engine/plugin please submit a new ticket.

Generated at Thu Feb 08 02:33:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.