search

vfremaux / moodle-local_shop

core plugin for a moodle integrated shop system. this is the community version
4 stars 3 forks source link

mysql specific SQL Syntax #2

Open danmarsden opened 6 years ago

danmarsden commented 6 years ago

GROUP_CONCAT, REGEXP mysql specific functions - it would be a good idea for you to test this on postgres to see what other sql needs to be fixed.

danmarsden commented 6 years ago

Mysql "IF" in select.

https://github.com/vfremaux/moodle-local_shop/blob/master/classes/Catalog.class.php#L686

danmarsden commented 6 years ago

this one will probably fail in other db types due to missing clauses in the group by statement: https://github.com/vfremaux/moodle-local_shop/blob/master/classes/Customer.class.php#L121

vfremaux commented 6 years ago

IF removed and replaced by CASE WHEN ... THEN .... ELSE .... END syntax