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 ]

Hide

Permalink

Fabio B. Silva added a comment - 21/Dec/12 12:03 PM

Show

Fabio B. Silva added a comment - 21/Dec/12 12:03 PM Fixed : https://github.com/doctrine/doctrine2/commit/8b5e4a9a52670992b85e7223d255b98cf77a35a3

This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DDC-2205, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

Vote (0)

Watch (2)