Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-24914

Check integer column types throughout Gen3 database schema

    XMLWordPrintable

    Details

    • Story Points:
      1
    • Epic Link:
    • Team:
      Data Release Production
    • Urgent?:
      No

      Description

      Dominique Boutigny has discovered that the column type for the _max fields in the instrument table is not large enough for the values we use in obs_lsst - apparently we're not using a 64-bit type, and we never noticed because <sigh> SQLite doesn't care about types.

      We should do full audit of all of our integer fields and make sure we chose appropriate sizes for all of them. This may involve switching from just "int" in the dimension configs to more precise types.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jbosch Jim Bosch
              Reporter:
              jbosch Jim Bosch
              Watchers:
              Dominique Boutigny, Jim Bosch
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.