github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/optimistic/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 select * from test_11; 212 c d 213 5 4 214 50 50 215 1 1 216 2 2 217 select * from test_11; 218 c d 219 3 1 220 4 2 221 50 50 222 1 1 223 2 2 224 commit; 225 set autocommit=1; 226 commit; 227 w-w conflict 228 set autocommit=1; 229 select * from test_11; 230 c d 231 1 1 232 2 2 233 3 1 234 4 2 235 50 50 236 select * from test_11; 237 c d 238 1 1 239 2 2 240 3 1 241 4 2 242 50 50 243 drop table if exists test_11; 244 create table test_11 (c int primary key,d int); 245 Insert into test_11 values(1,1); 246 Insert into test_11 values(2,2); 247 set autocommit=0; 248 select * from test_11; 249 c d 250 1 1 251 2 2 252 Insert into test_11 values(50,50); 253 select * from test_11; 254 c d 255 50 50 256 1 1 257 2 2 258 set autocommit=0; 259 select * from test_11; 260 c d 261 1 1 262 2 2 263 Insert into test_11 values(50,50); 264 select * from test_11; 265 c d 266 50 50 267 1 1 268 2 2 269 select * from test_11; 270 c d 271 50 50 272 1 1 273 2 2 274 delete from test_11 where c = 50; 275 select * from test_11; 276 c d 277 1 1 278 2 2 279 select * from test_11; 280 c d 281 50 50 282 1 1 283 2 2 284 commit; 285 set autocommit=1; 286 commit; 287 set autocommit=1; 288 select * from test_11; 289 c d 290 1 1 291 2 2 292 50 50 293 select * from test_11; 294 c d 295 1 1 296 2 2 297 50 50 298 drop table if exists test_11; 299 create table test_11 (c int primary key,d int); 300 Insert into test_11 values(1,1); 301 Insert into test_11 values(2,2); 302 set autocommit=0; 303 select * from test_11; 304 c d 305 1 1 306 2 2 307 Insert into test_11 values(50,50); 308 select * from test_11; 309 c d 310 50 50 311 1 1 312 2 2 313 set autocommit=0; 314 select * from test_11; 315 c d 316 1 1 317 2 2 318 Insert into test_11 values(50,50); 319 select * from test_11; 320 c d 321 50 50 322 1 1 323 2 2 324 select * from test_11; 325 c d 326 50 50 327 1 1 328 2 2 329 select * from test_11; 330 c d 331 50 50 332 1 1 333 2 2 334 update test_11 set c = 100 where d = 50; 335 select * from test_11; 336 c d 337 100 50 338 1 1 339 2 2 340 select * from test_11; 341 c d 342 50 50 343 1 1 344 2 2 345 Insert into test_11 values(100,50); 346 commit; 347 set autocommit=1; 348 commit; 349 w-w conflict 350 set autocommit=1; 351 select * from test_11; 352 c d 353 1 1 354 2 2 355 50 50 356 100 50 357 select * from test_11; 358 c d 359 1 1 360 2 2 361 50 50 362 100 50 363 drop table if exists test_11; 364 create table test_11 (c int primary key,d int); 365 Insert into test_11 values(1,1); 366 Insert into test_11 values(2,2); 367 set autocommit=0; 368 select * from test_11; 369 c d 370 1 1 371 2 2 372 Insert into test_11 values(50,50); 373 select * from test_11; 374 c d 375 50 50 376 1 1 377 2 2 378 set autocommit=0; 379 select * from test_11; 380 c d 381 1 1 382 2 2 383 Insert into test_11 values(50,50); 384 select * from test_11; 385 c d 386 50 50 387 1 1 388 2 2 389 select * from test_11; 390 c d 391 50 50 392 1 1 393 2 2 394 select * from test_11; 395 c d 396 50 50 397 1 1 398 2 2 399 update test_11 set c = 100 where d = 50; 400 select * from test_11; 401 c d 402 100 50 403 1 1 404 2 2 405 select * from test_11; 406 c d 407 50 50 408 1 1 409 2 2 410 update test_11 set c = 101 where c = 50; 411 commit; 412 set autocommit=1; 413 commit; 414 set autocommit=1; 415 select * from test_11; 416 c d 417 1 1 418 2 2 419 101 50 420 100 50 421 select * from test_11; 422 c d 423 1 1 424 2 2 425 101 50 426 100 50 427 drop table if exists test_11; 428 create table test_11 (c int primary key,d int); 429 Insert into test_11 values(1,1); 430 Insert into test_11 values(2,2); 431 set autocommit=0; 432 select * from test_11; 433 c d 434 1 1 435 2 2 436 Insert into test_11 values(50,50); 437 select * from test_11; 438 c d 439 50 50 440 1 1 441 2 2 442 set autocommit=0; 443 select * from test_11; 444 c d 445 1 1 446 2 2 447 Insert into test_11 values(50,50); 448 select * from test_11; 449 c d 450 50 50 451 1 1 452 2 2 453 select * from test_11; 454 c d 455 50 50 456 1 1 457 2 2 458 select * from test_11; 459 c d 460 50 50 461 1 1 462 2 2 463 update test_11 set c = 100 where d = 50; 464 select * from test_11; 465 c d 466 100 50 467 1 1 468 2 2 469 select * from test_11; 470 c d 471 50 50 472 1 1 473 2 2 474 update test_11 set c = 100 where d = 50; 475 commit; 476 set autocommit=1; 477 commit; 478 w-w conflict 479 set autocommit=1; 480 select * from test_11; 481 c d 482 1 1 483 2 2 484 100 50 485 select * from test_11; 486 c d 487 1 1 488 2 2 489 100 50 490 drop table if exists test_11; 491 set autocommit=0; 492 create table test_11 (c int primary key,d int); 493 Insert into test_11 values(1,1); 494 Insert into test_11 values(2,2); 495 select * from test_11; 496 c d 497 1 1 498 2 2 499 set autocommit=0; 500 select * from test_11; 501 SQL parser error: table "test_11" does not exist 502 commit; 503 set autocommit=1; 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 c d 512 1 1 513 2 2 514 drop table if exists test_11; 515 create table test_11 (c int primary key,d int); 516 Insert into test_11 values(1,1); 517 Insert into test_11 values(2,2); 518 select * from test_11; 519 c d 520 1 1 521 2 2 522 set autocommit=0; 523 select * from test_11; 524 c d 525 1 1 526 2 2 527 set autocommit=0; 528 drop table test_11; 529 select * from test_11; 530 SQL parser error: table "test_11" does not exist 531 select * from test_11; 532 c d 533 1 1 534 2 2 535 commit; 536 set autocommit=1; 537 select * from test_11; 538 SQL parser error: table "test_11" does not exist 539 commit; 540 set autocommit=1; 541 select * from test_11; 542 SQL parser error: table "test_11" does not exist 543 drop table if exists test_11; 544 set autocommit=0; 545 create table test_11 (c int primary key,d int); 546 Insert into test_11 values(1,1); 547 Insert into test_11 values(2,2); 548 select * from test_11; 549 c d 550 1 1 551 2 2 552 set autocommit=0; 553 select * from test_11; 554 SQL parser error: table "test_11" does not exist 555 select * from test_11; 556 c d 557 1 1 558 2 2 559 select * from test_11; 560 SQL parser error: table "test_11" does not exist 561 commit; 562 set autocommit=1; 563 select * from test_11; 564 c d 565 1 1 566 2 2 567 commit; 568 set autocommit=1; 569 select * from test_11; 570 c d 571 1 1 572 2 2 573 drop table if exists test_11;