move this to dev list
BJ Freeman sent the following on 7/16/2008 11:28 AM: > per > http://db.apache.org/derby/docs/10.1/ref/rrefkeywords29722.html > should use Alter for debry db > will see what I can do to make a patch. > > > BJ Freeman sent the following on 7/16/2008 9:17 AM: >> ran the web tools to update db. >> for the derby got this error a lot >> * SQL Exception while executing the following: ALTER TABLE >> OFBIZ.WORK_EFFORT_SEARCH_RESULT RENAME NUM_RESULTS TO TMP_NUMRESULTS >> Error was: java.sql.SQLException: Syntax error: Encountered "RENAME" at >> line 1, column 45. >> >> >> BJ Freeman sent the following on 7/16/2008 8:30 AM: >>> Database util seems to report tables size, missing or removed fine. >>> I was under the assumption that it also modified (altered) the Tables >>> and columns, to fit the new entities. >>> If so it is not doing it as far as i can tell on the default db (derby) >>> >>> next observation is that some of the tables are two char smaller than >>> the entities. I don't believe the entities have been changed since they >>> report 20 as the size, but the DB is 18. >>> >>> these are with >>> ant clean >>> you won't see this with a >>> ant clean-all >>> >>> >>> >>> >> >> >> > > > >
