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