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