Debian Codegraph @

mysql-test/suite/maria/create.test

raw
1 --source include/have_maria.inc
2
3 # MDEV-17021
4 # Server crash or assertion `length <= column->length' failure in
5 # write_block_record
6 #
7
8 CREATE OR REPLACE TABLE t1 (
9 f1 DECIMAL(43,0) NOT NULL,
10 f2 TIME(4) NULL,
11 f3 BINARY(101) NULL,
12 f4 TIMESTAMP(4) NULL,
13 f5 DATETIME(1) NULL,
14 f6 SET('a','b','c') NOT NULL DEFAULT 'a',
15 f7 VARBINARY(2332) NOT NULL DEFAULT '',
16 f8 DATE NULL,
17 f9 BLOB NULL,
18 f10 MEDIUMINT(45) NOT NULL DEFAULT 0,
19 f11 YEAR NULL,
20 f12 BIT(58) NULL,
21 v2 TIME(1) AS (f2) VIRTUAL,
22 v3 BINARY(115) AS (f3) VIRTUAL,
23 v4 TIMESTAMP(3) AS (f4) VIRTUAL,
24 v7 VARBINARY(658) AS (f7) PERSISTENT,
25 v8 DATE AS (f8) PERSISTENT,
26 v9 TINYTEXT AS (f9) PERSISTENT,
27 v11 YEAR AS (f11) VIRTUAL
28 ) ENGINE=Aria;
29 INSERT IGNORE INTO t1 (f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12) VALUES
30 (0.8,'16:01:46',NULL,'2006-03-01 12:44:34','2029-10-10 21:27:53','a','foo','1989-12-24','bar',9,1975,b'1');
31 DROP TABLE t1;
32
33 #
34 # MDEV-17067 Server crash in write_block_record
35 #
36
37 CREATE OR REPLACE TABLE t1 (a INT(45));
38 INSERT IGNORE INTO t1 VALUES (1),(2);
39
40 CREATE OR REPLACE TABLE t2 ENGINE=Aria AS SELECT SUM(a) AS f1, IFNULL( 'qux', ExtractValue( 'foo', 'bar' ) ) AS f2 FROM t1;
41 select * from t2;
42 DROP TABLE t1, t2;
43
44 --echo #
45 --echo # MDEV-23159 Assertion `table_share->tmp_table != NO_TMP_TABLE ||
46 --echo # m_lock_type != 2' + SIGSEGV in trnman_can_read_from
47 --echo # (on optimized builds)
48 --echo #
49
50 SET @org_sql_mode=@@SQL_MODE;
51 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=Aria ROW_FORMAT=COMPRESSED;
52 INSERT INTO t1 VALUES(1);
53 CREATE TEMPORARY TABLE t2(b INT);
54 EXPLAIN SELECT * FROM t1 WHERE a IN (SELECT MAX(a) FROM t2);
55 DROP TABLE t1,t2;
56
57 SET SQL_MODE='';
58 CREATE TABLE t1 (c INT PRIMARY KEY) ENGINE=Aria;
59 CREATE TABLE t2 (d INT);
60 INSERT INTO t1 VALUES (1);
61 SELECT c FROM t1 WHERE (c) IN (SELECT MIN(c) FROM t2);
62 DROP TABLE t1,t2;
63
64 USE test;
65 SET SQL_MODE='ONLY_FULL_GROUP_BY';
66 CREATE TABLE t3 (c1 DECIMAL(1,1) PRIMARY KEY,c2 DATE,c3 NUMERIC(10) UNSIGNED) ENGINE=Aria;
67 CREATE TABLE t2 (f1 INTEGER ) ENGINE=Aria;
68 INSERT INTO t3 VALUES (0,0,0);
69 SELECT c1 FROM t3 WHERE (c1) IN (SELECT MIN(DISTINCT c1) FROM t2);
70 DROP TABLE t2,t3;
71 SET @@SQL_MODE=@org_sql_mode;
72
73 --echo #
74 --echo # MDEV-23222 SIGSEGV in maria_status | Assertion `(longlong)
75 --echo # thd->status_var.local_memory_used >= 0
76 --echo #
77
78 let $mysqld_datadir= `select @@datadir`;
79 CREATE TABLE t1 (a INT);
80 INSERT INTO t1 VALUES (1);
81 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
82 --eval CREATE TABLE MDEV_23222 (i INT) DATA DIRECTORY = '$MYSQL_TMP_DIR', ENGINE=Aria TRANSACTIONAL=1;
83 flush tables;
84 --remove_file $mysqld_datadir/test/MDEV_23222.frm
85 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
86 --error 1,ER_TABLE_EXISTS_ERROR
87 --eval CREATE TABLE MDEV_23222 (i INT) DATA DIRECTORY = '$MYSQL_TMP_DIR', ENGINE=Aria TRANSACTIONAL=1;
88 DROP TABLE t1;
89
90 --echo #
91 --echo # End of 10.3 tests
92 --echo #
93
94 #
95 # MDEV-22686 # Assertion `trn' failed in ha_maria::start_stmt
96 # ASAN heap-after-free in maria_status
97 #
98
99 CREATE TABLE t1 (a INT) ENGINE=Aria;
100 INSERT INTO t1 VALUES (1);
101 CREATE TABLE t2 (b INT);
102 CREATE OR REPLACE TABLE t2 AS SELECT * FROM t1;
103 SELECT * from t1;
104 SELECT * from t2;
105
106 # Check also BEGIN/COMMIT
107
108 BEGIN;
109 CREATE OR REPLACE TABLE t2 AS SELECT * FROM t1;
110 SELECT * from t2;
111 COMMIT;
112
113 # Check also LOCK TABLES
114
115 LOCK TABLES t1 read, t2 write;
116 CREATE OR REPLACE TABLE t2 AS SELECT * FROM t1;
117 SELECT * from t2;
118 UNLOCK TABLES;
119
120 # Check with 3 tables
121 CREATE TABLE t3 (a INT) engine=Aria;
122 INSERT INTO t3 values(2);
123
124 CREATE OR REPLACE TABLE t2 AS SELECT t1.a,t3.a as b FROM t1,t3;
125 SELECT * from t2;
126
127 DROP TABLE t1, t2, t3;