[CALCITE-4445] Create new conformance level for Postgresql

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: core
• Assignee: Ondřej Štumpf
• Reporter: Ondřej Štumpf
• Created: 23/Dec/20 15:35
• Updated: 08/Jan/21 02:07

Description

In CALCITE-4443, a new Postgresql-specific operator ILIKE was introduced. Currently that operator is only enabled in LENIENT and BABEL conformance levels. Let's:

• create a new conformance level POSTGRESQL
  • make sure it supports ILIKE
• use this new conformance level in Postgresql and Vertica dialects
• update the tests for ILIKE to set POSTGRESQL conformance level instead of LENIENT

Issue Links

• is related to: CALCITE-4443 Add ILIKE operator (similar to LIKE, but case-insensitive, and PostgreSQL-specific)