Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-81282

Define the maximum allowed integer value in DML, with assertions

XMLWordPrintable

      This came from a discussion with stronk7 in MDL-81073 where the question was raised "How big is an integer across all of our supported database platforms, and where is that defined?" (example)

      It's currently defined ad-hoc as needed by calling code. We can define a constant somewhere in the DML for this value (9,999,999,999) and use it as required

      Ensure this constant is covered by test assertions for usage in select, insert, update & delete queries

            pholden Paul Holden
            pholden Paul Holden
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Andrew Lyons Andrew Lyons
            CiBoT CiBoT
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 3 hours, 45 minutes
                3h 45m

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.