Details

    • Type: Improvement
    • Status: Resolved
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 4.13.2
    • Fix Version/s: 5.6.0
    • Component/s: Build Info, Properties
    • Labels:
      None

      Description

      Under a large scale build info's recorded on the DB and build annotated properties (hundreds of thousands of properties), the issued DB query below (issued by Artifactory when navigating to the Builds tab on the UI)

      "SELECT distinct build_props.prop_key propsKey,build_props.prop_value propsValue from  build_props\n" +
                  "  inner join\n" +
                  "  builds on builds.build_id = build_props.build_id where builds.build_number = ?\n" +
                  "                                                         and builds.build_date = ?\n" +
                  "                                                         and build_props.prop_key not in (  SELECT distinct build_props.prop_key from  build_props inner join\n" +
                  "                                                                                            builds on builds.build_id = build_props.build_id where builds.build_number = ?\n" +
                  "                                                                                            and builds.build_date = ?\n" +
                  "                                                                                            and build_props.prop_key like 'buildInfo.env.%' )\n";
      

        Attachments

          Activity

            People

            • Assignee:
              saffih Saffi Hartal (Inactive)
              Reporter:
              andreik Andrei Komarov
              Assigned QA:
              Gilad Kalchheim (Inactive)
            • Votes:
              3 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: