Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6036

If you wrap a SELECT * view around a table, all of the columns are read from the base row even when you SELECT only a subset of the view columns.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.10.1.1
    • None
    • SQL
    • Normal
    • Repro attached, Workaround attached
    • Performance, Seen in production

    Description

      This also affects SELECTs from views wrapping RestrictedVTIs. Restrictions are pushed into a restricted VTI if you wrap it in a view. However, projections are not. I will attach a script showing this problem.

      Attachments

        1. derby-6036-01-aa-testForRestrictionPushing.diff
          3 kB
          Richard N. Hillegas
        2. derbyAST.xml
          267 kB
          Richard N. Hillegas
        3. derby-6036.sql
          1 kB
          Richard N. Hillegas

        Issue Links

          Activity

            People

              Unassigned Unassigned
              rhillegas Richard N. Hillegas
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: