Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 CREATE TABLE t1(c1 CHAR(100) NULL, c2 CHAR(100) NULL);
3 INSERT INTO t1 VALUES('abc','ABCDEFG');
4 INSERT INTO t1 VALUES('123','1234567890');
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 VARCHAR(100) NULL, c2 VARCHAR(100) NULL);
11 INSERT INTO t1 VALUES('abc','ABCDEFG');
12 INSERT INTO t1 VALUES('123','1234567890');
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 BINARY(100) NULL, c2 BINARY(100) NULL);
19 INSERT INTO t1 VALUES('abc','ABCDEFG');
20 INSERT INTO t1 VALUES('123','1234567890');
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 VARBINARY(100) NULL, c2 VARBINARY(100) NULL);
27 INSERT INTO t1 VALUES('abc','ABCDEFG');
28 INSERT INTO t1 VALUES('123','1234567890');
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 BLOB(100) NULL, c2 BLOB(100) NULL);
35 INSERT INTO t1 VALUES('abc','ABCDEFG');
36 INSERT INTO t1 VALUES('123','1234567890');
37 ANALYZE TABLE t1;
38 Table Op Msg_type Msg_text
39 test.t1 analyze status Engine-independent statistics collected
40 test.t1 analyze Warning Engine-independent statistics are not collected for column 'c1'
41 test.t1 analyze Warning Engine-independent statistics are not collected for column 'c2'
42 test.t1 analyze status OK
43 DROP TABLE t1;
44 CREATE TABLE t1(c1 TEXT(100) NULL, c2 TEXT(100) NULL);
45 INSERT INTO t1 VALUES('abc','ABCDEFG');
46 INSERT INTO t1 VALUES('123','1234567890');
47 ANALYZE TABLE t1;
48 Table Op Msg_type Msg_text
49 test.t1 analyze status Engine-independent statistics collected
50 test.t1 analyze Warning Engine-independent statistics are not collected for column 'c1'
51 test.t1 analyze Warning Engine-independent statistics are not collected for column 'c2'
52 test.t1 analyze status OK
53 DROP TABLE t1;