#
# Bug #37191: Failed assertion in CREATE VIEW
#
CREATE USER mysqluser1@localhost;
CREATE DATABASE mysqltest1;

USE mysqltest1;

CREATE TABLE t1 ( a INT );
CREATE TABLE t2 ( b INT );

CREATE VIEW v1 AS SELECT 1 AS a, 2 AS b;

GRANT CREATE VIEW ON mysqltest1.* TO mysqluser1@localhost;

GRANT SELECT ON t1 TO mysqluser1@localhost;
GRANT INSERT ON t2 TO mysqluser1@localhost;

--connect (connection1, localhost, mysqluser1, , mysqltest1)

# Crash!
CREATE VIEW v2 AS SELECT a, b FROM mysqltest1.t1, mysqltest1.t2;

--disconnect connection1
--connection default

DROP TABLE t1, t2;
DROP VIEW v1;
DROP DATABASE mysqltest1;
DROP USER mysqluser1@localhost;
USE test;