In the 1.8+ codebase there are only two places where both mysql and
postgres use CAST(). So I've tried altering the calls so that mysql
doens't need to use CAST().
This will probably need to be tested with a large data mysql db site
to see if any speed gains are made, and also the calls are still
working correctly.
All other places it is being used by postgres only
Signed-off-by: Robert Lyon <email address hidden>
Reviewed: https:/ /reviews. mahara. org/3163 gitorious. org/mahara/ mahara/ commit/ c6d8ccbf5a4ad53 8bddb18e96a2a2a 64eb18b3fb
Committed: http://
Submitter: Aaron Wells (<email address hidden>)
Branch: 1.7_STABLE
commit c6d8ccbf5a4ad53 8bddb18e96a2a2a 64eb18b3fb
Author: Robert Lyon <email address hidden>
Date: Tue Nov 26 15:06:22 2013 +1300
Getting mysql not to use CAST() (bug #1081947)
In the 1.8+ codebase there are only two places where both mysql and
postgres use CAST(). So I've tried altering the calls so that mysql
doens't need to use CAST().
This will probably need to be tested with a large data mysql db site
to see if any speed gains are made, and also the calls are still
working correctly.
All other places it is being used by postgres only
Signed-off-by: Robert Lyon <email address hidden>
Change-Id: I9eaf196d062ef2 a62bfdae0df1792 81f3411c392