Uploaded image for project: 'Apache HAWQ (Retired)'
  1. Apache HAWQ (Retired)
  2. HAWQ-771

Table and function can not be found by non-superuser in specified schema

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Invalid
    • 2.0.0.0-incubating
    • backlog
    • Catalog
    • None

    Description

      With non-superuser, table and function can not be found in specified schema. While:
      1) they can be found in default schema, i.e., "$user", public
      2) they can be found by superuser.

      This issue occurs in hawq 2.0 and postgres 9.x. See attached sql file for reproduction steps and out file for expected/actual error.

      Attachments

        1. function.out.bug
          1 kB
          Ruilong Huo
        2. function.out.expected
          1.0 kB
          Ruilong Huo
        3. function.sql
          0.7 kB
          Ruilong Huo
        4. table.out.bug
          0.9 kB
          Ruilong Huo
        5. table.out.expected
          0.8 kB
          Ruilong Huo
        6. table.sql
          0.5 kB
          Ruilong Huo

        Activity

          People

            huor Ruilong Huo
            huor Ruilong Huo
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: