Negative Values in Case Then expressions

DQL Expression:

SELECT (CASE WHEN t.id = 1 THEN -1 ELSE t.id END) FROM Table t

Gives an error:
[Syntax Error] line 0, col 32: Error: Unexpected '-'

It doesn't seem to like the negative number.

Ascending order - Click to sort in descending order

Ilya Biryukov made changes - 18/Dec/12 12:19 AM

Field	Original Value	New Value
Description	DQL Expression: SELECT (CASE WHEN t.id = 1 THEN -1 ELSE t.id END) FROM {$this->getEntityName()} t Gives an error: [Syntax Error] line 0, col 32: Error: Unexpected '-' It doesn't seem to like the negative number.	DQL Expression: SELECT (CASE WHEN t.id = 1 THEN -1 ELSE t.id END) FROM Table t Gives an error: [Syntax Error] line 0, col 32: Error: Unexpected '-' It doesn't seem to like the negative number.

Assignee

Benjamin Eberlei [ beberlei ]

Fabio B. Silva [ fabio.bat.silva ]

Vote (0)

Watch (2)