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

updatetypedrelation.php is not compatible with oracle

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 3.10.1, 3.9.5, 4.0.1, 4.1.0alpha1
    • 3.10.0, 4.0.0alpha2
    • Upgrading
    • None
    • Operating System:
      PHP Version: (please be specific, like '4.4.3' or '5.1.5')
      Database and version: Oracle 10g XE 10.2.0.1
      Browser (and version):

    Description

      Example:

      eZOracleDB:
      Error (920): ORA-00920: invalid relational operator

      Failed query at offset 262:
      SELECT count AS count
      FROM ezcontentobject_link
      WHERE from_contentobject_id=78297 AND
      from_contentobject_version=2 AND
      to_contentobject_id=78308 AND
      ( relation_type & 7 ) != 0 AND
      contentclassattribute_id=0 AND
      op_code='0'

      Start of error:
      & 7 ) != 0 AND
      contentclassattribute_id=0 AND
      op_code='0'

      Furthermore there are some "AS" elements that could perhaps be removed.

      Attachments

        Activity

          People

            cyberwolf cyberwolf
            ab@ez.no ab@ez.no
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: