Uploaded image for project: 'Hue'
  1. Hue
  2. HUE-2166

[core] Oracle database support in doc model

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.6.0
    • Fix Version/s: 3.7.0
    • Component/s: core.backend
    • Labels:
      None

      Description

      • Ensure table names are less than or equal to 30 characters
      • Ensure DISTINCT and JOIN aren't used in the same query:
        This does not work:
        SELECT DISTINCT "DESKTOP_DOCUMENT"."ID", "DESKTOP_DOCUMENT"."OWNER_ID", "DESKTOP_DOCUMENT"."NAME", "DESKTOP_DOCUMENT"."DESCRIPTION", "DESKTOP_DOCUMENT"."LAST_MODIFIED", "DESKTOP_DOCUMENT"."VERSION", "DESKTOP_DOCUMENT"."EXTRA", "DESKTOP_DOCUMENT"."CONTENT_TYPE_ID", "DESKTOP_DOCUMENT"."OBJECT_ID" FROM "DESKTOP_DOCUMENT" LEFT OUTER JOIN "DESKTOP_DOCUMENTPERMISSION" ON ("DESKTOP_DOCUMENT"."ID" = "DESKTOP_DOCUMENTPERMISSION"."DOC_ID")
        

        This does work:

        SELECT DISTINCT "DESKTOP_DOCUMENT"."ID", "DESKTOP_DOCUMENT"."OWNER_ID", "DESKTOP_DOCUMENT"."NAME", "DESKTOP_DOCUMENT"."DESCRIPTION", "DESKTOP_DOCUMENT"."LAST_MODIFIED", "DESKTOP_DOCUMENT"."VERSION", "DESKTOP_DOCUMENT"."EXTRA", "DESKTOP_DOCUMENT"."CONTENT_TYPE_ID", "DESKTOP_DOCUMENT"."OBJECT_ID" FROM "DESKTOP_DOCUMENT"
        

        Attachments

          Activity

            People

            • Assignee:
              abe Abraham Elmahrek
              Reporter:
              abe Abraham Elmahrek
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: