Boolean column does not include default value in schema when creating a table in mysql

Issue #1000 resolved
Former user created an issue

Create a mysql table with a Boolean column. As far as I can tell, there is no way to specify a default that gets included in the database schema. For mysql I would expect the column to look like : tinyint(1) not null default 1.

A script to reproduce is included.

Comments (1)

  1. jek

    default= is for a Python-side default. DDL defaults are not passed as keyword arguments:

        Column(u'boolTest', Boolean(), PassiveDefault(text('1')), nullable=False),
    

    It's a common error and a future release will try to smooth it out.

  2. Log in to comment