Issue Bug Closed

#81157Typoscript SELECT: orderBy = rand() fails

Oliver Hübner 05/06/17, 06:11 updated 01/15/20, 18:26

Description

A Database-Query via Typoscript e.g.

…
table = pages
select {
pidInList = this
orderBy = rand()
}
…

ends with an error, because the ts get rendered the rand() in quoutes

… ORDER BY `rand()` ASC’: Unknown column ‘rand()’ in ‘order clause’

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.