Bug #40335 Double equality sign
Submitted: 26 Oct 2008 19:23 Modified: 4 Feb 2009 18:53
Reporter: Sergei Kulakov (Candidate Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Parser Severity:S4 (Feature request)
Version:All OS:Any
Assigned to: CPU Architecture:Any
Tags: Double equality sign

[26 Oct 2008 19:23] Sergei Kulakov 
Description:
I'm sorry I tried seaching but didn't find anything, maybe I missed it. My idea is very simple - to allow double equal sign "==" for comparisons like 

Select (priority==0) as bOld From ... 

along with single equality sign (=), while keeping only the latter for assignments. The reason is I sometimes mistype == instead of = but at the same time I see no reason why you couldn't allow it. 

How to repeat:
-

Suggested fix:
-
[4 Feb 2009 15:04] Susanne Ebrecht 
Many thanks for writing a feature request.

I will give us into development for discussion.

But please consider, SQL is an own programming language. And the behaviour of = is given in SQL standard.

So I doubt that our development will change something here.
[4 Feb 2009 18:53] Sergei Kulakov 
I must say I doubt too. 
At the same time behaviour of = is not changed, but == can be added.