Re: Derby-573 - optimizer overrides changes to metadata.properties and upgrade

[Satheesh Bandaram]

I think some of the metadata querries are saved on disk... When you are in soft upgrade mode, those metadata querries in 10.1 database with optimizer hints in previous format may have to be recognized. This is because databases in soft upgrade mode should allow you to go back to previous versions, if needed. Satheesh Mamta Satoor wrote: I will have to admit my ignorance on soft upgrade. Can you point me somewhere to understand what is involved in a soft upgrade and then I will be able to answer your question?   Mamta   On 11/11/05, Mike Matrigali <[EMAIL PROTECTED]> wrote: In the case of soft upgrade (ie. the case where there are no changes to the metadata.properties) will you be disabling the new optimizer overrides? Mamta Satoor wrote: > Hi, > > The patch for optimizer overrides includes changes in > metadata.properties. I think this change in metadata.properties is going > to require some form of upgrade code so that the sql text stored in the > systems tables can be replaced with new sql text which uses this new > form of optimizer overrides. > > I wondered if anyone can give me some pointers on how to get started > with upgrade code to achieve this. In the mean time, I will start > looking into it too. > > thanks, > Mamta