From 650403ee643dabf64f11f6d3589124723dccaa01 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sat, 21 Jun 2014 18:11:04 -0400 Subject: [PATCH] - fix test failures --- test/dialect/mysql/test_compiler.py | 4 ++-- test/sql/test_constraints.py | 6 +++--- 2 files changed, 5 insertions(+), 5 deletions(-) diff --git a/test/dialect/mysql/test_compiler.py b/test/dialect/mysql/test_compiler.py index 3c2782994d..e8171fad5e 100644 --- a/test/dialect/mysql/test_compiler.py +++ b/test/dialect/mysql/test_compiler.py @@ -117,7 +117,7 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): PrimaryKeyConstraint('data')) self.assert_compile(schema.CreateTable(tbl), - "CREATE TABLE testtbl (data VARCHAR(255), PRIMARY KEY (data))") + "CREATE TABLE testtbl (data VARCHAR(255) NOT NULL, PRIMARY KEY (data))") def test_create_pk_with_using(self): m = MetaData() @@ -125,7 +125,7 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): PrimaryKeyConstraint('data', mysql_using='btree')) self.assert_compile(schema.CreateTable(tbl), - "CREATE TABLE testtbl (data VARCHAR(255), " + "CREATE TABLE testtbl (data VARCHAR(255) NOT NULL, " "PRIMARY KEY (data) USING btree)") def test_create_index_expr(self): diff --git a/test/sql/test_constraints.py b/test/sql/test_constraints.py index 8dd15eb021..992289d3e6 100644 --- a/test/sql/test_constraints.py +++ b/test/sql/test_constraints.py @@ -40,14 +40,14 @@ class ConstraintGenTest(fixtures.TestBase, AssertsExecutionResults): testing.db, lambda: metadata.create_all(checkfirst=False), CompiledSQL('CREATE TABLE employees (' - 'id INTEGER, ' - 'soc VARCHAR(40), ' + 'id INTEGER NOT NULL, ' + 'soc VARCHAR(40) NOT NULL, ' 'name VARCHAR(30), ' 'PRIMARY KEY (id, soc)' ')' ), CompiledSQL('CREATE TABLE elements (' - 'id INTEGER, ' + 'id INTEGER NOT NULL, ' 'stuff VARCHAR(30), ' 'emp_id INTEGER, ' 'emp_soc VARCHAR(40), ' -- 2.47.3