Revision: 3236
Author: silva.josemanuel1
Date: Tue Jan 19 14:37:22 2010
Log: Updated test to go with previous commit:
FIXED - bug 2323: Issue with COMMENT DDL for MySQL
http://trillian.sqlpower.ca/bugzilla/show_bug.cgi?id=2323
http://code.google.com/p/power-architect/source/detail?r=3236
Modified:
/trunk/regress/ca/sqlpower/architect/ddl/MySqlDDLGeneratorTest.java
=======================================
--- /trunk/regress/ca/sqlpower/architect/ddl/MySqlDDLGeneratorTest.java Fri
May 22 06:08:44 2009
+++ /trunk/regress/ca/sqlpower/architect/ddl/MySqlDDLGeneratorTest.java Tue
Jan 19 14:37:22 2010
@@ -44,14 +44,15 @@
// second, third and fourth statements should be the COMMENT ON ...
statements
List<DDLStatement> stmts = ddl.getDdlStatements();
assertEquals(4, stmts.size());
-
- String sql = stmts.get(1).getSQLText().trim();
+
+ String sql = stmts.get(1).getSQLText().trim();
+
assertEquals("ALTER TABLE test_table COMMENT 'Test single '' quotes'",
sql);
sql = stmts.get(2).getSQLText().trim();
- assertEquals("COMMENT ON COLUMN test_table.id IS 'The row''s primary
key'", sql);
-
+ assertEquals("ALTER TABLE test_table MODIFY COLUMN id INTEGER(0)
COMMENT 'The row''s primary key'", sql);
+
sql = stmts.get(3).getSQLText().trim();
- assertEquals("COMMENT ON COLUMN test_table.name IS 'The person''s
name'", sql);
+ assertEquals("ALTER TABLE test_table MODIFY COLUMN name
VARCHAR(50) COMMENT 'The person''s name'", sql);
}
}
