Re: DDL and DML in a transaction

2019-07-31 Thread Igal @ Lucee.org
Thank you, David. I should get more sleep... Igal On 7/31/2019 11:52 AM, David G. Johnston wrote: On Wed, Jul 31, 2019 at 11:38 AM Igal @ Lucee.org > wrote:      alter table some_table     rename column amount_num to amount_text; alter table some

Re: DDL and DML in a transaction

2019-07-31 Thread David G. Johnston
On Wed, Jul 31, 2019 at 11:38 AM Igal @ Lucee.org wrote: > alter table some_table > rename column amount_num to amount_text; > > alter table some_table > drop column amount_num; > You just renamed amount_num to amount_text so I'm not sure why you expect the drop to su