MySQL Bugs: #20448: querying view returns incosistent results

Bug #20448	querying view returns incosistent results
Submitted:	14 Jun 2006 7:09	Modified:	14 Jul 2006 7:26
Reporter:	Zhivan Predojevic	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	mySQL 5.0.19	OS:	Windows (Win32)
Assigned to:		CPU Architecture:	Any

Description:
i have a problem performing simple query over view. To make it short, so anyone can recognize whether it is something im missing, this is the problem:

* i have created few levels of views (some of them are based on actual tables and others are based on other created views or some mixed)
* lets say the name of the view i have problems with is "aView"
* when i perform "select * from aView"  i get to see the view is correctly populated
* when i add condition to the query above in some cases it returns ok results but in others it returns 0 rows (which is wrong)

select * from aView where a=1, works fine
select * from aView where a=1 or b=2, works fine
select * from aVew where a=1 and b=3, returns 0 rows --- which is wrong(of course not by itself but in my case there are rows with ok values)

i sincerely hope this is not bug, but i have no idea where to ask about it

How to repeat:
i am still trying to replicate it, and if neccessary i can send dump

You can use the "Files" tab in the bugs form to upload dumps, 
or you can upload stuff to our public FTP server.

The URL of the upload form for this bug report is:

  http://bugs.mysql.com/bug.php?id=20448&files=2

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".