# 65 characters exceed the maximum length of a column identifier. The system cannot derive the name from the constant. # Therefore it generates the identifier 'Name_exp_1'. CREATE VIEW v1 AS SELECT '<--- 65 --->'; SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'; COLUMN_NAME Name_exp_1 DROP VIEW v1; CREATE VIEW v1 AS select '<--- 65 --->' AS `Name_exp_1`; DROP VIEW v1; CREATE VIEW v1 AS select '<--- 65 --->' AS `Name_exp_1`; DROP VIEW v1; CREATE VIEW v1 AS SELECT 'A', (SELECT '<--- 65 --->'); SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'; COLUMN_NAME A Name_exp_2 DROP VIEW v1; CREATE VIEW v1 AS select 'A' AS `A`,(select '<--- 65 --->' AS `Name_exp_1`) AS `Name_exp_2`; DROP VIEW v1; CREATE VIEW v1 AS select 'A' AS `A`,(select '<--- 65 --->' AS `Name_exp_1`) AS `Name_exp_2`; DROP VIEW v1; # 64 characters do not exceed the maximum length of a column identifier. The system must derive the name from the constant. CREATE VIEW v1 AS SELECT '<--- 64 --->'; SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'; COLUMN_NAME <--- 64 ---> DROP VIEW v1; CREATE VIEW v1 AS select '<--- 64 --->' AS `<--- 64 --->`; DROP VIEW v1; CREATE VIEW v1 AS select '<--- 64 --->' AS `<--- 64 --->`; DROP VIEW v1; CREATE VIEW v1 AS SELECT 'A', (SELECT '<--- 64 --->'); SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'; COLUMN_NAME A Name_exp_2 DROP VIEW v1; CREATE VIEW v1 AS select 'A' AS `A`,(select '<--- 64 --->' AS `<--- 64 --->`) AS `Name_exp_2`; DROP VIEW v1; CREATE VIEW v1 AS select 'A' AS `A`,(select '<--- 64 --->' AS `<--- 64 --->`) AS `Name_exp_2`; DROP VIEW v1; # Identifiers must not have trailing spaces. The system cannot derive the name from the constant. # Generated identifiers have at their end the position within the select column list. # 'c2 ' -> 'Name_exp_1' , ' c4 ' -> 'Name_exp_2' CREATE VIEW v1 AS SELECT 'c1', 'c2 ', ' c3', ' c4 '; SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'; COLUMN_NAME c1 Name_exp_2 c3 Name_exp_4 DROP VIEW v1; CREATE VIEW v1 AS select 'c1' AS `c1`,'c2 ' AS `Name_exp_2`,' c3' AS `c3`,' c4 ' AS `Name_exp_4`; DROP VIEW v1; CREATE VIEW v1 AS select 'c1' AS `c1`,'c2 ' AS `Name_exp_2`,' c3' AS `c3`,' c4 ' AS `Name_exp_4`; DROP VIEW v1; CREATE VIEW v1 AS SELECT 'A', (SELECT ' c4 '); SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'; COLUMN_NAME A (SELECT ' c4 ') DROP VIEW v1; CREATE VIEW v1 AS select 'A' AS `A`,(select ' c4 ' AS `Name_exp_1`) AS `(SELECT ' c4 ')`; DROP VIEW v1; CREATE VIEW v1 AS select 'A' AS `A`,(select ' c4 ' AS `Name_exp_1`) AS `(SELECT ' c4 ')`; DROP VIEW v1;