summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <bell@sanja.is.com.ua>2004-07-04 10:40:24 +0300
committerunknown <bell@sanja.is.com.ua>2004-07-04 10:40:24 +0300
commitad165ad183213234e7ec29351abac79c087fb981 (patch)
tree506b5b689f8566999d52b45e68e8bc8849799e67 /mysql-test
parentd760bfd6b01e6d73719cd2198ba7b3a9b694a284 (diff)
downloadmariadb-git-ad165ad183213234e7ec29351abac79c087fb981.tar.gz
do not assign values of left expression of IN/ANN/ANY subquery in case of PS preparation (BUG#4403)
mysql-test/r/ps_2myisam.result: changes in results of select without order by mysql-test/r/ps_3innodb.result: changes in results of select without order by mysql-test/r/ps_5merge.result: changes in results of select without order by mysql-test/r/ps_6bdb.result: changes in results of select without order by sql/item_cmpfunc.cc: do not assign values of left expression of IN/ANN/ANY subquery in case of PS preparation
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/ps_2myisam.result12
-rw-r--r--mysql-test/r/ps_3innodb.result24
-rw-r--r--mysql-test/r/ps_5merge.result24
-rw-r--r--mysql-test/r/ps_6bdb.result12
4 files changed, 36 insertions, 36 deletions
diff --git a/mysql-test/r/ps_2myisam.result b/mysql-test/r/ps_2myisam.result
index 04c95271aad..d630730d96f 100644
--- a/mysql-test/r/ps_2myisam.result
+++ b/mysql-test/r/ps_2myisam.result
@@ -389,12 +389,12 @@ where @arg01 = first.b or first.a = second.a or second.b = @arg02;
a @arg00 a
1 ABC 1
2 ABC 1
+3 ABC 1
+4 ABC 1
2 ABC 2
2 ABC 3
-2 ABC 4
-3 ABC 1
3 ABC 3
-4 ABC 1
+2 ABC 4
4 ABC 4
prepare stmt1 from ' select first.a, ?, second.a FROM t1 first, t1 second
where ? = first.b or first.a = second.a or second.b = ? ';
@@ -402,12 +402,12 @@ execute stmt1 using @arg00, @arg01, @arg02;
a ? a
1 ABC 1
2 ABC 1
+3 ABC 1
+4 ABC 1
2 ABC 2
2 ABC 3
-2 ABC 4
-3 ABC 1
3 ABC 3
-4 ABC 1
+2 ABC 4
4 ABC 4
test_sequence
------ subquery tests ------
diff --git a/mysql-test/r/ps_3innodb.result b/mysql-test/r/ps_3innodb.result
index dfb147d0795..8cba3501a73 100644
--- a/mysql-test/r/ps_3innodb.result
+++ b/mysql-test/r/ps_3innodb.result
@@ -548,14 +548,14 @@ def in_s 8 21 1 Y 32768 0 8
def in_row_s 8 21 1 Y 32768 0 8
scalar_s exists_s in_s in_row_s
2.0000 0 1 0
-2.0000 0 1 0
18.0000 1 0 1
+2.0000 0 1 0
18.0000 1 0 1
execute stmt1 ;
scalar_s exists_s in_s in_row_s
2.0000 0 1 0
-2.0000 0 1 0
18.0000 1 0 1
+2.0000 0 1 0
18.0000 1 0 1
set @stmt= concat('explain ',@stmt);
prepare stmt1 from @stmt ;
@@ -572,8 +572,8 @@ def ref 253 1024 0 Y 0 31 63
def rows 8 10 1 N 32801 0 8
def Extra 253 255 44 N 1 31 63
id select_type table type possible_keys key key_len ref rows Extra
-1 PRIMARY <derived6> ALL NULL NULL NULL NULL 2
-1 PRIMARY t_many_col_types ALL NULL NULL NULL NULL 3 Using where
+1 PRIMARY t_many_col_types ALL NULL NULL NULL NULL 3
+1 PRIMARY <derived6> ALL NULL NULL NULL NULL 2 Using where
6 DERIVED t2 ALL NULL NULL NULL NULL 2
5 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 2 Using where
4 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 2 Using where
@@ -581,8 +581,8 @@ id select_type table type possible_keys key key_len ref rows Extra
2 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 2 Using where; Using temporary; Using filesort
execute stmt1 ;
id select_type table type possible_keys key key_len ref rows Extra
-1 PRIMARY <derived6> ALL NULL NULL NULL NULL 2
-1 PRIMARY t_many_col_types ALL NULL NULL NULL NULL 3 Using where
+1 PRIMARY t_many_col_types ALL NULL NULL NULL NULL 3
+1 PRIMARY <derived6> ALL NULL NULL NULL NULL 2 Using where
6 DERIVED t2 ALL NULL NULL NULL NULL 2
5 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 2 Using where
4 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 2 Using where
@@ -617,15 +617,15 @@ def in_s 8 21 1 Y 32768 0 8
def in_row_s 8 21 1 Y 32768 0 8
scalar_s exists_s in_s in_row_s
2 0 1 0
-2 0 1 0
18 1 0 1
+2 0 1 0
18 1 0 1
execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04, @arg05, @arg06,
@arg07, @arg08, @arg09 ;
scalar_s exists_s in_s in_row_s
2 0 1 0
-2 0 1 0
18 1 0 1
+2 0 1 0
18 1 0 1
set @stmt= concat('explain ',@stmt);
prepare stmt1 from @stmt ;
@@ -643,8 +643,8 @@ def ref 253 1024 0 Y 0 31 63
def rows 8 10 1 N 32801 0 8
def Extra 253 255 44 N 1 31 63
id select_type table type possible_keys key key_len ref rows Extra
-1 PRIMARY <derived6> ALL NULL NULL NULL NULL 2
-1 PRIMARY t_many_col_types ALL NULL NULL NULL NULL 3 Using where
+1 PRIMARY t_many_col_types ALL NULL NULL NULL NULL 3
+1 PRIMARY <derived6> ALL NULL NULL NULL NULL 2 Using where
6 DERIVED t2 ALL NULL NULL NULL NULL 2
5 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 2 Using where
4 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 2 Using where
@@ -653,8 +653,8 @@ id select_type table type possible_keys key key_len ref rows Extra
execute stmt1 using @arg00, @arg01, @arg02, @arg03, @arg04, @arg05, @arg06,
@arg07, @arg08, @arg09 ;
id select_type table type possible_keys key key_len ref rows Extra
-1 PRIMARY <derived6> ALL NULL NULL NULL NULL 2
-1 PRIMARY t_many_col_types ALL NULL NULL NULL NULL 3 Using where
+1 PRIMARY t_many_col_types ALL NULL NULL NULL NULL 3
+1 PRIMARY <derived6> ALL NULL NULL NULL NULL 2 Using where
6 DERIVED t2 ALL NULL NULL NULL NULL 2
5 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 2 Using where
4 DEPENDENT SUBQUERY t2 ALL NULL NULL NULL NULL 2 Using where
diff --git a/mysql-test/r/ps_5merge.result b/mysql-test/r/ps_5merge.result
index fab0b552b48..8fc035b0aef 100644
--- a/mysql-test/r/ps_5merge.result
+++ b/mysql-test/r/ps_5merge.result
@@ -432,12 +432,12 @@ where @arg01 = first.b or first.a = second.a or second.b = @arg02;
a @arg00 a
1 ABC 1
2 ABC 1
+3 ABC 1
+4 ABC 1
2 ABC 2
2 ABC 3
-2 ABC 4
-3 ABC 1
3 ABC 3
-4 ABC 1
+2 ABC 4
4 ABC 4
prepare stmt1 from ' select first.a, ?, second.a FROM t1 first, t1 second
where ? = first.b or first.a = second.a or second.b = ? ';
@@ -445,12 +445,12 @@ execute stmt1 using @arg00, @arg01, @arg02;
a ? a
1 ABC 1
2 ABC 1
+3 ABC 1
+4 ABC 1
2 ABC 2
2 ABC 3
-2 ABC 4
-3 ABC 1
3 ABC 3
-4 ABC 1
+2 ABC 4
4 ABC 4
test_sequence
------ subquery tests ------
@@ -1615,12 +1615,12 @@ where @arg01 = first.b or first.a = second.a or second.b = @arg02;
a @arg00 a
1 ABC 1
2 ABC 1
+3 ABC 1
+4 ABC 1
2 ABC 2
2 ABC 3
-2 ABC 4
-3 ABC 1
3 ABC 3
-4 ABC 1
+2 ABC 4
4 ABC 4
prepare stmt1 from ' select first.a, ?, second.a FROM t1 first, t1 second
where ? = first.b or first.a = second.a or second.b = ? ';
@@ -1628,12 +1628,12 @@ execute stmt1 using @arg00, @arg01, @arg02;
a ? a
1 ABC 1
2 ABC 1
+3 ABC 1
+4 ABC 1
2 ABC 2
2 ABC 3
-2 ABC 4
-3 ABC 1
3 ABC 3
-4 ABC 1
+2 ABC 4
4 ABC 4
test_sequence
------ subquery tests ------
diff --git a/mysql-test/r/ps_6bdb.result b/mysql-test/r/ps_6bdb.result
index ac0b38951c0..eeabd114b91 100644
--- a/mysql-test/r/ps_6bdb.result
+++ b/mysql-test/r/ps_6bdb.result
@@ -389,12 +389,12 @@ where @arg01 = first.b or first.a = second.a or second.b = @arg02;
a @arg00 a
1 ABC 1
2 ABC 1
+3 ABC 1
+4 ABC 1
2 ABC 2
2 ABC 3
-2 ABC 4
-3 ABC 1
3 ABC 3
-4 ABC 1
+2 ABC 4
4 ABC 4
prepare stmt1 from ' select first.a, ?, second.a FROM t1 first, t1 second
where ? = first.b or first.a = second.a or second.b = ? ';
@@ -402,12 +402,12 @@ execute stmt1 using @arg00, @arg01, @arg02;
a ? a
1 ABC 1
2 ABC 1
+3 ABC 1
+4 ABC 1
2 ABC 2
2 ABC 3
-2 ABC 4
-3 ABC 1
3 ABC 3
-4 ABC 1
+2 ABC 4
4 ABC 4
test_sequence
------ subquery tests ------
View Lorry Controller Status