Reflection on views not works anymore in MySQL

Issue #748 resolved
Former user created an issue

Patch attached

Comments (5)

  1. Former user Account Deleted

    The diff docstring says "SHOW CREATE TABLE" doesn't work with views, but it does, at least in MySQL 5.0.38.

  2. Former user Account Deleted

    It works, but the result is something like:

    CREATE ALGORITHM=TEMPTABLE DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `c_forums` AS select `c`.`id` AS `id`, ... from ... where ... group by ...
    

    There is no column info. But SQLAlchemy parses create table statement to find out column types. That not works for views.

  3. Log in to comment