Uploaded image for project: 'Xray for Jira'
  1. Xray for Jira
  2. XRAY-5102

SQL error in oracle databases due to 1000 element limit on "IN" clauses

    XporterXMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Done
    • None
    • 3.6.3
    • Database
    • None

    • OK

    Description

      SQL error in oracle databases due to 1000 element limit on "IN" clauses.

      Some of the sql queries are not correctly formatted to accommodate this limitation on oracle dbs

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. XRAY-4772 Test Repository with more than one thousand of folders is not showing correctly the number of Tests of each folder

          • Major - Major loss of function.
          • Resolved
          is cloned by

          Bug - A problem which impairs or prevents the functions of the product. XRAY-6876 Using Test Evolution Gadget with more than 1000 tests, there is an SQL error in oracle databases due to 1000 element limit on "IN" clauses

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. XRAY-4772 Test Repository with more than one thousand of folders is not showing correctly the number of Tests of each folder

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              ipvm Isabel Moreira
              cgso Claudio Sousa
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day, 3 hours, 15 minutes
                  1d 3h 15m