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. table.sql
          0.5 kB
          Ruilong Huo
        2. table.out.bug
          0.9 kB
          Ruilong Huo
        3. table.out.expected
          0.8 kB
          Ruilong Huo
        4. function.sql
          0.7 kB
          Ruilong Huo
        5. function.out.bug
          1 kB
          Ruilong Huo
        6. function.out.expected
          1.0 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: