[TYPO3-mvc] ORDER BY RAND()

[Xavier Perseguers]

Hi Susanne,

> as you are into this topic far more than I am, would you mind telling me
> what the best approach for getting something like RAND() would be? I
> know that there are similar functions in at least postgre, mssql and
> oracle, but I don't know anything about what needs to be observed when
> implementing a function for it. I guess there is some kind of mapping?

Basically, what must be respected is being able to map such functions to their equivalent in other DBMS. As you said, this means PostgreSQL, MSSQL and Oracle as these are those we are taking care of.

I did not checked if this equivalent exists but you said it is, really really great then!

What must be done is enhancing the parser to support it (t3lib_sqlparser and possibly ux_t3lib_sqlparser in DBAL) and the remapping in ux_t3lib_db (DBAL).

I'm OK with adding this support. I do not expect someone else to do it (but if you want, you're welcome of course). But at least, adding such feature in Core should be coordinated with DBAL in order 
to commit both patches one after this other, meaning the bugtracker should have a reference to the other feature request and having the list of corresponding functions in other DBMS as additional note 
or in description of bugtracker entry for DBAL just is what I need to be more efficient ;-)

 > Thanks in advance for enlightening me (and thanks for caring for other
 > DBMS ;)).

That's it! As you see, that's easy to make DBAL compliant :-)

Cheers

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en