[Commits] 3a5e080: Make explain_json.test pass on case-insensitive FS.

Sergei Petrunia psergey at askmonty.org
Fri Nov 28 15:46:05 EET 2014


revision-id: 3a5e080d4dbe58675e6324eaa807bc2c7aa8795d
parent(s): d5fbfb9a93704ebe4b1df37f74850a7464140991
committer: Sergei Petrunia
branch nick: 10.1-explain-json-r5
timestamp: 2014-11-28 16:46:05 +0300
message:

Make explain_json.test pass on case-insensitive FS.

---
 mysql-test/r/explain_json.result |   14 +++++++-------
 mysql-test/t/explain_json.test   |    4 ++--
 2 files changed, 9 insertions(+), 9 deletions(-)

diff --git a/mysql-test/r/explain_json.result b/mysql-test/r/explain_json.result
index fff80d9..d97abba 100644
--- a/mysql-test/r/explain_json.result
+++ b/mysql-test/r/explain_json.result
@@ -313,31 +313,31 @@ drop table t1;
 # Join buffering
 #
 create table t1 (a int, b int);
-insert into t1 select A.a+10*B.a, A.a+10*B.a from t0 A, t0 B;
+insert into t1 select tbl1.a+10*tbl2.a, tbl1.a+10*tbl2.a from t0 tbl1, t0 tbl2;
 explain format=json
-select * from t1 A, t1 B where A.a=B.a and A.b < 3 and B.b < 5;
+select * from t1 tbl1, t1 tbl2 where tbl1.a=tbl2.a and tbl1.b < 3 and tbl2.b < 5;
 EXPLAIN
 {
   "query_block": {
     "select_id": 1,
     "table": {
-      "table_name": "A",
+      "table_name": "tbl1",
       "access_type": "ALL",
       "rows": 100,
       "filtered": 100,
-      "attached_condition": "(A.b < 3)"
+      "attached_condition": "(tbl1.b < 3)"
     },
     "block-nl-join": {
       "table": {
-        "table_name": "B",
+        "table_name": "tbl2",
         "access_type": "ALL",
         "rows": 100,
         "filtered": 100,
-        "attached_condition": "(B.b < 5)"
+        "attached_condition": "(tbl2.b < 5)"
       },
       "buffer_type": "flat",
       "join_type": "BNL",
-      "attached_condition": "(B.a = A.a)"
+      "attached_condition": "(tbl2.a = tbl1.a)"
     }
   }
 }
diff --git a/mysql-test/t/explain_json.test b/mysql-test/t/explain_json.test
index 6a58796..3917ce4 100644
--- a/mysql-test/t/explain_json.test
+++ b/mysql-test/t/explain_json.test
@@ -63,10 +63,10 @@ drop table t1;
 --echo # Join buffering
 --echo #
 create table t1 (a int, b int);
-insert into t1 select A.a+10*B.a, A.a+10*B.a from t0 A, t0 B;
+insert into t1 select tbl1.a+10*tbl2.a, tbl1.a+10*tbl2.a from t0 tbl1, t0 tbl2;
 
 explain format=json
-select * from t1 A, t1 B where A.a=B.a and A.b < 3 and B.b < 5;
+select * from t1 tbl1, t1 tbl2 where tbl1.a=tbl2.a and tbl1.b < 3 and tbl2.b < 5;
 
 drop table t1;
 


More information about the commits mailing list