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

fix integration test query case01/queries/0010_leapSec.sql

    Details

    • Type: Story
    • Status: Won't Fix
    • Priority: Undefined
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Templates:
    • Story Points:
      0
    • Sprint:
      DB_F18_07
    • Team:
      Data Access and Database

      Description

      When running this query

      SELECT offset, mjdRef, drift
      FROM LeapSeconds 
      WHERE whenUtc = (
      SELECT MAX(whenUtc) 
      FROM LeapSeconds 
      WHERE whenUtc <= NAME_CONST('nsecs_',39900600000000000000000000)
      )
      

      qserv fails with the error

      ERROR 1146 (42S02): Table 'qservResult.result_4492' doesn't exist

        Attachments

          Container Issues

            Issue Links

              Activity

                People

                • Assignee:
                  npease Nate Pease
                  Reporter:
                  npease Nate Pease
                  Watchers:
                  Nate Pease
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Summary Panel