Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-2933

civicrm_option_value.value is text, so can't use MAX()

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      So this field is text, not an integer, so if we SELECT MAX(value) we get incorrect results if the highest value is > 9. We either need to use SELECT MAX(ROUND(value)), or change the field to be an integer.

      This issue exists in the upgrade php script and sql script. I'm guessing it might occur in other places in core as well.

        Attachments

          Activity

            People

            • Assignee:
              dgg David Greenberg
              Reporter:
              dalin dave hansen-lange
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: