4972
4972
# End of test BUG#57203
4974
# Bug#63020: Function "format"'s 'locale' argument is not considered
4975
# when creating a "view'
4977
CREATE TABLE t1 (f1 DECIMAL(10,2));
4978
INSERT INTO t1 VALUES (11.67),(17865.3),(12345678.92);
4979
CREATE VIEW view_t1 AS SELECT FORMAT(f1,1,'sk_SK') AS f1 FROM t1;
4980
SHOW CREATE VIEW view_t1;
4981
View Create View character_set_client collation_connection
4982
view_t1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_t1` AS select format(`t1`.`f1`,1,'sk_SK') AS `f1` from `t1` latin1 latin1_swedish_ci
4983
SELECT * FROM view_t1;
4990
# End of test BUG#63020