[DRILL-6370] Mod operator % is documented, but not available

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.13.0
• Labels: doc-impacting
• Assignee: Unassigned
• Reporter: Paul Rogers
• Created: 29/Apr/18 19:29
• Updated: 29/Apr/18 19:29

Description

The Operators page in the documentation states that the % operator does modulo division. The first issue is that % is listed in the precedence table, but not the math operator table.

Suppose we try to use the operator:

SELECT 10 % 3 FROM (VALUES(1));

Error: PARSE ERROR: Percent remainder '%' is not allowed under the
  current SQL conformance level

It seems that if we list the operator, we should support it. Or, failing that, add a note to say that the % operator is not currently supported.

The workaround is to use the mod() function:

SELECT mod(10, 3) FROM (VALUES(1));
+---------+
| EXPR$0  |
+---------+
| 1       |
+---------+