[Buildbot-commits] [Buildbot] #2171: older sqlalchemies fail to quote default values

[Buildbot]

#2171: older sqlalchemies fail to quote default values
---------------------+---------------------
Reporter:  dustin    |       Owner:  dustin
    Type:  defect    |      Status:  new
Priority:  major     |   Milestone:  0.8.6
 Version:  0.8.5     |  Resolution:
Keywords:  database  |
---------------------+---------------------

Comment (by dustin):

 Specifically, 0.7.1 fails with
 {{{
 import sqlalchemy as sa

 engine = sa.create_engine('sqlite:///', echo=True)
 engine.execute('''
     CREATE TABLE test (
         project VARCHAR(1) DEFAULT '' NOT NULL
 )''')

 metadata = sa.MetaData(bind=engine)
 tbl = sa.Table('test', metadata, autoload=True)
 engine.execute('drop table test')
 tbl.create()
 }}}
 with
 {{{
 2012-01-07 17:22:08,981 INFO sqlalchemy.engine.base.Engine
     CREATE TABLE test (
         project VARCHAR(1) DEFAULT '' NOT NULL
 )
 ...
 CREATE TABLE test (
         project VARCHAR(1) DEFAULT  NOT NULL
 )
 }}}

 I'll see what the diffs are between those versions and try to monkey-patch
 in the fix.

-- 
Ticket URL: <http://trac.buildbot.net/ticket/2171#comment:1>
Buildbot <http://buildbot.net/>
Buildbot: build/test automation