[MCOL-782] Non-recursive Common Table Expressions used in view caused an error Created: 2017-06-21 Updated: 2018-02-14 Resolved: 2018-02-14 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MariaDB Server |
| Affects Version/s: | 1.1.0 |
| Fix Version/s: | 1.1.3 |
| Type: | Bug | Priority: | Major |
| Reporter: | Daniel Lee (Inactive) | Assignee: | Daniel Lee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||
| Epic Link: | ColumnStore Compatibility Improvements | ||||||||||||||||
| Sprint: | 2017-25, 2018-01, 2018-03, 2018-04 | ||||||||||||||||
| Description |
|
Build tested: Github source 1.1.0-1 It works as a stand alone query, or in procedures, but failed in views. This query worked: This procedure worked: DELIMITER // call shownations; This view did not work: MariaDB [mytest]> create view v as select * from nation n ,region r where n.n_regionkey = r.r_regionkey and r.r_regionkey in (with t as (select * from region where r_regionkey <=3) select r_regionkey from t where r_name <> "ASIA"); MariaDB [mytest]> select * from v; |
| Comments |
| Comment by David Hall (Inactive) [ 2018-01-16 ] |
|
This appears to be a problem in the server. |
| Comment by Andrew Hutchings (Inactive) [ 2018-01-18 ] |
|
Moving out of sprint as any work on this is depends on the MDEV |
| Comment by Andrew Hutchings (Inactive) [ 2018-02-02 ] |
|
Added to current sprint to be tested once 10.2.13 is merged. |
| Comment by David Hall (Inactive) [ 2018-02-13 ] |
|
The fix for |
| Comment by Daniel Lee (Inactive) [ 2018-02-14 ] |
|
Build verified: Github source 1.1.3-1 [root@localhost ~]# cat mariadb-columnstore-1.1.3-1-centos7.x86_64.bin.tar.gz.txt Merge pull request #95 from mariadb-corporation/ /root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine Merge pull request #404 from mariadb-corporation/fix-sig-handler Fix sig handler for ExeMgr |