mysql> show create view v_info_top50_tablecount\G
*************************** 1. row ***************************
View: v_info_top50_tablecount
Create View: CREATE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY DEFINER
VIEW `deeden`.`v_info_top50_tablecount` AS select sql_no_cache
`v_info_tablecount`.`schema_name` AS
`schema_name`,`v_info_tablecount`.`table_count` AS `table_count` from
`deeden`.`v_info_tablecount` order by `v_info_tablecount`.`table_count` desc
limit 50
1 row in set (0.00 sec)
mysql> show create view v_info_tablecount\G
*************************** 1. row ***************************
View: v_info_tablecount
Create View: CREATE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY DEFINER
VIEW `deeden`.`v_info_tablecount` AS select sql_no_cache `s`.`SCHEMA_NAME` AS
`schema_name`,count(`t`.`TABLE_NAME`) AS `table_count` from
(`information_schema`.`schemata` `s` left join `information_schema`.`tables`
`t` on((`s`.`SCHEMA_NAME` = `t`.`TABLE_SCHEMA`))) group by `s`.`SCHEMA_NAME`
1 row in set (0.00 sec)
mysql> select count(*) from information_schema.tables;
+----------+
| count(*) |
+----------+
| 8519 |
+----------+
1 row in set (3.36 sec)
mysql> select count(*) from information_schema.schemata;
+----------+
| count(*) |
+----------+
| 247 |
+----------+
1 row in set (0.01 sec)
mysql> explain select * from v_info_top50_tablecount;
ERROR 2013 (HY000): Lost connection to MySQL server during query
--
Fix for MySQL Bug #22413 should be backported to LTS releases
https://bugs.launchpad.net/bugs/161127
You received this bug notification because you are a member of Ubuntu
Bugs, which is the bug contact for Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
