Skip to content
This repository was archived by the owner on Jan 28, 2021. It is now read-only.
This repository was archived by the owner on Jan 28, 2021. It is now read-only.

Possible error in SHOW CREATE TABLE #594

Closed
@erizocosmico

Description

@erizocosmico

SQLAlchemy says this:

/Users/erizocosmico/Library/Python/2.7/lib/python/site-packages/sqlalchemy/dialects/mysql/reflection.py:62: SAWarning: Unknown schema content: u'`ref_name` TEXT NOT NULL,'
  util.warn("Unknown schema content: %r" % line)
/Users/erizocosmico/Library/Python/2.7/lib/python/site-packages/sqlalchemy/dialects/mysql/reflection.py:62: SAWarning: Unknown schema content: u'`commit_hash` TEXT NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4'
  util.warn("Unknown schema content: %r" % line)
Traceback (most recent call last):
  File "foo.py", line 7, in <module>
    repo_df = pd.read_sql_table("refs", con=conn)
  File "/Users/erizocosmico/Library/Python/2.7/lib/python/site-packages/pandas/io/sql.py", line 242, in read_sql_table
    raise ValueError("Table %s not found" % table_name)
ValueError: Table refs not found

It's possible we have some kind of error in our SHOW CREATE TABLE implementation.

Reproduction case:

import pandas as pd
import sqlalchemy

engine = sqlalchemy.create_engine('mysql+pymysql://[email protected]:3306/gitbase')
with engine.connect() as conn:
    repo_df = pd.read_sql_table("refs", con=conn)

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions