github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/pessimistic_transaction/autocommit_isolation.result (about) 1 drop table if exists test_11; 2 create table test_11 (c int primary key,d int); 3 Insert into test_11 values(1,1); 4 Insert into test_11 values(2,2); 5 set @@autocommit=0; 6 Insert into test_11 values(3,1); 7 Insert into test_11 values(4,2); 8 select * from test_11; 9 c d 10 3 1 11 4 2 12 1 1 13 2 2 14 use autocommit_isolation; 15 select * from test_11; 16 c d 17 1 1 18 2 2 19 commit; 20 set @@autocommit=1; 21 select * from test_11; 22 c d 23 1 1 24 2 2 25 3 1 26 4 2 27 select * from test_11; 28 c d 29 1 1 30 2 2 31 3 1 32 4 2 33 drop table if exists test_11; 34 create table test_11 (c int primary key,d int); 35 Insert into test_11 values(1,1); 36 Insert into test_11 values(2,2); 37 set @@autocommit=0; 38 Insert into test_11 values(3,1); 39 Insert into test_11 values(4,2); 40 select * from test_11; 41 c d 42 3 1 43 4 2 44 1 1 45 2 2 46 select * from test_11; 47 c d 48 1 1 49 2 2 50 delete from test_11 where c =1; 51 select * from test_11; 52 c d 53 3 1 54 4 2 55 2 2 56 select * from test_11; 57 c d 58 1 1 59 2 2 60 update test_11 set d = c +1 where c > 2; 61 select * from test_11; 62 c d 63 3 4 64 4 5 65 2 2 66 select * from test_11; 67 c d 68 1 1 69 2 2 70 commit; 71 set @@autocommit=1; 72 select * from test_11; 73 c d 74 2 2 75 3 4 76 4 5 77 select * from test_11; 78 c d 79 2 2 80 3 4 81 4 5 82 drop table if exists test_11; 83 set @@autocommit=0; 84 create table test_11 (c int primary key,d int); 85 Insert into test_11 values(1,1); 86 Insert into test_11 values(2,2); 87 select * from test_11; 88 c d 89 1 1 90 2 2 91 select * from test_11; 92 SQL parser error: table "test_11" does not exist 93 commit; 94 set @@autocommit=1; 95 select * from test_11; 96 c d 97 1 1 98 2 2 99 select * from test_11; 100 c d 101 1 1 102 2 2 103 drop table if exists test_11; 104 set @@autocommit=0; 105 create table test_11 (c int primary key,d int); 106 Insert into test_11 values(1,1); 107 Insert into test_11 values(2,2); 108 select * from test_11; 109 c d 110 1 1 111 2 2 112 delete from test_11 where c = 1; 113 no such table autocommit_isolation.test_11 114 select * from test_11; 115 SQL parser error: table "test_11" does not exist 116 Insert into test_11 values(1,1); 117 Duplicate entry '\d' for key 'c' 118 select * from test_11; 119 SQL parser error: table "test_11" does not exist 120 commit; 121 set @@autocommit=1; 122 select * from test_11; 123 SQL parser error: table "test_11" does not exist 124 select * from test_11; 125 SQL parser error: table "test_11" does not exist 126 drop table if exists test_11; 127 create table test_11 (c int primary key,d int); 128 Insert into test_11 values(1,1); 129 Insert into test_11 values(2,2); 130 set @@autocommit=0; 131 Insert into test_11 values(3,1); 132 Insert into test_11 values(4,2); 133 select * from test_11; 134 c d 135 3 1 136 4 2 137 1 1 138 2 2 139 select * from test_11; 140 c d 141 1 1 142 2 2 143 Insert into test_11 values(5,4); 144 select * from test_11; 145 c d 146 1 1 147 2 2 148 5 4 149 select * from test_11; 150 c d 151 3 1 152 4 2 153 1 1 154 2 2 155 5 4 156 Insert into test_11 values(50,50); 157 Insert into test_11 values(50,50); 158 Duplicate entry '\d{2}' for key 'c' 159 select * from test_11; 160 c d 161 1 1 162 2 2 163 5 4 164 3 1 165 4 2 166 50 50 167 select * from test_11; 168 c d 169 1 1 170 2 2 171 5 4 172 3 1 173 4 2 174 50 50 175 commit; 176 set @@autocommit=1; 177 select * from test_11; 178 c d 179 1 1 180 2 2 181 5 4 182 3 1 183 4 2 184 50 50 185 select * from test_11; 186 c d 187 1 1 188 2 2 189 5 4 190 3 1 191 4 2 192 50 50 193 drop table if exists test_11; 194 create table test_11 (c int primary key,d int); 195 Insert into test_11 values(1,1); 196 Insert into test_11 values(2,2); 197 set @@autocommit=0; 198 select * from test_11; 199 c d 200 1 1 201 2 2 202 select * from test_11; 203 c d 204 1 1 205 2 2 206 Insert into test_11 values(50,50); 207 select * from test_11; 208 c d 209 1 1 210 2 2 211 50 50 212 Insert into test_11 values(50,50); 213 Duplicate entry '\d{2}' for key 'c' 214 select * from test_11; 215 c d 216 50 50 217 1 1 218 2 2 219 commit; 220 set @@autocommit=1; 221 select * from test_11; 222 c d 223 1 1 224 2 2 225 50 50 226 select * from test_11; 227 c d 228 1 1 229 2 2 230 50 50 231 drop table if exists test_11; 232 create table test_11 (c int primary key,d int); 233 Insert into test_11 values(1,1); 234 Insert into test_11 values(2,2); 235 set @@autocommit=0; 236 select * from test_11; 237 c d 238 1 1 239 2 2 240 Insert into test_11 values(50,50); 241 select * from test_11; 242 c d 243 50 50 244 1 1 245 2 2 246 select * from test_11; 247 c d 248 1 1 249 2 2 250 Insert into test_11 values(50,50); 251 Duplicate entry '\d{2}' for key 'c' 252 select * from test_11; 253 c d 254 1 1 255 2 2 256 50 50 257 select * from test_11; 258 c d 259 50 50 260 1 1 261 2 2 262 select * from test_11; 263 c d 264 1 1 265 2 2 266 50 50 267 delete from test_11 where c = 50; 268 select * from test_11; 269 c d 270 1 1 271 2 2 272 select * from test_11; 273 c d 274 1 1 275 2 2 276 commit; 277 set @@autocommit=1; 278 select * from test_11; 279 c d 280 1 1 281 2 2 282 select * from test_11; 283 c d 284 1 1 285 2 2 286 drop table if exists test_11; 287 create table test_11 (c int primary key,d int); 288 Insert into test_11 values(1,1); 289 Insert into test_11 values(2,2); 290 set @@autocommit=0; 291 select * from test_11; 292 c d 293 1 1 294 2 2 295 Insert into test_11 values(50,50); 296 select * from test_11; 297 c d 298 50 50 299 1 1 300 2 2 301 select * from test_11; 302 c d 303 1 1 304 2 2 305 Insert into test_11 values(50,50); 306 Duplicate entry '\d{2}' for key 'c' 307 select * from test_11; 308 c d 309 1 1 310 2 2 311 50 50 312 select * from test_11; 313 c d 314 50 50 315 1 1 316 2 2 317 select * from test_11; 318 c d 319 1 1 320 2 2 321 50 50 322 update test_11 set c = 100 where d = 50; 323 select * from test_11; 324 c d 325 1 1 326 2 2 327 100 50 328 select * from test_11; 329 c d 330 1 1 331 2 2 332 100 50 333 Insert into test_11 values(100,50); 334 Duplicate entry '\d{3}' for key 'c' 335 commit; 336 set @@autocommit=1; 337 select * from test_11; 338 c d 339 1 1 340 2 2 341 100 50 342 select * from test_11; 343 c d 344 1 1 345 2 2 346 100 50 347 drop table if exists test_11; 348 create table test_11 (c int primary key,d int); 349 Insert into test_11 values(1,1); 350 Insert into test_11 values(2,2); 351 set @@autocommit=0; 352 select * from test_11; 353 c d 354 1 1 355 2 2 356 Insert into test_11 values(50,50); 357 select * from test_11; 358 c d 359 50 50 360 1 1 361 2 2 362 select * from test_11; 363 c d 364 1 1 365 2 2 366 Insert into test_11 values(50,50); 367 Duplicate entry '\d{2}' for key 'c' 368 select * from test_11; 369 c d 370 1 1 371 2 2 372 50 50 373 select * from test_11; 374 c d 375 50 50 376 1 1 377 2 2 378 select * from test_11; 379 c d 380 1 1 381 2 2 382 50 50 383 update test_11 set c = 100 where d = 50; 384 select * from test_11; 385 c d 386 1 1 387 2 2 388 100 50 389 select * from test_11; 390 c d 391 1 1 392 2 2 393 100 50 394 update test_11 set c = 101 where c = 50; 395 commit; 396 set @@autocommit=1; 397 select * from test_11; 398 c d 399 1 1 400 2 2 401 100 50 402 select * from test_11; 403 c d 404 1 1 405 2 2 406 100 50 407 drop table if exists test_11; 408 create table test_11 (c int primary key,d int); 409 Insert into test_11 values(1,1); 410 Insert into test_11 values(2,2); 411 set @@autocommit=0; 412 select * from test_11; 413 c d 414 1 1 415 2 2 416 Insert into test_11 values(50,50); 417 select * from test_11; 418 c d 419 50 50 420 1 1 421 2 2 422 select * from test_11; 423 c d 424 1 1 425 2 2 426 Insert into test_11 values(50,50); 427 Duplicate entry '\d{2}' for key 'c' 428 select * from test_11; 429 c d 430 1 1 431 2 2 432 50 50 433 select * from test_11; 434 c d 435 50 50 436 1 1 437 2 2 438 select * from test_11; 439 c d 440 1 1 441 2 2 442 50 50 443 update test_11 set c = 100 where d = 50; 444 select * from test_11; 445 c d 446 1 1 447 2 2 448 100 50 449 select * from test_11; 450 c d 451 1 1 452 2 2 453 100 50 454 update test_11 set c = 100 where d = 50; 455 commit; 456 set @@autocommit=1; 457 select * from test_11; 458 c d 459 1 1 460 2 2 461 100 50 462 select * from test_11; 463 c d 464 1 1 465 2 2 466 100 50 467 drop table if exists test_11; 468 set @@autocommit=0; 469 create table test_11 (c int primary key,d int); 470 Insert into test_11 values(1,1); 471 Insert into test_11 values(2,2); 472 select * from test_11; 473 c d 474 1 1 475 2 2 476 select * from test_11; 477 SQL parser error: table "test_11" does not exist 478 commit; 479 set @@autocommit=1; 480 select * from test_11; 481 c d 482 1 1 483 2 2 484 select * from test_11; 485 c d 486 1 1 487 2 2 488 drop table if exists test_11; 489 create table test_11 (c int primary key,d int); 490 Insert into test_11 values(1,1); 491 Insert into test_11 values(2,2); 492 select * from test_11; 493 c d 494 1 1 495 2 2 496 select * from test_11; 497 c d 498 1 1 499 2 2 500 set @@autocommit=0; 501 drop table test_11; 502 select * from test_11; 503 SQL parser error: table "test_11" does not exist 504 select * from test_11; 505 c d 506 1 1 507 2 2 508 commit; 509 set @@autocommit=1; 510 select * from test_11; 511 SQL parser error: table "test_11" does not exist 512 select * from test_11; 513 SQL parser error: table "test_11" does not exist 514 drop table if exists test_11; 515 set @@autocommit=0; 516 create table test_11 (c int primary key,d int); 517 Insert into test_11 values(1,1); 518 Insert into test_11 values(2,2); 519 select * from test_11; 520 c d 521 1 1 522 2 2 523 select * from test_11; 524 SQL parser error: table "test_11" does not exist 525 select * from test_11; 526 c d 527 1 1 528 2 2 529 select * from test_11; 530 SQL parser error: table "test_11" does not exist 531 commit; 532 set @@autocommit=1; 533 select * from test_11; 534 c d 535 1 1 536 2 2 537 select * from test_11; 538 c d 539 1 1 540 2 2 541 drop table if exists test_11; 542 create database test_drop_db; 543 set autocommit=0; 544 use test_drop_db; 545 drop database test_drop_db; 546 show databases like '%test_drop_db%'; 547 Database 548 set autocommit=1;