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/3158 gitorious. org/mahara/ mahara/ commit/ e35d3ea8b72a260 57a5edf7e8e9f1e d0ad138391
Committed: http://
Submitter: Son Nguyen (<email address hidden>)
Branch: 1.6_STABLE
commit e35d3ea8b72a260 57a5edf7e8e9f1e d0ad138391
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