#
# MCOL-4778 Recursive CTE Crashing MariaDB - fix crash produce err.
#
-- source ../include/have_columnstore.inc

--disable_warnings
DROP DATABASE IF EXISTS mcol_4778;
--enable_warnings
CREATE DATABASE mcol_4778;
USE mcol_4778;

CREATE TABLE bus_routes (origin varchar(50), dst varchar(50)) engine=columnstore;

INSERT INTO bus_routes VALUES
  ('New York', 'Boston'),
  ('Boston', 'New York'),
  ('New York', 'Washington'),
  ('Washington', 'Boston'),
  ('Washington', 'Raleigh');

--error ER_CHECK_NOT_IMPLEMENTED
WITH RECURSIVE bus_dst as (
    SELECT origin as dst FROM bus_routes WHERE origin='New York'
  UNION
    SELECT bus_routes.dst FROM bus_routes JOIN bus_dst ON bus_dst.dst = bus_routes.origin
)
SELECT * FROM bus_dst;

DROP DATABASE mcol_4778;