diff options
| author | Igor Babaev <igor@askmonty.org> | 2010-12-09 21:55:14 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2010-12-09 21:55:14 -0800 |
| commit | c4080280dfb45e31d3e6936fe08f571d66a62ed9 (patch) | |
| tree | edd6c95f94663af654b856acb327213b3e408958 /mysql-test/suite/pbxt/r/subselect.result | |
| parent | f960f2334dab6bef702a6f36e90dcdf6835588b6 (diff) | |
| parent | 3e946fa7ad833751e90d2263ca896d419c6a499d (diff) | |
| download | mariadb-git-c4080280dfb45e31d3e6936fe08f571d66a62ed9.tar.gz | |
Merge
Diffstat (limited to 'mysql-test/suite/pbxt/r/subselect.result')
| -rw-r--r-- | mysql-test/suite/pbxt/r/subselect.result | 4 |
1 files changed, 0 insertions, 4 deletions
diff --git a/mysql-test/suite/pbxt/r/subselect.result b/mysql-test/suite/pbxt/r/subselect.result index ebe74e442a2..b68654db911 100644 --- a/mysql-test/suite/pbxt/r/subselect.result +++ b/mysql-test/suite/pbxt/r/subselect.result @@ -3667,8 +3667,6 @@ CREATE TABLE t1 (a int, b int auto_increment, PRIMARY KEY (b)); CREATE TABLE t2 (x int auto_increment, y int, z int, PRIMARY KEY (x), FOREIGN KEY (y) REFERENCES t1 (b)); SET SESSION sort_buffer_size = 32 * 1024; -Warnings: -Warning 1292 Truncated incorrect sort_buffer_size value: '32768' SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT a, b, (SELECT x FROM t2 WHERE y=b ORDER BY z DESC LIMIT 1) c FROM t1) t; @@ -4104,8 +4102,6 @@ INSERT INTO `t1` VALUES ('asdf','2007-02-08 01:11:26'); INSERT INTO `t2` VALUES ('abcdefghijk'); INSERT INTO `t2` VALUES ('asdf'); SET session sort_buffer_size=8192; -Warnings: -Warning 1292 Truncated incorrect sort_buffer_size value: '8192' SELECT (SELECT 1 FROM t1 WHERE t1.a=t2.a ORDER BY t1.b LIMIT 1) AS d1 FROM t2; d1 1 |