Skip to content

Reflection on views not works anymore in MySQL #748

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
sqlalchemy-bot opened this issue Aug 17, 2007 · 6 comments
Closed

Reflection on views not works anymore in MySQL #748

sqlalchemy-bot opened this issue Aug 17, 2007 · 6 comments
Labels
bug Something isn't working mysql
Milestone
0.4.0

Comments

@sqlalchemy-bot
Copy link
Collaborator

Migrated issue, originally created by Anonymous

Patch attached

Attachments: sqlalchemy_views.diff
@sqlalchemy-bot
Copy link
Collaborator Author

jek (@jek) wrote:

this looks great, thanks!

@sqlalchemy-bot
Copy link
Collaborator Author

Changes by jek (@jek):

  • changed assignee from "zzzeek" to "jek"

@sqlalchemy-bot
Copy link
Collaborator Author

Anonymous wrote:

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

@sqlalchemy-bot
Copy link
Collaborator Author

Anonymous wrote:

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.

@sqlalchemy-bot
Copy link
Collaborator Author

jek (@jek) wrote:

Ok folks, views are reflecting again in 731dd1e.

@sqlalchemy-bot
Copy link
Collaborator Author

Changes by jek (@jek):

  • changed milestone from "0.4.xx" to "0.4.0"
  • changed status to closed

@sqlalchemy-bot sqlalchemy-bot added bug Something isn't working mysql labels Nov 27, 2018
@sqlalchemy-bot sqlalchemy-bot added this to the 0.4.0 milestone Nov 27, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working mysql
Projects
None yet
Milestone
0.4.0
Development

No branches or pull requests
1 participant
@sqlalchemy-bot