Menu
▾
▴
#2518 (ok 2.11.4) Subquery results without \"as\" are ignored
The following is valid MySQL syntax:
SELECT * FROM (SELECT 1,2) t1
In 2.11.0, this produces no results--not even a row count. Oddly, the lefthand frame containing the list of database tables also refreshes.
The workaround is to change the query to:
SELECT * FROM (SELECT 1,2) AS t1
Note that the first method did work in 2.10.1, but has since been broken.
Discussion
Logged In: YES
user_id=1615140
Originator: NO
I found this bug in 2.11.2.1. Thanks for the workaround.
Logged In: YES
user_id=1615140
Originator: NO
This query still fails ->
SELECT t1.a
FROM (
SELECT a
FROM `tableA`
WHERE `id` =60
AND `cstatus` = 'Y'
) AS t1
WHERE a NOT
IN (
SELECT a
FROM tableB s1
WHERE s1.a = t1.a
)
Logged In: YES
user_id=326580
Originator: NO
same problem described here:
bug #1723297 No result when using cross join of tables
https://sf.net/support/tracker.php?aid=1723297
Logged In: YES
user_id=210714
Originator: NO
Fixed in subversion, thanks for reporting.