<?xml version="1.0" encoding="UTF-8"?>
<!--
  ~ Licensed to the Apache Software Foundation (ASF) under one or more
  ~ contributor license agreements.  See the NOTICE file distributed with
  ~ this work for additional information regarding copyright ownership.
  ~ The ASF licenses this file to You under the Apache License, Version 2.0
  ~ (the "License"); you may not use this file except in compliance with
  ~ the License.  You may obtain a copy of the License at
  ~
  ~     http://www.apache.org/licenses/LICENSE-2.0
  ~
  ~ Unless required by applicable law or agreed to in writing, software
  ~ distributed under the License is distributed on an "AS IS" BASIS,
  ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  ~ See the License for the specific language governing permissions and
  ~ limitations under the License.
  -->

<sql-cases db-types="MySQL">
    <sql-case id="setTransaction" value="SET TRANSACTION ISOLATION LEVEL REPEATABLE READ" db-types="MySQL,Oracle,PostgreSQL,SQLServer" />
    <sql-case id="commit" value="COMMIT" db-types="MySQL,Oracle,SQLServer" />
    <sql-case id="commitWithName" value="COMMIT TRANSACTION transaction1" db-types="SQLServer" />
    <sql-case id="commitWithComment" value="COMMIT COMMENT 'comment1'" db-types="Oracle" />
    <sql-case id="commitForce" value="COMMIT FORCE 'transaction1'" db-types="Oracle" />
    <sql-case id="rollback" value="ROLLBACK" db-types="MySQL,Oracle,PostgreSQL,SQLServer" />
    <sql-case id="rollbackWithName" value="ROLLBACK TRANSACTION transaction1" db-types="SQLServer" />
    <sql-case id="rollbackForce" value="ROLLBACK FORCE 'transaction1'" db-types="Oracle" />
    <sql-case id="savepoint" value="SAVEPOINT savepoint1" db-types="MySQL" />
    <sql-case id="begin" value="BEGIN" db-types="MySQL" />
    <sql-case id="beginTransaction" value="BEGIN TRANSACTION" db-types="SQLServer" />
    <sql-case id="beginWithName" value="BEGIN TRANSACTION transaction1" db-types="SQLServer" />
    <sql-case id="setAutoCommitOn" value="SET AUTOCOMMIT = 1" db-types="MySQL" />
    <sql-case id="setAutoCommitOnWithScope" value="SET @@SESSION.AUTOCOMMIT = ON" db-types="MySQL" />
    <sql-case id="setAutoCommitOff" value="SET AUTOCOMMIT = 0" db-types="MySQL" />
    <sql-case id="setAutoCommitOffWithScope" value="SET SESSION AUTOCOMMIT = OFF" db-types="MySQL" />
    <sql-case id="setImplicitTransactionsOn" value="SET IMPLICIT_TRANSACTIONS ON" db-types="SQLServer" />
    <sql-case id="setImplicitTransactionsOff" value="IF @@TRANCOUNT > 0 COMMIT TRAN SET IMPLICIT_TRANSACTIONS OFF" db-types="SQLServer" />
    <sql-case id="rollbackToSavepoint" value="ROLLBACK TO savepoint1" />
    <sql-case id="setGlobalTransaction" value="SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ" />
    <sql-case id="setTransactionReadOnly" value="SET TRANSACTION READ ONLY" db-types="MySQL,Oracle,PostgreSQL" />
    <sql-case id="setTransactionWithName" value="SET TRANSACTION NAME 'comment1'" />
    <sql-case id="beginReadCommitted" value="BEGIN ISOLATION LEVEL READ COMMITTED" db-types="PostgreSQL" />
    <sql-case id="beginReadOnly" value="BEGIN READ ONLY" db-types="PostgreSQL" />
    <sql-case id="commitPrepare" value="COMMIT PREPARED transaction1" db-types="PostgreSQL" />
    <sql-case id="rollbackPrepare" value="ROLLBACK PREPARED transaction1" db-types="PostgreSQL" />
    <sql-case id="setTransactionSnapshot" value="SET TRANSACTION SNAPSHOT snapshot1" db-types="PostgreSQL" />
    <sql-case id="setSessionTransaction" value="SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED" db-types="PostgreSQL" />
</sql-cases>
