[Info-ingres] Upgrading Ingres 9.2 to 10.2 - are there know problems ?

[Roy Hann]

J.F. wrote:

> Użytkownik "tanyadavidg"  napisał w wiadomości grup 
> dyskusyjnych:a26e4a8a-dd6b-48d0-8b09-1de71dbc14ea at googlegroups.com...
>>We want to upgrade Ingres , on VMS, from version 9.2 to version 10.2.
>>Has anyone done that kind of upgrade ?
>>Are there know problems in the upgrade ?
>>Are there any 9.2 features that are no longer supported by version 
>>10.2 ?
>
> I have done it only on Windows - surprise was date field with very old 
> year.
>
> For example - someone mistakenly entered date 20-12-0215.
>
> Ingres 9 keep it without problem. It dump it to backup files.
> Ingres 10 report error and cannot import this file.
> Whole table is not imported !
>
> So ... made a test installation, dump database, import to test, check 
> for errors - if there is none, you can upgrade your real database.

Ingres has handled proleptic Gregorian dates (i.e. dates
before—generally—1582) since release Ingres II 2.5. Your problem is
either an Ingres bug that should be reported, or a configuration error
in your upgraded system.

Roy