Skip to content

--schema_only doesn't work with empty tables #2

@lathonez

Description

@lathonez
2015-08-12 11:08:58 inserting a minimal row into target database..
Traceback (most recent call last):
  File "/Users/stephen/code/mysql-clone-row/CloneRow.py", line 611, in <module>
    DOLLY.insert_target()
  File "/Users/stephen/code/mysql-clone-row/CloneRow.py", line 428, in insert_target
    cur.execute(insert_sql, (self.database['filter'],))
  File "/usr/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, "Unknown column 'None' in 'field list'")

It'll be cause we're doing select * limit 1 to get the columns.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions