github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/transaction/autocommit_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 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; 15 select * from test_11; 16 c d 17 1 1 18 2 2 19 commit; 20 set @@autocommit=1; 21 select * from test_11; 22 c d 23 1 1 24 2 2 25 3 1 26 4 2 27 select * from test_11; 28 c d 29 1 1 30 2 2 31 3 1 32 4 2 33 drop table if exists test_11; 34 create table test_11 (c int primary key,d int); 35 Insert into test_11 values(1,1); 36 Insert into test_11 values(2,2); 37 set @@autocommit=0; 38 Insert into test_11 values(3,1); 39 Insert into test_11 values(4,2); 40 select * from test_11; 41 c d 42 3 1 43 4 2 44 1 1 45 2 2 46 select * from test_11; 47 c d 48 1 1 49 2 2 50 delete from test_11 where c =1; 51 select * from test_11; 52 c d 53 3 1 54 4 2 55 2 2 56 select * from test_11; 57 c d 58 1 1 59 2 2 60 update test_11 set d = c +1 where c > 2; 61 select * from test_11; 62 c d 63 3 4 64 4 5 65 2 2 66 select * from test_11; 67 c d 68 1 1 69 2 2 70 commit; 71 set @@autocommit=1; 72 select * from test_11; 73 c d 74 2 2 75 3 4 76 4 5 77 select * from test_11; 78 c d 79 2 2 80 3 4 81 4 5 82 drop table if exists test_11; 83 set @@autocommit=0; 84 create table test_11 (c int primary key,d int); 85 Insert into test_11 values(1,1); 86 Insert into test_11 values(2,2); 87 select * from test_11; 88 c d 89 1 1 90 2 2 91 select * from test_11; 92 SQL parser error: table "test_11" does not exist 93 commit; 94 set @@autocommit=1; 95 select * from test_11; 96 c d 97 1 1 98 2 2 99 select * from test_11; 100 c d 101 1 1 102 2 2 103 drop table if exists test_11; 104 set @@autocommit=0; 105 create table test_11 (c int primary key,d int); 106 Insert into test_11 values(1,1); 107 Insert into test_11 values(2,2); 108 select * from test_11; 109 c d 110 1 1 111 2 2 112 delete from test_11 where c = 1; 113 no such table autocommit_isolation.test_11 114 select * from test_11; 115 SQL parser error: table "test_11" does not exist 116 Insert into test_11 values(1,1); 117 Duplicate entry '1' for key 'c' 118 Previous DML conflicts with existing constraints or data format. This transaction has to be aborted 119 select * from test_11; 120 SQL parser error: table "test_11" does not exist 121 Previous DML conflicts with existing constraints or data format. This transaction has to be aborted 122 commit; 123 set @@autocommit=1; 124 select * from test_11; 125 SQL parser error: table "test_11" does not exist 126 select * from test_11; 127 SQL parser error: table "test_11" does not exist 128 drop table if exists test_11; 129 create table test_11 (c int primary key,d int); 130 Insert into test_11 values(1,1); 131 Insert into test_11 values(2,2); 132 set @@autocommit=0; 133 Insert into test_11 values(3,1); 134 Insert into test_11 values(4,2); 135 select * from test_11; 136 c d 137 3 1 138 4 2 139 1 1 140 2 2 141 select * from test_11; 142 c d 143 1 1 144 2 2 145 Insert into test_11 values(5,4); 146 select * from test_11; 147 c d 148 1 1 149 2 2 150 5 4 151 select * from test_11; 152 c d 153 3 1 154 4 2 155 1 1 156 2 2 157 Insert into test_11 values(50,50); 158 Insert into test_11 values(50,50); 159 select * from test_11; 160 c d 161 1 1 162 2 2 163 5 4 164 50 50 165 select * from test_11; 166 c d 167 3 1 168 4 2 169 50 50 170 1 1 171 2 2 172 commit; 173 w-w conflict 174 set @@autocommit=1; 175 select * from test_11; 176 c d 177 1 1 178 2 2 179 5 4 180 50 50 181 select * from test_11; 182 c d 183 1 1 184 2 2 185 5 4 186 50 50 187 drop table if exists test_11; 188 create table test_11 (c int primary key,d int); 189 Insert into test_11 values(1,1); 190 Insert into test_11 values(2,2); 191 set @@autocommit=0; 192 select * from test_11; 193 c d 194 1 1 195 2 2 196 select * from test_11; 197 c d 198 1 1 199 2 2 200 Insert into test_11 values(50,50); 201 select * from test_11; 202 c d 203 1 1 204 2 2 205 50 50 206 Insert into test_11 values(50,50); 207 select * from test_11; 208 c d 209 50 50 210 1 1 211 2 2 212 commit; 213 w-w conflict 214 set @@autocommit=1; 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 set @@autocommit=0; 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 select * from test_11; 246 c d 247 1 1 248 2 2 249 50 50 250 select * from test_11; 251 c d 252 50 50 253 1 1 254 2 2 255 select * from test_11; 256 c d 257 1 1 258 2 2 259 50 50 260 delete from test_11 where c = 50; 261 select * from test_11; 262 c d 263 1 1 264 2 2 265 select * from test_11; 266 c d 267 50 50 268 1 1 269 2 2 270 commit; 271 w-w conflict 272 set @@autocommit=1; 273 select * from test_11; 274 c d 275 1 1 276 2 2 277 select * from test_11; 278 c d 279 1 1 280 2 2 281 drop table if exists test_11; 282 create table test_11 (c int primary key,d int); 283 Insert into test_11 values(1,1); 284 Insert into test_11 values(2,2); 285 set @@autocommit=0; 286 select * from test_11; 287 c d 288 1 1 289 2 2 290 Insert into test_11 values(50,50); 291 select * from test_11; 292 c d 293 50 50 294 1 1 295 2 2 296 select * from test_11; 297 c d 298 1 1 299 2 2 300 Insert into test_11 values(50,50); 301 select * from test_11; 302 c d 303 1 1 304 2 2 305 50 50 306 select * from test_11; 307 c d 308 50 50 309 1 1 310 2 2 311 select * from test_11; 312 c d 313 1 1 314 2 2 315 50 50 316 update test_11 set c = 100 where d = 50; 317 select * from test_11; 318 c d 319 1 1 320 2 2 321 100 50 322 select * from test_11; 323 c d 324 50 50 325 1 1 326 2 2 327 Insert into test_11 values(100,50); 328 commit; 329 w-w conflict 330 set @@autocommit=1; 331 select * from test_11; 332 c d 333 1 1 334 2 2 335 100 50 336 select * from test_11; 337 c d 338 1 1 339 2 2 340 100 50 341 drop table if exists test_11; 342 create table test_11 (c int primary key,d int); 343 Insert into test_11 values(1,1); 344 Insert into test_11 values(2,2); 345 set @@autocommit=0; 346 select * from test_11; 347 c d 348 1 1 349 2 2 350 Insert into test_11 values(50,50); 351 select * from test_11; 352 c d 353 50 50 354 1 1 355 2 2 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 1 1 364 2 2 365 50 50 366 select * from test_11; 367 c d 368 50 50 369 1 1 370 2 2 371 select * from test_11; 372 c d 373 1 1 374 2 2 375 50 50 376 update test_11 set c = 100 where d = 50; 377 select * from test_11; 378 c d 379 1 1 380 2 2 381 100 50 382 select * from test_11; 383 c d 384 50 50 385 1 1 386 2 2 387 update test_11 set c = 101 where c = 50; 388 commit; 389 set @@autocommit=1; 390 select * from test_11; 391 c d 392 1 1 393 2 2 394 100 50 395 101 50 396 select * from test_11; 397 c d 398 1 1 399 2 2 400 100 50 401 101 50 402 drop table if exists test_11; 403 create table test_11 (c int primary key,d int); 404 Insert into test_11 values(1,1); 405 Insert into test_11 values(2,2); 406 set @@autocommit=0; 407 select * from test_11; 408 c d 409 1 1 410 2 2 411 Insert into test_11 values(50,50); 412 select * from test_11; 413 c d 414 50 50 415 1 1 416 2 2 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 1 1 425 2 2 426 50 50 427 select * from test_11; 428 c d 429 50 50 430 1 1 431 2 2 432 select * from test_11; 433 c d 434 1 1 435 2 2 436 50 50 437 update test_11 set c = 100 where d = 50; 438 select * from test_11; 439 c d 440 1 1 441 2 2 442 100 50 443 select * from test_11; 444 c d 445 50 50 446 1 1 447 2 2 448 update test_11 set c = 100 where d = 50; 449 commit; 450 w-w conflict 451 set @@autocommit=1; 452 select * from test_11; 453 c d 454 1 1 455 2 2 456 100 50 457 select * from test_11; 458 c d 459 1 1 460 2 2 461 100 50 462 drop table if exists test_11; 463 set @@autocommit=0; 464 create table test_11 (c int primary key,d int); 465 Insert into test_11 values(1,1); 466 Insert into test_11 values(2,2); 467 select * from test_11; 468 c d 469 1 1 470 2 2 471 select * from test_11; 472 SQL parser error: table "test_11" does not exist 473 commit; 474 set @@autocommit=1; 475 select * from test_11; 476 c d 477 1 1 478 2 2 479 select * from test_11; 480 c d 481 1 1 482 2 2 483 drop table if exists test_11; 484 create table test_11 (c int primary key,d int); 485 Insert into test_11 values(1,1); 486 Insert into test_11 values(2,2); 487 select * from test_11; 488 c d 489 1 1 490 2 2 491 select * from test_11; 492 c d 493 1 1 494 2 2 495 set @@autocommit=0; 496 drop table test_11; 497 select * from test_11; 498 SQL parser error: table "test_11" does not exist 499 Previous DML conflicts with existing constraints or data format. This transaction has to be aborted 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 SQL parser error: table "test_11" does not exist 506 select * from test_11; 507 SQL parser error: table "test_11" does not exist 508 drop table if exists test_11; 509 set @@autocommit=0; 510 create table test_11 (c int primary key,d int); 511 Insert into test_11 values(1,1); 512 Insert into test_11 values(2,2); 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 select * from test_11; 520 c d 521 1 1 522 2 2 523 select * from test_11; 524 SQL parser error: table "test_11" does not exist 525 commit; 526 set @@autocommit=1; 527 select * from test_11; 528 c d 529 1 1 530 2 2 531 select * from test_11; 532 c d 533 1 1 534 2 2 535 drop table if exists test_11;