1

Topic: DDL and DML in one transaction

Question to developers. In 4 there is in force a statement

wrote:

So far the [undocumented] practice was that you cannot mix DDL and DML
inside a single transaction.

?

2

Re: DDL and DML in one transaction

It even in 1.5 was not truth, without specifications.

3

Re: DDL and DML in one transaction

Rustam wrote:

It even in 1.5 was not truth, without specifications.

I any more do not remember in what version, is not inclined to repeated  on the same rake, therefore remembered once and for all. Created a new field, in its same transaction , . And the update transited! But in other field.

4

Re: DDL and DML in one transaction

The old teddy bear> Created a new field, in its same transaction
For .

5

Re: DDL and DML in one transaction

sysdba22 wrote:

the Question to developers. In 4 there is in force a statement
it is passed...
?

Yes

6

Re: DDL and DML in one transaction

Then still a question. If transaction one and sequence such:
DDL
CommitRetaining
DML
It is normal?

7

Re: DDL and DML in one transaction

sysdba22;
CommitRetaining in itself it is abnormal:-D

8

Re: DDL and DML in one transaction

sysdba22 wrote:

Then still a question. If transaction one and sequence such:
DDL
CommitRetaining
DML
It is normal?

It not so is bad, as generally without  between DDL and DML.
But - what for? On what we hope? smile

9

Re: DDL and DML in one transaction

Yes simply old code I try to reorganize. It ferro-concrete it is finite, still at the time of Yaffil the written.
There broad gull SQL which is formed are fulfilled in an exclusive mode, with reconnections to a DB. If who remembers well-known object is in use times Yaffil. The problem that when the difficult decision on a DB is loaded, there can be thousand these commands and all process occupies decently time. Here also I think, there where probably to get rid of reconnections and  DML in groups that on one transaction to fulfill.

10

Re: DDL and DML in one transaction

sysdba22;
It is all clearly. Not clearly - what for commit retaining ?

11

Re: DDL and DML in one transaction

Singularities of the old code. It will be altered.

12

Re: DDL and DML in one transaction

sysdba22;
Actually, CommitRetaining in any way to IB/FB/YA or to their versions it is not anchored, so it it is possible without problems .
Probably, the author of that code something in a head represented to itself about CommitRetaining that does not represent the facts. Happens.