Bug #65185 ErrorCode 1379: View's SELECT still can't contain a subquery
Submitted: 3 May 2012 8:42 Modified: 7 May 2012 7:18
Reporter: Arjan Saly Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DML Severity:S1 (Critical)
Version:5.5 OS:Linux (Ubuntu)
Assigned to: CPU Architecture:Any
Tags: ErrorCode 1349, SELECT, subquery, VIEW

[3 May 2012 8:42] Arjan Saly 
Description:
Already reported in 2006 for version 5.0, still not solved in 5.5:

When creating a view, subqueries are still not allowed in the SELECT clause. What's the point of creating a view when it cannot contain complex queries?

In my opinion a serious RDMBS SHOULD be able to accept complex queries, hence incuding subqueries, to keep these kind of queries maintainable.

Wondering though: Do the developers really under estimate the importance of these requests? Or has it actually been solved in 5.5, but did I stumble into a bug for this particular distribution?

How to repeat:
create view Test as
select TestNumber
From
   (
        select 0 as TestNumber union all
        select 1 as TestNumber union all
        select 2 as TestNumber union all
        select 3 as TestNumber 
    ) TestNumbers
[4 May 2012 17:47] Sveta Smirnova 
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of bug #12755
[7 May 2012 7:18] Arjan Saly 
Don't reply patronising like this as I could NOT find the original bug report using both google and your own search engine. I did find another one, but that one was from an older version (as is the one you mention) and was not open anymore.

Replies like this do not motivate me to report other bugs or feature request, given the fact that apparently your search engine does not work. Nor do I feel taken seriously as we are talking about a request that is open for 7 years already!