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

Using Test Runs List Gadget with more than 1000 tests, there is an SQL error in oracle databases due to 1000 element limit on "IN" clauses

    XporterXMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Won't Fix
    • 4.2.11
    • None
    • Database
    • None

    • UNCOVERED

    Description

      Description
      Using Test Runs List Gadget with more than 1000 tests, there is an SQL error in oracle databases due to 1000 element limit on "IN" clauses.

      How to reproduce

      1. Create a filter with more than 1000 Test Executions
      2. Add this filter to Test Runs List Gadget

      Actual result/Attachments
      The gadget presents the message: No Test Runs found.

      Error on the logs:

      2021-03-25 10:25:18,909 http-nio-3500-exec-1 ERROR admin 625x2426x1 i0pr2g 10.20.10.110 /rest/raven/1.0/chart/testrunlist/datapaginated [c.x.r.dao.impl.DAOContextImpl] Error executing SQL select statement
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
	....

      Expected result
      The gadget should present all Test Runs.

      Version

      • 4.2.5
      • 4.2.11

      Attachments

        Issue Links

          mentioned in

          Page Loading...

          Activity

            People

              helder.ferreira Helder Ferreira
              amgt Ana Teixeira
              Votes:
              3 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: