[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.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.10.1.1
• Component/s: SQL
• Labels: derby_triage10_11
• Urgency: Normal
• Issue & fix info: Repro attached, Workaround attached
• Bug behavior facts: Performance, Seen in production
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 07/Jan/13 15:10
• Updated: 13/Dec/13 14:44

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.

Issue Links

• is related to: DERBY-6109 Allow CREATE SYNONYM for table function invocations.