diff options
| author | Varun Gupta <varunraiko1803@gmail.com> | 2018-05-31 15:51:59 +0530 |
|---|---|---|
| committer | Varun Gupta <varunraiko1803@gmail.com> | 2018-12-08 23:35:36 +0200 |
| commit | 9deae355e5da2b40c6a940e2272d8e7a98912be7 (patch) | |
| tree | a619c5ced37b0156487a9107d304fbfd7590001a /mysql-test/suite/engines/funcs/r/an_string.result | |
| parent | a25ce5ab4b38f0557abba8c5eb71b0839dc1ec4b (diff) | |
| download | mariadb-git-10.4-selectivity3.tar.gz | |
MDEV-15253: Default optimizer setting changes for MariaDB 10.410.4-selectivity3
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/an_string.result')
| -rw-r--r-- | mysql-test/suite/engines/funcs/r/an_string.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/suite/engines/funcs/r/an_string.result b/mysql-test/suite/engines/funcs/r/an_string.result index c7762155a7d..f3e7eaedb15 100644 --- a/mysql-test/suite/engines/funcs/r/an_string.result +++ b/mysql-test/suite/engines/funcs/r/an_string.result @@ -4,6 +4,7 @@ INSERT INTO t1 VALUES('abc','ABCDEFG'); INSERT INTO t1 VALUES('123','1234567890'); ANALYZE TABLE t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK DROP TABLE t1; CREATE TABLE t1(c1 VARCHAR(100) NULL, c2 VARCHAR(100) NULL); @@ -11,6 +12,7 @@ INSERT INTO t1 VALUES('abc','ABCDEFG'); INSERT INTO t1 VALUES('123','1234567890'); ANALYZE TABLE t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK DROP TABLE t1; CREATE TABLE t1(c1 BINARY(100) NULL, c2 BINARY(100) NULL); @@ -18,6 +20,7 @@ INSERT INTO t1 VALUES('abc','ABCDEFG'); INSERT INTO t1 VALUES('123','1234567890'); ANALYZE TABLE t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK DROP TABLE t1; CREATE TABLE t1(c1 VARBINARY(100) NULL, c2 VARBINARY(100) NULL); @@ -25,6 +28,7 @@ INSERT INTO t1 VALUES('abc','ABCDEFG'); INSERT INTO t1 VALUES('123','1234567890'); ANALYZE TABLE t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected test.t1 analyze status OK DROP TABLE t1; CREATE TABLE t1(c1 BLOB(100) NULL, c2 BLOB(100) NULL); @@ -32,6 +36,9 @@ INSERT INTO t1 VALUES('abc','ABCDEFG'); INSERT INTO t1 VALUES('123','1234567890'); ANALYZE TABLE t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected +test.t1 analyze Warning Engine-independent statistics are not collected for column 'c1' +test.t1 analyze Warning Engine-independent statistics are not collected for column 'c2' test.t1 analyze status OK DROP TABLE t1; CREATE TABLE t1(c1 TEXT(100) NULL, c2 TEXT(100) NULL); @@ -39,5 +46,8 @@ INSERT INTO t1 VALUES('abc','ABCDEFG'); INSERT INTO t1 VALUES('123','1234567890'); ANALYZE TABLE t1; Table Op Msg_type Msg_text +test.t1 analyze status Engine-independent statistics collected +test.t1 analyze Warning Engine-independent statistics are not collected for column 'c1' +test.t1 analyze Warning Engine-independent statistics are not collected for column 'c2' test.t1 analyze status OK DROP TABLE t1; |