[#DDC-2208] CASE WHEN ... WHEN doesn't work - Doctrine Project

Fabio B. Silva made changes - 20/Dec/12 1:33 AM

Field	Original Value	New Value
Assignee	Benjamin Eberlei [ beberlei ]	Fabio B. Silva [ fabio.bat.silva ]

Miha Vrhovnik made changes - 20/Dec/12 6:41 AM

Description

Having the following part in select DQL throws an exception.

{code:sql}
SUM(CASE
            WHEN c.startDate <= :start THEN c.endDate - :start
            WHEN c.endDate >= :end THEN :end - c.startDate
            ELSE 0
            END)
{code}

exception:
{code}
[Syntax Error] line 0, col 124: Error: Expected Doctrine\ORM\Query\Lexer::T_ELSE, got '-'
{code}
It seems that it's failing inside the second THEN

Having the following part in select DQL throws an exception.

{code:sql}
SUM(CASE
            WHEN c.startDate <= :start THEN c.endDate - :start
            WHEN c.endDate >= :end THEN :end - c.startDate
            ELSE 0
            END)
{code}

exception:
{code}
[Syntax Error] line 0, col 124: Error: Expected Doctrine\ORM\Query\Lexer::T_ELSE, got '-'
{code}
It seems that it's failing inside the second THEN

This one also seems to fail:
{code:sql}
SUM(CASE
            WHEN c.startDate <= :start THEN (c.endDate - :start)
            WHEN c.endDate >= :end THEN (:end - c.startDate)
            ELSE 0
            END)
{code}

exception:
{code}
[Syntax Error] line 0, col 60: Error: Unexpected '('
{code}

Miha Vrhovnik made changes - 20/Dec/12 5:22 PM

Description

Having the following part in select DQL throws an exception.

{code:sql}
SUM(CASE
            WHEN c.startDate <= :start THEN c.endDate - :start
            WHEN c.endDate >= :end THEN :end - c.startDate
            ELSE 0
            END)
{code}

exception:
{code}
[Syntax Error] line 0, col 124: Error: Expected Doctrine\ORM\Query\Lexer::T_ELSE, got '-'
{code}
It seems that it's failing inside the second THEN

This one also seems to fail:
{code:sql}
SUM(CASE
            WHEN c.startDate <= :start THEN (c.endDate - :start)
            WHEN c.endDate >= :end THEN (:end - c.startDate)
            ELSE 0
            END)
{code}

exception:
{code}
[Syntax Error] line 0, col 60: Error: Unexpected '('
{code}

Having the following part in select DQL throws an exception.

{code:sql}
SUM(CASE
            WHEN c.startDate <= :start THEN c.endDate - :start
            WHEN c.endDate >= :end THEN :end - c.startDate
            ELSE 0
            END)
{code}

exception:
{code}
[Syntax Error] line 0, col 124: Error: Expected Doctrine\ORM\Query\Lexer::T_ELSE, got '-'
{code}
It seems that it's failing inside the second THEN

This one also seems to fail:
{code:sql}
SUM(CASE
            WHEN c.startDate <= :start THEN (c.endDate - :start)
            WHEN c.endDate >= :end THEN (:end - c.startDate)
            ELSE 0
            END)
{code}

exception:
{code}
[Syntax Error] line 0, col 60: Error: Unexpected '('
{code}

Another one:
{code:sql}
SUM(CASE
                WHEN c.startDate <= :start THEN c.endDate - :start
                WHEN c.endDate >= :end THEN :end - c.startDate
                ELSE 0
                END) = :result FROM ...
{code}

exception:
{code}
[Syntax Error] line 0, col 60: Error: Expected Doctrine\ORM\Query\Lexer::T_FROM, got '='
{code}

Benjamin Eberlei made changes - 22/Dec/12 12:00 PM

Status	Open [ 1 ]	Closed [ 6 ]
Fix Version/s		2.4 [ 10321 ]
Resolution		Fixed [ 1 ]

Miha Vrhovnik made changes - 08/Jan/13 9:05 PM

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Reopened [ 4 ]

CASE WHEN ... WHEN doesn't work

Details

Description

Activity

People

Dates