# Bug#45346 VIEW containing INTERVALL(...) can be created but does not work
#

--disable_warnings
DROP VIEW IF EXISTS v1;
--enable_warnings

let $my_select= SELECT INTERVAL(55,10) AS my_col;
eval
CREATE OR REPLACE VIEW v1 AS
$my_select;
SHOW TABLES;

# We only want to check if the following statements are successfull.
# Result sets are out of the scope!
# SHOW CREATE VIEW results might change if the server is improved and
# require maintenance of the file with expected results.
# We avoid this by disabling the result set logging.
--echo # The result log is disabled.
--disable_result_log
eval $my_select;
SHOW CREATE VIEW v1;
SELECT * FROM v1;
--disable_result_log

DROP VIEW v1;