Operator precedence issue

[donataso]

Overview of the Issue

sqlparser seems to not respect parentheses, x * (a div b) is executed as x * a div b. It works correctly when executed directly in MySQL.

Reproduction Steps

• Execute select hex(0x4000000000000000*(1500 div 1000));

Expected output:

+-----------------------------------------+
| hex(0x4000000000000000*(1500 div 1000)) |
+-----------------------------------------+
| 4000000000000000                        |
+-----------------------------------------+
1 row in set (0.00 sec)

Actual output:

ERROR 1690 (22003): vtgate: http://localhost:15001/: target: shard.0.master, used tablet: zone1-150 (localhost): vttablet: rpc error: code = InvalidArgument desc = BIGINT UNSIGNED value is out of range in '(0x4000000000000000 * 1500)' (errno 1690) (sqlstate 22003) (CallerID: userData1): Sql: "select hex(0x4000000000000000 * :vtg1 div :vtg2) from dual", BindVars: {#maxLimit: "type:INT64 value:\"10001\" "vtg1: "type:INT64 value:\"1500\" "vtg2: "type:INT64 value:\"1000\" "}

Operating system and Environment details

• Operating system: Ubuntu 18.04.5 LTS
• Kernel version: Linux 5.3.0-62-generic
• Architecture: x86_64