Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-20824

ezoracle: db driver - $db->generateSQLINStatement - not working correctly for items > 1000



      The restriction for oracle database, which only allows a total amount of 1000 elements in an IN statement is generating a where clause that is not safely encapsulated in braces *( ... )*

      In consequence, when the return value of this method is combined in other *and* clauses on query construction (such as the one in kernel/classes/notification/handler/ezsubtree/ezsubtreenotificationrule.php) the result set won't be the desired one.

      Steps to reproduce:
      • On an environment with eZOracle and over 1000 user accounts, all of them set up to be notified on changes to an object,
      • perform the changes
      • run the notification cronjob (active in *frequent*, by default)
      • The outcome may vary into a fatal error, if your data is large enough to provoke it or an undesired list of users being notified.


        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Backlog Backlog
        2m 17s 1 joaquim.cavalleri@ez.no 06/May/13 12:43 PM
        Backlog Backlog InputQ InputQ
        8d 22h 45m 1 Gunnstein Lye 15/May/13 11:29 AM
        QA QA InputQ InputQ
        49s 1 pedro.resende@ez.no 29/May/13 12:43 PM
        InputQ InputQ Development Development
        3d 4h 42m 2 yannick.roger@ez.no 30/May/13 10:19 AM
        Development Development Development Done Development Done
        3d 20h 11m 2 yannick.roger@ez.no 30/May/13 10:20 AM
        Development Done Development Done Documentation Review done Documentation Review done
        26s 2 yannick.roger@ez.no 30/May/13 10:20 AM
        Documentation Review done Documentation Review done QA QA
        8d 3h 16m 2 pedro.resende@ez.no 30/May/13 3:40 PM
        QA QA QA Done QA Done
        3d 17h 34m 1 pedro.resende@ez.no 03/Jun/13 9:15 AM
        QA Done QA Done Closed Closed
        7d 9h 8m 1 André Rømcke 10/Jun/13 6:24 PM


          • Assignee:
            Joaquim Cavalleri (Inactive)
          • Votes:
            0 Vote for this issue
            4 Start watching this issue


            • Created:

              Time Tracking

              Original Estimate - Not Specified
              Not Specified
              Remaining Estimate - 0 minutes
              Time Spent - 1 hour