github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/transaction/atomicity_1.result (about) 1 drop table if exists atomic_table_1; 2 drop table if exists atomic_table_2; 3 drop table if exists atomic_table_3; 4 drop table if exists atomic_view_1; 5 drop table if exists atomic_view_2; 6 drop table if exists t_code_rule_2; 7 create table atomic_table_2(a bigint ,b varchar(200),c double); 8 begin; 9 create table atomic_table_1(a bigint not null,b varchar(200),c double,primary key(a,b)); 10 insert into atomic_table_1 select 1,"gooooooge",8092.9; 11 insert into atomic_table_1 select 2,"caaaaaate",92.09; 12 commit; 13 select * from atomic_table_1; 14 a b c 15 1 gooooooge 8092.9 16 2 caaaaaate 92.09 17 start transaction ; 18 insert into atomic_table_2 select * from atomic_table_1; 19 select * from atomic_table_2; 20 a b c 21 1 gooooooge 8092.9 22 2 caaaaaate 92.09 23 rollback ; 24 select * from atomic_table_2; 25 a b c 26 begin; 27 insert into atomic_table_2 select * from atomic_table_1; 28 commit; 29 select * from atomic_table_2; 30 a b c 31 1 gooooooge 8092.9 32 2 caaaaaate 92.09 33 begin; 34 create view atomic_view_1 as select * from atomic_table_1; 35 insert into atomic_table_1 select 10,"eeeeee",20.3; 36 commit; 37 select * from atomic_view_1; 38 a b c 39 1 gooooooge 8092.9 40 2 caaaaaate 92.09 41 10 eeeeee 20.3 42 start transaction ; 43 insert into atomic_table_1 select 10,"eeeeee",20.3; 44 insert into atomic_table_1 select 11,"ffff",2.3; 45 commit; 46 Duplicate entry '3b150a460165656565656500' for key '__mo_cpkey_001a001b' 47 select * from atomic_table_1; 48 a b c 49 1 gooooooge 8092.9 50 2 caaaaaate 92.09 51 10 eeeeee 20.3 52 select * from atomic_view_1; 53 a b c 54 1 gooooooge 8092.9 55 2 caaaaaate 92.09 56 10 eeeeee 20.3 57 begin; 58 create view atomic_view_2 as select * from atomic_table_2; 59 rollback ; 60 select * from atomic_view_2; 61 SQL parser error: table "atomic_view_2" does not exist 62 show create table atomic_view_2; 63 no such table atomicity_1.atomic_view_2 64 begin; 65 drop view atomic_view_2; 66 internal error: Only CREATE of DDL is supported in transactions 67 commit ; 68 drop view atomic_view_2; 69 invalid view 'atomicity_1.atomic_view_2' 70 create table atomic_table_3a(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col1))partition by hash(col1)partitions 4; 71 begin; 72 [unknown result because it is related to issue#5941] 73 load data infile '$resources/external_table_file/pt_table_data.csv' into table atomic_table_3a; 74 [unknown result because it is related to issue#5941] 75 select col1,col2 from atomic_table_3a; 76 [unknown result because it is related to issue#5941] 77 update atomic_table_3a set col1=400; 78 [unknown result because it is related to issue#5941] 79 rollback; 80 [unknown result because it is related to issue#5941] 81 select col1 from atomic_table_3a; 82 [unknown result because it is related to issue#5941] 83 start transaction ; 84 [unknown result because it is related to issue#5941] 85 load data infile '$resources/external_table_file/pt_table_data.csv' into table atomic_table_3a; 86 [unknown result because it is related to issue#5941] 87 select count(*) from atomic_table_3a; 88 [unknown result because it is related to issue#5941] 89 update atomic_table_3a set col1=100; 90 [unknown result because it is related to issue#5941] 91 commit; 92 [unknown result because it is related to issue#5941] 93 select col1 from atomic_table_3a; 94 [unknown result because it is related to issue#5941] 95 create table atomic_table_3(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col1))partition by hash(col1)partitions 4; 96 load data infile '$resources/external_table_file/pt_table_data.csv' into table atomic_table_3; 97 start transaction ; 98 update atomic_table_3 set col2=20; 99 select col1,col2 from atomic_table_3; 100 col1 col2 101 -62 20 102 91 20 103 33 20 104 121 20 105 40 20 106 -8 20 107 -75 20 108 21 20 109 -93 20 110 110 20 111 122 20 112 show create table atomic_table_3; 113 Table Create Table 114 atomic_table_3 CREATE TABLE `atomic_table_3` (\n`col1` TINYINT NOT NULL,\n`col2` SMALLINT DEFAULT NULL,\n`col3` INT DEFAULT NULL,\n`clo4` BIGINT DEFAULT NULL,\n`col5` TINYINT UNSIGNED DEFAULT NULL,\n`col6` SMALLINT UNSIGNED DEFAULT NULL,\n`col7` INT UNSIGNED DEFAULT NULL,\n`col8` BIGINT UNSIGNED DEFAULT NULL,\n`col9` FLOAT DEFAULT NULL,\n`col10` DOUBLE DEFAULT NULL,\n`col11` VARCHAR(255) DEFAULT NULL,\n`col12` DATE DEFAULT NULL,\n`col13` DATETIME DEFAULT NULL,\n`col14` TIMESTAMP DEFAULT NULL,\n`col15` BOOL DEFAULT NULL,\n`col16` DECIMAL(5,2) DEFAULT NULL,\n`col17` TEXT DEFAULT NULL,\n`col18` VARCHAR(255) DEFAULT NULL,\n`col19` VARCHAR(255) DEFAULT NULL,\n`col20` TEXT DEFAULT NULL,\nPRIMARY KEY (`col1`)\n) partition by hash (col1) partitions 4 115 rollback ; 116 select col1,col2 from atomic_table_3; 117 col1 col2 118 -62 5807 119 91 19514 120 33 4300 121 121 -22564 122 40 30792 123 -8 -30001 124 -75 11896 125 21 775 126 -93 -18596 127 110 -23777 128 122 19053 129 begin; 130 create external table atomic_ex_table(num_col1 tinyint,num_col2 smallint,num_col3 int,num_col4 bigint,num_col5 tinyint unsigned,num_col6 smallint unsigned,num_col7 int unsigned,num_col8 bigint unsigned ,num_col9 float(5,3),num_col10 double(6,5),num_col11 decimal(38,19)) infile{"filepath"='$resources/external_table_file/ex_table_number.csv'} fields terminated by ',' enclosed by '\"' lines terminated by '\n'; 131 select num_col1 from atomic_ex_table; 132 num_col1 133 60 134 -128 135 127 136 null 137 rollback ; 138 select num_col1 from atomic_ex_table; 139 SQL parser error: table "atomic_ex_table" does not exist 140 show create table atomic_ex_table; 141 no such table atomicity_1.atomic_ex_table 142 desc atomic_ex_table; 143 no such table atomicity_1.atomic_ex_table 144 create TEMPORARY TABLE atomic_temp(a int); 145 begin; 146 insert into atomic_temp values (5); 147 rollback ; 148 select * from atomic_temp; 149 a 150 drop table atomic_temp; 151 start transaction ; 152 create TEMPORARY TABLE atomic_temp(a int); 153 insert into atomic_temp values (5); 154 select * from atomic_temp; 155 a 156 5 157 rollback ; 158 select * from atomic_temp; 159 SQL parser error: table "atomic_temp" does not exist 160 show create table atomic_temp; 161 no such table atomicity_1.atomic_temp 162 start transaction ; 163 create TEMPORARY TABLE atomic_temp(a int); 164 insert into atomic_temp values (5); 165 commit ; 166 select * from atomic_temp; 167 a 168 5 169 CREATE TABLE `t_code_rule` ( 170 `code_id` bigint(20) NOT NULL AUTO_INCREMENT, 171 `code_no` varchar(50) NOT NULL, 172 `org_no` varchar(50) NOT NULL, 173 `org_name` varchar(50) NOT NULL, 174 `code_type` int(11) NOT NULL DEFAULT '0', 175 PRIMARY KEY (`code_id`), 176 UNIQUE KEY `code_type` (`code_type`), 177 KEY `code_no` (`code_no`), 178 KEY `org_no` (`org_no`) 179 ); 180 start transaction ; 181 insert into t_code_rule values (18373453,'aaaaaa','fffff','ccccc',10); 182 insert into t_code_rule values (18373453,'aaaaaa','fffff','ccccc',20); 183 Duplicate entry '18373453' for key 'code_id' 184 Previous DML conflicts with existing constraints or data format. This transaction has to be aborted 185 commit ; 186 select * from t_code_rule; 187 code_id code_no org_no org_name code_type 188 begin; 189 insert into t_code_rule values (18373453,'aaaaaa','fffff','ccccc',5); 190 delete from t_code_rule where code_id=18373453; 191 select * from t_code_rule; 192 code_id code_no org_no org_name code_type 193 rollback ; 194 select * from t_code_rule; 195 code_id code_no org_no org_name code_type 196 insert into t_code_rule values (18373453,'aaaaaa','fffff','ccccc',5); 197 begin ; 198 delete from t_code_rule where code_id=18373453; 199 commit ; 200 begin; 201 insert into t_code_rule(code_no,org_no,org_name,code_type) values ('',null,'ccccc',5); 202 constraint violation: Column 'org_no' cannot be null 203 Previous DML conflicts with existing constraints or data format. This transaction has to be aborted 204 commit ; 205 select * from t_code_rule; 206 code_id code_no org_no org_name code_type 207 insert into t_code_rule values (18373453,'aaaaaa','fffff','ccccc',5); 208 Duplicate entry '5' for key 'code_type' 209 begin; 210 update t_code_rule set org_name=NULL where code_id=18373453; 211 constraint violation: Column 'org_name' cannot be null 212 Previous DML conflicts with existing constraints or data format. This transaction has to be aborted 213 commit ; 214 select * from t_code_rule; 215 code_id code_no org_no org_name code_type 216 18373453 aaaaaa fffff ccccc 5 217 begin ; 218 create account aname admin_name 'admin' identified by '111'; 219 internal error: administrative command is unsupported in transactions 220 create role role1,role2; 221 internal error: administrative command is unsupported in transactions 222 grant role1 to role2; 223 internal error: administrative command is unsupported in transactions 224 grant create table ,drop table on database * to role1; 225 internal error: administrative command is unsupported in transactions 226 truncate table t_code_rule; 227 internal error: Only CREATE of DDL is supported in transactions 228 drop table t_code_rule; 229 internal error: Only CREATE of DDL is supported in transactions 230 drop database atomic_1; 231 internal error: Only CREATE of DDL is supported in transactions 232 drop role role1,role2; 233 internal error: administrative command is unsupported in transactions 234 commit;