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

Hardcoded sql in IOMetadataHandler break pgsql compatibility

    Details

    • Type: Improvement Improvement
    • Status: Confirmed
    • Priority: High High
    • Resolution: Unresolved
    • Affects Version/s: 5.4.6, 16.02
    • Fix Version/s: None
    • Component/s: 5.x > Legacy IO
    • Labels:

      Description

      This hardcoded SQL statement break pgsql compatibilty :
      https://github.com/ezsystems/ezpublish-kernel/blob/451c4f92d2ea27200f3f6e135733aa3177c08f89/eZ/Publish/Core/IO/IOMetadataHandler/LegacyDFSCluster.php#L69

      Postgresql doesn't support ON DUPLICATE KEY UPDATE feature

        Activity

        Mathieu Poulenard created issue -
        Bertrand Dunogier made changes -
        Field Original Value New Value
        Issue Type Bug [ 1 ] Improvement [ 4 ]
        Bertrand Dunogier made changes -
        Affects Version/s 16.02 [ 14501 ]
        Affects Version/s 5.4.6 [ 14493 ]
        Bertrand Dunogier made changes -
        Status Open [ 1 ] Confirmed [ 10037 ]
        Hide
        Bertrand Dunogier added a comment -

        Indeed, this ain't gonna work.

        The easiest for now would be to implement an extra handler specialized for postgres.

        Show
        Bertrand Dunogier added a comment - Indeed, this ain't gonna work. The easiest for now would be to implement an extra handler specialized for postgres.
        Bertrand Dunogier made changes -
        Labels postgresql
        Alex Schuster made changes -
        Workflow EZ* Development Workflow [ 98276 ] EZEE Development Workflow [ 108692 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Confirmed Confirmed
        10d 21h 17m 1 Bertrand Dunogier 09/Apr/16 1:14 PM

          People

          • Assignee:
            Unassigned
            Reporter:
            Mathieu Poulenard
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated: