[CALCITE-319] Table aliases should follow case-sensitivity policy

• Type: Test
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.9.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 02/Jul/14 00:19
• Updated: 27/Feb/24 22:23
• Resolved: 06/Jul/16 05:35

Description

Table aliases should follow case-sensitivity policy. For example,

SELECT * FROM dept "d", dept "D"

should be allowed if identifiers are case-sensitive, should give error if identifiers are case-insensitive. Currently it is allowed under all policies, and that is wrong.

See unit test in SqlValidatorTest.testCaseSensitive.

Issue Links

• is related to: CALCITE-1305 Case-insensitive table aliases and GROUP BY