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/2748 gitorious. org/mahara/ mahara/ commit/ 2b35e42a9233a99 51204cf29a8206a fbd3cbb4a8
Committed: http://
Submitter: Aaron Wells (<email address hidden>)
Branch: master
commit 2b35e42a9233a99 51204cf29a8206a fbd3cbb4a8
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