На mysql 5.6.20 не срабатывает двойной select*from
А name_const не прокатит для обычных запросов
Код:
SELECT GeometryCollection((select*from(select*from(select@@version)f)x));
ERROR 1367 (22007): Illegal non geometric '(select `x`.`@@version` from (select
`f`.`@@version` AS `@@version` from (select @@version AS `@@version`) `f`) `x`)'
value found during parsing