diff options
author | Sergei Petrunia <psergey@askmonty.org> | 2014-12-02 10:35:28 +0300 |
---|---|---|
committer | Sergei Petrunia <psergey@askmonty.org> | 2014-12-02 10:35:28 +0300 |
commit | d6e881643508b77ae482014a061927f91f4a8eec (patch) | |
tree | 6ea2f1f0f0a5c7b4b06bf5efa4168b524264405d /mysql-test/r/analyze_format_json.result | |
parent | b3d930b39c1d874d269a256e7ae05ae3e1956d4d (diff) | |
download | mariadb-git-d6e881643508b77ae482014a061927f91f4a8eec.tar.gz |
Make analyze_format_json.test work on case-insensitive FS.
Diffstat (limited to 'mysql-test/r/analyze_format_json.result')
-rw-r--r-- | mysql-test/r/analyze_format_json.result | 28 |
1 files changed, 14 insertions, 14 deletions
diff --git a/mysql-test/r/analyze_format_json.result b/mysql-test/r/analyze_format_json.result index 53fdf3ef3d9..b496fe5a68e 100644 --- a/mysql-test/r/analyze_format_json.result +++ b/mysql-test/r/analyze_format_json.result @@ -97,36 +97,36 @@ EXPLAIN } } analyze -select * from t1 A, t1 B where A.b<2 and B.b>5; +select * from t1 tbl1, t1 tbl2 where tbl1.b<2 and tbl2.b>5; id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra -1 SIMPLE A ALL NULL NULL NULL NULL 100 100 100.00 2.00 Using where -1 SIMPLE B ALL NULL NULL NULL NULL 100 100 100.00 94.00 Using where; Using join buffer (flat, BNL join) +1 SIMPLE tbl1 ALL NULL NULL NULL NULL 100 100 100.00 2.00 Using where +1 SIMPLE tbl2 ALL NULL NULL NULL NULL 100 100 100.00 94.00 Using where; Using join buffer (flat, BNL join) analyze format=json -select * from t1 A, t1 B where A.b<20 and B.b<60; +select * from t1 tbl1, t1 tbl2 where tbl1.b<20 and tbl2.b<60; EXPLAIN { "query_block": { "select_id": 1, "table": { - "table_name": "A", + "table_name": "tbl1", "access_type": "ALL", "r_loops": 1, "rows": 100, "r_rows": 100, "filtered": 100, "r_filtered": 20, - "attached_condition": "(A.b < 20)" + "attached_condition": "(tbl1.b < 20)" }, "block-nl-join": { "table": { - "table_name": "B", + "table_name": "tbl2", "access_type": "ALL", "r_loops": 1, "rows": 100, "r_rows": 100, "filtered": 100, "r_filtered": 60, - "attached_condition": "(B.b < 60)" + "attached_condition": "(tbl2.b < 60)" }, "buffer_type": "flat", "join_type": "BNL", @@ -135,35 +135,35 @@ EXPLAIN } } analyze format=json -select * from t1 A, t1 B where A.b<20 and B.b<60 and A.c > B.c; +select * from t1 tbl1, t1 tbl2 where tbl1.b<20 and tbl2.b<60 and tbl1.c > tbl2.c; EXPLAIN { "query_block": { "select_id": 1, "table": { - "table_name": "A", + "table_name": "tbl1", "access_type": "ALL", "r_loops": 1, "rows": 100, "r_rows": 100, "filtered": 100, "r_filtered": 20, - "attached_condition": "(A.b < 20)" + "attached_condition": "(tbl1.b < 20)" }, "block-nl-join": { "table": { - "table_name": "B", + "table_name": "tbl2", "access_type": "ALL", "r_loops": 1, "rows": 100, "r_rows": 100, "filtered": 100, "r_filtered": 60, - "attached_condition": "(B.b < 60)" + "attached_condition": "(tbl2.b < 60)" }, "buffer_type": "flat", "join_type": "BNL", - "attached_condition": "(A.c > B.c)", + "attached_condition": "(tbl1.c > tbl2.c)", "r_filtered": 15.833 } } |