github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/pessimistic_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 commit; 101 set autocommit=1; 102 select * from test_11; 103 c d 104 1 1 105 2 2 106 commit; 107 set autocommit=1; 108 select * from test_11; 109 c d 110 1 1 111 2 2 112 drop table if exists test_11; 113 create table test_11 (c int primary key,d int); 114 Insert into test_11 values(1,1); 115 Insert into test_11 values(2,2); 116 set autocommit=0; 117 Insert into test_11 values(3,1); 118 Insert into test_11 values(4,2); 119 select * from test_11; 120 c d 121 3 1 122 4 2 123 1 1 124 2 2 125 set autocommit=0; 126 select * from test_11; 127 c d 128 1 1 129 2 2 130 Insert into test_11 values(5,4); 131 select * from test_11; 132 c d 133 5 4 134 1 1 135 2 2 136 select * from test_11; 137 c d 138 3 1 139 4 2 140 1 1 141 2 2 142 Insert into test_11 values(50,50); 143 Insert into test_11 values(51,50); 144 select * from test_11; 145 c d 146 5 4 147 51 50 148 1 1 149 2 2 150 select * from test_11; 151 c d 152 3 1 153 4 2 154 50 50 155 1 1 156 2 2 157 commit; 158 set autocommit=1; 159 commit; 160 set autocommit=1; 161 select * from test_11; 162 c d 163 1 1 164 2 2 165 3 1 166 4 2 167 50 50 168 5 4 169 51 50 170 select * from test_11; 171 c d 172 1 1 173 2 2 174 3 1 175 4 2 176 50 50 177 5 4 178 51 50 179 drop table if exists test_11; 180 create table test_11 (c int primary key,d int); 181 Insert into test_11 values(1,1); 182 Insert into test_11 values(2,2); 183 set autocommit=0; 184 Insert into test_11 values(3,1); 185 Insert into test_11 values(4,2); 186 select * from test_11; 187 c d 188 3 1 189 4 2 190 1 1 191 2 2 192 set autocommit=0; 193 select * from test_11; 194 c d 195 1 1 196 2 2 197 Insert into test_11 values(5,4); 198 select * from test_11; 199 c d 200 5 4 201 1 1 202 2 2 203 select * from test_11; 204 c d 205 3 1 206 4 2 207 1 1 208 2 2 209 Insert into test_11 values(50,50); 210 Insert into test_11 values(50,50); 211 Duplicate entry '50' for key 'c' 212 select * from test_11; 213 c d 214 1 1 215 2 2 216 3 1 217 4 2 218 50 50 219 5 4 220 select * from test_11; 221 c d 222 3 1 223 4 2 224 50 50 225 1 1 226 2 2 227 commit; 228 set autocommit=1; 229 commit; 230 set autocommit=1; 231 select * from test_11; 232 c d 233 1 1 234 2 2 235 3 1 236 4 2 237 50 50 238 5 4 239 select * from test_11; 240 c d 241 1 1 242 2 2 243 3 1 244 4 2 245 50 50 246 5 4 247 drop table if exists test_11; 248 create table test_11 (c int primary key,d int); 249 Insert into test_11 values(1,1); 250 Insert into test_11 values(2,2); 251 set autocommit=0; 252 select * from test_11; 253 c d 254 1 1 255 2 2 256 Insert into test_11 values(50,50); 257 select * from test_11; 258 c d 259 50 50 260 1 1 261 2 2 262 set autocommit=0; 263 select * from test_11; 264 c d 265 1 1 266 2 2 267 Insert into test_11 values(50,50); 268 Duplicate entry '50' for key 'c' 269 select * from test_11; 270 c d 271 50 50 272 1 1 273 2 2 274 select * from test_11; 275 c d 276 50 50 277 1 1 278 2 2 279 delete from test_11 where c = 50; 280 select * from test_11; 281 c d 282 1 1 283 2 2 284 select * from test_11; 285 c d 286 50 50 287 1 1 288 2 2 289 commit; 290 set autocommit=1; 291 commit; 292 set autocommit=1; 293 select * from test_11; 294 c d 295 1 1 296 2 2 297 select * from test_11; 298 c d 299 1 1 300 2 2 301 drop table if exists test_11; 302 create table test_11 (c int primary key,d int); 303 Insert into test_11 values(1,1); 304 Insert into test_11 values(2,2); 305 set autocommit=0; 306 select * from test_11; 307 c d 308 1 1 309 2 2 310 Insert into test_11 values(50,50); 311 select * from test_11; 312 c d 313 50 50 314 1 1 315 2 2 316 set autocommit=0; 317 select * from test_11; 318 c d 319 1 1 320 2 2 321 Insert into test_11 values(50,50); 322 Duplicate entry '50' for key 'c' 323 select * from test_11; 324 c d 325 50 50 326 1 1 327 2 2 328 select * from test_11; 329 c d 330 50 50 331 1 1 332 2 2 333 select * from test_11; 334 c d 335 50 50 336 1 1 337 2 2 338 update test_11 set c = 100 where d = 50; 339 select * from test_11; 340 c d 341 100 50 342 1 1 343 2 2 344 select * from test_11; 345 c d 346 50 50 347 1 1 348 2 2 349 Insert into test_11 values(100,50); 350 Duplicate entry '100' for key 'c' 351 commit; 352 set autocommit=1; 353 commit; 354 set autocommit=1; 355 select * from test_11; 356 c d 357 1 1 358 2 2 359 100 50 360 select * from test_11; 361 c d 362 1 1 363 2 2 364 100 50 365 drop table if exists test_11; 366 create table test_11 (c int primary key,d int); 367 Insert into test_11 values(1,1); 368 Insert into test_11 values(2,2); 369 set autocommit=0; 370 select * from test_11; 371 c d 372 1 1 373 2 2 374 Insert into test_11 values(50,50); 375 select * from test_11; 376 c d 377 50 50 378 1 1 379 2 2 380 set autocommit=0; 381 select * from test_11; 382 c d 383 1 1 384 2 2 385 Insert into test_11 values(50,50); 386 Duplicate entry '50' for key 'c' 387 select * from test_11; 388 c d 389 50 50 390 1 1 391 2 2 392 select * from test_11; 393 c d 394 50 50 395 1 1 396 2 2 397 select * from test_11; 398 c d 399 50 50 400 1 1 401 2 2 402 update test_11 set c = 100 where d = 50; 403 select * from test_11; 404 c d 405 100 50 406 1 1 407 2 2 408 select * from test_11; 409 c d 410 50 50 411 1 1 412 2 2 413 update test_11 set c = 101 where c = 50; 414 commit; 415 set autocommit=1; 416 commit; 417 set autocommit=1; 418 select * from test_11; 419 c d 420 1 1 421 2 2 422 100 50 423 select * from test_11; 424 c d 425 1 1 426 2 2 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 Duplicate entry '50' for key 'c' 450 select * from test_11; 451 c d 452 50 50 453 1 1 454 2 2 455 select * from test_11; 456 c d 457 50 50 458 1 1 459 2 2 460 select * from test_11; 461 c d 462 50 50 463 1 1 464 2 2 465 update test_11 set c = 100 where d = 50; 466 select * from test_11; 467 c d 468 100 50 469 1 1 470 2 2 471 select * from test_11; 472 c d 473 50 50 474 1 1 475 2 2 476 update test_11 set c = 100 where d = 50; 477 commit; 478 set autocommit=1; 479 commit; 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 commit; 504 set autocommit=1; 505 select * from test_11; 506 c d 507 1 1 508 2 2 509 commit; 510 set autocommit=1; 511 select * from test_11; 512 c d 513 1 1 514 2 2 515 drop table if exists test_11; 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 set autocommit=0; 524 select * from test_11; 525 c d 526 1 1 527 2 2 528 set autocommit=0; 529 drop table test_11; 530 select * from test_11; 531 SQL parser error: table "test_11" does not exist 532 select * from test_11; 533 c d 534 1 1 535 2 2 536 commit; 537 set autocommit=1; 538 select * from test_11; 539 SQL parser error: table "test_11" does not exist 540 commit; 541 set autocommit=1; 542 select * from test_11; 543 SQL parser error: table "test_11" does not exist 544 drop table if exists test_11; 545 set autocommit=0; 546 create table test_11 (c int primary key,d int); 547 Insert into test_11 values(1,1); 548 Insert into test_11 values(2,2); 549 select * from test_11; 550 c d 551 1 1 552 2 2 553 set autocommit=0; 554 select * from test_11; 555 SQL parser error: table "test_11" does not exist 556 select * from test_11; 557 c d 558 1 1 559 2 2 560 select * from test_11; 561 SQL parser error: table "test_11" does not exist 562 commit; 563 set autocommit=1; 564 select * from test_11; 565 c d 566 1 1 567 2 2 568 commit; 569 set autocommit=1; 570 select * from test_11; 571 c d 572 1 1 573 2 2 574 drop table if exists test_11;