Comment 1 for bug 934597

Revision history for this message
Sergey Petrunia (sergefp) wrote :

Not repeatable in the latest 5.3 tree:

mysql> CREATE TABLE t AS
    -> SELECT a AS field1 FROM t1
    -> WHERE ( SELECT alias1.a
    -> FROM t1 AS alias1
    -> ) IS NOT NULL;
Query OK, 0 rows affected, 1 warning (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> show warnings\G
*************************** 1. row ***************************
  Level: Error
   Code: 1242
Message: Subquery returns more than 1 row
1 row in set (0.00 sec)