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