mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 19:06:14 +01:00
77 lines
2.5 KiB
Text
77 lines
2.5 KiB
Text
--- main/alter_table_combinations.result
|
|
+++ main/alter_table_combinations.reject
|
|
@@ -11,7 +11,7 @@
|
|
alter table t1 change x xx int, algorithm=inplace;
|
|
check table t1;
|
|
Table Op Msg_type Msg_text
|
|
-test.t1 check status OK
|
|
+test.t1 check note The storage engine for the table doesn't support check
|
|
drop table t1;
|
|
#
|
|
# End of 10.3 tests
|
|
@@ -173,8 +173,7 @@
|
|
t3 CREATE TABLE `t3` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`b` int(11) DEFAULT NULL,
|
|
- KEY `b` (`b`),
|
|
- CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`b`) REFERENCES `t1` (`bb`)
|
|
+ KEY `b` (`b`)
|
|
) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
|
ALTER TABLE t1 RENAME COLUMN bb TO b;
|
|
SHOW CREATE TABLE t1;
|
|
@@ -190,8 +189,7 @@
|
|
t3 CREATE TABLE `t3` (
|
|
`a` int(11) DEFAULT NULL,
|
|
`c` int(11) DEFAULT NULL,
|
|
- KEY `b` (`c`),
|
|
- CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`c`) REFERENCES `t1` (`b`)
|
|
+ KEY `b` (`c`)
|
|
) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
|
CREATE TABLE t4(a int);
|
|
ALTER TABLE t4 RENAME COLUMN a TO aa, ALGORITHM = INPLACE;
|
|
@@ -231,36 +229,6 @@
|
|
ERROR 42S22: Unknown column 'd' in 'field list'
|
|
DROP TRIGGER trg1;
|
|
DROP PROCEDURE sp1;
|
|
-CREATE TABLE t_gen(a INT, b DOUBLE GENERATED ALWAYS AS (SQRT(a)));
|
|
-INSERT INTO t_gen(a) VALUES(4);
|
|
-SELECT * FROM t_gen;
|
|
-a b
|
|
-4 2
|
|
-SHOW CREATE TABLE t_gen;
|
|
-Table Create Table
|
|
-t_gen CREATE TABLE `t_gen` (
|
|
- `a` int(11) DEFAULT NULL,
|
|
- `b` double GENERATED ALWAYS AS (sqrt(`a`)) VIRTUAL
|
|
-) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
|
-ALTER TABLE t_gen RENAME COLUMN a TO c, CHANGE COLUMN b b DOUBLE GENERATED ALWAYS AS (SQRT(c));
|
|
-SELECT * FROM t_gen;
|
|
-c b
|
|
-4 2
|
|
-SHOW CREATE TABLE t_gen;
|
|
-Table Create Table
|
|
-t_gen CREATE TABLE `t_gen` (
|
|
- `c` int(11) DEFAULT NULL,
|
|
- `b` double GENERATED ALWAYS AS (sqrt(`c`)) VIRTUAL
|
|
-) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
|
-ALTER TABLE t_gen CHANGE COLUMN c x INT;
|
|
-show create table t_gen;
|
|
-Table Create Table
|
|
-t_gen CREATE TABLE `t_gen` (
|
|
- `x` int(11) DEFAULT NULL,
|
|
- `b` double GENERATED ALWAYS AS (sqrt(`x`)) VIRTUAL
|
|
-) ENGINE=DEFAULT_ENGINE DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
|
-ALTER TABLE t_gen RENAME COLUMN x TO a;
|
|
-DROP TABLE t_gen;
|
|
SHOW CREATE TABLE t1;
|
|
Table Create Table
|
|
t1 CREATE TABLE `t1` (
|
|
@@ -316,7 +284,7 @@
|
|
alter table t1 change x xx int, algorithm=inplace;
|
|
check table t1;
|
|
Table Op Msg_type Msg_text
|
|
-test.t1 check status OK
|
|
+test.t1 check note The storage engine for the table doesn't support check
|
|
drop table t1;
|
|
#
|
|
# End of 10.5 tests
|