Debian Codegraph @

mysql-test/suite/engines/funcs/r/an_number.result

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 TINYINT NULL, c2 TINYINT NULL);
3 INSERT INTO t1 VALUES(1,2);
4 INSERT INTO t1 VALUES(3,4);
5 ANALYZE TABLE t1;
6 Table Op Msg_type Msg_text
7 test.t1 analyze status Engine-independent statistics collected
8 test.t1 analyze status OK
9 DROP TABLE t1;
10 CREATE TABLE t1(c1 SMALLINT NULL, c2 SMALLINT NULL);
11 INSERT INTO t1 VALUES(1,2);
12 INSERT INTO t1 VALUES(3,4);
13 ANALYZE TABLE t1;
14 Table Op Msg_type Msg_text
15 test.t1 analyze status Engine-independent statistics collected
16 test.t1 analyze status OK
17 DROP TABLE t1;
18 CREATE TABLE t1(c1 MEDIUMINT NULL, c2 MEDIUMINT NULL);
19 INSERT INTO t1 VALUES(1,2);
20 INSERT INTO t1 VALUES(3,4);
21 ANALYZE TABLE t1;
22 Table Op Msg_type Msg_text
23 test.t1 analyze status Engine-independent statistics collected
24 test.t1 analyze status OK
25 DROP TABLE t1;
26 CREATE TABLE t1(c1 INT NULL, c2 INT NULL);
27 INSERT INTO t1 VALUES(1,2);
28 INSERT INTO t1 VALUES(3,4);
29 ANALYZE TABLE t1;
30 Table Op Msg_type Msg_text
31 test.t1 analyze status Engine-independent statistics collected
32 test.t1 analyze status OK
33 DROP TABLE t1;
34 CREATE TABLE t1(c1 INTEGER NULL, c2 INTEGER NULL);
35 INSERT INTO t1 VALUES(1,2);
36 INSERT INTO t1 VALUES(3,4);
37 ANALYZE TABLE t1;
38 Table Op Msg_type Msg_text
39 test.t1 analyze status Engine-independent statistics collected
40 test.t1 analyze status OK
41 DROP TABLE t1;
42 CREATE TABLE t1(c1 BIGINT NULL, c2 BIGINT NULL);
43 INSERT INTO t1 VALUES(1,2);
44 INSERT INTO t1 VALUES(3,4);
45 ANALYZE TABLE t1;
46 Table Op Msg_type Msg_text
47 test.t1 analyze status Engine-independent statistics collected
48 test.t1 analyze status OK
49 DROP TABLE t1;
50 CREATE TABLE t1(c1 DECIMAL NULL, c2 DECIMAL NULL);
51 INSERT INTO t1 VALUES(1,2);
52 INSERT INTO t1 VALUES(3,4);
53 ANALYZE TABLE t1;
54 Table Op Msg_type Msg_text
55 test.t1 analyze status Engine-independent statistics collected
56 test.t1 analyze status OK
57 DROP TABLE t1;
58 CREATE TABLE t1(c1 DEC NULL, c2 DEC NULL);
59 INSERT INTO t1 VALUES(1,2);
60 INSERT INTO t1 VALUES(3,4);
61 ANALYZE TABLE t1;
62 Table Op Msg_type Msg_text
63 test.t1 analyze status Engine-independent statistics collected
64 test.t1 analyze status OK
65 DROP TABLE t1;
66 CREATE TABLE t1(c1 FIXED NULL, c2 FIXED NULL);
67 INSERT INTO t1 VALUES(1,2);
68 INSERT INTO t1 VALUES(3,4);
69 ANALYZE TABLE t1;
70 Table Op Msg_type Msg_text
71 test.t1 analyze status Engine-independent statistics collected
72 test.t1 analyze status OK
73 DROP TABLE t1;
74 CREATE TABLE t1(c1 NUMERIC NULL, c2 NUMERIC NULL);
75 INSERT INTO t1 VALUES(1,2);
76 INSERT INTO t1 VALUES(3,4);
77 ANALYZE TABLE t1;
78 Table Op Msg_type Msg_text
79 test.t1 analyze status Engine-independent statistics collected
80 test.t1 analyze status OK
81 DROP TABLE t1;
82 CREATE TABLE t1(c1 DOUBLE NULL, c2 DOUBLE NULL);
83 INSERT INTO t1 VALUES(1,2);
84 INSERT INTO t1 VALUES(3,4);
85 ANALYZE TABLE t1;
86 Table Op Msg_type Msg_text
87 test.t1 analyze status Engine-independent statistics collected
88 test.t1 analyze status OK
89 DROP TABLE t1;
90 CREATE TABLE t1(c1 REAL NULL, c2 REAL NULL);
91 INSERT INTO t1 VALUES(1,2);
92 INSERT INTO t1 VALUES(3,4);
93 ANALYZE TABLE t1;
94 Table Op Msg_type Msg_text
95 test.t1 analyze status Engine-independent statistics collected
96 test.t1 analyze status OK
97 DROP TABLE t1;
98 CREATE TABLE t1(c1 DOUBLE PRECISION NULL, c2 DOUBLE PRECISION NULL);
99 INSERT INTO t1 VALUES(1,2);
100 INSERT INTO t1 VALUES(3,4);
101 ANALYZE TABLE t1;
102 Table Op Msg_type Msg_text
103 test.t1 analyze status Engine-independent statistics collected
104 test.t1 analyze status OK
105 DROP TABLE t1;
106 CREATE TABLE t1(c1 FLOAT NULL, c2 FLOAT NULL);
107 INSERT INTO t1 VALUES(1,2);
108 INSERT INTO t1 VALUES(3,4);
109 ANALYZE TABLE t1;
110 Table Op Msg_type Msg_text
111 test.t1 analyze status Engine-independent statistics collected
112 test.t1 analyze status OK
113 DROP TABLE t1;