xigongxiaoche opened a new issue, #31700:
URL: https://github.com/apache/shardingsphere/issues/31700
## which is the key code or g4 rule in 5.5.0 for open transanction in oracle
plsql
shardingsphere version: 5.5.0
## In mysql oracle sql, start with begin and end with end;
5.5.0 is support this kind of sql, before the version 5.5.0 is not support,
the commit is too many, I would like to know the key configuration in Oracle
that allows SQL statements to execute within the same transaction. Can someone
help me identify which module covers this?
···
begin
update
T_EMPI_RULE_MATCH_GROUP
set
status = '1',
BUILD_WAY = '0',
UPDATE_BY = '1',
priority = 10,
UPDATE_TIME = to_char(
sysdate, 'yyyy-MM-dd hh24:mi:ss'
)
where
rule_type = '0'
and id = '922B5C5CE166466D9505BFCE592D461C';
update
T_EMPI_RULE_MATCH_GROUP
set
status = '1',
BUILD_WAY = '0',
UPDATE_BY = '1',
priority = 15,
UPDATE_TIME = to_char(
sysdate, 'yyyy-MM-dd hh24:mi:ss'
)
where
rule_type = '0'
and id = '3953BD247C2B49818F533DEC8ADE48BB';
update
T_EMPI_RULE_MATCH_GROUP
set
status = '1',
BUILD_WAY = '0',
UPDATE_BY = '1',
priority = 20,
UPDATE_TIME = to_char(
sysdate, 'yyyy-MM-dd hh24:mi:ss'
)
where
rule_type = '0'
and id = '8F22D1F686CC48C68A5354B36D5AA1DA';
update
T_EMPI_RULE_MATCH_GROUP
set
status = '1',
BUILD_WAY = '0',
UPDATE_BY = '1',
priority = 30,
UPDATE_TIME = to_char(
sysdate, 'yyyy-MM-dd hh24:mi:ss'
)
where
rule_type = '0'
and id = '08F29F541D3D4415A5E0672DEF936277';
update
T_EMPI_RULE_MATCH_GROUP
set
status = '1',
BUILD_WAY = '1',
UPDATE_BY = '1',
priority = 65,
UPDATE_TIME = to_char(
sysdate, 'yyyy-MM-dd hh24:mi:ss'
)
where
rule_type = '0'
and id = '3FB76A70260143D7A8C46F5BBDB43E3F';
update
T_EMPI_RULE_MATCH_GROUP
set
status = '1',
BUILD_WAY = '1',
UPDATE_BY = '1',
priority = 70,
UPDATE_TIME = to_char(
sysdate, 'yyyy-MM-dd hh24:mi:ss'
)
where
rule_type = '0'
and id = 'A4AC4D5C037043E79FB5EF5D993B5DE1'; end;
···
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
