opt_range.cc:

  Fix for the bug#31048 for 64bit platforms.
subselect.test, subselect.result:
  Corrected text case for the bug#31048.

2 files changed, 10 insertions, 15 deletions

diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result
index a99b5e5925b..4c398b12a8c 100644
--- a/mysql-test/r/subselect.result
+++ b/mysql-test/r/subselect.result
@@ -4148,9 +4148,8 @@ select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
 select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
 select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
 select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
-select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
-select sum(a) from t1
-)group by b limit 1)group by b limit 1)group by b limit 1
+select sum(a) from t1 where a> ( select sum(a) from t1
+)group by b limit 1)group by b limit 1
 )group by b limit 1)group by b limit 1)group by b limit 1
 )group by b limit 1)group by b limit 1)group by b limit 1
 )group by b limit 1)group by b limit 1)group by b limit 1) 
@@ -4191,9 +4190,8 @@ select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
 select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
 select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
 select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
-select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
-select sum(a) from t1
-)group by b limit 1)group by b limit 1)group by b limit 1
+select sum(a) from t1 where a> ( select sum(a) from t1 
+)group by b limit 1)group by b limit 1
 )group by b limit 1)group by b limit 1)group by b limit 1
 )group by b limit 1)group by b limit 1)group by b limit 1
 )group by b limit 1)group by b limit 1)group by b limit 1) 
@@ -4210,9 +4208,8 @@ id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 9	SUBQUERY	t1	range	a	a	5	NULL	9	Using where; Using temporary; Using filesort
 10	SUBQUERY	t1	range	a	a	5	NULL	9	Using where; Using temporary; Using filesort
 11	SUBQUERY	t1	range	a	a	5	NULL	9	Using where; Using temporary; Using filesort
-12	SUBQUERY	t1	range	a	a	5	NULL	9	Using where; Using temporary; Using filesort
-13	SUBQUERY	t1	range	a	a	5	NULL	1	Using where; Using temporary; Using filesort
-14	SUBQUERY	t1	index	NULL	a	5	NULL	9	Using index
+12	SUBQUERY	t1	range	a	a	5	NULL	1	Using where; Using temporary; Using filesort
+13	SUBQUERY	t1	index	NULL	a	5	NULL	9	Using index
 explain select sum(a),a from t1 where a> (
 select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
 select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test
index 64b390e413d..562794ba501 100644
--- a/mysql-test/t/subselect.test
+++ b/mysql-test/t/subselect.test
@@ -3000,9 +3000,8 @@ select sum(a),a from t1 where a> (
   select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
   select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
   select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
-  select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
-  select sum(a) from t1
-  )group by b limit 1)group by b limit 1)group by b limit 1
+  select sum(a) from t1 where a> ( select sum(a) from t1
+  )group by b limit 1)group by b limit 1
   )group by b limit 1)group by b limit 1)group by b limit 1
   )group by b limit 1)group by b limit 1)group by b limit 1
   )group by b limit 1)group by b limit 1)group by b limit 1) 
@@ -3044,9 +3043,8 @@ explain select sum(a),a from t1 where a> (
   select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
   select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
   select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
-  select sum(a) from t1 where a> ( select sum(a) from t1 where a> (
-  select sum(a) from t1
-  )group by b limit 1)group by b limit 1)group by b limit 1
+  select sum(a) from t1 where a> ( select sum(a) from t1 
+  )group by b limit 1)group by b limit 1
   )group by b limit 1)group by b limit 1)group by b limit 1
   )group by b limit 1)group by b limit 1)group by b limit 1
   )group by b limit 1)group by b limit 1)group by b limit 1)