Couple of DB issues

[BJ Freeman]

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

[BJ Freeman]

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
>
>
>
>

[BJ Freeman]

 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
>>
>>
>>
>>
>
>
>
>

[BJ Freeman]

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
>>>
>>>
>>>
>>>
>>
>>
>>
>
>
>
>