1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
SET @@session.default_storage_engine = 'ndbcluster';
create table stored_basic
(i int not null primary key,
gcol_int int GENERATED ALWAYS AS (100 + i) STORED,
misc int,
gcol_str varchar(20) GENERATED ALWAYS AS (concat("User ", i)) STORED
);
insert into stored_basic(i) values(1), (2), (3), (4), (5);
select * from stored_basic order by i;
i gcol_int misc gcol_str
1 101 NULL User 1
2 102 NULL User 2
3 103 NULL User 3
4 104 NULL User 4
5 105 NULL User 5
delete from stored_basic where i = 1;
affected rows: 1
delete from stored_basic where gcol_int = 102;
affected rows: 1
delete from stored_basic where misc is null;
affected rows: 3
insert into stored_basic(i) values(1), (2), (3), (4), (5);
select gcol_str from stored_basic;
gcol_str
User 1
User 2
User 3
User 4
User 5
update stored_basic set gcol_int = 44 where i = 4;
ERROR HY000: The value specified for generated column 'gcol_int' in table 'stored_basic' is not allowed.
update stored_basic set misc = 44 where gcol_int = 104;
create table stored_basic_2 like stored_basic;
insert into stored_basic_2 (i,misc) select i,misc from stored_basic;
select * from stored_basic_2 order by i;
i gcol_int misc gcol_str
1 101 NULL User 1
2 102 NULL User 2
3 103 NULL User 3
4 104 44 User 4
5 105 NULL User 5
drop table stored_basic_2;
drop table stored_basic;
|
