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)
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)