1include/rpl_init.inc [topology=none] 2SET @old_sql_notes= @@GLOBAL.SQL_NOTES; 3SET GLOBAL SQL_NOTES= 0; 4SET SESSION SQL_NOTES= 0; 5CALL mtr.add_suppression('Statement violates GTID consistency:'); 6CALL mtr.add_suppression('Unsafe statement written to the binary log'); 7SET GLOBAL ENFORCE_GTID_CONSISTENCY = 0; 8SET GLOBAL GTID_MODE = OFF_PERMISSIVE; 9SET GLOBAL GTID_MODE = ON_PERMISSIVE; 10SET GLOBAL GTID_MODE = 2; 11######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=ON_PERMISSIVE GTID_NEXT=AUTOMATIC ######## 12---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 13# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC 14SET GTID_NEXT = 'AUTOMATIC'; 15BEGIN; 16error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 17CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 18ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 19include/assert.inc [One warning/error should be generated.] 20include/assert.inc [It should be an Error, not a Warning.] 21include/assert.inc [Text should be "violates GTID consistency"] 22include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 23include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 24ROLLBACK; 25SET GTID_NEXT = 'AUTOMATIC'; 26include/assert.inc [Both counters should be 0] 27DROP TEMPORARY TABLE IF EXISTS t1; 28Warnings: 29Note 1051 Unknown table 'test.t1' 30---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 31# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC 32SET GTID_NEXT = 'AUTOMATIC'; 33BEGIN; 34error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 35CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 36ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 37include/assert.inc [One warning/error should be generated.] 38include/assert.inc [It should be an Error, not a Warning.] 39include/assert.inc [Text should be "violates GTID consistency"] 40include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 41include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 42ROLLBACK; 43SET GTID_NEXT = 'AUTOMATIC'; 44include/assert.inc [Both counters should be 0] 45DROP TEMPORARY TABLE IF EXISTS t1; 46Warnings: 47Note 1051 Unknown table 'test.t1' 48---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 49SET AUTOCOMMIT = 0; 50# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC 51SET GTID_NEXT = 'AUTOMATIC'; 52error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 53CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 54ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 55include/assert.inc [One warning/error should be generated.] 56include/assert.inc [It should be an Error, not a Warning.] 57include/assert.inc [Text should be "violates GTID consistency"] 58include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 59include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 60ROLLBACK; 61SET GTID_NEXT = 'AUTOMATIC'; 62include/assert.inc [Both counters should be 0] 63SET AUTOCOMMIT = 1; 64DROP TEMPORARY TABLE IF EXISTS t1; 65Warnings: 66Note 1051 Unknown table 'test.t1' 67---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 68SET AUTOCOMMIT = 0; 69# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC 70SET GTID_NEXT = 'AUTOMATIC'; 71error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 72CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 73ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 74include/assert.inc [One warning/error should be generated.] 75include/assert.inc [It should be an Error, not a Warning.] 76include/assert.inc [Text should be "violates GTID consistency"] 77include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 78include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 79ROLLBACK; 80SET GTID_NEXT = 'AUTOMATIC'; 81include/assert.inc [Both counters should be 0] 82SET AUTOCOMMIT = 1; 83DROP TEMPORARY TABLE IF EXISTS t1; 84Warnings: 85Note 1051 Unknown table 'test.t1' 86---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 87CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 88# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC 89SET GTID_NEXT = 'AUTOMATIC'; 90BEGIN; 91error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 92DROP TEMPORARY TABLE t1; 93ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 94include/assert.inc [One warning/error should be generated.] 95include/assert.inc [It should be an Error, not a Warning.] 96include/assert.inc [Text should be "violates GTID consistency"] 97include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 98include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 99ROLLBACK; 100SET GTID_NEXT = 'AUTOMATIC'; 101include/assert.inc [Both counters should be 0] 102---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 103CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 104Warnings: 105Note 1050 Table 't1' already exists 106# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC 107SET GTID_NEXT = 'AUTOMATIC'; 108BEGIN; 109error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 110DROP TEMPORARY TABLE t1; 111ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 112include/assert.inc [One warning/error should be generated.] 113include/assert.inc [It should be an Error, not a Warning.] 114include/assert.inc [Text should be "violates GTID consistency"] 115include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 116include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 117ROLLBACK; 118SET GTID_NEXT = 'AUTOMATIC'; 119include/assert.inc [Both counters should be 0] 120---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 121CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 122Warnings: 123Note 1050 Table 't1' already exists 124SET AUTOCOMMIT = 0; 125# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC 126SET GTID_NEXT = 'AUTOMATIC'; 127error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 128DROP TEMPORARY TABLE t1; 129ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 130include/assert.inc [One warning/error should be generated.] 131include/assert.inc [It should be an Error, not a Warning.] 132include/assert.inc [Text should be "violates GTID consistency"] 133include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 134include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 135ROLLBACK; 136SET GTID_NEXT = 'AUTOMATIC'; 137include/assert.inc [Both counters should be 0] 138SET AUTOCOMMIT = 1; 139---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 140CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 141Warnings: 142Note 1050 Table 't1' already exists 143SET AUTOCOMMIT = 0; 144# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=AUTOMATIC 145SET GTID_NEXT = 'AUTOMATIC'; 146error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 147DROP TEMPORARY TABLE t1; 148ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 149include/assert.inc [One warning/error should be generated.] 150include/assert.inc [It should be an Error, not a Warning.] 151include/assert.inc [Text should be "violates GTID consistency"] 152include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 153include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 154ROLLBACK; 155SET GTID_NEXT = 'AUTOMATIC'; 156include/assert.inc [Both counters should be 0] 157SET AUTOCOMMIT = 1; 158DROP TEMPORARY TABLE IF EXISTS t1; 159######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=ON_PERMISSIVE GTID_NEXT=ANONYMOUS ######## 160---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 161# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS 162SET GTID_NEXT = 'ANONYMOUS'; 163BEGIN; 164[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 165include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 166include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 167[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 168include/assert.inc [No warning or error should be generated.] 169include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 170include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 171ROLLBACK; 172Warnings: 173Warning 1751 The creation of some temporary tables could not be rolled back. 174SET GTID_NEXT = 'AUTOMATIC'; 175include/assert.inc [Both counters should be 0] 176DROP TEMPORARY TABLE IF EXISTS t1; 177---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 178# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS 179SET GTID_NEXT = 'ANONYMOUS'; 180BEGIN; 181[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 182include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 183include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 184[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 185include/assert.inc [No warning or error should be generated.] 186include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 187include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 188ROLLBACK; 189Warnings: 190Warning 1751 The creation of some temporary tables could not be rolled back. 191SET GTID_NEXT = 'AUTOMATIC'; 192include/assert.inc [Both counters should be 0] 193DROP TEMPORARY TABLE IF EXISTS t1; 194---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 195SET AUTOCOMMIT = 0; 196# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS 197SET GTID_NEXT = 'ANONYMOUS'; 198[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 199include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 200include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 201[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 202include/assert.inc [No warning or error should be generated.] 203include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 204include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 205ROLLBACK; 206Warnings: 207Warning 1751 The creation of some temporary tables could not be rolled back. 208SET GTID_NEXT = 'AUTOMATIC'; 209include/assert.inc [Both counters should be 0] 210SET AUTOCOMMIT = 1; 211DROP TEMPORARY TABLE IF EXISTS t1; 212---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 213SET AUTOCOMMIT = 0; 214# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS 215SET GTID_NEXT = 'ANONYMOUS'; 216[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 217include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 218include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 219[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 220include/assert.inc [No warning or error should be generated.] 221include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 222include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 223ROLLBACK; 224Warnings: 225Warning 1751 The creation of some temporary tables could not be rolled back. 226SET GTID_NEXT = 'AUTOMATIC'; 227include/assert.inc [Both counters should be 0] 228SET AUTOCOMMIT = 1; 229DROP TEMPORARY TABLE IF EXISTS t1; 230---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 231CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 232# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS 233SET GTID_NEXT = 'ANONYMOUS'; 234BEGIN; 235[START] DROP TEMPORARY TABLE t1; 236include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 237include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 238[END] DROP TEMPORARY TABLE t1; 239include/assert.inc [No warning or error should be generated.] 240include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 241include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 242ROLLBACK; 243Warnings: 244Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 245SET GTID_NEXT = 'AUTOMATIC'; 246include/assert.inc [Both counters should be 0] 247---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 248CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 249# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS 250SET GTID_NEXT = 'ANONYMOUS'; 251BEGIN; 252[START] DROP TEMPORARY TABLE t1; 253include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 254include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 255[END] DROP TEMPORARY TABLE t1; 256include/assert.inc [No warning or error should be generated.] 257include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 258include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 259ROLLBACK; 260Warnings: 261Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 262SET GTID_NEXT = 'AUTOMATIC'; 263include/assert.inc [Both counters should be 0] 264---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 265CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 266SET AUTOCOMMIT = 0; 267# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS 268SET GTID_NEXT = 'ANONYMOUS'; 269[START] DROP TEMPORARY TABLE t1; 270include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 271include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 272[END] DROP TEMPORARY TABLE t1; 273include/assert.inc [No warning or error should be generated.] 274include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 275include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 276ROLLBACK; 277Warnings: 278Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 279SET GTID_NEXT = 'AUTOMATIC'; 280include/assert.inc [Both counters should be 0] 281SET AUTOCOMMIT = 1; 282---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 283CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 284SET AUTOCOMMIT = 0; 285# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=ANONYMOUS 286SET GTID_NEXT = 'ANONYMOUS'; 287[START] DROP TEMPORARY TABLE t1; 288include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 289include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 290[END] DROP TEMPORARY TABLE t1; 291include/assert.inc [No warning or error should be generated.] 292include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 293include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 294ROLLBACK; 295Warnings: 296Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 297SET GTID_NEXT = 'AUTOMATIC'; 298include/assert.inc [Both counters should be 0] 299SET AUTOCOMMIT = 1; 300DROP TEMPORARY TABLE IF EXISTS t1; 301Warnings: 302Note 1051 Unknown table 'test.t1' 303######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=ON_PERMISSIVE GTID_NEXT=GTID ######## 304---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 305# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID 306SET GTID_NEXT = 'GTID'; 307BEGIN; 308error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 309CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 310ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 311include/assert.inc [One warning/error should be generated.] 312include/assert.inc [It should be an Error, not a Warning.] 313include/assert.inc [Text should be "violates GTID consistency"] 314include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 315include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 316ROLLBACK; 317SET GTID_NEXT = 'AUTOMATIC'; 318include/assert.inc [Both counters should be 0] 319DROP TEMPORARY TABLE IF EXISTS t1; 320Warnings: 321Note 1051 Unknown table 'test.t1' 322---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 323# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID 324SET GTID_NEXT = 'GTID'; 325BEGIN; 326error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 327CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 328ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 329include/assert.inc [One warning/error should be generated.] 330include/assert.inc [It should be an Error, not a Warning.] 331include/assert.inc [Text should be "violates GTID consistency"] 332include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 333include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 334ROLLBACK; 335SET GTID_NEXT = 'AUTOMATIC'; 336include/assert.inc [Both counters should be 0] 337DROP TEMPORARY TABLE IF EXISTS t1; 338Warnings: 339Note 1051 Unknown table 'test.t1' 340---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 341SET AUTOCOMMIT = 0; 342# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID 343SET GTID_NEXT = 'GTID'; 344error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 345CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 346ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 347include/assert.inc [One warning/error should be generated.] 348include/assert.inc [It should be an Error, not a Warning.] 349include/assert.inc [Text should be "violates GTID consistency"] 350include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 351include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 352ROLLBACK; 353SET GTID_NEXT = 'AUTOMATIC'; 354include/assert.inc [Both counters should be 0] 355SET AUTOCOMMIT = 1; 356DROP TEMPORARY TABLE IF EXISTS t1; 357Warnings: 358Note 1051 Unknown table 'test.t1' 359---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 360SET AUTOCOMMIT = 0; 361# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID 362SET GTID_NEXT = 'GTID'; 363error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 364CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 365ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 366include/assert.inc [One warning/error should be generated.] 367include/assert.inc [It should be an Error, not a Warning.] 368include/assert.inc [Text should be "violates GTID consistency"] 369include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 370include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 371ROLLBACK; 372SET GTID_NEXT = 'AUTOMATIC'; 373include/assert.inc [Both counters should be 0] 374SET AUTOCOMMIT = 1; 375DROP TEMPORARY TABLE IF EXISTS t1; 376Warnings: 377Note 1051 Unknown table 'test.t1' 378---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 379CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 380# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID 381SET GTID_NEXT = 'GTID'; 382BEGIN; 383error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 384DROP TEMPORARY TABLE t1; 385ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 386include/assert.inc [One warning/error should be generated.] 387include/assert.inc [It should be an Error, not a Warning.] 388include/assert.inc [Text should be "violates GTID consistency"] 389include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 390include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 391ROLLBACK; 392SET GTID_NEXT = 'AUTOMATIC'; 393include/assert.inc [Both counters should be 0] 394---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 395CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 396Warnings: 397Note 1050 Table 't1' already exists 398# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID 399SET GTID_NEXT = 'GTID'; 400BEGIN; 401error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 402DROP TEMPORARY TABLE t1; 403ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 404include/assert.inc [One warning/error should be generated.] 405include/assert.inc [It should be an Error, not a Warning.] 406include/assert.inc [Text should be "violates GTID consistency"] 407include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 408include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 409ROLLBACK; 410SET GTID_NEXT = 'AUTOMATIC'; 411include/assert.inc [Both counters should be 0] 412---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 413CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 414Warnings: 415Note 1050 Table 't1' already exists 416SET AUTOCOMMIT = 0; 417# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID 418SET GTID_NEXT = 'GTID'; 419error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 420DROP TEMPORARY TABLE t1; 421ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 422include/assert.inc [One warning/error should be generated.] 423include/assert.inc [It should be an Error, not a Warning.] 424include/assert.inc [Text should be "violates GTID consistency"] 425include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 426include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 427ROLLBACK; 428SET GTID_NEXT = 'AUTOMATIC'; 429include/assert.inc [Both counters should be 0] 430SET AUTOCOMMIT = 1; 431---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 432CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 433Warnings: 434Note 1050 Table 't1' already exists 435SET AUTOCOMMIT = 0; 436# enforce_gtid_consistency=0 gtid_mode=2 gtid_next=GTID 437SET GTID_NEXT = 'GTID'; 438error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 439DROP TEMPORARY TABLE t1; 440ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 441include/assert.inc [One warning/error should be generated.] 442include/assert.inc [It should be an Error, not a Warning.] 443include/assert.inc [Text should be "violates GTID consistency"] 444include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 445include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 446ROLLBACK; 447SET GTID_NEXT = 'AUTOMATIC'; 448include/assert.inc [Both counters should be 0] 449SET AUTOCOMMIT = 1; 450DROP TEMPORARY TABLE IF EXISTS t1; 451SET GLOBAL GTID_MODE = 1; 452######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF_PERMISSIVE GTID_NEXT=AUTOMATIC ######## 453---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 454# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC 455SET GTID_NEXT = 'AUTOMATIC'; 456BEGIN; 457[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 458include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 459include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 460[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 461include/assert.inc [No warning or error should be generated.] 462include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 463include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 464ROLLBACK; 465Warnings: 466Warning 1751 The creation of some temporary tables could not be rolled back. 467SET GTID_NEXT = 'AUTOMATIC'; 468include/assert.inc [Both counters should be 0] 469DROP TEMPORARY TABLE IF EXISTS t1; 470---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 471# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC 472SET GTID_NEXT = 'AUTOMATIC'; 473BEGIN; 474[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 475include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 476include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 477[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 478include/assert.inc [No warning or error should be generated.] 479include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 480include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 481ROLLBACK; 482Warnings: 483Warning 1751 The creation of some temporary tables could not be rolled back. 484SET GTID_NEXT = 'AUTOMATIC'; 485include/assert.inc [Both counters should be 0] 486DROP TEMPORARY TABLE IF EXISTS t1; 487---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 488SET AUTOCOMMIT = 0; 489# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC 490SET GTID_NEXT = 'AUTOMATIC'; 491[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 492include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 493include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 494[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 495include/assert.inc [No warning or error should be generated.] 496include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 497include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 498ROLLBACK; 499Warnings: 500Warning 1751 The creation of some temporary tables could not be rolled back. 501SET GTID_NEXT = 'AUTOMATIC'; 502include/assert.inc [Both counters should be 0] 503SET AUTOCOMMIT = 1; 504DROP TEMPORARY TABLE IF EXISTS t1; 505---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 506SET AUTOCOMMIT = 0; 507# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC 508SET GTID_NEXT = 'AUTOMATIC'; 509[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 510include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 511include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 512[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 513include/assert.inc [No warning or error should be generated.] 514include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 515include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 516ROLLBACK; 517Warnings: 518Warning 1751 The creation of some temporary tables could not be rolled back. 519SET GTID_NEXT = 'AUTOMATIC'; 520include/assert.inc [Both counters should be 0] 521SET AUTOCOMMIT = 1; 522DROP TEMPORARY TABLE IF EXISTS t1; 523---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 524CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 525# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC 526SET GTID_NEXT = 'AUTOMATIC'; 527BEGIN; 528[START] DROP TEMPORARY TABLE t1; 529include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 530include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 531[END] DROP TEMPORARY TABLE t1; 532include/assert.inc [No warning or error should be generated.] 533include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 534include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 535ROLLBACK; 536Warnings: 537Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 538SET GTID_NEXT = 'AUTOMATIC'; 539include/assert.inc [Both counters should be 0] 540---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 541CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 542# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC 543SET GTID_NEXT = 'AUTOMATIC'; 544BEGIN; 545[START] DROP TEMPORARY TABLE t1; 546include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 547include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 548[END] DROP TEMPORARY TABLE t1; 549include/assert.inc [No warning or error should be generated.] 550include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 551include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 552ROLLBACK; 553Warnings: 554Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 555SET GTID_NEXT = 'AUTOMATIC'; 556include/assert.inc [Both counters should be 0] 557---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 558CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 559SET AUTOCOMMIT = 0; 560# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC 561SET GTID_NEXT = 'AUTOMATIC'; 562[START] DROP TEMPORARY TABLE t1; 563include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 564include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 565[END] DROP TEMPORARY TABLE t1; 566include/assert.inc [No warning or error should be generated.] 567include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 568include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 569ROLLBACK; 570Warnings: 571Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 572SET GTID_NEXT = 'AUTOMATIC'; 573include/assert.inc [Both counters should be 0] 574SET AUTOCOMMIT = 1; 575---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 576CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 577SET AUTOCOMMIT = 0; 578# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=AUTOMATIC 579SET GTID_NEXT = 'AUTOMATIC'; 580[START] DROP TEMPORARY TABLE t1; 581include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 582include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 583[END] DROP TEMPORARY TABLE t1; 584include/assert.inc [No warning or error should be generated.] 585include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 586include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 587ROLLBACK; 588Warnings: 589Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 590SET GTID_NEXT = 'AUTOMATIC'; 591include/assert.inc [Both counters should be 0] 592SET AUTOCOMMIT = 1; 593DROP TEMPORARY TABLE IF EXISTS t1; 594Warnings: 595Note 1051 Unknown table 'test.t1' 596######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF_PERMISSIVE GTID_NEXT=ANONYMOUS ######## 597---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 598# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS 599SET GTID_NEXT = 'ANONYMOUS'; 600BEGIN; 601[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 602include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 603include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 604[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 605include/assert.inc [No warning or error should be generated.] 606include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 607include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 608ROLLBACK; 609Warnings: 610Warning 1751 The creation of some temporary tables could not be rolled back. 611SET GTID_NEXT = 'AUTOMATIC'; 612include/assert.inc [Both counters should be 0] 613DROP TEMPORARY TABLE IF EXISTS t1; 614---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 615# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS 616SET GTID_NEXT = 'ANONYMOUS'; 617BEGIN; 618[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 619include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 620include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 621[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 622include/assert.inc [No warning or error should be generated.] 623include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 624include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 625ROLLBACK; 626Warnings: 627Warning 1751 The creation of some temporary tables could not be rolled back. 628SET GTID_NEXT = 'AUTOMATIC'; 629include/assert.inc [Both counters should be 0] 630DROP TEMPORARY TABLE IF EXISTS t1; 631---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 632SET AUTOCOMMIT = 0; 633# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS 634SET GTID_NEXT = 'ANONYMOUS'; 635[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 636include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 637include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 638[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 639include/assert.inc [No warning or error should be generated.] 640include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 641include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 642ROLLBACK; 643Warnings: 644Warning 1751 The creation of some temporary tables could not be rolled back. 645SET GTID_NEXT = 'AUTOMATIC'; 646include/assert.inc [Both counters should be 0] 647SET AUTOCOMMIT = 1; 648DROP TEMPORARY TABLE IF EXISTS t1; 649---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 650SET AUTOCOMMIT = 0; 651# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS 652SET GTID_NEXT = 'ANONYMOUS'; 653[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 654include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 655include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 656[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 657include/assert.inc [No warning or error should be generated.] 658include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 659include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 660ROLLBACK; 661Warnings: 662Warning 1751 The creation of some temporary tables could not be rolled back. 663SET GTID_NEXT = 'AUTOMATIC'; 664include/assert.inc [Both counters should be 0] 665SET AUTOCOMMIT = 1; 666DROP TEMPORARY TABLE IF EXISTS t1; 667---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 668CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 669# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS 670SET GTID_NEXT = 'ANONYMOUS'; 671BEGIN; 672[START] DROP TEMPORARY TABLE t1; 673include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 674include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 675[END] DROP TEMPORARY TABLE t1; 676include/assert.inc [No warning or error should be generated.] 677include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 678include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 679ROLLBACK; 680Warnings: 681Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 682SET GTID_NEXT = 'AUTOMATIC'; 683include/assert.inc [Both counters should be 0] 684---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 685CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 686# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS 687SET GTID_NEXT = 'ANONYMOUS'; 688BEGIN; 689[START] DROP TEMPORARY TABLE t1; 690include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 691include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 692[END] DROP TEMPORARY TABLE t1; 693include/assert.inc [No warning or error should be generated.] 694include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 695include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 696ROLLBACK; 697Warnings: 698Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 699SET GTID_NEXT = 'AUTOMATIC'; 700include/assert.inc [Both counters should be 0] 701---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 702CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 703SET AUTOCOMMIT = 0; 704# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS 705SET GTID_NEXT = 'ANONYMOUS'; 706[START] DROP TEMPORARY TABLE t1; 707include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 708include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 709[END] DROP TEMPORARY TABLE t1; 710include/assert.inc [No warning or error should be generated.] 711include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 712include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 713ROLLBACK; 714Warnings: 715Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 716SET GTID_NEXT = 'AUTOMATIC'; 717include/assert.inc [Both counters should be 0] 718SET AUTOCOMMIT = 1; 719---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 720CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 721SET AUTOCOMMIT = 0; 722# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=ANONYMOUS 723SET GTID_NEXT = 'ANONYMOUS'; 724[START] DROP TEMPORARY TABLE t1; 725include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 726include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 727[END] DROP TEMPORARY TABLE t1; 728include/assert.inc [No warning or error should be generated.] 729include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 730include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 731ROLLBACK; 732Warnings: 733Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 734SET GTID_NEXT = 'AUTOMATIC'; 735include/assert.inc [Both counters should be 0] 736SET AUTOCOMMIT = 1; 737DROP TEMPORARY TABLE IF EXISTS t1; 738Warnings: 739Note 1051 Unknown table 'test.t1' 740######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF_PERMISSIVE GTID_NEXT=GTID ######## 741---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 742# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID 743SET GTID_NEXT = 'GTID'; 744BEGIN; 745error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 746CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 747ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 748include/assert.inc [One warning/error should be generated.] 749include/assert.inc [It should be an Error, not a Warning.] 750include/assert.inc [Text should be "violates GTID consistency"] 751include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 752include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 753ROLLBACK; 754SET GTID_NEXT = 'AUTOMATIC'; 755include/assert.inc [Both counters should be 0] 756DROP TEMPORARY TABLE IF EXISTS t1; 757Warnings: 758Note 1051 Unknown table 'test.t1' 759---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 760# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID 761SET GTID_NEXT = 'GTID'; 762BEGIN; 763error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 764CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 765ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 766include/assert.inc [One warning/error should be generated.] 767include/assert.inc [It should be an Error, not a Warning.] 768include/assert.inc [Text should be "violates GTID consistency"] 769include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 770include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 771ROLLBACK; 772SET GTID_NEXT = 'AUTOMATIC'; 773include/assert.inc [Both counters should be 0] 774DROP TEMPORARY TABLE IF EXISTS t1; 775Warnings: 776Note 1051 Unknown table 'test.t1' 777---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 778SET AUTOCOMMIT = 0; 779# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID 780SET GTID_NEXT = 'GTID'; 781error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 782CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 783ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 784include/assert.inc [One warning/error should be generated.] 785include/assert.inc [It should be an Error, not a Warning.] 786include/assert.inc [Text should be "violates GTID consistency"] 787include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 788include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 789ROLLBACK; 790SET GTID_NEXT = 'AUTOMATIC'; 791include/assert.inc [Both counters should be 0] 792SET AUTOCOMMIT = 1; 793DROP TEMPORARY TABLE IF EXISTS t1; 794Warnings: 795Note 1051 Unknown table 'test.t1' 796---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 797SET AUTOCOMMIT = 0; 798# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID 799SET GTID_NEXT = 'GTID'; 800error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 801CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 802ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 803include/assert.inc [One warning/error should be generated.] 804include/assert.inc [It should be an Error, not a Warning.] 805include/assert.inc [Text should be "violates GTID consistency"] 806include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 807include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 808ROLLBACK; 809SET GTID_NEXT = 'AUTOMATIC'; 810include/assert.inc [Both counters should be 0] 811SET AUTOCOMMIT = 1; 812DROP TEMPORARY TABLE IF EXISTS t1; 813Warnings: 814Note 1051 Unknown table 'test.t1' 815---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 816CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 817# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID 818SET GTID_NEXT = 'GTID'; 819BEGIN; 820error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 821DROP TEMPORARY TABLE t1; 822ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 823include/assert.inc [One warning/error should be generated.] 824include/assert.inc [It should be an Error, not a Warning.] 825include/assert.inc [Text should be "violates GTID consistency"] 826include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 827include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 828ROLLBACK; 829SET GTID_NEXT = 'AUTOMATIC'; 830include/assert.inc [Both counters should be 0] 831---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 832CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 833Warnings: 834Note 1050 Table 't1' already exists 835# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID 836SET GTID_NEXT = 'GTID'; 837BEGIN; 838error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 839DROP TEMPORARY TABLE t1; 840ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 841include/assert.inc [One warning/error should be generated.] 842include/assert.inc [It should be an Error, not a Warning.] 843include/assert.inc [Text should be "violates GTID consistency"] 844include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 845include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 846ROLLBACK; 847SET GTID_NEXT = 'AUTOMATIC'; 848include/assert.inc [Both counters should be 0] 849---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 850CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 851Warnings: 852Note 1050 Table 't1' already exists 853SET AUTOCOMMIT = 0; 854# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID 855SET GTID_NEXT = 'GTID'; 856error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 857DROP TEMPORARY TABLE t1; 858ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 859include/assert.inc [One warning/error should be generated.] 860include/assert.inc [It should be an Error, not a Warning.] 861include/assert.inc [Text should be "violates GTID consistency"] 862include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 863include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 864ROLLBACK; 865SET GTID_NEXT = 'AUTOMATIC'; 866include/assert.inc [Both counters should be 0] 867SET AUTOCOMMIT = 1; 868---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 869CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 870Warnings: 871Note 1050 Table 't1' already exists 872SET AUTOCOMMIT = 0; 873# enforce_gtid_consistency=0 gtid_mode=1 gtid_next=GTID 874SET GTID_NEXT = 'GTID'; 875error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 876DROP TEMPORARY TABLE t1; 877ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 878include/assert.inc [One warning/error should be generated.] 879include/assert.inc [It should be an Error, not a Warning.] 880include/assert.inc [Text should be "violates GTID consistency"] 881include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 882include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 883ROLLBACK; 884SET GTID_NEXT = 'AUTOMATIC'; 885include/assert.inc [Both counters should be 0] 886SET AUTOCOMMIT = 1; 887DROP TEMPORARY TABLE IF EXISTS t1; 888SET GLOBAL GTID_MODE = 0; 889######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF GTID_NEXT=AUTOMATIC ######## 890---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 891# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC 892SET GTID_NEXT = 'AUTOMATIC'; 893BEGIN; 894[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 895include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 896include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 897[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 898include/assert.inc [No warning or error should be generated.] 899include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 900include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 901ROLLBACK; 902Warnings: 903Warning 1751 The creation of some temporary tables could not be rolled back. 904SET GTID_NEXT = 'AUTOMATIC'; 905include/assert.inc [Both counters should be 0] 906DROP TEMPORARY TABLE IF EXISTS t1; 907---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 908# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC 909SET GTID_NEXT = 'AUTOMATIC'; 910BEGIN; 911[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 912include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 913include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 914[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 915include/assert.inc [No warning or error should be generated.] 916include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 917include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 918ROLLBACK; 919Warnings: 920Warning 1751 The creation of some temporary tables could not be rolled back. 921SET GTID_NEXT = 'AUTOMATIC'; 922include/assert.inc [Both counters should be 0] 923DROP TEMPORARY TABLE IF EXISTS t1; 924---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 925SET AUTOCOMMIT = 0; 926# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC 927SET GTID_NEXT = 'AUTOMATIC'; 928[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 929include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 930include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 931[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 932include/assert.inc [No warning or error should be generated.] 933include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 934include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 935ROLLBACK; 936Warnings: 937Warning 1751 The creation of some temporary tables could not be rolled back. 938SET GTID_NEXT = 'AUTOMATIC'; 939include/assert.inc [Both counters should be 0] 940SET AUTOCOMMIT = 1; 941DROP TEMPORARY TABLE IF EXISTS t1; 942---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 943SET AUTOCOMMIT = 0; 944# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC 945SET GTID_NEXT = 'AUTOMATIC'; 946[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 947include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 948include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 949[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 950include/assert.inc [No warning or error should be generated.] 951include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 952include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 953ROLLBACK; 954Warnings: 955Warning 1751 The creation of some temporary tables could not be rolled back. 956SET GTID_NEXT = 'AUTOMATIC'; 957include/assert.inc [Both counters should be 0] 958SET AUTOCOMMIT = 1; 959DROP TEMPORARY TABLE IF EXISTS t1; 960---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 961CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 962# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC 963SET GTID_NEXT = 'AUTOMATIC'; 964BEGIN; 965[START] DROP TEMPORARY TABLE t1; 966include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 967include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 968[END] DROP TEMPORARY TABLE t1; 969include/assert.inc [No warning or error should be generated.] 970include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 971include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 972ROLLBACK; 973Warnings: 974Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 975SET GTID_NEXT = 'AUTOMATIC'; 976include/assert.inc [Both counters should be 0] 977---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 978CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 979# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC 980SET GTID_NEXT = 'AUTOMATIC'; 981BEGIN; 982[START] DROP TEMPORARY TABLE t1; 983include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 984include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 985[END] DROP TEMPORARY TABLE t1; 986include/assert.inc [No warning or error should be generated.] 987include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 988include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 989ROLLBACK; 990Warnings: 991Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 992SET GTID_NEXT = 'AUTOMATIC'; 993include/assert.inc [Both counters should be 0] 994---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 995CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 996SET AUTOCOMMIT = 0; 997# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC 998SET GTID_NEXT = 'AUTOMATIC'; 999[START] DROP TEMPORARY TABLE t1; 1000include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1001include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1002[END] DROP TEMPORARY TABLE t1; 1003include/assert.inc [No warning or error should be generated.] 1004include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1005include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1006ROLLBACK; 1007Warnings: 1008Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 1009SET GTID_NEXT = 'AUTOMATIC'; 1010include/assert.inc [Both counters should be 0] 1011SET AUTOCOMMIT = 1; 1012---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1013CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1014SET AUTOCOMMIT = 0; 1015# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=AUTOMATIC 1016SET GTID_NEXT = 'AUTOMATIC'; 1017[START] DROP TEMPORARY TABLE t1; 1018include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1019include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1020[END] DROP TEMPORARY TABLE t1; 1021include/assert.inc [No warning or error should be generated.] 1022include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1023include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1024ROLLBACK; 1025Warnings: 1026Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 1027SET GTID_NEXT = 'AUTOMATIC'; 1028include/assert.inc [Both counters should be 0] 1029SET AUTOCOMMIT = 1; 1030DROP TEMPORARY TABLE IF EXISTS t1; 1031Warnings: 1032Note 1051 Unknown table 'test.t1' 1033######## ENFORCE_GTID_CONSISTENCY=OFF GTID_MODE=OFF GTID_NEXT=ANONYMOUS ######## 1034---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 1035# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS 1036SET GTID_NEXT = 'ANONYMOUS'; 1037BEGIN; 1038[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1039include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1040include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1041[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1042include/assert.inc [No warning or error should be generated.] 1043include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1044include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1045ROLLBACK; 1046Warnings: 1047Warning 1751 The creation of some temporary tables could not be rolled back. 1048SET GTID_NEXT = 'AUTOMATIC'; 1049include/assert.inc [Both counters should be 0] 1050DROP TEMPORARY TABLE IF EXISTS t1; 1051---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 1052# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS 1053SET GTID_NEXT = 'ANONYMOUS'; 1054BEGIN; 1055[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1056include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1057include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1058[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1059include/assert.inc [No warning or error should be generated.] 1060include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1061include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 1062ROLLBACK; 1063Warnings: 1064Warning 1751 The creation of some temporary tables could not be rolled back. 1065SET GTID_NEXT = 'AUTOMATIC'; 1066include/assert.inc [Both counters should be 0] 1067DROP TEMPORARY TABLE IF EXISTS t1; 1068---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1069SET AUTOCOMMIT = 0; 1070# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS 1071SET GTID_NEXT = 'ANONYMOUS'; 1072[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1073include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1074include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1075[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1076include/assert.inc [No warning or error should be generated.] 1077include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1078include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1079ROLLBACK; 1080Warnings: 1081Warning 1751 The creation of some temporary tables could not be rolled back. 1082SET GTID_NEXT = 'AUTOMATIC'; 1083include/assert.inc [Both counters should be 0] 1084SET AUTOCOMMIT = 1; 1085DROP TEMPORARY TABLE IF EXISTS t1; 1086---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1087SET AUTOCOMMIT = 0; 1088# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS 1089SET GTID_NEXT = 'ANONYMOUS'; 1090[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1091include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1092include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1093[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1094include/assert.inc [No warning or error should be generated.] 1095include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1096include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 1097ROLLBACK; 1098Warnings: 1099Warning 1751 The creation of some temporary tables could not be rolled back. 1100SET GTID_NEXT = 'AUTOMATIC'; 1101include/assert.inc [Both counters should be 0] 1102SET AUTOCOMMIT = 1; 1103DROP TEMPORARY TABLE IF EXISTS t1; 1104---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 1105CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 1106# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS 1107SET GTID_NEXT = 'ANONYMOUS'; 1108BEGIN; 1109[START] DROP TEMPORARY TABLE t1; 1110include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1111include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1112[END] DROP TEMPORARY TABLE t1; 1113include/assert.inc [No warning or error should be generated.] 1114include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1115include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1116ROLLBACK; 1117Warnings: 1118Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 1119SET GTID_NEXT = 'AUTOMATIC'; 1120include/assert.inc [Both counters should be 0] 1121---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 1122CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1123# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS 1124SET GTID_NEXT = 'ANONYMOUS'; 1125BEGIN; 1126[START] DROP TEMPORARY TABLE t1; 1127include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1128include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1129[END] DROP TEMPORARY TABLE t1; 1130include/assert.inc [No warning or error should be generated.] 1131include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1132include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1133ROLLBACK; 1134Warnings: 1135Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 1136SET GTID_NEXT = 'AUTOMATIC'; 1137include/assert.inc [Both counters should be 0] 1138---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1139CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 1140SET AUTOCOMMIT = 0; 1141# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS 1142SET GTID_NEXT = 'ANONYMOUS'; 1143[START] DROP TEMPORARY TABLE t1; 1144include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1145include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1146[END] DROP TEMPORARY TABLE t1; 1147include/assert.inc [No warning or error should be generated.] 1148include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1149include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1150ROLLBACK; 1151Warnings: 1152Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 1153SET GTID_NEXT = 'AUTOMATIC'; 1154include/assert.inc [Both counters should be 0] 1155SET AUTOCOMMIT = 1; 1156---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1157CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1158SET AUTOCOMMIT = 0; 1159# enforce_gtid_consistency=0 gtid_mode=0 gtid_next=ANONYMOUS 1160SET GTID_NEXT = 'ANONYMOUS'; 1161[START] DROP TEMPORARY TABLE t1; 1162include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1163include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 1164[END] DROP TEMPORARY TABLE t1; 1165include/assert.inc [No warning or error should be generated.] 1166include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1167include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1168ROLLBACK; 1169Warnings: 1170Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 1171SET GTID_NEXT = 'AUTOMATIC'; 1172include/assert.inc [Both counters should be 0] 1173SET AUTOCOMMIT = 1; 1174DROP TEMPORARY TABLE IF EXISTS t1; 1175Warnings: 1176Note 1051 Unknown table 'test.t1' 1177SET GLOBAL ENFORCE_GTID_CONSISTENCY = 1; 1178SET GLOBAL GTID_MODE = OFF_PERMISSIVE; 1179SET GLOBAL GTID_MODE = ON_PERMISSIVE; 1180SET GLOBAL GTID_MODE = ON; 1181SET GLOBAL GTID_MODE = 3; 1182######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON GTID_NEXT=AUTOMATIC ######## 1183---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 1184# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC 1185SET GTID_NEXT = 'AUTOMATIC'; 1186BEGIN; 1187error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1188CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1189ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1190include/assert.inc [One warning/error should be generated.] 1191include/assert.inc [It should be an Error, not a Warning.] 1192include/assert.inc [Text should be "violates GTID consistency"] 1193include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1194include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1195ROLLBACK; 1196SET GTID_NEXT = 'AUTOMATIC'; 1197include/assert.inc [Both counters should be 0] 1198DROP TEMPORARY TABLE IF EXISTS t1; 1199Warnings: 1200Note 1051 Unknown table 'test.t1' 1201---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 1202# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC 1203SET GTID_NEXT = 'AUTOMATIC'; 1204BEGIN; 1205error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1206CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1207ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1208include/assert.inc [One warning/error should be generated.] 1209include/assert.inc [It should be an Error, not a Warning.] 1210include/assert.inc [Text should be "violates GTID consistency"] 1211include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 1212include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1213ROLLBACK; 1214SET GTID_NEXT = 'AUTOMATIC'; 1215include/assert.inc [Both counters should be 0] 1216DROP TEMPORARY TABLE IF EXISTS t1; 1217Warnings: 1218Note 1051 Unknown table 'test.t1' 1219---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1220SET AUTOCOMMIT = 0; 1221# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC 1222SET GTID_NEXT = 'AUTOMATIC'; 1223error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1224CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1225ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1226include/assert.inc [One warning/error should be generated.] 1227include/assert.inc [It should be an Error, not a Warning.] 1228include/assert.inc [Text should be "violates GTID consistency"] 1229include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1230include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1231ROLLBACK; 1232SET GTID_NEXT = 'AUTOMATIC'; 1233include/assert.inc [Both counters should be 0] 1234SET AUTOCOMMIT = 1; 1235DROP TEMPORARY TABLE IF EXISTS t1; 1236Warnings: 1237Note 1051 Unknown table 'test.t1' 1238---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1239SET AUTOCOMMIT = 0; 1240# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC 1241SET GTID_NEXT = 'AUTOMATIC'; 1242error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1243CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1244ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1245include/assert.inc [One warning/error should be generated.] 1246include/assert.inc [It should be an Error, not a Warning.] 1247include/assert.inc [Text should be "violates GTID consistency"] 1248include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 1249include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1250ROLLBACK; 1251SET GTID_NEXT = 'AUTOMATIC'; 1252include/assert.inc [Both counters should be 0] 1253SET AUTOCOMMIT = 1; 1254DROP TEMPORARY TABLE IF EXISTS t1; 1255Warnings: 1256Note 1051 Unknown table 'test.t1' 1257---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 1258CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 1259# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC 1260SET GTID_NEXT = 'AUTOMATIC'; 1261BEGIN; 1262error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1263DROP TEMPORARY TABLE t1; 1264ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1265include/assert.inc [One warning/error should be generated.] 1266include/assert.inc [It should be an Error, not a Warning.] 1267include/assert.inc [Text should be "violates GTID consistency"] 1268include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1269include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1270ROLLBACK; 1271SET GTID_NEXT = 'AUTOMATIC'; 1272include/assert.inc [Both counters should be 0] 1273---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 1274CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1275Warnings: 1276Note 1050 Table 't1' already exists 1277# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC 1278SET GTID_NEXT = 'AUTOMATIC'; 1279BEGIN; 1280error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1281DROP TEMPORARY TABLE t1; 1282ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1283include/assert.inc [One warning/error should be generated.] 1284include/assert.inc [It should be an Error, not a Warning.] 1285include/assert.inc [Text should be "violates GTID consistency"] 1286include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1287include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1288ROLLBACK; 1289SET GTID_NEXT = 'AUTOMATIC'; 1290include/assert.inc [Both counters should be 0] 1291---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1292CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 1293Warnings: 1294Note 1050 Table 't1' already exists 1295SET AUTOCOMMIT = 0; 1296# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC 1297SET GTID_NEXT = 'AUTOMATIC'; 1298error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1299DROP TEMPORARY TABLE t1; 1300ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1301include/assert.inc [One warning/error should be generated.] 1302include/assert.inc [It should be an Error, not a Warning.] 1303include/assert.inc [Text should be "violates GTID consistency"] 1304include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1305include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1306ROLLBACK; 1307SET GTID_NEXT = 'AUTOMATIC'; 1308include/assert.inc [Both counters should be 0] 1309SET AUTOCOMMIT = 1; 1310---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1311CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1312Warnings: 1313Note 1050 Table 't1' already exists 1314SET AUTOCOMMIT = 0; 1315# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=AUTOMATIC 1316SET GTID_NEXT = 'AUTOMATIC'; 1317error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1318DROP TEMPORARY TABLE t1; 1319ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1320include/assert.inc [One warning/error should be generated.] 1321include/assert.inc [It should be an Error, not a Warning.] 1322include/assert.inc [Text should be "violates GTID consistency"] 1323include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1324include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1325ROLLBACK; 1326SET GTID_NEXT = 'AUTOMATIC'; 1327include/assert.inc [Both counters should be 0] 1328SET AUTOCOMMIT = 1; 1329DROP TEMPORARY TABLE IF EXISTS t1; 1330######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON GTID_NEXT=GTID ######## 1331---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 1332# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID 1333SET GTID_NEXT = 'GTID'; 1334BEGIN; 1335error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1336CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1337ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1338include/assert.inc [One warning/error should be generated.] 1339include/assert.inc [It should be an Error, not a Warning.] 1340include/assert.inc [Text should be "violates GTID consistency"] 1341include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1342include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1343ROLLBACK; 1344SET GTID_NEXT = 'AUTOMATIC'; 1345include/assert.inc [Both counters should be 0] 1346DROP TEMPORARY TABLE IF EXISTS t1; 1347Warnings: 1348Note 1051 Unknown table 'test.t1' 1349---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 1350# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID 1351SET GTID_NEXT = 'GTID'; 1352BEGIN; 1353error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1354CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1355ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1356include/assert.inc [One warning/error should be generated.] 1357include/assert.inc [It should be an Error, not a Warning.] 1358include/assert.inc [Text should be "violates GTID consistency"] 1359include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1360include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1361ROLLBACK; 1362SET GTID_NEXT = 'AUTOMATIC'; 1363include/assert.inc [Both counters should be 0] 1364DROP TEMPORARY TABLE IF EXISTS t1; 1365Warnings: 1366Note 1051 Unknown table 'test.t1' 1367---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1368SET AUTOCOMMIT = 0; 1369# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID 1370SET GTID_NEXT = 'GTID'; 1371error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1372CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1373ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1374include/assert.inc [One warning/error should be generated.] 1375include/assert.inc [It should be an Error, not a Warning.] 1376include/assert.inc [Text should be "violates GTID consistency"] 1377include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1378include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1379ROLLBACK; 1380SET GTID_NEXT = 'AUTOMATIC'; 1381include/assert.inc [Both counters should be 0] 1382SET AUTOCOMMIT = 1; 1383DROP TEMPORARY TABLE IF EXISTS t1; 1384Warnings: 1385Note 1051 Unknown table 'test.t1' 1386---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1387SET AUTOCOMMIT = 0; 1388# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID 1389SET GTID_NEXT = 'GTID'; 1390error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1391CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1392ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1393include/assert.inc [One warning/error should be generated.] 1394include/assert.inc [It should be an Error, not a Warning.] 1395include/assert.inc [Text should be "violates GTID consistency"] 1396include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1397include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1398ROLLBACK; 1399SET GTID_NEXT = 'AUTOMATIC'; 1400include/assert.inc [Both counters should be 0] 1401SET AUTOCOMMIT = 1; 1402DROP TEMPORARY TABLE IF EXISTS t1; 1403Warnings: 1404Note 1051 Unknown table 'test.t1' 1405---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 1406CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 1407# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID 1408SET GTID_NEXT = 'GTID'; 1409BEGIN; 1410error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1411DROP TEMPORARY TABLE t1; 1412ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1413include/assert.inc [One warning/error should be generated.] 1414include/assert.inc [It should be an Error, not a Warning.] 1415include/assert.inc [Text should be "violates GTID consistency"] 1416include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1417include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1418ROLLBACK; 1419SET GTID_NEXT = 'AUTOMATIC'; 1420include/assert.inc [Both counters should be 0] 1421---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 1422CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1423Warnings: 1424Note 1050 Table 't1' already exists 1425# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID 1426SET GTID_NEXT = 'GTID'; 1427BEGIN; 1428error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1429DROP TEMPORARY TABLE t1; 1430ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1431include/assert.inc [One warning/error should be generated.] 1432include/assert.inc [It should be an Error, not a Warning.] 1433include/assert.inc [Text should be "violates GTID consistency"] 1434include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1435include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1436ROLLBACK; 1437SET GTID_NEXT = 'AUTOMATIC'; 1438include/assert.inc [Both counters should be 0] 1439---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1440CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 1441Warnings: 1442Note 1050 Table 't1' already exists 1443SET AUTOCOMMIT = 0; 1444# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID 1445SET GTID_NEXT = 'GTID'; 1446error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1447DROP TEMPORARY TABLE t1; 1448ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1449include/assert.inc [One warning/error should be generated.] 1450include/assert.inc [It should be an Error, not a Warning.] 1451include/assert.inc [Text should be "violates GTID consistency"] 1452include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1453include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1454ROLLBACK; 1455SET GTID_NEXT = 'AUTOMATIC'; 1456include/assert.inc [Both counters should be 0] 1457SET AUTOCOMMIT = 1; 1458---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1459CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1460Warnings: 1461Note 1050 Table 't1' already exists 1462SET AUTOCOMMIT = 0; 1463# enforce_gtid_consistency=1 gtid_mode=3 gtid_next=GTID 1464SET GTID_NEXT = 'GTID'; 1465error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1466DROP TEMPORARY TABLE t1; 1467ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1468include/assert.inc [One warning/error should be generated.] 1469include/assert.inc [It should be an Error, not a Warning.] 1470include/assert.inc [Text should be "violates GTID consistency"] 1471include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1472include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1473ROLLBACK; 1474SET GTID_NEXT = 'AUTOMATIC'; 1475include/assert.inc [Both counters should be 0] 1476SET AUTOCOMMIT = 1; 1477DROP TEMPORARY TABLE IF EXISTS t1; 1478SET GLOBAL GTID_MODE = 2; 1479######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON_PERMISSIVE GTID_NEXT=AUTOMATIC ######## 1480---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 1481# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC 1482SET GTID_NEXT = 'AUTOMATIC'; 1483BEGIN; 1484error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1485CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1486ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1487include/assert.inc [One warning/error should be generated.] 1488include/assert.inc [It should be an Error, not a Warning.] 1489include/assert.inc [Text should be "violates GTID consistency"] 1490include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1491include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1492ROLLBACK; 1493SET GTID_NEXT = 'AUTOMATIC'; 1494include/assert.inc [Both counters should be 0] 1495DROP TEMPORARY TABLE IF EXISTS t1; 1496Warnings: 1497Note 1051 Unknown table 'test.t1' 1498---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 1499# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC 1500SET GTID_NEXT = 'AUTOMATIC'; 1501BEGIN; 1502error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1503CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1504ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1505include/assert.inc [One warning/error should be generated.] 1506include/assert.inc [It should be an Error, not a Warning.] 1507include/assert.inc [Text should be "violates GTID consistency"] 1508include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 1509include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1510ROLLBACK; 1511SET GTID_NEXT = 'AUTOMATIC'; 1512include/assert.inc [Both counters should be 0] 1513DROP TEMPORARY TABLE IF EXISTS t1; 1514Warnings: 1515Note 1051 Unknown table 'test.t1' 1516---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1517SET AUTOCOMMIT = 0; 1518# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC 1519SET GTID_NEXT = 'AUTOMATIC'; 1520error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1521CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1522ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1523include/assert.inc [One warning/error should be generated.] 1524include/assert.inc [It should be an Error, not a Warning.] 1525include/assert.inc [Text should be "violates GTID consistency"] 1526include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1527include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1528ROLLBACK; 1529SET GTID_NEXT = 'AUTOMATIC'; 1530include/assert.inc [Both counters should be 0] 1531SET AUTOCOMMIT = 1; 1532DROP TEMPORARY TABLE IF EXISTS t1; 1533Warnings: 1534Note 1051 Unknown table 'test.t1' 1535---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1536SET AUTOCOMMIT = 0; 1537# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC 1538SET GTID_NEXT = 'AUTOMATIC'; 1539error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1540CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1541ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1542include/assert.inc [One warning/error should be generated.] 1543include/assert.inc [It should be an Error, not a Warning.] 1544include/assert.inc [Text should be "violates GTID consistency"] 1545include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 1546include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1547ROLLBACK; 1548SET GTID_NEXT = 'AUTOMATIC'; 1549include/assert.inc [Both counters should be 0] 1550SET AUTOCOMMIT = 1; 1551DROP TEMPORARY TABLE IF EXISTS t1; 1552Warnings: 1553Note 1051 Unknown table 'test.t1' 1554---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 1555CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 1556# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC 1557SET GTID_NEXT = 'AUTOMATIC'; 1558BEGIN; 1559error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1560DROP TEMPORARY TABLE t1; 1561ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1562include/assert.inc [One warning/error should be generated.] 1563include/assert.inc [It should be an Error, not a Warning.] 1564include/assert.inc [Text should be "violates GTID consistency"] 1565include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1566include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1567ROLLBACK; 1568SET GTID_NEXT = 'AUTOMATIC'; 1569include/assert.inc [Both counters should be 0] 1570---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 1571CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1572Warnings: 1573Note 1050 Table 't1' already exists 1574# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC 1575SET GTID_NEXT = 'AUTOMATIC'; 1576BEGIN; 1577error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1578DROP TEMPORARY TABLE t1; 1579ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1580include/assert.inc [One warning/error should be generated.] 1581include/assert.inc [It should be an Error, not a Warning.] 1582include/assert.inc [Text should be "violates GTID consistency"] 1583include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1584include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1585ROLLBACK; 1586SET GTID_NEXT = 'AUTOMATIC'; 1587include/assert.inc [Both counters should be 0] 1588---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1589CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 1590Warnings: 1591Note 1050 Table 't1' already exists 1592SET AUTOCOMMIT = 0; 1593# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC 1594SET GTID_NEXT = 'AUTOMATIC'; 1595error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1596DROP TEMPORARY TABLE t1; 1597ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1598include/assert.inc [One warning/error should be generated.] 1599include/assert.inc [It should be an Error, not a Warning.] 1600include/assert.inc [Text should be "violates GTID consistency"] 1601include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1602include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1603ROLLBACK; 1604SET GTID_NEXT = 'AUTOMATIC'; 1605include/assert.inc [Both counters should be 0] 1606SET AUTOCOMMIT = 1; 1607---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1608CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1609Warnings: 1610Note 1050 Table 't1' already exists 1611SET AUTOCOMMIT = 0; 1612# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=AUTOMATIC 1613SET GTID_NEXT = 'AUTOMATIC'; 1614error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1615DROP TEMPORARY TABLE t1; 1616ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1617include/assert.inc [One warning/error should be generated.] 1618include/assert.inc [It should be an Error, not a Warning.] 1619include/assert.inc [Text should be "violates GTID consistency"] 1620include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1621include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1622ROLLBACK; 1623SET GTID_NEXT = 'AUTOMATIC'; 1624include/assert.inc [Both counters should be 0] 1625SET AUTOCOMMIT = 1; 1626DROP TEMPORARY TABLE IF EXISTS t1; 1627######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON_PERMISSIVE GTID_NEXT=ANONYMOUS ######## 1628---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 1629# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS 1630SET GTID_NEXT = 'ANONYMOUS'; 1631BEGIN; 1632error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1633CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1634ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1635include/assert.inc [One warning/error should be generated.] 1636include/assert.inc [It should be an Error, not a Warning.] 1637include/assert.inc [Text should be "violates GTID consistency"] 1638include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1639include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1640ROLLBACK; 1641SET GTID_NEXT = 'AUTOMATIC'; 1642include/assert.inc [Both counters should be 0] 1643DROP TEMPORARY TABLE IF EXISTS t1; 1644Warnings: 1645Note 1051 Unknown table 'test.t1' 1646---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 1647# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS 1648SET GTID_NEXT = 'ANONYMOUS'; 1649BEGIN; 1650error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1651CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1652ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1653include/assert.inc [One warning/error should be generated.] 1654include/assert.inc [It should be an Error, not a Warning.] 1655include/assert.inc [Text should be "violates GTID consistency"] 1656include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1657include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 1658ROLLBACK; 1659SET GTID_NEXT = 'AUTOMATIC'; 1660include/assert.inc [Both counters should be 0] 1661DROP TEMPORARY TABLE IF EXISTS t1; 1662Warnings: 1663Note 1051 Unknown table 'test.t1' 1664---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1665SET AUTOCOMMIT = 0; 1666# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS 1667SET GTID_NEXT = 'ANONYMOUS'; 1668error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1669CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1670ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1671include/assert.inc [One warning/error should be generated.] 1672include/assert.inc [It should be an Error, not a Warning.] 1673include/assert.inc [Text should be "violates GTID consistency"] 1674include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1675include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1676ROLLBACK; 1677SET GTID_NEXT = 'AUTOMATIC'; 1678include/assert.inc [Both counters should be 0] 1679SET AUTOCOMMIT = 1; 1680DROP TEMPORARY TABLE IF EXISTS t1; 1681Warnings: 1682Note 1051 Unknown table 'test.t1' 1683---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1684SET AUTOCOMMIT = 0; 1685# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS 1686SET GTID_NEXT = 'ANONYMOUS'; 1687error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1688CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1689ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1690include/assert.inc [One warning/error should be generated.] 1691include/assert.inc [It should be an Error, not a Warning.] 1692include/assert.inc [Text should be "violates GTID consistency"] 1693include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1694include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 1695ROLLBACK; 1696SET GTID_NEXT = 'AUTOMATIC'; 1697include/assert.inc [Both counters should be 0] 1698SET AUTOCOMMIT = 1; 1699DROP TEMPORARY TABLE IF EXISTS t1; 1700Warnings: 1701Note 1051 Unknown table 'test.t1' 1702---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 1703CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 1704# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS 1705SET GTID_NEXT = 'ANONYMOUS'; 1706BEGIN; 1707error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1708DROP TEMPORARY TABLE t1; 1709ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1710include/assert.inc [One warning/error should be generated.] 1711include/assert.inc [It should be an Error, not a Warning.] 1712include/assert.inc [Text should be "violates GTID consistency"] 1713include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1714include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1715ROLLBACK; 1716SET GTID_NEXT = 'AUTOMATIC'; 1717include/assert.inc [Both counters should be 0] 1718---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 1719CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1720Warnings: 1721Note 1050 Table 't1' already exists 1722# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS 1723SET GTID_NEXT = 'ANONYMOUS'; 1724BEGIN; 1725error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1726DROP TEMPORARY TABLE t1; 1727ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1728include/assert.inc [One warning/error should be generated.] 1729include/assert.inc [It should be an Error, not a Warning.] 1730include/assert.inc [Text should be "violates GTID consistency"] 1731include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1732include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1733ROLLBACK; 1734SET GTID_NEXT = 'AUTOMATIC'; 1735include/assert.inc [Both counters should be 0] 1736---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1737CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 1738Warnings: 1739Note 1050 Table 't1' already exists 1740SET AUTOCOMMIT = 0; 1741# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS 1742SET GTID_NEXT = 'ANONYMOUS'; 1743error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1744DROP TEMPORARY TABLE t1; 1745ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1746include/assert.inc [One warning/error should be generated.] 1747include/assert.inc [It should be an Error, not a Warning.] 1748include/assert.inc [Text should be "violates GTID consistency"] 1749include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1750include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1751ROLLBACK; 1752SET GTID_NEXT = 'AUTOMATIC'; 1753include/assert.inc [Both counters should be 0] 1754SET AUTOCOMMIT = 1; 1755---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1756CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1757Warnings: 1758Note 1050 Table 't1' already exists 1759SET AUTOCOMMIT = 0; 1760# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=ANONYMOUS 1761SET GTID_NEXT = 'ANONYMOUS'; 1762error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1763DROP TEMPORARY TABLE t1; 1764ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1765include/assert.inc [One warning/error should be generated.] 1766include/assert.inc [It should be an Error, not a Warning.] 1767include/assert.inc [Text should be "violates GTID consistency"] 1768include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1769include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1770ROLLBACK; 1771SET GTID_NEXT = 'AUTOMATIC'; 1772include/assert.inc [Both counters should be 0] 1773SET AUTOCOMMIT = 1; 1774DROP TEMPORARY TABLE IF EXISTS t1; 1775######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=ON_PERMISSIVE GTID_NEXT=GTID ######## 1776---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 1777# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID 1778SET GTID_NEXT = 'GTID'; 1779BEGIN; 1780error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1781CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1782ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1783include/assert.inc [One warning/error should be generated.] 1784include/assert.inc [It should be an Error, not a Warning.] 1785include/assert.inc [Text should be "violates GTID consistency"] 1786include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1787include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1788ROLLBACK; 1789SET GTID_NEXT = 'AUTOMATIC'; 1790include/assert.inc [Both counters should be 0] 1791DROP TEMPORARY TABLE IF EXISTS t1; 1792Warnings: 1793Note 1051 Unknown table 'test.t1' 1794---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 1795# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID 1796SET GTID_NEXT = 'GTID'; 1797BEGIN; 1798error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1799CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1800ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1801include/assert.inc [One warning/error should be generated.] 1802include/assert.inc [It should be an Error, not a Warning.] 1803include/assert.inc [Text should be "violates GTID consistency"] 1804include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1805include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1806ROLLBACK; 1807SET GTID_NEXT = 'AUTOMATIC'; 1808include/assert.inc [Both counters should be 0] 1809DROP TEMPORARY TABLE IF EXISTS t1; 1810Warnings: 1811Note 1051 Unknown table 'test.t1' 1812---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1813SET AUTOCOMMIT = 0; 1814# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID 1815SET GTID_NEXT = 'GTID'; 1816error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1817CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1818ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1819include/assert.inc [One warning/error should be generated.] 1820include/assert.inc [It should be an Error, not a Warning.] 1821include/assert.inc [Text should be "violates GTID consistency"] 1822include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1823include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1824ROLLBACK; 1825SET GTID_NEXT = 'AUTOMATIC'; 1826include/assert.inc [Both counters should be 0] 1827SET AUTOCOMMIT = 1; 1828DROP TEMPORARY TABLE IF EXISTS t1; 1829Warnings: 1830Note 1051 Unknown table 'test.t1' 1831---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1832SET AUTOCOMMIT = 0; 1833# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID 1834SET GTID_NEXT = 'GTID'; 1835error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1836CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1837ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1838include/assert.inc [One warning/error should be generated.] 1839include/assert.inc [It should be an Error, not a Warning.] 1840include/assert.inc [Text should be "violates GTID consistency"] 1841include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1842include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1843ROLLBACK; 1844SET GTID_NEXT = 'AUTOMATIC'; 1845include/assert.inc [Both counters should be 0] 1846SET AUTOCOMMIT = 1; 1847DROP TEMPORARY TABLE IF EXISTS t1; 1848Warnings: 1849Note 1051 Unknown table 'test.t1' 1850---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 1851CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 1852# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID 1853SET GTID_NEXT = 'GTID'; 1854BEGIN; 1855error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1856DROP TEMPORARY TABLE t1; 1857ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1858include/assert.inc [One warning/error should be generated.] 1859include/assert.inc [It should be an Error, not a Warning.] 1860include/assert.inc [Text should be "violates GTID consistency"] 1861include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1862include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1863ROLLBACK; 1864SET GTID_NEXT = 'AUTOMATIC'; 1865include/assert.inc [Both counters should be 0] 1866---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 1867CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1868Warnings: 1869Note 1050 Table 't1' already exists 1870# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID 1871SET GTID_NEXT = 'GTID'; 1872BEGIN; 1873error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1874DROP TEMPORARY TABLE t1; 1875ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1876include/assert.inc [One warning/error should be generated.] 1877include/assert.inc [It should be an Error, not a Warning.] 1878include/assert.inc [Text should be "violates GTID consistency"] 1879include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1880include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1881ROLLBACK; 1882SET GTID_NEXT = 'AUTOMATIC'; 1883include/assert.inc [Both counters should be 0] 1884---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1885CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 1886Warnings: 1887Note 1050 Table 't1' already exists 1888SET AUTOCOMMIT = 0; 1889# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID 1890SET GTID_NEXT = 'GTID'; 1891error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1892DROP TEMPORARY TABLE t1; 1893ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1894include/assert.inc [One warning/error should be generated.] 1895include/assert.inc [It should be an Error, not a Warning.] 1896include/assert.inc [Text should be "violates GTID consistency"] 1897include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1898include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1899ROLLBACK; 1900SET GTID_NEXT = 'AUTOMATIC'; 1901include/assert.inc [Both counters should be 0] 1902SET AUTOCOMMIT = 1; 1903---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1904CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 1905Warnings: 1906Note 1050 Table 't1' already exists 1907SET AUTOCOMMIT = 0; 1908# enforce_gtid_consistency=1 gtid_mode=2 gtid_next=GTID 1909SET GTID_NEXT = 'GTID'; 1910error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1911DROP TEMPORARY TABLE t1; 1912ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1913include/assert.inc [One warning/error should be generated.] 1914include/assert.inc [It should be an Error, not a Warning.] 1915include/assert.inc [Text should be "violates GTID consistency"] 1916include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1917include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1918ROLLBACK; 1919SET GTID_NEXT = 'AUTOMATIC'; 1920include/assert.inc [Both counters should be 0] 1921SET AUTOCOMMIT = 1; 1922DROP TEMPORARY TABLE IF EXISTS t1; 1923SET GLOBAL GTID_MODE = 1; 1924######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF_PERMISSIVE GTID_NEXT=AUTOMATIC ######## 1925---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 1926# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC 1927SET GTID_NEXT = 'AUTOMATIC'; 1928BEGIN; 1929error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1930CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1931ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1932include/assert.inc [One warning/error should be generated.] 1933include/assert.inc [It should be an Error, not a Warning.] 1934include/assert.inc [Text should be "violates GTID consistency"] 1935include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1936include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1937ROLLBACK; 1938SET GTID_NEXT = 'AUTOMATIC'; 1939include/assert.inc [Both counters should be 0] 1940DROP TEMPORARY TABLE IF EXISTS t1; 1941Warnings: 1942Note 1051 Unknown table 'test.t1' 1943---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 1944# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC 1945SET GTID_NEXT = 'AUTOMATIC'; 1946BEGIN; 1947error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1948CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1949ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1950include/assert.inc [One warning/error should be generated.] 1951include/assert.inc [It should be an Error, not a Warning.] 1952include/assert.inc [Text should be "violates GTID consistency"] 1953include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 1954include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1955ROLLBACK; 1956SET GTID_NEXT = 'AUTOMATIC'; 1957include/assert.inc [Both counters should be 0] 1958DROP TEMPORARY TABLE IF EXISTS t1; 1959Warnings: 1960Note 1051 Unknown table 'test.t1' 1961---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 1962SET AUTOCOMMIT = 0; 1963# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC 1964SET GTID_NEXT = 'AUTOMATIC'; 1965error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1966CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 1967ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1968include/assert.inc [One warning/error should be generated.] 1969include/assert.inc [It should be an Error, not a Warning.] 1970include/assert.inc [Text should be "violates GTID consistency"] 1971include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1972include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1973ROLLBACK; 1974SET GTID_NEXT = 'AUTOMATIC'; 1975include/assert.inc [Both counters should be 0] 1976SET AUTOCOMMIT = 1; 1977DROP TEMPORARY TABLE IF EXISTS t1; 1978Warnings: 1979Note 1051 Unknown table 'test.t1' 1980---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 1981SET AUTOCOMMIT = 0; 1982# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC 1983SET GTID_NEXT = 'AUTOMATIC'; 1984error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 1985CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 1986ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 1987include/assert.inc [One warning/error should be generated.] 1988include/assert.inc [It should be an Error, not a Warning.] 1989include/assert.inc [Text should be "violates GTID consistency"] 1990include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 1991include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 1992ROLLBACK; 1993SET GTID_NEXT = 'AUTOMATIC'; 1994include/assert.inc [Both counters should be 0] 1995SET AUTOCOMMIT = 1; 1996DROP TEMPORARY TABLE IF EXISTS t1; 1997Warnings: 1998Note 1051 Unknown table 'test.t1' 1999---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 2000CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2001# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC 2002SET GTID_NEXT = 'AUTOMATIC'; 2003BEGIN; 2004error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2005DROP TEMPORARY TABLE t1; 2006ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2007include/assert.inc [One warning/error should be generated.] 2008include/assert.inc [It should be an Error, not a Warning.] 2009include/assert.inc [Text should be "violates GTID consistency"] 2010include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2011include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2012ROLLBACK; 2013SET GTID_NEXT = 'AUTOMATIC'; 2014include/assert.inc [Both counters should be 0] 2015---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 2016CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2017Warnings: 2018Note 1050 Table 't1' already exists 2019# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC 2020SET GTID_NEXT = 'AUTOMATIC'; 2021BEGIN; 2022error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2023DROP TEMPORARY TABLE t1; 2024ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2025include/assert.inc [One warning/error should be generated.] 2026include/assert.inc [It should be an Error, not a Warning.] 2027include/assert.inc [Text should be "violates GTID consistency"] 2028include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2029include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2030ROLLBACK; 2031SET GTID_NEXT = 'AUTOMATIC'; 2032include/assert.inc [Both counters should be 0] 2033---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2034CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2035Warnings: 2036Note 1050 Table 't1' already exists 2037SET AUTOCOMMIT = 0; 2038# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC 2039SET GTID_NEXT = 'AUTOMATIC'; 2040error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2041DROP TEMPORARY TABLE t1; 2042ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2043include/assert.inc [One warning/error should be generated.] 2044include/assert.inc [It should be an Error, not a Warning.] 2045include/assert.inc [Text should be "violates GTID consistency"] 2046include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2047include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2048ROLLBACK; 2049SET GTID_NEXT = 'AUTOMATIC'; 2050include/assert.inc [Both counters should be 0] 2051SET AUTOCOMMIT = 1; 2052---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2053CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2054Warnings: 2055Note 1050 Table 't1' already exists 2056SET AUTOCOMMIT = 0; 2057# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=AUTOMATIC 2058SET GTID_NEXT = 'AUTOMATIC'; 2059error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2060DROP TEMPORARY TABLE t1; 2061ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2062include/assert.inc [One warning/error should be generated.] 2063include/assert.inc [It should be an Error, not a Warning.] 2064include/assert.inc [Text should be "violates GTID consistency"] 2065include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2066include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2067ROLLBACK; 2068SET GTID_NEXT = 'AUTOMATIC'; 2069include/assert.inc [Both counters should be 0] 2070SET AUTOCOMMIT = 1; 2071DROP TEMPORARY TABLE IF EXISTS t1; 2072######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF_PERMISSIVE GTID_NEXT=ANONYMOUS ######## 2073---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 2074# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS 2075SET GTID_NEXT = 'ANONYMOUS'; 2076BEGIN; 2077error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2078CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2079ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2080include/assert.inc [One warning/error should be generated.] 2081include/assert.inc [It should be an Error, not a Warning.] 2082include/assert.inc [Text should be "violates GTID consistency"] 2083include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2084include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2085ROLLBACK; 2086SET GTID_NEXT = 'AUTOMATIC'; 2087include/assert.inc [Both counters should be 0] 2088DROP TEMPORARY TABLE IF EXISTS t1; 2089Warnings: 2090Note 1051 Unknown table 'test.t1' 2091---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 2092# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS 2093SET GTID_NEXT = 'ANONYMOUS'; 2094BEGIN; 2095error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2096CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2097ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2098include/assert.inc [One warning/error should be generated.] 2099include/assert.inc [It should be an Error, not a Warning.] 2100include/assert.inc [Text should be "violates GTID consistency"] 2101include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2102include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 2103ROLLBACK; 2104SET GTID_NEXT = 'AUTOMATIC'; 2105include/assert.inc [Both counters should be 0] 2106DROP TEMPORARY TABLE IF EXISTS t1; 2107Warnings: 2108Note 1051 Unknown table 'test.t1' 2109---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2110SET AUTOCOMMIT = 0; 2111# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS 2112SET GTID_NEXT = 'ANONYMOUS'; 2113error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2114CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2115ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2116include/assert.inc [One warning/error should be generated.] 2117include/assert.inc [It should be an Error, not a Warning.] 2118include/assert.inc [Text should be "violates GTID consistency"] 2119include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2120include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2121ROLLBACK; 2122SET GTID_NEXT = 'AUTOMATIC'; 2123include/assert.inc [Both counters should be 0] 2124SET AUTOCOMMIT = 1; 2125DROP TEMPORARY TABLE IF EXISTS t1; 2126Warnings: 2127Note 1051 Unknown table 'test.t1' 2128---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2129SET AUTOCOMMIT = 0; 2130# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS 2131SET GTID_NEXT = 'ANONYMOUS'; 2132error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2133CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2134ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2135include/assert.inc [One warning/error should be generated.] 2136include/assert.inc [It should be an Error, not a Warning.] 2137include/assert.inc [Text should be "violates GTID consistency"] 2138include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2139include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 2140ROLLBACK; 2141SET GTID_NEXT = 'AUTOMATIC'; 2142include/assert.inc [Both counters should be 0] 2143SET AUTOCOMMIT = 1; 2144DROP TEMPORARY TABLE IF EXISTS t1; 2145Warnings: 2146Note 1051 Unknown table 'test.t1' 2147---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 2148CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2149# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS 2150SET GTID_NEXT = 'ANONYMOUS'; 2151BEGIN; 2152error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2153DROP TEMPORARY TABLE t1; 2154ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2155include/assert.inc [One warning/error should be generated.] 2156include/assert.inc [It should be an Error, not a Warning.] 2157include/assert.inc [Text should be "violates GTID consistency"] 2158include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2159include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2160ROLLBACK; 2161SET GTID_NEXT = 'AUTOMATIC'; 2162include/assert.inc [Both counters should be 0] 2163---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 2164CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2165Warnings: 2166Note 1050 Table 't1' already exists 2167# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS 2168SET GTID_NEXT = 'ANONYMOUS'; 2169BEGIN; 2170error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2171DROP TEMPORARY TABLE t1; 2172ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2173include/assert.inc [One warning/error should be generated.] 2174include/assert.inc [It should be an Error, not a Warning.] 2175include/assert.inc [Text should be "violates GTID consistency"] 2176include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2177include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2178ROLLBACK; 2179SET GTID_NEXT = 'AUTOMATIC'; 2180include/assert.inc [Both counters should be 0] 2181---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2182CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2183Warnings: 2184Note 1050 Table 't1' already exists 2185SET AUTOCOMMIT = 0; 2186# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS 2187SET GTID_NEXT = 'ANONYMOUS'; 2188error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2189DROP TEMPORARY TABLE t1; 2190ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2191include/assert.inc [One warning/error should be generated.] 2192include/assert.inc [It should be an Error, not a Warning.] 2193include/assert.inc [Text should be "violates GTID consistency"] 2194include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2195include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2196ROLLBACK; 2197SET GTID_NEXT = 'AUTOMATIC'; 2198include/assert.inc [Both counters should be 0] 2199SET AUTOCOMMIT = 1; 2200---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2201CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2202Warnings: 2203Note 1050 Table 't1' already exists 2204SET AUTOCOMMIT = 0; 2205# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=ANONYMOUS 2206SET GTID_NEXT = 'ANONYMOUS'; 2207error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2208DROP TEMPORARY TABLE t1; 2209ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2210include/assert.inc [One warning/error should be generated.] 2211include/assert.inc [It should be an Error, not a Warning.] 2212include/assert.inc [Text should be "violates GTID consistency"] 2213include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2214include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2215ROLLBACK; 2216SET GTID_NEXT = 'AUTOMATIC'; 2217include/assert.inc [Both counters should be 0] 2218SET AUTOCOMMIT = 1; 2219DROP TEMPORARY TABLE IF EXISTS t1; 2220######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF_PERMISSIVE GTID_NEXT=GTID ######## 2221---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 2222# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID 2223SET GTID_NEXT = 'GTID'; 2224BEGIN; 2225error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2226CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2227ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2228include/assert.inc [One warning/error should be generated.] 2229include/assert.inc [It should be an Error, not a Warning.] 2230include/assert.inc [Text should be "violates GTID consistency"] 2231include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2232include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2233ROLLBACK; 2234SET GTID_NEXT = 'AUTOMATIC'; 2235include/assert.inc [Both counters should be 0] 2236DROP TEMPORARY TABLE IF EXISTS t1; 2237Warnings: 2238Note 1051 Unknown table 'test.t1' 2239---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 2240# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID 2241SET GTID_NEXT = 'GTID'; 2242BEGIN; 2243error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2244CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2245ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2246include/assert.inc [One warning/error should be generated.] 2247include/assert.inc [It should be an Error, not a Warning.] 2248include/assert.inc [Text should be "violates GTID consistency"] 2249include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2250include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2251ROLLBACK; 2252SET GTID_NEXT = 'AUTOMATIC'; 2253include/assert.inc [Both counters should be 0] 2254DROP TEMPORARY TABLE IF EXISTS t1; 2255Warnings: 2256Note 1051 Unknown table 'test.t1' 2257---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2258SET AUTOCOMMIT = 0; 2259# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID 2260SET GTID_NEXT = 'GTID'; 2261error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2262CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2263ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2264include/assert.inc [One warning/error should be generated.] 2265include/assert.inc [It should be an Error, not a Warning.] 2266include/assert.inc [Text should be "violates GTID consistency"] 2267include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2268include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2269ROLLBACK; 2270SET GTID_NEXT = 'AUTOMATIC'; 2271include/assert.inc [Both counters should be 0] 2272SET AUTOCOMMIT = 1; 2273DROP TEMPORARY TABLE IF EXISTS t1; 2274Warnings: 2275Note 1051 Unknown table 'test.t1' 2276---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2277SET AUTOCOMMIT = 0; 2278# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID 2279SET GTID_NEXT = 'GTID'; 2280error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2281CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2282ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2283include/assert.inc [One warning/error should be generated.] 2284include/assert.inc [It should be an Error, not a Warning.] 2285include/assert.inc [Text should be "violates GTID consistency"] 2286include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2287include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2288ROLLBACK; 2289SET GTID_NEXT = 'AUTOMATIC'; 2290include/assert.inc [Both counters should be 0] 2291SET AUTOCOMMIT = 1; 2292DROP TEMPORARY TABLE IF EXISTS t1; 2293Warnings: 2294Note 1051 Unknown table 'test.t1' 2295---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 2296CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2297# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID 2298SET GTID_NEXT = 'GTID'; 2299BEGIN; 2300error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2301DROP TEMPORARY TABLE t1; 2302ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2303include/assert.inc [One warning/error should be generated.] 2304include/assert.inc [It should be an Error, not a Warning.] 2305include/assert.inc [Text should be "violates GTID consistency"] 2306include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2307include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2308ROLLBACK; 2309SET GTID_NEXT = 'AUTOMATIC'; 2310include/assert.inc [Both counters should be 0] 2311---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 2312CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2313Warnings: 2314Note 1050 Table 't1' already exists 2315# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID 2316SET GTID_NEXT = 'GTID'; 2317BEGIN; 2318error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2319DROP TEMPORARY TABLE t1; 2320ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2321include/assert.inc [One warning/error should be generated.] 2322include/assert.inc [It should be an Error, not a Warning.] 2323include/assert.inc [Text should be "violates GTID consistency"] 2324include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2325include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2326ROLLBACK; 2327SET GTID_NEXT = 'AUTOMATIC'; 2328include/assert.inc [Both counters should be 0] 2329---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2330CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2331Warnings: 2332Note 1050 Table 't1' already exists 2333SET AUTOCOMMIT = 0; 2334# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID 2335SET GTID_NEXT = 'GTID'; 2336error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2337DROP TEMPORARY TABLE t1; 2338ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2339include/assert.inc [One warning/error should be generated.] 2340include/assert.inc [It should be an Error, not a Warning.] 2341include/assert.inc [Text should be "violates GTID consistency"] 2342include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2343include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2344ROLLBACK; 2345SET GTID_NEXT = 'AUTOMATIC'; 2346include/assert.inc [Both counters should be 0] 2347SET AUTOCOMMIT = 1; 2348---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2349CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2350Warnings: 2351Note 1050 Table 't1' already exists 2352SET AUTOCOMMIT = 0; 2353# enforce_gtid_consistency=1 gtid_mode=1 gtid_next=GTID 2354SET GTID_NEXT = 'GTID'; 2355error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2356DROP TEMPORARY TABLE t1; 2357ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2358include/assert.inc [One warning/error should be generated.] 2359include/assert.inc [It should be an Error, not a Warning.] 2360include/assert.inc [Text should be "violates GTID consistency"] 2361include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2362include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2363ROLLBACK; 2364SET GTID_NEXT = 'AUTOMATIC'; 2365include/assert.inc [Both counters should be 0] 2366SET AUTOCOMMIT = 1; 2367DROP TEMPORARY TABLE IF EXISTS t1; 2368SET GLOBAL GTID_MODE = 0; 2369######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF GTID_NEXT=AUTOMATIC ######## 2370---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 2371# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC 2372SET GTID_NEXT = 'AUTOMATIC'; 2373BEGIN; 2374error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2375CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2376ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2377include/assert.inc [One warning/error should be generated.] 2378include/assert.inc [It should be an Error, not a Warning.] 2379include/assert.inc [Text should be "violates GTID consistency"] 2380include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2381include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2382ROLLBACK; 2383SET GTID_NEXT = 'AUTOMATIC'; 2384include/assert.inc [Both counters should be 0] 2385DROP TEMPORARY TABLE IF EXISTS t1; 2386Warnings: 2387Note 1051 Unknown table 'test.t1' 2388---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 2389# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC 2390SET GTID_NEXT = 'AUTOMATIC'; 2391BEGIN; 2392error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2393CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2394ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2395include/assert.inc [One warning/error should be generated.] 2396include/assert.inc [It should be an Error, not a Warning.] 2397include/assert.inc [Text should be "violates GTID consistency"] 2398include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 2399include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2400ROLLBACK; 2401SET GTID_NEXT = 'AUTOMATIC'; 2402include/assert.inc [Both counters should be 0] 2403DROP TEMPORARY TABLE IF EXISTS t1; 2404Warnings: 2405Note 1051 Unknown table 'test.t1' 2406---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2407SET AUTOCOMMIT = 0; 2408# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC 2409SET GTID_NEXT = 'AUTOMATIC'; 2410error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2411CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2412ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2413include/assert.inc [One warning/error should be generated.] 2414include/assert.inc [It should be an Error, not a Warning.] 2415include/assert.inc [Text should be "violates GTID consistency"] 2416include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2417include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2418ROLLBACK; 2419SET GTID_NEXT = 'AUTOMATIC'; 2420include/assert.inc [Both counters should be 0] 2421SET AUTOCOMMIT = 1; 2422DROP TEMPORARY TABLE IF EXISTS t1; 2423Warnings: 2424Note 1051 Unknown table 'test.t1' 2425---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2426SET AUTOCOMMIT = 0; 2427# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC 2428SET GTID_NEXT = 'AUTOMATIC'; 2429error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2430CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2431ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2432include/assert.inc [One warning/error should be generated.] 2433include/assert.inc [It should be an Error, not a Warning.] 2434include/assert.inc [Text should be "violates GTID consistency"] 2435include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 2436include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2437ROLLBACK; 2438SET GTID_NEXT = 'AUTOMATIC'; 2439include/assert.inc [Both counters should be 0] 2440SET AUTOCOMMIT = 1; 2441DROP TEMPORARY TABLE IF EXISTS t1; 2442Warnings: 2443Note 1051 Unknown table 'test.t1' 2444---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 2445CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2446# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC 2447SET GTID_NEXT = 'AUTOMATIC'; 2448BEGIN; 2449error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2450DROP TEMPORARY TABLE t1; 2451ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2452include/assert.inc [One warning/error should be generated.] 2453include/assert.inc [It should be an Error, not a Warning.] 2454include/assert.inc [Text should be "violates GTID consistency"] 2455include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2456include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2457ROLLBACK; 2458SET GTID_NEXT = 'AUTOMATIC'; 2459include/assert.inc [Both counters should be 0] 2460---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 2461CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2462Warnings: 2463Note 1050 Table 't1' already exists 2464# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC 2465SET GTID_NEXT = 'AUTOMATIC'; 2466BEGIN; 2467error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2468DROP TEMPORARY TABLE t1; 2469ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2470include/assert.inc [One warning/error should be generated.] 2471include/assert.inc [It should be an Error, not a Warning.] 2472include/assert.inc [Text should be "violates GTID consistency"] 2473include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2474include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2475ROLLBACK; 2476SET GTID_NEXT = 'AUTOMATIC'; 2477include/assert.inc [Both counters should be 0] 2478---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2479CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2480Warnings: 2481Note 1050 Table 't1' already exists 2482SET AUTOCOMMIT = 0; 2483# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC 2484SET GTID_NEXT = 'AUTOMATIC'; 2485error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2486DROP TEMPORARY TABLE t1; 2487ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2488include/assert.inc [One warning/error should be generated.] 2489include/assert.inc [It should be an Error, not a Warning.] 2490include/assert.inc [Text should be "violates GTID consistency"] 2491include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2492include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2493ROLLBACK; 2494SET GTID_NEXT = 'AUTOMATIC'; 2495include/assert.inc [Both counters should be 0] 2496SET AUTOCOMMIT = 1; 2497---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2498CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2499Warnings: 2500Note 1050 Table 't1' already exists 2501SET AUTOCOMMIT = 0; 2502# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=AUTOMATIC 2503SET GTID_NEXT = 'AUTOMATIC'; 2504error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2505DROP TEMPORARY TABLE t1; 2506ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2507include/assert.inc [One warning/error should be generated.] 2508include/assert.inc [It should be an Error, not a Warning.] 2509include/assert.inc [Text should be "violates GTID consistency"] 2510include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2511include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2512ROLLBACK; 2513SET GTID_NEXT = 'AUTOMATIC'; 2514include/assert.inc [Both counters should be 0] 2515SET AUTOCOMMIT = 1; 2516DROP TEMPORARY TABLE IF EXISTS t1; 2517######## ENFORCE_GTID_CONSISTENCY=ERROR GTID_MODE=OFF GTID_NEXT=ANONYMOUS ######## 2518---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 2519# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS 2520SET GTID_NEXT = 'ANONYMOUS'; 2521BEGIN; 2522error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2523CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2524ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2525include/assert.inc [One warning/error should be generated.] 2526include/assert.inc [It should be an Error, not a Warning.] 2527include/assert.inc [Text should be "violates GTID consistency"] 2528include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2529include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2530ROLLBACK; 2531SET GTID_NEXT = 'AUTOMATIC'; 2532include/assert.inc [Both counters should be 0] 2533DROP TEMPORARY TABLE IF EXISTS t1; 2534Warnings: 2535Note 1051 Unknown table 'test.t1' 2536---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 2537# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS 2538SET GTID_NEXT = 'ANONYMOUS'; 2539BEGIN; 2540error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2541CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2542ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2543include/assert.inc [One warning/error should be generated.] 2544include/assert.inc [It should be an Error, not a Warning.] 2545include/assert.inc [Text should be "violates GTID consistency"] 2546include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2547include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 2548ROLLBACK; 2549SET GTID_NEXT = 'AUTOMATIC'; 2550include/assert.inc [Both counters should be 0] 2551DROP TEMPORARY TABLE IF EXISTS t1; 2552Warnings: 2553Note 1051 Unknown table 'test.t1' 2554---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2555SET AUTOCOMMIT = 0; 2556# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS 2557SET GTID_NEXT = 'ANONYMOUS'; 2558error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2559CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2560ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2561include/assert.inc [One warning/error should be generated.] 2562include/assert.inc [It should be an Error, not a Warning.] 2563include/assert.inc [Text should be "violates GTID consistency"] 2564include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2565include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2566ROLLBACK; 2567SET GTID_NEXT = 'AUTOMATIC'; 2568include/assert.inc [Both counters should be 0] 2569SET AUTOCOMMIT = 1; 2570DROP TEMPORARY TABLE IF EXISTS t1; 2571Warnings: 2572Note 1051 Unknown table 'test.t1' 2573---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2574SET AUTOCOMMIT = 0; 2575# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS 2576SET GTID_NEXT = 'ANONYMOUS'; 2577error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2578CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2579ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2580include/assert.inc [One warning/error should be generated.] 2581include/assert.inc [It should be an Error, not a Warning.] 2582include/assert.inc [Text should be "violates GTID consistency"] 2583include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2584include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 2585ROLLBACK; 2586SET GTID_NEXT = 'AUTOMATIC'; 2587include/assert.inc [Both counters should be 0] 2588SET AUTOCOMMIT = 1; 2589DROP TEMPORARY TABLE IF EXISTS t1; 2590Warnings: 2591Note 1051 Unknown table 'test.t1' 2592---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 2593CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2594# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS 2595SET GTID_NEXT = 'ANONYMOUS'; 2596BEGIN; 2597error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2598DROP TEMPORARY TABLE t1; 2599ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2600include/assert.inc [One warning/error should be generated.] 2601include/assert.inc [It should be an Error, not a Warning.] 2602include/assert.inc [Text should be "violates GTID consistency"] 2603include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2604include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2605ROLLBACK; 2606SET GTID_NEXT = 'AUTOMATIC'; 2607include/assert.inc [Both counters should be 0] 2608---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 2609CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2610Warnings: 2611Note 1050 Table 't1' already exists 2612# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS 2613SET GTID_NEXT = 'ANONYMOUS'; 2614BEGIN; 2615error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2616DROP TEMPORARY TABLE t1; 2617ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2618include/assert.inc [One warning/error should be generated.] 2619include/assert.inc [It should be an Error, not a Warning.] 2620include/assert.inc [Text should be "violates GTID consistency"] 2621include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2622include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2623ROLLBACK; 2624SET GTID_NEXT = 'AUTOMATIC'; 2625include/assert.inc [Both counters should be 0] 2626---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2627CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2628Warnings: 2629Note 1050 Table 't1' already exists 2630SET AUTOCOMMIT = 0; 2631# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS 2632SET GTID_NEXT = 'ANONYMOUS'; 2633error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2634DROP TEMPORARY TABLE t1; 2635ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2636include/assert.inc [One warning/error should be generated.] 2637include/assert.inc [It should be an Error, not a Warning.] 2638include/assert.inc [Text should be "violates GTID consistency"] 2639include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2640include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2641ROLLBACK; 2642SET GTID_NEXT = 'AUTOMATIC'; 2643include/assert.inc [Both counters should be 0] 2644SET AUTOCOMMIT = 1; 2645---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2646CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2647Warnings: 2648Note 1050 Table 't1' already exists 2649SET AUTOCOMMIT = 0; 2650# enforce_gtid_consistency=1 gtid_mode=0 gtid_next=ANONYMOUS 2651SET GTID_NEXT = 'ANONYMOUS'; 2652error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2653DROP TEMPORARY TABLE t1; 2654ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2655include/assert.inc [One warning/error should be generated.] 2656include/assert.inc [It should be an Error, not a Warning.] 2657include/assert.inc [Text should be "violates GTID consistency"] 2658include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2659include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2660ROLLBACK; 2661SET GTID_NEXT = 'AUTOMATIC'; 2662include/assert.inc [Both counters should be 0] 2663SET AUTOCOMMIT = 1; 2664DROP TEMPORARY TABLE IF EXISTS t1; 2665SET GLOBAL ENFORCE_GTID_CONSISTENCY = 2; 2666SET GLOBAL GTID_MODE = OFF_PERMISSIVE; 2667SET GLOBAL GTID_MODE = ON_PERMISSIVE; 2668SET GLOBAL GTID_MODE = 2; 2669######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=ON_PERMISSIVE GTID_NEXT=AUTOMATIC ######## 2670---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 2671# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC 2672SET GTID_NEXT = 'AUTOMATIC'; 2673BEGIN; 2674error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2675CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2676ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2677include/assert.inc [One warning/error should be generated.] 2678include/assert.inc [It should be an Error, not a Warning.] 2679include/assert.inc [Text should be "violates GTID consistency"] 2680include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2681include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2682ROLLBACK; 2683SET GTID_NEXT = 'AUTOMATIC'; 2684include/assert.inc [Both counters should be 0] 2685DROP TEMPORARY TABLE IF EXISTS t1; 2686Warnings: 2687Note 1051 Unknown table 'test.t1' 2688---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 2689# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC 2690SET GTID_NEXT = 'AUTOMATIC'; 2691BEGIN; 2692error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2693CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2694ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2695include/assert.inc [One warning/error should be generated.] 2696include/assert.inc [It should be an Error, not a Warning.] 2697include/assert.inc [Text should be "violates GTID consistency"] 2698include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 2699include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2700ROLLBACK; 2701SET GTID_NEXT = 'AUTOMATIC'; 2702include/assert.inc [Both counters should be 0] 2703DROP TEMPORARY TABLE IF EXISTS t1; 2704Warnings: 2705Note 1051 Unknown table 'test.t1' 2706---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2707SET AUTOCOMMIT = 0; 2708# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC 2709SET GTID_NEXT = 'AUTOMATIC'; 2710error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2711CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2712ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2713include/assert.inc [One warning/error should be generated.] 2714include/assert.inc [It should be an Error, not a Warning.] 2715include/assert.inc [Text should be "violates GTID consistency"] 2716include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2717include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2718ROLLBACK; 2719SET GTID_NEXT = 'AUTOMATIC'; 2720include/assert.inc [Both counters should be 0] 2721SET AUTOCOMMIT = 1; 2722DROP TEMPORARY TABLE IF EXISTS t1; 2723Warnings: 2724Note 1051 Unknown table 'test.t1' 2725---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2726SET AUTOCOMMIT = 0; 2727# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC 2728SET GTID_NEXT = 'AUTOMATIC'; 2729error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2730CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2731ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2732include/assert.inc [One warning/error should be generated.] 2733include/assert.inc [It should be an Error, not a Warning.] 2734include/assert.inc [Text should be "violates GTID consistency"] 2735include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 2736include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2737ROLLBACK; 2738SET GTID_NEXT = 'AUTOMATIC'; 2739include/assert.inc [Both counters should be 0] 2740SET AUTOCOMMIT = 1; 2741DROP TEMPORARY TABLE IF EXISTS t1; 2742Warnings: 2743Note 1051 Unknown table 'test.t1' 2744---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 2745CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2746# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC 2747SET GTID_NEXT = 'AUTOMATIC'; 2748BEGIN; 2749error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2750DROP TEMPORARY TABLE t1; 2751ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2752include/assert.inc [One warning/error should be generated.] 2753include/assert.inc [It should be an Error, not a Warning.] 2754include/assert.inc [Text should be "violates GTID consistency"] 2755include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2756include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2757ROLLBACK; 2758SET GTID_NEXT = 'AUTOMATIC'; 2759include/assert.inc [Both counters should be 0] 2760---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 2761CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2762Warnings: 2763Note 1050 Table 't1' already exists 2764# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC 2765SET GTID_NEXT = 'AUTOMATIC'; 2766BEGIN; 2767error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2768DROP TEMPORARY TABLE t1; 2769ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2770include/assert.inc [One warning/error should be generated.] 2771include/assert.inc [It should be an Error, not a Warning.] 2772include/assert.inc [Text should be "violates GTID consistency"] 2773include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2774include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2775ROLLBACK; 2776SET GTID_NEXT = 'AUTOMATIC'; 2777include/assert.inc [Both counters should be 0] 2778---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2779CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2780Warnings: 2781Note 1050 Table 't1' already exists 2782SET AUTOCOMMIT = 0; 2783# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC 2784SET GTID_NEXT = 'AUTOMATIC'; 2785error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2786DROP TEMPORARY TABLE t1; 2787ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2788include/assert.inc [One warning/error should be generated.] 2789include/assert.inc [It should be an Error, not a Warning.] 2790include/assert.inc [Text should be "violates GTID consistency"] 2791include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2792include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2793ROLLBACK; 2794SET GTID_NEXT = 'AUTOMATIC'; 2795include/assert.inc [Both counters should be 0] 2796SET AUTOCOMMIT = 1; 2797---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2798CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2799Warnings: 2800Note 1050 Table 't1' already exists 2801SET AUTOCOMMIT = 0; 2802# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=AUTOMATIC 2803SET GTID_NEXT = 'AUTOMATIC'; 2804error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2805DROP TEMPORARY TABLE t1; 2806ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2807include/assert.inc [One warning/error should be generated.] 2808include/assert.inc [It should be an Error, not a Warning.] 2809include/assert.inc [Text should be "violates GTID consistency"] 2810include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2811include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2812ROLLBACK; 2813SET GTID_NEXT = 'AUTOMATIC'; 2814include/assert.inc [Both counters should be 0] 2815SET AUTOCOMMIT = 1; 2816DROP TEMPORARY TABLE IF EXISTS t1; 2817######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=ON_PERMISSIVE GTID_NEXT=ANONYMOUS ######## 2818---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 2819# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS 2820SET GTID_NEXT = 'ANONYMOUS'; 2821BEGIN; 2822[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2823include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2824include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 2825[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2826Warnings: 2827Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2828include/assert.inc [One warning/error should be generated.] 2829include/assert.inc [It should be a Warning, not an Error.] 2830include/assert.inc [Text should be "violates GTID consistency"] 2831include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2832include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 2833ROLLBACK; 2834Warnings: 2835Warning 1751 The creation of some temporary tables could not be rolled back. 2836SET GTID_NEXT = 'AUTOMATIC'; 2837include/assert.inc [Both counters should be 0] 2838DROP TEMPORARY TABLE IF EXISTS t1; 2839---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 2840# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS 2841SET GTID_NEXT = 'ANONYMOUS'; 2842BEGIN; 2843[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2844include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2845include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 2846[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2847Warnings: 2848Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2849include/assert.inc [One warning/error should be generated.] 2850include/assert.inc [It should be a Warning, not an Error.] 2851include/assert.inc [Text should be "violates GTID consistency"] 2852include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2853include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 2854ROLLBACK; 2855Warnings: 2856Warning 1751 The creation of some temporary tables could not be rolled back. 2857SET GTID_NEXT = 'AUTOMATIC'; 2858include/assert.inc [Both counters should be 0] 2859DROP TEMPORARY TABLE IF EXISTS t1; 2860---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2861SET AUTOCOMMIT = 0; 2862# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS 2863SET GTID_NEXT = 'ANONYMOUS'; 2864[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2865include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2866include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 2867[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 2868Warnings: 2869Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2870include/assert.inc [One warning/error should be generated.] 2871include/assert.inc [It should be a Warning, not an Error.] 2872include/assert.inc [Text should be "violates GTID consistency"] 2873include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2874include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 2875ROLLBACK; 2876Warnings: 2877Warning 1751 The creation of some temporary tables could not be rolled back. 2878SET GTID_NEXT = 'AUTOMATIC'; 2879include/assert.inc [Both counters should be 0] 2880SET AUTOCOMMIT = 1; 2881DROP TEMPORARY TABLE IF EXISTS t1; 2882---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2883SET AUTOCOMMIT = 0; 2884# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS 2885SET GTID_NEXT = 'ANONYMOUS'; 2886[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2887include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2888include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 2889[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 2890Warnings: 2891Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2892include/assert.inc [One warning/error should be generated.] 2893include/assert.inc [It should be a Warning, not an Error.] 2894include/assert.inc [Text should be "violates GTID consistency"] 2895include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2896include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 2897ROLLBACK; 2898Warnings: 2899Warning 1751 The creation of some temporary tables could not be rolled back. 2900SET GTID_NEXT = 'AUTOMATIC'; 2901include/assert.inc [Both counters should be 0] 2902SET AUTOCOMMIT = 1; 2903DROP TEMPORARY TABLE IF EXISTS t1; 2904---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 2905CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2906# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS 2907SET GTID_NEXT = 'ANONYMOUS'; 2908BEGIN; 2909[START] DROP TEMPORARY TABLE t1; 2910include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2911include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 2912[END] DROP TEMPORARY TABLE t1; 2913Warnings: 2914Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2915include/assert.inc [One warning/error should be generated.] 2916include/assert.inc [It should be a Warning, not an Error.] 2917include/assert.inc [Text should be "violates GTID consistency"] 2918include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2919include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 2920ROLLBACK; 2921Warnings: 2922Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 2923SET GTID_NEXT = 'AUTOMATIC'; 2924include/assert.inc [Both counters should be 0] 2925---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 2926CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2927# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS 2928SET GTID_NEXT = 'ANONYMOUS'; 2929BEGIN; 2930[START] DROP TEMPORARY TABLE t1; 2931include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2932include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 2933[END] DROP TEMPORARY TABLE t1; 2934Warnings: 2935Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2936include/assert.inc [One warning/error should be generated.] 2937include/assert.inc [It should be a Warning, not an Error.] 2938include/assert.inc [Text should be "violates GTID consistency"] 2939include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2940include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2941ROLLBACK; 2942Warnings: 2943Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 2944SET GTID_NEXT = 'AUTOMATIC'; 2945include/assert.inc [Both counters should be 0] 2946---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 2947CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 2948SET AUTOCOMMIT = 0; 2949# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS 2950SET GTID_NEXT = 'ANONYMOUS'; 2951[START] DROP TEMPORARY TABLE t1; 2952include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2953include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 2954[END] DROP TEMPORARY TABLE t1; 2955Warnings: 2956Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2957include/assert.inc [One warning/error should be generated.] 2958include/assert.inc [It should be a Warning, not an Error.] 2959include/assert.inc [Text should be "violates GTID consistency"] 2960include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2961include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 2962ROLLBACK; 2963Warnings: 2964Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 2965SET GTID_NEXT = 'AUTOMATIC'; 2966include/assert.inc [Both counters should be 0] 2967SET AUTOCOMMIT = 1; 2968---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 2969CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 2970SET AUTOCOMMIT = 0; 2971# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=ANONYMOUS 2972SET GTID_NEXT = 'ANONYMOUS'; 2973[START] DROP TEMPORARY TABLE t1; 2974include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2975include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 2976[END] DROP TEMPORARY TABLE t1; 2977Warnings: 2978Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 2979include/assert.inc [One warning/error should be generated.] 2980include/assert.inc [It should be a Warning, not an Error.] 2981include/assert.inc [Text should be "violates GTID consistency"] 2982include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2983include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 2984ROLLBACK; 2985Warnings: 2986Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 2987SET GTID_NEXT = 'AUTOMATIC'; 2988include/assert.inc [Both counters should be 0] 2989SET AUTOCOMMIT = 1; 2990DROP TEMPORARY TABLE IF EXISTS t1; 2991Warnings: 2992Note 1051 Unknown table 'test.t1' 2993######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=ON_PERMISSIVE GTID_NEXT=GTID ######## 2994---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 2995# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID 2996SET GTID_NEXT = 'GTID'; 2997BEGIN; 2998error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 2999CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3000ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3001include/assert.inc [One warning/error should be generated.] 3002include/assert.inc [It should be an Error, not a Warning.] 3003include/assert.inc [Text should be "violates GTID consistency"] 3004include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3005include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3006ROLLBACK; 3007SET GTID_NEXT = 'AUTOMATIC'; 3008include/assert.inc [Both counters should be 0] 3009DROP TEMPORARY TABLE IF EXISTS t1; 3010Warnings: 3011Note 1051 Unknown table 'test.t1' 3012---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 3013# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID 3014SET GTID_NEXT = 'GTID'; 3015BEGIN; 3016error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3017CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3018ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3019include/assert.inc [One warning/error should be generated.] 3020include/assert.inc [It should be an Error, not a Warning.] 3021include/assert.inc [Text should be "violates GTID consistency"] 3022include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3023include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3024ROLLBACK; 3025SET GTID_NEXT = 'AUTOMATIC'; 3026include/assert.inc [Both counters should be 0] 3027DROP TEMPORARY TABLE IF EXISTS t1; 3028Warnings: 3029Note 1051 Unknown table 'test.t1' 3030---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 3031SET AUTOCOMMIT = 0; 3032# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID 3033SET GTID_NEXT = 'GTID'; 3034error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3035CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3036ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3037include/assert.inc [One warning/error should be generated.] 3038include/assert.inc [It should be an Error, not a Warning.] 3039include/assert.inc [Text should be "violates GTID consistency"] 3040include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3041include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3042ROLLBACK; 3043SET GTID_NEXT = 'AUTOMATIC'; 3044include/assert.inc [Both counters should be 0] 3045SET AUTOCOMMIT = 1; 3046DROP TEMPORARY TABLE IF EXISTS t1; 3047Warnings: 3048Note 1051 Unknown table 'test.t1' 3049---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 3050SET AUTOCOMMIT = 0; 3051# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID 3052SET GTID_NEXT = 'GTID'; 3053error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3054CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3055ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3056include/assert.inc [One warning/error should be generated.] 3057include/assert.inc [It should be an Error, not a Warning.] 3058include/assert.inc [Text should be "violates GTID consistency"] 3059include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3060include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3061ROLLBACK; 3062SET GTID_NEXT = 'AUTOMATIC'; 3063include/assert.inc [Both counters should be 0] 3064SET AUTOCOMMIT = 1; 3065DROP TEMPORARY TABLE IF EXISTS t1; 3066Warnings: 3067Note 1051 Unknown table 'test.t1' 3068---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 3069CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 3070# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID 3071SET GTID_NEXT = 'GTID'; 3072BEGIN; 3073error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3074DROP TEMPORARY TABLE t1; 3075ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3076include/assert.inc [One warning/error should be generated.] 3077include/assert.inc [It should be an Error, not a Warning.] 3078include/assert.inc [Text should be "violates GTID consistency"] 3079include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3080include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3081ROLLBACK; 3082SET GTID_NEXT = 'AUTOMATIC'; 3083include/assert.inc [Both counters should be 0] 3084---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 3085CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 3086Warnings: 3087Note 1050 Table 't1' already exists 3088# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID 3089SET GTID_NEXT = 'GTID'; 3090BEGIN; 3091error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3092DROP TEMPORARY TABLE t1; 3093ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3094include/assert.inc [One warning/error should be generated.] 3095include/assert.inc [It should be an Error, not a Warning.] 3096include/assert.inc [Text should be "violates GTID consistency"] 3097include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3098include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3099ROLLBACK; 3100SET GTID_NEXT = 'AUTOMATIC'; 3101include/assert.inc [Both counters should be 0] 3102---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 3103CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 3104Warnings: 3105Note 1050 Table 't1' already exists 3106SET AUTOCOMMIT = 0; 3107# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID 3108SET GTID_NEXT = 'GTID'; 3109error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3110DROP TEMPORARY TABLE t1; 3111ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3112include/assert.inc [One warning/error should be generated.] 3113include/assert.inc [It should be an Error, not a Warning.] 3114include/assert.inc [Text should be "violates GTID consistency"] 3115include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3116include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3117ROLLBACK; 3118SET GTID_NEXT = 'AUTOMATIC'; 3119include/assert.inc [Both counters should be 0] 3120SET AUTOCOMMIT = 1; 3121---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 3122CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 3123Warnings: 3124Note 1050 Table 't1' already exists 3125SET AUTOCOMMIT = 0; 3126# enforce_gtid_consistency=2 gtid_mode=2 gtid_next=GTID 3127SET GTID_NEXT = 'GTID'; 3128error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3129DROP TEMPORARY TABLE t1; 3130ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3131include/assert.inc [One warning/error should be generated.] 3132include/assert.inc [It should be an Error, not a Warning.] 3133include/assert.inc [Text should be "violates GTID consistency"] 3134include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3135include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3136ROLLBACK; 3137SET GTID_NEXT = 'AUTOMATIC'; 3138include/assert.inc [Both counters should be 0] 3139SET AUTOCOMMIT = 1; 3140DROP TEMPORARY TABLE IF EXISTS t1; 3141SET GLOBAL GTID_MODE = 1; 3142######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF_PERMISSIVE GTID_NEXT=AUTOMATIC ######## 3143---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 3144# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC 3145SET GTID_NEXT = 'AUTOMATIC'; 3146BEGIN; 3147[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3148include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3149include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3150[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3151Warnings: 3152Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3153include/assert.inc [One warning/error should be generated.] 3154include/assert.inc [It should be a Warning, not an Error.] 3155include/assert.inc [Text should be "violates GTID consistency"] 3156include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3157include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3158ROLLBACK; 3159Warnings: 3160Warning 1751 The creation of some temporary tables could not be rolled back. 3161SET GTID_NEXT = 'AUTOMATIC'; 3162include/assert.inc [Both counters should be 0] 3163DROP TEMPORARY TABLE IF EXISTS t1; 3164---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 3165# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC 3166SET GTID_NEXT = 'AUTOMATIC'; 3167BEGIN; 3168[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3169include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3170include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3171[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3172Warnings: 3173Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3174include/assert.inc [One warning/error should be generated.] 3175include/assert.inc [It should be a Warning, not an Error.] 3176include/assert.inc [Text should be "violates GTID consistency"] 3177include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 3178include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3179ROLLBACK; 3180Warnings: 3181Warning 1751 The creation of some temporary tables could not be rolled back. 3182SET GTID_NEXT = 'AUTOMATIC'; 3183include/assert.inc [Both counters should be 0] 3184DROP TEMPORARY TABLE IF EXISTS t1; 3185---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 3186SET AUTOCOMMIT = 0; 3187# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC 3188SET GTID_NEXT = 'AUTOMATIC'; 3189[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3190include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3191include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3192[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3193Warnings: 3194Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3195include/assert.inc [One warning/error should be generated.] 3196include/assert.inc [It should be a Warning, not an Error.] 3197include/assert.inc [Text should be "violates GTID consistency"] 3198include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3199include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3200ROLLBACK; 3201Warnings: 3202Warning 1751 The creation of some temporary tables could not be rolled back. 3203SET GTID_NEXT = 'AUTOMATIC'; 3204include/assert.inc [Both counters should be 0] 3205SET AUTOCOMMIT = 1; 3206DROP TEMPORARY TABLE IF EXISTS t1; 3207---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 3208SET AUTOCOMMIT = 0; 3209# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC 3210SET GTID_NEXT = 'AUTOMATIC'; 3211[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3212include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3213include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3214[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3215Warnings: 3216Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3217include/assert.inc [One warning/error should be generated.] 3218include/assert.inc [It should be a Warning, not an Error.] 3219include/assert.inc [Text should be "violates GTID consistency"] 3220include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 3221include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3222ROLLBACK; 3223Warnings: 3224Warning 1751 The creation of some temporary tables could not be rolled back. 3225SET GTID_NEXT = 'AUTOMATIC'; 3226include/assert.inc [Both counters should be 0] 3227SET AUTOCOMMIT = 1; 3228DROP TEMPORARY TABLE IF EXISTS t1; 3229---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 3230CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 3231# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC 3232SET GTID_NEXT = 'AUTOMATIC'; 3233BEGIN; 3234[START] DROP TEMPORARY TABLE t1; 3235include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3236include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3237[END] DROP TEMPORARY TABLE t1; 3238Warnings: 3239Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3240include/assert.inc [One warning/error should be generated.] 3241include/assert.inc [It should be a Warning, not an Error.] 3242include/assert.inc [Text should be "violates GTID consistency"] 3243include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3244include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3245ROLLBACK; 3246Warnings: 3247Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3248SET GTID_NEXT = 'AUTOMATIC'; 3249include/assert.inc [Both counters should be 0] 3250---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 3251CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 3252# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC 3253SET GTID_NEXT = 'AUTOMATIC'; 3254BEGIN; 3255[START] DROP TEMPORARY TABLE t1; 3256include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3257include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3258[END] DROP TEMPORARY TABLE t1; 3259Warnings: 3260Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3261include/assert.inc [One warning/error should be generated.] 3262include/assert.inc [It should be a Warning, not an Error.] 3263include/assert.inc [Text should be "violates GTID consistency"] 3264include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3265include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3266ROLLBACK; 3267Warnings: 3268Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3269SET GTID_NEXT = 'AUTOMATIC'; 3270include/assert.inc [Both counters should be 0] 3271---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 3272CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 3273SET AUTOCOMMIT = 0; 3274# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC 3275SET GTID_NEXT = 'AUTOMATIC'; 3276[START] DROP TEMPORARY TABLE t1; 3277include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3278include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3279[END] DROP TEMPORARY TABLE t1; 3280Warnings: 3281Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3282include/assert.inc [One warning/error should be generated.] 3283include/assert.inc [It should be a Warning, not an Error.] 3284include/assert.inc [Text should be "violates GTID consistency"] 3285include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3286include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3287ROLLBACK; 3288Warnings: 3289Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3290SET GTID_NEXT = 'AUTOMATIC'; 3291include/assert.inc [Both counters should be 0] 3292SET AUTOCOMMIT = 1; 3293---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 3294CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 3295SET AUTOCOMMIT = 0; 3296# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=AUTOMATIC 3297SET GTID_NEXT = 'AUTOMATIC'; 3298[START] DROP TEMPORARY TABLE t1; 3299include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3300include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3301[END] DROP TEMPORARY TABLE t1; 3302Warnings: 3303Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3304include/assert.inc [One warning/error should be generated.] 3305include/assert.inc [It should be a Warning, not an Error.] 3306include/assert.inc [Text should be "violates GTID consistency"] 3307include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3308include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3309ROLLBACK; 3310Warnings: 3311Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3312SET GTID_NEXT = 'AUTOMATIC'; 3313include/assert.inc [Both counters should be 0] 3314SET AUTOCOMMIT = 1; 3315DROP TEMPORARY TABLE IF EXISTS t1; 3316Warnings: 3317Note 1051 Unknown table 'test.t1' 3318######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF_PERMISSIVE GTID_NEXT=ANONYMOUS ######## 3319---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 3320# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS 3321SET GTID_NEXT = 'ANONYMOUS'; 3322BEGIN; 3323[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3324include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3325include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3326[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3327Warnings: 3328Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3329include/assert.inc [One warning/error should be generated.] 3330include/assert.inc [It should be a Warning, not an Error.] 3331include/assert.inc [Text should be "violates GTID consistency"] 3332include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3333include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3334ROLLBACK; 3335Warnings: 3336Warning 1751 The creation of some temporary tables could not be rolled back. 3337SET GTID_NEXT = 'AUTOMATIC'; 3338include/assert.inc [Both counters should be 0] 3339DROP TEMPORARY TABLE IF EXISTS t1; 3340---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 3341# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS 3342SET GTID_NEXT = 'ANONYMOUS'; 3343BEGIN; 3344[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3345include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3346include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3347[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3348Warnings: 3349Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3350include/assert.inc [One warning/error should be generated.] 3351include/assert.inc [It should be a Warning, not an Error.] 3352include/assert.inc [Text should be "violates GTID consistency"] 3353include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3354include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 3355ROLLBACK; 3356Warnings: 3357Warning 1751 The creation of some temporary tables could not be rolled back. 3358SET GTID_NEXT = 'AUTOMATIC'; 3359include/assert.inc [Both counters should be 0] 3360DROP TEMPORARY TABLE IF EXISTS t1; 3361---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 3362SET AUTOCOMMIT = 0; 3363# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS 3364SET GTID_NEXT = 'ANONYMOUS'; 3365[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3366include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3367include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3368[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3369Warnings: 3370Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3371include/assert.inc [One warning/error should be generated.] 3372include/assert.inc [It should be a Warning, not an Error.] 3373include/assert.inc [Text should be "violates GTID consistency"] 3374include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3375include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3376ROLLBACK; 3377Warnings: 3378Warning 1751 The creation of some temporary tables could not be rolled back. 3379SET GTID_NEXT = 'AUTOMATIC'; 3380include/assert.inc [Both counters should be 0] 3381SET AUTOCOMMIT = 1; 3382DROP TEMPORARY TABLE IF EXISTS t1; 3383---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 3384SET AUTOCOMMIT = 0; 3385# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS 3386SET GTID_NEXT = 'ANONYMOUS'; 3387[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3388include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3389include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3390[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3391Warnings: 3392Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3393include/assert.inc [One warning/error should be generated.] 3394include/assert.inc [It should be a Warning, not an Error.] 3395include/assert.inc [Text should be "violates GTID consistency"] 3396include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3397include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 3398ROLLBACK; 3399Warnings: 3400Warning 1751 The creation of some temporary tables could not be rolled back. 3401SET GTID_NEXT = 'AUTOMATIC'; 3402include/assert.inc [Both counters should be 0] 3403SET AUTOCOMMIT = 1; 3404DROP TEMPORARY TABLE IF EXISTS t1; 3405---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 3406CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 3407# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS 3408SET GTID_NEXT = 'ANONYMOUS'; 3409BEGIN; 3410[START] DROP TEMPORARY TABLE t1; 3411include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3412include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3413[END] DROP TEMPORARY TABLE t1; 3414Warnings: 3415Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3416include/assert.inc [One warning/error should be generated.] 3417include/assert.inc [It should be a Warning, not an Error.] 3418include/assert.inc [Text should be "violates GTID consistency"] 3419include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3420include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3421ROLLBACK; 3422Warnings: 3423Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3424SET GTID_NEXT = 'AUTOMATIC'; 3425include/assert.inc [Both counters should be 0] 3426---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 3427CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 3428# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS 3429SET GTID_NEXT = 'ANONYMOUS'; 3430BEGIN; 3431[START] DROP TEMPORARY TABLE t1; 3432include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3433include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3434[END] DROP TEMPORARY TABLE t1; 3435Warnings: 3436Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3437include/assert.inc [One warning/error should be generated.] 3438include/assert.inc [It should be a Warning, not an Error.] 3439include/assert.inc [Text should be "violates GTID consistency"] 3440include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3441include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3442ROLLBACK; 3443Warnings: 3444Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3445SET GTID_NEXT = 'AUTOMATIC'; 3446include/assert.inc [Both counters should be 0] 3447---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 3448CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 3449SET AUTOCOMMIT = 0; 3450# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS 3451SET GTID_NEXT = 'ANONYMOUS'; 3452[START] DROP TEMPORARY TABLE t1; 3453include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3454include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3455[END] DROP TEMPORARY TABLE t1; 3456Warnings: 3457Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3458include/assert.inc [One warning/error should be generated.] 3459include/assert.inc [It should be a Warning, not an Error.] 3460include/assert.inc [Text should be "violates GTID consistency"] 3461include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3462include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3463ROLLBACK; 3464Warnings: 3465Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3466SET GTID_NEXT = 'AUTOMATIC'; 3467include/assert.inc [Both counters should be 0] 3468SET AUTOCOMMIT = 1; 3469---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 3470CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 3471SET AUTOCOMMIT = 0; 3472# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=ANONYMOUS 3473SET GTID_NEXT = 'ANONYMOUS'; 3474[START] DROP TEMPORARY TABLE t1; 3475include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3476include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3477[END] DROP TEMPORARY TABLE t1; 3478Warnings: 3479Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3480include/assert.inc [One warning/error should be generated.] 3481include/assert.inc [It should be a Warning, not an Error.] 3482include/assert.inc [Text should be "violates GTID consistency"] 3483include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3484include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3485ROLLBACK; 3486Warnings: 3487Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3488SET GTID_NEXT = 'AUTOMATIC'; 3489include/assert.inc [Both counters should be 0] 3490SET AUTOCOMMIT = 1; 3491DROP TEMPORARY TABLE IF EXISTS t1; 3492Warnings: 3493Note 1051 Unknown table 'test.t1' 3494######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF_PERMISSIVE GTID_NEXT=GTID ######## 3495---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 3496# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID 3497SET GTID_NEXT = 'GTID'; 3498BEGIN; 3499error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3500CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3501ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3502include/assert.inc [One warning/error should be generated.] 3503include/assert.inc [It should be an Error, not a Warning.] 3504include/assert.inc [Text should be "violates GTID consistency"] 3505include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3506include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3507ROLLBACK; 3508SET GTID_NEXT = 'AUTOMATIC'; 3509include/assert.inc [Both counters should be 0] 3510DROP TEMPORARY TABLE IF EXISTS t1; 3511Warnings: 3512Note 1051 Unknown table 'test.t1' 3513---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 3514# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID 3515SET GTID_NEXT = 'GTID'; 3516BEGIN; 3517error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3518CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3519ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3520include/assert.inc [One warning/error should be generated.] 3521include/assert.inc [It should be an Error, not a Warning.] 3522include/assert.inc [Text should be "violates GTID consistency"] 3523include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3524include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3525ROLLBACK; 3526SET GTID_NEXT = 'AUTOMATIC'; 3527include/assert.inc [Both counters should be 0] 3528DROP TEMPORARY TABLE IF EXISTS t1; 3529Warnings: 3530Note 1051 Unknown table 'test.t1' 3531---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 3532SET AUTOCOMMIT = 0; 3533# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID 3534SET GTID_NEXT = 'GTID'; 3535error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3536CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3537ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3538include/assert.inc [One warning/error should be generated.] 3539include/assert.inc [It should be an Error, not a Warning.] 3540include/assert.inc [Text should be "violates GTID consistency"] 3541include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3542include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3543ROLLBACK; 3544SET GTID_NEXT = 'AUTOMATIC'; 3545include/assert.inc [Both counters should be 0] 3546SET AUTOCOMMIT = 1; 3547DROP TEMPORARY TABLE IF EXISTS t1; 3548Warnings: 3549Note 1051 Unknown table 'test.t1' 3550---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 3551SET AUTOCOMMIT = 0; 3552# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID 3553SET GTID_NEXT = 'GTID'; 3554error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3555CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3556ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3557include/assert.inc [One warning/error should be generated.] 3558include/assert.inc [It should be an Error, not a Warning.] 3559include/assert.inc [Text should be "violates GTID consistency"] 3560include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3561include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3562ROLLBACK; 3563SET GTID_NEXT = 'AUTOMATIC'; 3564include/assert.inc [Both counters should be 0] 3565SET AUTOCOMMIT = 1; 3566DROP TEMPORARY TABLE IF EXISTS t1; 3567Warnings: 3568Note 1051 Unknown table 'test.t1' 3569---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 3570CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 3571# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID 3572SET GTID_NEXT = 'GTID'; 3573BEGIN; 3574error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3575DROP TEMPORARY TABLE t1; 3576ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3577include/assert.inc [One warning/error should be generated.] 3578include/assert.inc [It should be an Error, not a Warning.] 3579include/assert.inc [Text should be "violates GTID consistency"] 3580include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3581include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3582ROLLBACK; 3583SET GTID_NEXT = 'AUTOMATIC'; 3584include/assert.inc [Both counters should be 0] 3585---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 3586CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 3587Warnings: 3588Note 1050 Table 't1' already exists 3589# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID 3590SET GTID_NEXT = 'GTID'; 3591BEGIN; 3592error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3593DROP TEMPORARY TABLE t1; 3594ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3595include/assert.inc [One warning/error should be generated.] 3596include/assert.inc [It should be an Error, not a Warning.] 3597include/assert.inc [Text should be "violates GTID consistency"] 3598include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3599include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3600ROLLBACK; 3601SET GTID_NEXT = 'AUTOMATIC'; 3602include/assert.inc [Both counters should be 0] 3603---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 3604CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 3605Warnings: 3606Note 1050 Table 't1' already exists 3607SET AUTOCOMMIT = 0; 3608# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID 3609SET GTID_NEXT = 'GTID'; 3610error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3611DROP TEMPORARY TABLE t1; 3612ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3613include/assert.inc [One warning/error should be generated.] 3614include/assert.inc [It should be an Error, not a Warning.] 3615include/assert.inc [Text should be "violates GTID consistency"] 3616include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3617include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3618ROLLBACK; 3619SET GTID_NEXT = 'AUTOMATIC'; 3620include/assert.inc [Both counters should be 0] 3621SET AUTOCOMMIT = 1; 3622---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 3623CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 3624Warnings: 3625Note 1050 Table 't1' already exists 3626SET AUTOCOMMIT = 0; 3627# enforce_gtid_consistency=2 gtid_mode=1 gtid_next=GTID 3628SET GTID_NEXT = 'GTID'; 3629error ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION 3630DROP TEMPORARY TABLE t1; 3631ERROR HY000: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3632include/assert.inc [One warning/error should be generated.] 3633include/assert.inc [It should be an Error, not a Warning.] 3634include/assert.inc [Text should be "violates GTID consistency"] 3635include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3636include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3637ROLLBACK; 3638SET GTID_NEXT = 'AUTOMATIC'; 3639include/assert.inc [Both counters should be 0] 3640SET AUTOCOMMIT = 1; 3641DROP TEMPORARY TABLE IF EXISTS t1; 3642SET GLOBAL GTID_MODE = 0; 3643######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF GTID_NEXT=AUTOMATIC ######## 3644---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 3645# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC 3646SET GTID_NEXT = 'AUTOMATIC'; 3647BEGIN; 3648[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3649include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3650include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3651[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3652Warnings: 3653Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3654include/assert.inc [One warning/error should be generated.] 3655include/assert.inc [It should be a Warning, not an Error.] 3656include/assert.inc [Text should be "violates GTID consistency"] 3657include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3658include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3659ROLLBACK; 3660Warnings: 3661Warning 1751 The creation of some temporary tables could not be rolled back. 3662SET GTID_NEXT = 'AUTOMATIC'; 3663include/assert.inc [Both counters should be 0] 3664DROP TEMPORARY TABLE IF EXISTS t1; 3665---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 3666# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC 3667SET GTID_NEXT = 'AUTOMATIC'; 3668BEGIN; 3669[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3670include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3671include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3672[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3673Warnings: 3674Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3675include/assert.inc [One warning/error should be generated.] 3676include/assert.inc [It should be a Warning, not an Error.] 3677include/assert.inc [Text should be "violates GTID consistency"] 3678include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 3679include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3680ROLLBACK; 3681Warnings: 3682Warning 1751 The creation of some temporary tables could not be rolled back. 3683SET GTID_NEXT = 'AUTOMATIC'; 3684include/assert.inc [Both counters should be 0] 3685DROP TEMPORARY TABLE IF EXISTS t1; 3686---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 3687SET AUTOCOMMIT = 0; 3688# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC 3689SET GTID_NEXT = 'AUTOMATIC'; 3690[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3691include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3692include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3693[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3694Warnings: 3695Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3696include/assert.inc [One warning/error should be generated.] 3697include/assert.inc [It should be a Warning, not an Error.] 3698include/assert.inc [Text should be "violates GTID consistency"] 3699include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3700include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3701ROLLBACK; 3702Warnings: 3703Warning 1751 The creation of some temporary tables could not be rolled back. 3704SET GTID_NEXT = 'AUTOMATIC'; 3705include/assert.inc [Both counters should be 0] 3706SET AUTOCOMMIT = 1; 3707DROP TEMPORARY TABLE IF EXISTS t1; 3708---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 3709SET AUTOCOMMIT = 0; 3710# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC 3711SET GTID_NEXT = 'AUTOMATIC'; 3712[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3713include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3714include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3715[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3716Warnings: 3717Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3718include/assert.inc [One warning/error should be generated.] 3719include/assert.inc [It should be a Warning, not an Error.] 3720include/assert.inc [Text should be "violates GTID consistency"] 3721include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 3722include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3723ROLLBACK; 3724Warnings: 3725Warning 1751 The creation of some temporary tables could not be rolled back. 3726SET GTID_NEXT = 'AUTOMATIC'; 3727include/assert.inc [Both counters should be 0] 3728SET AUTOCOMMIT = 1; 3729DROP TEMPORARY TABLE IF EXISTS t1; 3730---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 3731CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 3732# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC 3733SET GTID_NEXT = 'AUTOMATIC'; 3734BEGIN; 3735[START] DROP TEMPORARY TABLE t1; 3736include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3737include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3738[END] DROP TEMPORARY TABLE t1; 3739Warnings: 3740Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3741include/assert.inc [One warning/error should be generated.] 3742include/assert.inc [It should be a Warning, not an Error.] 3743include/assert.inc [Text should be "violates GTID consistency"] 3744include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3745include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3746ROLLBACK; 3747Warnings: 3748Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3749SET GTID_NEXT = 'AUTOMATIC'; 3750include/assert.inc [Both counters should be 0] 3751---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 3752CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 3753# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC 3754SET GTID_NEXT = 'AUTOMATIC'; 3755BEGIN; 3756[START] DROP TEMPORARY TABLE t1; 3757include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3758include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3759[END] DROP TEMPORARY TABLE t1; 3760Warnings: 3761Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3762include/assert.inc [One warning/error should be generated.] 3763include/assert.inc [It should be a Warning, not an Error.] 3764include/assert.inc [Text should be "violates GTID consistency"] 3765include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3766include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3767ROLLBACK; 3768Warnings: 3769Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3770SET GTID_NEXT = 'AUTOMATIC'; 3771include/assert.inc [Both counters should be 0] 3772---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 3773CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 3774SET AUTOCOMMIT = 0; 3775# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC 3776SET GTID_NEXT = 'AUTOMATIC'; 3777[START] DROP TEMPORARY TABLE t1; 3778include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3779include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3780[END] DROP TEMPORARY TABLE t1; 3781Warnings: 3782Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3783include/assert.inc [One warning/error should be generated.] 3784include/assert.inc [It should be a Warning, not an Error.] 3785include/assert.inc [Text should be "violates GTID consistency"] 3786include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3787include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3788ROLLBACK; 3789Warnings: 3790Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3791SET GTID_NEXT = 'AUTOMATIC'; 3792include/assert.inc [Both counters should be 0] 3793SET AUTOCOMMIT = 1; 3794---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 3795CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 3796SET AUTOCOMMIT = 0; 3797# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=AUTOMATIC 3798SET GTID_NEXT = 'AUTOMATIC'; 3799[START] DROP TEMPORARY TABLE t1; 3800include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3801include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3802[END] DROP TEMPORARY TABLE t1; 3803Warnings: 3804Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3805include/assert.inc [One warning/error should be generated.] 3806include/assert.inc [It should be a Warning, not an Error.] 3807include/assert.inc [Text should be "violates GTID consistency"] 3808include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3809include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3810ROLLBACK; 3811Warnings: 3812Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3813SET GTID_NEXT = 'AUTOMATIC'; 3814include/assert.inc [Both counters should be 0] 3815SET AUTOCOMMIT = 1; 3816DROP TEMPORARY TABLE IF EXISTS t1; 3817Warnings: 3818Note 1051 Unknown table 'test.t1' 3819######## ENFORCE_GTID_CONSISTENCY=WARN GTID_MODE=OFF GTID_NEXT=ANONYMOUS ######## 3820---- CREATE TEMPORARY in trx (InnoDB, BEGIN) ---- 3821# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS 3822SET GTID_NEXT = 'ANONYMOUS'; 3823BEGIN; 3824[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3825include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3826include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3827[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3828Warnings: 3829Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3830include/assert.inc [One warning/error should be generated.] 3831include/assert.inc [It should be a Warning, not an Error.] 3832include/assert.inc [Text should be "violates GTID consistency"] 3833include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3834include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3835ROLLBACK; 3836Warnings: 3837Warning 1751 The creation of some temporary tables could not be rolled back. 3838SET GTID_NEXT = 'AUTOMATIC'; 3839include/assert.inc [Both counters should be 0] 3840DROP TEMPORARY TABLE IF EXISTS t1; 3841---- CREATE TEMPORARY in trx (MyISAM, BEGIN) ---- 3842# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS 3843SET GTID_NEXT = 'ANONYMOUS'; 3844BEGIN; 3845[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3846include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3847include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3848[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3849Warnings: 3850Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3851include/assert.inc [One warning/error should be generated.] 3852include/assert.inc [It should be a Warning, not an Error.] 3853include/assert.inc [Text should be "violates GTID consistency"] 3854include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3855include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 3856ROLLBACK; 3857Warnings: 3858Warning 1751 The creation of some temporary tables could not be rolled back. 3859SET GTID_NEXT = 'AUTOMATIC'; 3860include/assert.inc [Both counters should be 0] 3861DROP TEMPORARY TABLE IF EXISTS t1; 3862---- CREATE TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 3863SET AUTOCOMMIT = 0; 3864# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS 3865SET GTID_NEXT = 'ANONYMOUS'; 3866[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3867include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3868include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3869[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = InnoDB; 3870Warnings: 3871Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3872include/assert.inc [One warning/error should be generated.] 3873include/assert.inc [It should be a Warning, not an Error.] 3874include/assert.inc [Text should be "violates GTID consistency"] 3875include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3876include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3877ROLLBACK; 3878Warnings: 3879Warning 1751 The creation of some temporary tables could not be rolled back. 3880SET GTID_NEXT = 'AUTOMATIC'; 3881include/assert.inc [Both counters should be 0] 3882SET AUTOCOMMIT = 1; 3883DROP TEMPORARY TABLE IF EXISTS t1; 3884---- CREATE TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 3885SET AUTOCOMMIT = 0; 3886# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS 3887SET GTID_NEXT = 'ANONYMOUS'; 3888[START] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3889include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3890include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3891[END] CREATE TEMPORARY TABLE t1 (a INT) ENGINE = MyISAM; 3892Warnings: 3893Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3894include/assert.inc [One warning/error should be generated.] 3895include/assert.inc [It should be a Warning, not an Error.] 3896include/assert.inc [Text should be "violates GTID consistency"] 3897include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3898include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0 (stm) / 1 (row)] 3899ROLLBACK; 3900Warnings: 3901Warning 1751 The creation of some temporary tables could not be rolled back. 3902SET GTID_NEXT = 'AUTOMATIC'; 3903include/assert.inc [Both counters should be 0] 3904SET AUTOCOMMIT = 1; 3905DROP TEMPORARY TABLE IF EXISTS t1; 3906---- DROP TEMPORARY in trx (InnoDB, BEGIN) ---- 3907CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 3908# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS 3909SET GTID_NEXT = 'ANONYMOUS'; 3910BEGIN; 3911[START] DROP TEMPORARY TABLE t1; 3912include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3913include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3914[END] DROP TEMPORARY TABLE t1; 3915Warnings: 3916Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3917include/assert.inc [One warning/error should be generated.] 3918include/assert.inc [It should be a Warning, not an Error.] 3919include/assert.inc [Text should be "violates GTID consistency"] 3920include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3921include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3922ROLLBACK; 3923Warnings: 3924Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3925SET GTID_NEXT = 'AUTOMATIC'; 3926include/assert.inc [Both counters should be 0] 3927---- DROP TEMPORARY in trx (MyISAM, BEGIN) ---- 3928CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 3929# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS 3930SET GTID_NEXT = 'ANONYMOUS'; 3931BEGIN; 3932[START] DROP TEMPORARY TABLE t1; 3933include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3934include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3935[END] DROP TEMPORARY TABLE t1; 3936Warnings: 3937Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3938include/assert.inc [One warning/error should be generated.] 3939include/assert.inc [It should be a Warning, not an Error.] 3940include/assert.inc [Text should be "violates GTID consistency"] 3941include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3942include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3943ROLLBACK; 3944Warnings: 3945Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3946SET GTID_NEXT = 'AUTOMATIC'; 3947include/assert.inc [Both counters should be 0] 3948---- DROP TEMPORARY in trx (InnoDB, AUTOCOMMIT=0) ---- 3949CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = InnoDB; 3950SET AUTOCOMMIT = 0; 3951# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS 3952SET GTID_NEXT = 'ANONYMOUS'; 3953[START] DROP TEMPORARY TABLE t1; 3954include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3955include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3956[END] DROP TEMPORARY TABLE t1; 3957Warnings: 3958Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3959include/assert.inc [One warning/error should be generated.] 3960include/assert.inc [It should be a Warning, not an Error.] 3961include/assert.inc [Text should be "violates GTID consistency"] 3962include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3963include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3964ROLLBACK; 3965Warnings: 3966Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3967SET GTID_NEXT = 'AUTOMATIC'; 3968include/assert.inc [Both counters should be 0] 3969SET AUTOCOMMIT = 1; 3970---- DROP TEMPORARY in trx (MyISAM, AUTOCOMMIT=0) ---- 3971CREATE TEMPORARY TABLE IF NOT EXISTS t1 (a INT) ENGINE = MyISAM; 3972SET AUTOCOMMIT = 0; 3973# enforce_gtid_consistency=2 gtid_mode=0 gtid_next=ANONYMOUS 3974SET GTID_NEXT = 'ANONYMOUS'; 3975[START] DROP TEMPORARY TABLE t1; 3976include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3977include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 1] 3978[END] DROP TEMPORARY TABLE t1; 3979Warnings: 3980Warning 1787 Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context. These statements are also not allowed in a function or trigger because functions and triggers are also considered to be multi-statement transactions. 3981include/assert.inc [One warning/error should be generated.] 3982include/assert.inc [It should be a Warning, not an Error.] 3983include/assert.inc [Text should be "violates GTID consistency"] 3984include/assert.inc [ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3985include/assert.inc [ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT should be 0] 3986ROLLBACK; 3987Warnings: 3988Warning 1752 Some temporary tables were dropped, but these operations could not be rolled back. 3989SET GTID_NEXT = 'AUTOMATIC'; 3990include/assert.inc [Both counters should be 0] 3991SET AUTOCOMMIT = 1; 3992DROP TEMPORARY TABLE IF EXISTS t1; 3993Warnings: 3994Note 1051 Unknown table 'test.t1' 3995SET GLOBAL ENFORCE_GTID_CONSISTENCY = OFF; 3996SET GLOBAL SQL_NOTES = @old_sql_notes; 3997include/rpl_end.inc 3998