[Info-ingres] alter from nchar to char

[armand pirvu]

Thanks Karl

That's what I was expecting. Will see if I can reproduce reliably. The idea is it got also into a tx log wrap and a ton of undo errors

Armand

Sent from my iPhone

> On May 19, 2018, at 9:47 PM, Karl and Betty Schendel <schendel at kbcomputer.com> wrote:
> 
> Assuming that the alter is accepted, no.  It works just like an alter table
> add column in that the old rows are coerced on the fly and new rows are
> written with the new column definition.
> 
> A modify of the table will rewrite all the values but it logs as a regular
> modify (i.e. a few log records, not one for each table row.)
> 
> Karl
> 
>> On May 18, 2018, at 5:29 PM, armand pirvu <armand.pirvu at gmail.com> wrote:
>> 
>> Hi  all
>> 
>> Does alter from nchar to char in a total table rewrite with massive logging ?
>> 
>> alter table irs.acb_cd_0216095833 alter column crd_logical_destination char(80) not null default ' ' \p\g
>> 
>> 
>> Thanks
>> — Armand
>> _______________________________________________
>> Info-ingres mailing list
>> Info-ingres at lists.planetingres.org
>> http://lists.planetingres.org/mailman/listinfo/info-ingres
> 
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org
> http://lists.planetingres.org/mailman/listinfo/info-ingres