github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/pessimistic_transaction/insert.result (about) 1 drop table if exists names; 2 create table names(id int PRIMARY KEY,name VARCHAR(255),age int); 3 insert into names(id, name, age) values(1,"Abby", 24); 4 insert into names(id, name, age) values(2,"Bob", 25); 5 insert into names(id, name, age) values(3,"Carol", 23); 6 insert into names(id, name, age) values(4,"Dora", 29); 7 select id,name,age from names; 8 id name age 9 1 Abby 24 10 2 Bob 25 11 3 Carol 23 12 4 Dora 29 13 drop table if exists weights; 14 create table weights(a int unique); 15 insert into weights values(1); 16 select * from weights; 17 a 18 1 19 drop table if exists test; 20 create table test(id int primary key, name varchar(10), age int); 21 insert into test values(1, 'Abby', 20); 22 insert into test values(2, 'Bob', 21); 23 select id,name,age from test; 24 id name age 25 1 Abby 20 26 2 Bob 21 27 drop table if exists pet; 28 create table pet(name char(10),owner char(10), species char(10), gender char(1), weight float,age int); 29 insert into pet values ('Sunsweet01','Dsant01','otter','f',30.11,2), 30 ('Sunsweet02','Dsant02','otter','m',30.11,3); 31 insert into pet(name, owner, species, gender, weight, age) values ('Sunsweet03','Dsant01','otter','f',30.11,2), 32 ('Sunsweet04','Dsant02','otter','m',30.11,3); 33 select * from pet; 34 name owner species gender weight age 35 Sunsweet01 Dsant01 otter f 30.11 2 36 Sunsweet02 Dsant02 otter m 30.11 3 37 Sunsweet03 Dsant01 otter f 30.11 2 38 Sunsweet04 Dsant02 otter m 30.11 3 39 drop table if exists t1; 40 create table t1 (a bigint unsigned not null, primary key(a)); 41 insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFE), (18446744073709551613), (18446744073709551612); 42 select * from t1; 43 a 44 18446744073709551615 45 18446744073709551614 46 18446744073709551613 47 18446744073709551612 48 drop table if exists t1; 49 create table t1(a int, b int); 50 insert into t1 values(), (); 51 select * from t1; 52 a b 53 null null 54 null null 55 drop table if exists t1; 56 create table t1(a int default (1+12), b int); 57 insert into t1(b) values(1), (1); 58 select * from t1; 59 a b 60 13 1 61 13 1 62 drop table if exists t1; 63 create table t1(a int primary key default (1+12)); 64 insert into t1 values(); 65 select * from t1; 66 a 67 13 68 drop table if exists t1; 69 create table t1(a int, b int); 70 insert into t1(a) values(1), (2); 71 select * from t1; 72 a b 73 1 null 74 2 null 75 drop table if exists t1; 76 create table t1 (a int); 77 insert into t1 values (1+2), (2*2); 78 select * from t1; 79 a 80 3 81 4 82 drop table if exists t1; 83 create table t1 (a datetime default now()); 84 insert into t1 values(); 85 insert into t1 values(now()); 86 drop table if exists t1; 87 create table t1 (a int); 88 insert into t1 values(1+2*3), (666/2); 89 select * from t1; 90 a 91 7 92 333 93 drop table if exists t; 94 CREATE TABLE t (i1 INT, d1 DOUBLE, e2 DECIMAL(5,2)); 95 INSERT INTO t VALUES ( 6, 6.0, 10.0/3), ( null, 9.0, 10.0/3), ( 1, null, 10.0/3), ( 2, 2.0, null ); 96 select * from t; 97 i1 d1 e2 98 6 6.0 3.33 99 null 9.0 3.33 100 1 null 3.33 101 2 2.0 null 102 drop table if exists t1; 103 create table t1 (a date); 104 insert into t1 values(DATE("2017-06-15 09:34:21")),(DATE("2019-06-25 10:12:21")),(DATE("2019-06-25 18:20:49")); 105 select * from t1; 106 a 107 2017-06-15 108 2019-06-25 109 2019-06-25 110 drop table if exists t1; 111 create table t1 (a date default DATE("2017-06-15 09:34:21")); 112 insert into t1 (a) values (default), (default), (default); 113 select * from t1; 114 a 115 2017-06-15 116 2017-06-15 117 2017-06-15 118 drop table if exists t1; 119 create table t1(a int auto_increment, b int); 120 insert into t1 values(null, 2), (3, null), (null, null); 121 select * from t1; 122 a b 123 1 2 124 3 null 125 4 null 126 drop table if exists t1; 127 create table t1(a int auto_increment, b bigint auto_increment); 128 insert into t1 values(null, 2), (3, null), (null, null); 129 select * from t1; 130 a b 131 1 2 132 3 3 133 4 4 134 insert into t1 values(100, 2), (null, null), (null, null); 135 select * from t1; 136 a b 137 1 2 138 3 3 139 4 4 140 100 2 141 101 5 142 102 6 143 drop table if exists t1; 144 create table t1(a int, b int, primary key(a)); 145 insert into t1 values(null, 1); 146 constraint violation: Column 'a' cannot be null 147 drop table if exists t1; 148 create table t1(a int, b int, primary key(a, b)); 149 insert into t1 values(null, 1); 150 constraint violation: Column 'a' cannot be null 151 drop table if exists t1; 152 create table t1(a int, b varchar(20), primary key(a, b)); 153 insert into t1 values(1, '2'); 154 insert into t1 values(1, '3'); 155 insert into t1 values(2, '2'); 156 insert into t1 values(2, '3'); 157 select * from t1; 158 a b 159 1 2 160 1 3 161 2 2 162 2 3 163 insert into t1 values(2, '3'); 164 Duplicate entry '(2,3)' for key '__mo_cpkey_col' 165 drop table if exists t1; 166 create table t1(a int, b int, c int); 167 insert into t1 values(1, 2, 3) on duplicate key update a=5; 168 insert into t1 values(1, 2, 3) on duplicate key update a=5, b=6, c=7; 169 insert into t1 values(1, 2, 3) on duplicate key update a=values(b)+values(c); 170 drop table if exists t1; 171 create table t1(a int, primary key(b)); 172 invalid input: column 'b' doesn't exist in table 173 create table t1(a int, b int, primary key(b, c)); 174 invalid input: column 'c' doesn't exist in table 175 drop table if exists t1; 176 [unknown result because it is related to issue#5790] 177 create table t1(a int, b varchar(20), unique key(a)); 178 [unknown result because it is related to issue#5790] 179 insert into t1 values(1, '1'); 180 [unknown result because it is related to issue#5790] 181 insert into t1 values(2, '2'); 182 [unknown result because it is related to issue#5790] 183 insert into t1 values(3, '3'); 184 [unknown result because it is related to issue#5790] 185 insert into t1 values(4, '4'); 186 [unknown result because it is related to issue#5790] 187 select * from t1; 188 [unknown result because it is related to issue#5790] 189 insert into t1 values(1, '1'); 190 [unknown result because it is related to issue#5790] 191 insert into t1 values(null, '1'); 192 [unknown result because it is related to issue#5790] 193 insert into t1 values(null, '1'); 194 [unknown result because it is related to issue#5790] 195 drop table if exists t1; 196 [unknown result because it is related to issue#5790] 197 create table t1(a int, b varchar(20), unique key(a, b)); 198 [unknown result because it is related to issue#5790] 199 insert into t1 values(1, '2'); 200 [unknown result because it is related to issue#5790] 201 insert into t1 values(1, '3'); 202 [unknown result because it is related to issue#5790] 203 insert into t1 values(2, '2'); 204 [unknown result because it is related to issue#5790] 205 insert into t1 values(2, '3'); 206 [unknown result because it is related to issue#5790] 207 select * from t1; 208 [unknown result because it is related to issue#5790] 209 insert into t1 values(2, '3'); 210 [unknown result because it is related to issue#5790] 211 insert into t1 values(null, '1'); 212 [unknown result because it is related to issue#5790] 213 insert into t1 values(null, '2'); 214 [unknown result because it is related to issue#5790] 215 insert into t1 values(null, '2'); 216 [unknown result because it is related to issue#5790] 217 drop table if exists flush_logtail; 218 create table flush_logtail(a int, b int); 219 insert into flush_logtail values(1, 1); 220 insert into flush_logtail values(2, 2); 221 insert into flush_logtail values(3, 3); 222 insert into flush_logtail values(4, 4); 223 insert into flush_logtail values(5, 5); 224 select mo_ctl('dn', 'AddFaultPoint', 'enable_fault_injection'); 225 mo_ctl(dn, AddFaultPoint, enable_fault_injection) 226 {\n "method": "AddFaultPoint",\n "result": [\n {\n "returnStr": "OK"\n }\n ]\n}\n 227 select mo_ctl('dn', 'AddFaultPoint', 'flush_table_error.:::.echo.0.flush_table_fault'); 228 mo_ctl(dn, AddFaultPoint, flush_table_error.:::.echo.0.flush_table_fault) 229 {\n "method": "AddFaultPoint",\n "result": [\n {\n "returnStr": "OK"\n }\n ]\n}\n 230 select mo_ctl('dn', 'flush', 'insert.flush_logtail'); 231 internal error: flush_table_fault 232 select * from flush_logtail; 233 a b 234 1 1 235 2 2 236 3 3 237 4 4 238 5 5 239 select mo_ctl('dn', 'AddFaultPoint', 'disable_fault_injection'); 240 mo_ctl(dn, AddFaultPoint, disable_fault_injection) 241 {\n "method": "AddFaultPoint",\n "result": [\n {\n "returnStr": "OK"\n }\n ]\n}\n 242 select mo_ctl('dn', 'flush', 'insert.flush_logtail'); 243 mo_ctl(dn, flush, insert.flush_logtail) 244 {\n "method": "Flush",\n "result": [\n {\n "returnStr": "OK"\n }\n ]\n}\n 245 drop table if exists t1; 246 create table t1 (a varchar(50)); 247 insert into t1 values("这是一个字节数超过五十的字符串，但是utf8没有超过"); 248 drop table if exists t1; 249 create table t1 (col1 bigint primary key,col2 varchar(25),col3 float,col4 varchar(50),unique key num_phone(col2),key num_id(col4)); 250 insert into t1 values (67834,'13456789872',20.23,'4090'),(56473,'13456789872',100.00,'5678'); 251 Duplicate entry '13456789872' for key '__mo_index_idx_col' 252 drop table if exists t; 253 create table t(a int); 254 insert into t values(1); 255 insert into t select * from t; 256 select count(*) from t; 257 count(*) 258 2 259 insert into t select * from t; 260 select count(*) from t; 261 count(*) 262 4 263 insert into t select * from t; 264 select count(*) from t; 265 count(*) 266 8 267 insert into t select * from t; 268 select count(*) from t; 269 count(*) 270 16 271 insert into t select * from t; 272 select count(*) from t; 273 count(*) 274 32 275 insert into t select * from t; 276 select count(*) from t; 277 count(*) 278 64 279 insert into t select * from t; 280 select count(*) from t; 281 count(*) 282 128 283 insert into t select * from t; 284 select count(*) from t; 285 count(*) 286 256 287 insert into t select * from t; 288 select count(*) from t; 289 count(*) 290 512 291 insert into t select * from t; 292 select count(*) from t; 293 count(*) 294 1024 295 insert into t select * from t; 296 select count(*) from t; 297 count(*) 298 2048 299 insert into t select * from t; 300 select count(*) from t; 301 count(*) 302 4096 303 insert into t select * from t; 304 select count(*) from t; 305 count(*) 306 8192 307 insert into t select * from t; 308 select count(*) from t; 309 count(*) 310 16384 311 insert into t select * from t; 312 select count(*) from t; 313 count(*) 314 32768 315 insert into t select * from t; 316 select count(*) from t; 317 count(*) 318 65536 319 insert into t select * from t; 320 select count(*) from t; 321 count(*) 322 131072 323 insert into t select * from t; 324 select count(*) from t; 325 count(*) 326 262144 327 insert into t select * from t; 328 select count(*) from t; 329 count(*) 330 524288 331 insert into t select * from t; 332 select count(*) from t; 333 count(*) 334 1048576 335 insert into t select * from t; 336 select count(*) from t; 337 count(*) 338 2097152 339 insert into t select * from t; 340 select count(*) from t; 341 count(*) 342 4194304 343 insert into t select * from t; 344 select count(*) from t; 345 count(*) 346 8388608 347 insert into t select * from t; 348 select count(*) from t; 349 count(*) 350 16777216 351 begin; 352 insert into t select * from t; 353 select count(*) from t; 354 count(*) 355 33554432 356 commit; 357 select count(*) from t; 358 count(*) 359 33554432 360 drop table t; 361 create table t(a int primary key); 362 insert into t select * from generate_series(1,200000) g; 363 select count(*) from t; 364 count(*) 365 200000 366 insert into t select * from t; 367 Duplicate entry ('[0-9]{6}'|'[0-9]{5}'|'[0-9]{4}'|'[0-9]{3}'|'[0-9]{2}'|'[0-9]{1}') for key 'a' 368 begin; 369 insert into t select * from t; 370 Duplicate entry ('[0-9]{6}'|'[0-9]{5}'|'[0-9]{4}'|'[0-9]{3}'|'[0-9]{2}'|'[0-9]{1}') for key 'a' 371 select count(*) from t; 372 count(*) 373 200000 374 commit; 375 select count(*) from t; 376 count(*) 377 200000 378 insert into t select null; 379 constraint violation: Column 'a' cannot be null 380 drop table t; 381 create table t(a int,b int); 382 [unknown result because it is related to issue#5790] 383 create table temp(c int); 384 [unknown result because it is related to issue#5790] 385 insert into temp select * from generate_series(1,200000) g; 386 [unknown result because it is related to issue#5790] 387 insert into t select c,c from temp; 388 [unknown result because it is related to issue#5790] 389 select count(*) from t; 390 [unknown result because it is related to issue#5790] 391 insert into t select * from t order by a, b; 392 [unknown result because it is related to issue#5790] 393 begin; 394 [unknown result because it is related to issue#5790] 395 insert into t select * from t order by a, b; 396 [unknown result because it is related to issue#5790] 397 select count(*) from t; 398 [unknown result because it is related to issue#5790] 399 commit; 400 [unknown result because it is related to issue#5790] 401 select count(*) from t; 402 [unknown result because it is related to issue#5790] 403 insert into t select null,null; 404 [unknown result because it is related to issue#5790] 405 drop table t; 406 [unknown result because it is related to issue#5790] 407 drop table temp; 408 [unknown result because it is related to issue#5790] 409 create table t(a int); 410 [unknown result because it is related to issue#5790] 411 insert into t select * from generate_series(1,200000) g; 412 [unknown result because it is related to issue#5790] 413 select count(*) from t; 414 [unknown result because it is related to issue#5790] 415 insert into t select * from t order by a; 416 [unknown result because it is related to issue#5790] 417 begin; 418 [unknown result because it is related to issue#5790] 419 insert into t select * from t order by a; 420 [unknown result because it is related to issue#5790] 421 select count(*) from t; 422 [unknown result because it is related to issue#5790] 423 commit; 424 [unknown result because it is related to issue#5790] 425 select count(*) from t; 426 [unknown result because it is related to issue#5790] 427 insert into t select null; 428 [unknown result because it is related to issue#5790] 429 select count(*) from t; 430 [unknown result because it is related to issue#5790] 431 drop table t; 432 [unknown result because it is related to issue#5790] 433 create table t(a int auto_increment,b int); 434 [unknown result because it is related to issue#5790] 435 insert into t(b) select * from generate_series(1,200000) g; 436 [unknown result because it is related to issue#5790] 437 select count(*) from t; 438 [unknown result because it is related to issue#5790] 439 select a from t where a > 199990; 440 [unknown result because it is related to issue#5790] 441 drop table t; 442 [unknown result because it is related to issue#5790] 443 drop table if exists t1; 444 [unknown result because it is related to issue#5790] 445 create table t1( 446 col1 tinyint, 447 col2 smallint, 448 col3 int, 449 col4 bigint, 450 col5 tinyint unsigned, 451 col6 smallint unsigned, 452 col7 int unsigned, 453 col8 bigint unsigned 454 ); 455 [unknown result because it is related to issue#5790] 456 load data infile '$resources/load_data/integer_numbers_3.csv' into table t1 fields terminated by ','; 457 [unknown result because it is related to issue#5790] 458 select * from t1; 459 [unknown result because it is related to issue#5790] 460 drop table t1; 461 [unknown result because it is related to issue#5790] 462 create database ssb;use ssb; 463 [unknown result because it is related to issue#5790] 464 create table t2(c1 int) cluster by c1; 465 [unknown result because it is related to issue#5790] 466 insert into t2 values(3),(5),(1),(4),(2); 467 [unknown result because it is related to issue#5790] 468 select * from t2; 469 [unknown result because it is related to issue#5790] 470 select mo_ctl('dn', 'flush', 'ssb.t2'); 471 [unknown result because it is related to issue#5790] 472 select * from t2; 473 [unknown result because it is related to issue#5790] 474 drop table t2; 475 [unknown result because it is related to issue#5790] 476 create table t2(c1 int) cluster by c1; 477 [unknown result because it is related to issue#5790] 478 load data infile '$resources/load_data/integer.csv' into table t2 fields terminated by ','; 479 [unknown result because it is related to issue#5790] 480 select * from t2; 481 [unknown result because it is related to issue#5790] 482 select mo_ctl('dn', 'flush', 'ssb.t2'); 483 [unknown result because it is related to issue#5790] 484 select * from t2; 485 [unknown result because it is related to issue#5790] 486 drop table t2; 487 [unknown result because it is related to issue#5790] 488 create table t2(c1 int,c2 int) cluster by (c1,c2); 489 [unknown result because it is related to issue#5790] 490 load data infile '$resources/load_data/integer2.csv' into table t2 fields terminated by ','; 491 [unknown result because it is related to issue#5790] 492 select * from t2; 493 [unknown result because it is related to issue#5790] 494 select mo_ctl('dn', 'flush', 'ssb.t2'); 495 [unknown result because it is related to issue#5790] 496 select * from t2; 497 [unknown result because it is related to issue#5790] 498 drop table t2; 499 [unknown result because it is related to issue#5790] 500 drop database ssb; 501 [unknown result because it is related to issue#5790] 502 drop table if exists indup_11; 503 create table indup_11(a int, b varchar(20), primary key(a, b)); 504 insert into indup_11(a, b) values (1, "2"); 505 insert into indup_11(b, a) values ("2", 1); 506 Duplicate entry '(1,2)' for key '__mo_cpkey_col' 507 drop table indup_11; 508 drop table if exists t4; 509 create table t4(col1 int, col2 decimal, col3 smallint, primary key(col1, col3)); 510 insert into t4 (col1, col2, col3) values(6, 6, 8); 511 insert into t4 (col2, col3, col1) values(2, 3, 1); 512 insert into t4 (col3, col1) values (8, 6); 513 Duplicate entry '(6,8)' for key '__mo_cpkey_col' 514 select * from t4; 515 col1 col2 col3 516 6 6 8 517 1 2 3 518 drop table t4;