Uploaded image for project: 'Hue (READ ONLY)'
  1. Hue (READ ONLY)
  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.api
          • 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: