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