Debian Codegraph @

mysql-test/suite/sys_vars/r/mysql56_temporal_format_func.result

raw
1 #
2 # MariaDB-5.3 format
3 #
4 SET @@global.mysql56_temporal_format=false;
5 CREATE TABLE t1 (a DATETIME NOT NULL, b DATETIME NOT NULL);
6 INSERT INTO t1 VALUES ('2001-01-01 10:10:10','2001-01-01 10:10:10');
7 SELECT * FROM t1;
8 a b
9 2001-01-01 10:10:10 2001-01-01 10:10:10
10 SELECT (AVG_ROW_LENGTH-1) DIV 2 AS FIELD_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1';
11 FIELD_LENGTH DATA_LENGTH
12 8 17
13 DROP TABLE t1;
14 CREATE TABLE t1 (a DATETIME(5) NOT NULL, b DATETIME(5) NOT NULL);
15 INSERT INTO t1 VALUES ('2001-01-01 10:10:10.12345','2001-01-01 10:10:10.12345');
16 SELECT (AVG_ROW_LENGTH-1) DIV 2 AS FIELD_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1';
17 FIELD_LENGTH DATA_LENGTH
18 7 15
19 SELECT * FROM t1;
20 a b
21 2001-01-01 10:10:10.12345 2001-01-01 10:10:10.12345
22 DROP TABLE t1;
23 CREATE TABLE t1 (a TIME(5) NOT NULL,b TIME(5) NOT NULL);
24 INSERT INTO t1 VALUES ('10:10:10.12345','10:10:10.12345');
25 SELECT * FROM t1;
26 a b
27 10:10:10.12345 10:10:10.12345
28 SELECT (AVG_ROW_LENGTH-1) DIV 2 AS FIELD_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1';
29 FIELD_LENGTH DATA_LENGTH
30 5 11
31 DROP TABLE t1;
32 #
33 # MySQL-5.6 format
34 #
35 SET @@global.mysql56_temporal_format=true;
36 CREATE TABLE t1 (a DATETIME NOT NULL, b DATETIME NOT NULL);
37 INSERT INTO t1 VALUES ('2001-01-01 10:10:10','2001-01-01 10:10:10');
38 SELECT * FROM t1;
39 a b
40 2001-01-01 10:10:10 2001-01-01 10:10:10
41 SELECT (AVG_ROW_LENGTH-1) DIV 2 AS FIELD_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1';
42 FIELD_LENGTH DATA_LENGTH
43 5 11
44 DROP TABLE t1;
45 CREATE TABLE t1 (a DATETIME(5) NOT NULL, b DATETIME(5) NOT NULL);
46 INSERT INTO t1 VALUES ('2001-01-01 10:10:10.12345','2001-01-01 10:10:10.12345');
47 SELECT * FROM t1;
48 a b
49 2001-01-01 10:10:10.12345 2001-01-01 10:10:10.12345
50 SELECT (AVG_ROW_LENGTH-1) DIV 2 AS FIELD_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1';
51 FIELD_LENGTH DATA_LENGTH
52 8 17
53 DROP TABLE t1;
54 CREATE TABLE t1 (a TIME(5) NOT NULL,b TIME(5) NOT NULL);
55 INSERT INTO t1 VALUES ('10:10:10.12345','10:10:10.12345');
56 SELECT * FROM t1;
57 a b
58 10:10:10.12345 10:10:10.12345
59 SELECT (AVG_ROW_LENGTH-1) DIV 2 AS FIELD_LENGTH,DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1';
60 FIELD_LENGTH DATA_LENGTH
61 6 13
62 DROP TABLE t1;
63 SET @@global.mysql56_temporal_format=DEFAULT;