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

Check integer column types throughout Gen3 database schema

    XMLWordPrintable

Details

    • 1
    • Data Release Production
    • No

    Description

      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

            jbosch Jim Bosch created issue -
            jbosch Jim Bosch made changes -
            Field Original Value New Value
            Epic Link DM-23737 [ 431393 ]
            yusra Yusra AlSayyad made changes -
            Epic Link DM-23737 [ 431393 ] DM-25268 [ 435627 ]
            jbosch Jim Bosch made changes -
            Link This issue duplicates DM-25347 [ DM-25347 ]
            jbosch Jim Bosch made changes -
            Resolution Done [ 10000 ]
            Status To Do [ 10001 ] Invalid [ 11005 ]

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Jenkins

                  No builds found.