3394
3394
DROP TABLE t1,t2;
3397
--echo # Bug#12329653
3398
--echo # EXPLAIN, UNION, PREPARED STATEMENT, CRASH, SQL_FULL_GROUP_BY
3401
CREATE TABLE t1(a1 int);
3402
INSERT INTO t1 VALUES (1),(2);
3404
SELECT @@session.sql_mode INTO @old_sql_mode;
3405
SET SESSION sql_mode='ONLY_FULL_GROUP_BY';
3407
## First a simpler query, illustrating the transformation
3408
## '1 < some (...)' => '1 < max(...)'
3409
SELECT 1 FROM t1 WHERE 1 < SOME (SELECT a1 FROM t1);
3411
## The query which made the server crash.
3416
(SELECT 1 FROM t1 AS t1_0
3417
WHERE 1 < SOME (SELECT a1 FROM t1)
3420
--error ER_SUBQUERY_NO_1_ROW
3422
--error ER_SUBQUERY_NO_1_ROW
3425
SET SESSION sql_mode=@old_sql_mode;
3427
DEALLOCATE PREPARE stmt;
3397
3430
--echo End of 5.0 tests.
3726
3759
--enable_result_log
3728
3761
--echo End of 5.1 tests
3764
--echo # Bug #11765713 58705:
3765
--echo # OPTIMIZER LET ENGINE DEPEND ON UNINITIALIZED VALUES
3766
--echo # CREATED BY OPT_SUM_QUERY
3769
CREATE TABLE t1(a INT NOT NULL, KEY (a));
3770
INSERT INTO t1 VALUES (0), (1);
3772
--error ER_SUBQUERY_NO_1_ROW
3773
SELECT 1 as foo FROM t1 WHERE a < SOME
3774
(SELECT a FROM t1 WHERE a <=>
3778
SELECT 1 as foo FROM t1 WHERE a < SOME
3779
(SELECT a FROM t1 WHERE a <=>
3780
(SELECT a FROM t1 where a is null)