Uploaded image for project: 'In-Commerce'
  1. In-Commerce
  2. MINC-72

Check all DECIMAL Database Fields for Correct Definitions

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.1.2-B2
    • Fix Version/s: 5.1.3-B1
    • Component/s: General
    • Labels:
      None

      Description

      Check all DECIMAL database fields for correct definitions and make corrections.

      Recently we have come across the table AffiliatePlansBrackets, field Percent uses DECIMAL(3,2) which would allow to save only numbers below 10 (9.99 etc), sa far as 10.00 is out of range already.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                dmitry Dmitry Andrejev [Intechnic]
                Developer:
                Dmitry Andrejev [Intechnic]
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: