At file:///home/psergey/dev/maria-5.3-subqueries-r12/
------------------------------------------------------------
revno: 2791
revision-id: pser...@askmonty.org-20100406091710-xamea3aolh3rdspu
parent: pser...@askmonty.org-20100406083401-36tcbqvit0wtilcx
committer: Sergey Petrunya <pser...@askmonty.org>
branch nick: maria-5.3-subqueries-r12
timestamp: Tue 2010-04-06 13:17:10 +0400
message:
MWL#90: Subqueries: Inside-out execution for non-semijoin materialized
subqueries that are AND-parts of the WHERE
- Update test results
=== modified file 'mysql-test/r/metadata.result'
--- a/mysql-test/r/metadata.result 2008-10-10 11:44:10 +0000
+++ b/mysql-test/r/metadata.result 2010-04-06 09:17:10 +0000
@@ -55,7 +55,7 @@
2 female no
select t1.id from t1 union select t2.id from t2;
Catalog Database Table Table_alias Column Column_alias
Type Length Max length Is_null Flags Decimals Charsetnr
-def id id 1 4 1 Y
32768 0 63
+def id id 1 4 1 Y
49152 0 63
id
1
2
@@ -66,7 +66,7 @@
set @arg00=1 ;
select @arg00 FROM t1 where a=1 union distinct select 1 FROM t1 where a=1;
Catalog Database Table Table_alias Column Column_alias
Type Length Max length Is_null Flags Decimals Charsetnr
-def @arg00 @arg00 8 20 1 Y
32768 0 63
+def @arg00 @arg00 8 20 1 Y
49152 0 63
@arg00
1
select * from (select @arg00) aaa;
@@ -76,7 +76,7 @@
1
select 1 union select 1;
Catalog Database Table Table_alias Column Column_alias
Type Length Max length Is_null Flags Decimals Charsetnr
-def 1 1 8 20 1 N
32769 0 63
+def 1 1 8 20 1 N
49153 0 63
1
1
select * from (select 1 union select 1) aaa;
=== modified file 'mysql-test/suite/pbxt/r/metadata.result'
--- a/mysql-test/suite/pbxt/r/metadata.result 2009-04-02 10:03:14 +0000
+++ b/mysql-test/suite/pbxt/r/metadata.result 2010-04-06 09:17:10 +0000
@@ -55,7 +55,7 @@
2 female no
select t1.id from t1 union select t2.id from t2;
Catalog Database Table Table_alias Column Column_alias
Type Length Max length Is_null Flags Decimals Charsetnr
-def id id 1 4 1 Y
32768 0 63
+def id id 1 4 1 Y
49152 0 63
id
1
2
@@ -66,7 +66,7 @@
set @arg00=1 ;
select @arg00 FROM t1 where a=1 union distinct select 1 FROM t1 where a=1;
Catalog Database Table Table_alias Column Column_alias
Type Length Max length Is_null Flags Decimals Charsetnr
-def @arg00 @arg00 8 20 1 Y
32768 0 63
+def @arg00 @arg00 8 20 1 Y
49152 0 63
@arg00
1
select * from (select @arg00) aaa;
@@ -76,7 +76,7 @@
1
select 1 union select 1;
Catalog Database Table Table_alias Column Column_alias
Type Length Max length Is_null Flags Decimals Charsetnr
-def 1 1 8 20 1 N
32769 0 63
+def 1 1 8 20 1 N
49153 0 63
1
1
select * from (select 1 union select 1) aaa;
_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help : https://help.launchpad.net/ListHelp
