DDC-1213: Make Bit comparsion available #1522

New Issue

admin · 2026-01-22T13:16:53+01:00

admin commented

2026-01-22 13:16:53 +01:00

Originally created by @doctrinebot on GitHub (Jun 17, 2011).

Jira issue originally created by user scyks:

When you go to compare Bit Values in MySQL Database you can do thiy by "&" or "|" If you do this with Doctrine 2 you got an exception like following:
Message: [Syntax Error] line 0, col 161: Error: Expected =, <, <=, <>, >, >=, != got '&'

So i fixed this problem for me:

Doctrine\ORM\Query\Parser:
Line 2633

    /****
     * ComparisonOperator ::= "=" | "<" | "<=" | "<>" | ">" | ">=" | "!=" | "&" | "|"
     *
     * @return string
     */
    public function ComparisonOperator()
    {
        switch ($this->_lexer->lookahead['value']) {
            case '=':
                $this->match(Lexer::T_EQUALS);

                return '=';

            case '<':
                $this->match(Lexer::T*LOWER*THAN);
                $operator = '<';

                if ($this->*lexer->isNextToken(Lexer::T*EQUALS)) {
                    $this->match(Lexer::T_EQUALS);
                    $operator .= '=';
                } else if ($this->*lexer->isNextToken(Lexer::T_GREATER*THAN)) {
                    $this->match(Lexer::T*GREATER*THAN);
                    $operator .= '>';
                }

                return $operator;

            case '>':
                $this->match(Lexer::T*GREATER*THAN);
                $operator = '>';

                if ($this->*lexer->isNextToken(Lexer::T*EQUALS)) {
                    $this->match(Lexer::T_EQUALS);
                    $operator .= '=';
                }

                return $operator;

            case '!':
                $this->match(Lexer::T_NEGATE);
                $this->match(Lexer::T_EQUALS);

                return '<>';
            /** Changes by SR-RM to make Bit Oprations available **/
            case '&':
                $this->match(LEXER::T*BIT*AND);
                return '&';
            case '|':
                $this->match(LEXER::T*BIT*OR);
                return '|';
            /** Changes by SR-RM End **/
            default:
                $this->syntaxError('=, <, <=, <>, >, >=, !=, &, |');
        }
    }

Doctrine\ORM\Query\Lexer:
Line 53

/** Changes SR-RM to make Bit Oprations available **/
const T*BIT*AND             = 30;
const T*BIT*OR               = 31;
/** Changes by SR-RM End **/

Line 193

/** Changes SR-RM to make Bit Oprations available **/
case '&': return self::T*BIT*AND;
case '|': return self::T*BIT*OR;
/** Changes by SR-RM End **/

So, maybe you gonna ad this in next Release ;)

Thanks or your good Job

Originally created by @doctrinebot on GitHub (Jun 17, 2011). Jira issue originally created by user scyks: When you go to compare Bit Values in MySQL Database you can do thiy by "&" or "|" If you do this with Doctrine 2 you got an exception like following: Message: [Syntax Error] line 0, col 161: Error: Expected =, <, <=, <>, >, >=, != got '&' So i fixed this problem for me: Doctrine\ORM\Query\Parser: Line 2633 ``` /**** * ComparisonOperator ::= "=" | "<" | "<=" | "<>" | ">" | ">=" | "!=" | "&" | "|" * * @return string */ public function ComparisonOperator() { switch ($this->_lexer->lookahead['value']) { case '=': $this->match(Lexer::T_EQUALS); return '='; case '<': $this->match(Lexer::T*LOWER*THAN); $operator = '<'; if ($this->*lexer->isNextToken(Lexer::T*EQUALS)) { $this->match(Lexer::T_EQUALS); $operator .= '='; } else if ($this->*lexer->isNextToken(Lexer::T_GREATER*THAN)) { $this->match(Lexer::T*GREATER*THAN); $operator .= '>'; } return $operator; case '>': $this->match(Lexer::T*GREATER*THAN); $operator = '>'; if ($this->*lexer->isNextToken(Lexer::T*EQUALS)) { $this->match(Lexer::T_EQUALS); $operator .= '='; } return $operator; case '!': $this->match(Lexer::T_NEGATE); $this->match(Lexer::T_EQUALS); return '<>'; /** Changes by SR-RM to make Bit Oprations available **/ case '&': $this->match(LEXER::T*BIT*AND); return '&'; case '|': $this->match(LEXER::T*BIT*OR); return '|'; /** Changes by SR-RM End **/ default: $this->syntaxError('=, <, <=, <>, >, >=, !=, &, |'); } } ``` Doctrine\ORM\Query\Lexer: Line 53 ``` /** Changes SR-RM to make Bit Oprations available **/ const T*BIT*AND = 30; const T*BIT*OR = 31; /** Changes by SR-RM End **/ ``` Line 193 ``` /** Changes SR-RM to make Bit Oprations available **/ case '&': return self::T*BIT*AND; case '|': return self::T*BIT*OR; /** Changes by SR-RM End **/ ``` So, maybe you gonna ad this in next Release ;) Thanks or your good Job

admin added the Improvement label 2026-01-22 13:16:53 +01:00

admin closed this issue

2026-01-22 13:16:53 +01:00

admin commented

2026-01-22 13:16:54 +01:00