Debian Codegraph @

mysql-test/suite/maria/create.result

raw
1 CREATE OR REPLACE TABLE t1 (
2 f1 DECIMAL(43,0) NOT NULL,
3 f2 TIME(4) NULL,
4 f3 BINARY(101) NULL,
5 f4 TIMESTAMP(4) NULL,
6 f5 DATETIME(1) NULL,
7 f6 SET('a','b','c') NOT NULL DEFAULT 'a',
8 f7 VARBINARY(2332) NOT NULL DEFAULT '',
9 f8 DATE NULL,
10 f9 BLOB NULL,
11 f10 MEDIUMINT(45) NOT NULL DEFAULT 0,
12 f11 YEAR NULL,
13 f12 BIT(58) NULL,
14 v2 TIME(1) AS (f2) VIRTUAL,
15 v3 BINARY(115) AS (f3) VIRTUAL,
16 v4 TIMESTAMP(3) AS (f4) VIRTUAL,
17 v7 VARBINARY(658) AS (f7) PERSISTENT,
18 v8 DATE AS (f8) PERSISTENT,
19 v9 TINYTEXT AS (f9) PERSISTENT,
20 v11 YEAR AS (f11) VIRTUAL
21 ) ENGINE=Aria;
22 INSERT IGNORE INTO t1 (f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12) VALUES
23 (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');
24 Warnings:
25 Note 1265 Data truncated for column 'f1' at row 1
26 DROP TABLE t1;
27 CREATE OR REPLACE TABLE t1 (a INT(45));
28 INSERT IGNORE INTO t1 VALUES (1),(2);
29 CREATE OR REPLACE TABLE t2 ENGINE=Aria AS SELECT SUM(a) AS f1, IFNULL( 'qux', ExtractValue( 'foo', 'bar' ) ) AS f2 FROM t1;
30 select * from t2;
31 f1 f2
32 3 qux
33 DROP TABLE t1, t2;
34 #
35 # MDEV-23159 Assertion `table_share->tmp_table != NO_TMP_TABLE ||
36 # m_lock_type != 2' + SIGSEGV in trnman_can_read_from
37 # (on optimized builds)
38 #
39 SET @org_sql_mode=@@SQL_MODE;
40 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=Aria ROW_FORMAT=COMPRESSED;
41 INSERT INTO t1 VALUES(1);
42 CREATE TEMPORARY TABLE t2(b INT);
43 EXPLAIN SELECT * FROM t1 WHERE a IN (SELECT MAX(a) FROM t2);
44 id select_type table type possible_keys key key_len ref rows Extra
45 1 PRIMARY t1 system NULL NULL NULL NULL 1 Using index
46 2 DEPENDENT SUBQUERY NULL NULL NULL NULL NULL NULL NULL Select tables optimized away
47 DROP TABLE t1,t2;
48 SET SQL_MODE='';
49 CREATE TABLE t1 (c INT PRIMARY KEY) ENGINE=Aria;
50 CREATE TABLE t2 (d INT);
51 INSERT INTO t1 VALUES (1);
52 SELECT c FROM t1 WHERE (c) IN (SELECT MIN(c) FROM t2);
53 c
54 DROP TABLE t1,t2;
55 USE test;
56 SET SQL_MODE='ONLY_FULL_GROUP_BY';
57 CREATE TABLE t3 (c1 DECIMAL(1,1) PRIMARY KEY,c2 DATE,c3 NUMERIC(10) UNSIGNED) ENGINE=Aria;
58 CREATE TABLE t2 (f1 INTEGER ) ENGINE=Aria;
59 INSERT INTO t3 VALUES (0,0,0);
60 SELECT c1 FROM t3 WHERE (c1) IN (SELECT MIN(DISTINCT c1) FROM t2);
61 c1
62 DROP TABLE t2,t3;
63 SET @@SQL_MODE=@org_sql_mode;
64 #
65 # MDEV-23222 SIGSEGV in maria_status | Assertion `(longlong)
66 # thd->status_var.local_memory_used >= 0
67 #
68 CREATE TABLE t1 (a INT);
69 INSERT INTO t1 VALUES (1);
70 CREATE TABLE MDEV_23222 (i INT) DATA DIRECTORY = 'MYSQL_TMP_DIR', ENGINE=Aria TRANSACTIONAL=1;;
71 flush tables;
72 CREATE TABLE MDEV_23222 (i INT) DATA DIRECTORY = 'MYSQL_TMP_DIR', ENGINE=Aria TRANSACTIONAL=1;;
73 Got one of the listed errors
74 DROP TABLE t1;
75 #
76 # End of 10.3 tests
77 #
78 CREATE TABLE t1 (a INT) ENGINE=Aria;
79 INSERT INTO t1 VALUES (1);
80 CREATE TABLE t2 (b INT);
81 CREATE OR REPLACE TABLE t2 AS SELECT * FROM t1;
82 SELECT * from t1;
83 a
84 1
85 SELECT * from t2;
86 a
87 1
88 BEGIN;
89 CREATE OR REPLACE TABLE t2 AS SELECT * FROM t1;
90 SELECT * from t2;
91 a
92 1
93 COMMIT;
94 LOCK TABLES t1 read, t2 write;
95 CREATE OR REPLACE TABLE t2 AS SELECT * FROM t1;
96 SELECT * from t2;
97 a
98 1
99 UNLOCK TABLES;
100 CREATE TABLE t3 (a INT) engine=Aria;
101 INSERT INTO t3 values(2);
102 CREATE OR REPLACE TABLE t2 AS SELECT t1.a,t3.a as b FROM t1,t3;
103 SELECT * from t2;
104 a b
105 1 2
106 DROP TABLE t1, t2, t3;