Hi Bryan, Mamta,
I try to use a decorator to overload decorateSQL method in which you can put
all the create table/view/function. But the problem is if I use that method
some of the create table must leave as it is now,
1.assertStatementError("42894", st," create table neg(c1 int default
These are asserting errors so we can keep them as they are now.
2. some times the same table names used by dropping the table.
st.executeUpdate(" drop table neg");
st.executeUpdate("create table neg(c1 int default 10)");
This can recover by using other name for the table.
But the biggest problem is the when we move the create table statements in
a separate method the readability is reduced(I think), because it is
checking the default values of the columns.
We can use alter table add column for this as a solution.
So the problem what can I do?