[DERBY-5781] Investigate lifting the limit on the number of columns in a Derby table

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.10.2.0
• Component/s: SQL
• Labels: derby_triage10_11
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 24/May/12 15:58
• Updated: 16/Apr/14 02:41

Description

Derby tables are limited to 1012 columns. This arbitrary limit is not found in the SQL Standard and is the value of Limits.DB2_MAX_ELEMENTS_IN_SELECT_LIST. We should investigate lifting this limit based on user demand: http://old.nabble.com/limit-on-the-number-of-columns-to33901308.html#a33901308

Issue Links

• is related to: DERBY-5782 Consider lifting the limit on the number of columns which can appear in a SELECT list