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 OK
8 DROP TABLE t1;
9 CREATE TABLE t1(c1 SMALLINT NULL, c2 SMALLINT NULL);
10 INSERT INTO t1 VALUES(1,2);
11 INSERT INTO t1 VALUES(3,4);
12 ANALYZE TABLE t1;
13 Table Op Msg_type Msg_text
14 test.t1 analyze status OK
15 DROP TABLE t1;
16 CREATE TABLE t1(c1 MEDIUMINT NULL, c2 MEDIUMINT NULL);
17 INSERT INTO t1 VALUES(1,2);
18 INSERT INTO t1 VALUES(3,4);
19 ANALYZE TABLE t1;
20 Table Op Msg_type Msg_text
21 test.t1 analyze status OK
22 DROP TABLE t1;
23 CREATE TABLE t1(c1 INT NULL, c2 INT NULL);
24 INSERT INTO t1 VALUES(1,2);
25 INSERT INTO t1 VALUES(3,4);
26 ANALYZE TABLE t1;
27 Table Op Msg_type Msg_text
28 test.t1 analyze status OK
29 DROP TABLE t1;
30 CREATE TABLE t1(c1 INTEGER NULL, c2 INTEGER NULL);
31 INSERT INTO t1 VALUES(1,2);
32 INSERT INTO t1 VALUES(3,4);
33 ANALYZE TABLE t1;
34 Table Op Msg_type Msg_text
35 test.t1 analyze status OK
36 DROP TABLE t1;
37 CREATE TABLE t1(c1 BIGINT NULL, c2 BIGINT NULL);
38 INSERT INTO t1 VALUES(1,2);
39 INSERT INTO t1 VALUES(3,4);
40 ANALYZE TABLE t1;
41 Table Op Msg_type Msg_text
42 test.t1 analyze status OK
43 DROP TABLE t1;
44 CREATE TABLE t1(c1 DECIMAL NULL, c2 DECIMAL NULL);
45 INSERT INTO t1 VALUES(1,2);
46 INSERT INTO t1 VALUES(3,4);
47 ANALYZE TABLE t1;
48 Table Op Msg_type Msg_text
49 test.t1 analyze status OK
50 DROP TABLE t1;
51 CREATE TABLE t1(c1 DEC NULL, c2 DEC NULL);
52 INSERT INTO t1 VALUES(1,2);
53 INSERT INTO t1 VALUES(3,4);
54 ANALYZE TABLE t1;
55 Table Op Msg_type Msg_text
56 test.t1 analyze status OK
57 DROP TABLE t1;
58 CREATE TABLE t1(c1 FIXED NULL, c2 FIXED 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 OK
64 DROP TABLE t1;
65 CREATE TABLE t1(c1 NUMERIC NULL, c2 NUMERIC NULL);
66 INSERT INTO t1 VALUES(1,2);
67 INSERT INTO t1 VALUES(3,4);
68 ANALYZE TABLE t1;
69 Table Op Msg_type Msg_text
70 test.t1 analyze status OK
71 DROP TABLE t1;
72 CREATE TABLE t1(c1 DOUBLE NULL, c2 DOUBLE NULL);
73 INSERT INTO t1 VALUES(1,2);
74 INSERT INTO t1 VALUES(3,4);
75 ANALYZE TABLE t1;
76 Table Op Msg_type Msg_text
77 test.t1 analyze status OK
78 DROP TABLE t1;
79 CREATE TABLE t1(c1 REAL NULL, c2 REAL NULL);
80 INSERT INTO t1 VALUES(1,2);
81 INSERT INTO t1 VALUES(3,4);
82 ANALYZE TABLE t1;
83 Table Op Msg_type Msg_text
84 test.t1 analyze status OK
85 DROP TABLE t1;
86 CREATE TABLE t1(c1 DOUBLE PRECISION NULL, c2 DOUBLE PRECISION NULL);
87 INSERT INTO t1 VALUES(1,2);
88 INSERT INTO t1 VALUES(3,4);
89 ANALYZE TABLE t1;
90 Table Op Msg_type Msg_text
91 test.t1 analyze status OK
92 DROP TABLE t1;
93 CREATE TABLE t1(c1 FLOAT NULL, c2 FLOAT NULL);
94 INSERT INTO t1 VALUES(1,2);
95 INSERT INTO t1 VALUES(3,4);
96 ANALYZE TABLE t1;
97 Table Op Msg_type Msg_text
98 test.t1 analyze status OK
99 DROP TABLE t1;