Operator "<=" not allowed on reference operands

[rmoff]

Reproduced in KSQL 5.0.0-SNAPSHOT and KSQL 4.1.1

KSQL throws an error if a predicate is attempted on a MAP.

Source data:

echo '{"id":"a42","category":"foo","timestamp":"2018-06-21 10:04:57 BST","deviceID":42,"deviceProperties":{"status":"false","foo":"bar"}}'| \
kafkacat -b localhost:9092 -t test_map2 -P

Define stream:

CREATE STREAM fakeData22 (Id VARCHAR, category VARCHAR, timeStamp VARCHAR, deviceID INTEGER, deviceProperties MAP<VARCHAR, VARCHAR>) WITH (KAFKA_TOPIC='test_map2', VALUE_FORMAT='JSON');

Standard predicate:

ksql> select * from fakedata22 where deviceid=42;
1529572405759 | null | a42 | foo | 2018-06-21 10:04:57 BST | 42 | {foo=bar, status=false}

MAP predicate:

ksql> select * from fakedata22 where deviceproperties['foo']='bar';
Failed to generate code for SqlPredicate.filterExpression: (FAKEDATA22.DEVICEPROPERTIES['foo'] = 'bar')schema:org.apache.kafka.connect.data.SchemaBuilder@6636ccb2isWindowedKey:false
Caused by: Line 1, Column 168: Operator "<=" not allowed on reference operands

[rmoff]

Also fails on ARRAY data type:

CREATE STREAM fakeData225 (Id VARCHAR, category VARCHAR, timeStamp VARCHAR, deviceID INTEGER, deviceProperties ARRAY<VARCHAR>) WITH (KAFKA_TOPIC='test_map2', VALUE_FORMAT='JSON');

ksql> select deviceproperties[0] from fakeData225;
{"status":"false","foo":"bar"}
^CQuery terminated
ksql>
ksql> select deviceproperties from fakeData225 where deviceProperties[0]='foo';
Failed to generate code for SqlPredicate.filterExpression: (FAKEDATA225.DEVICEPROPERTIES[0] = 'foo')schema:org.apache.kafka.connect.data.SchemaBuilder@13f34c71isWindowedKey:false
Caused by: Line 1, Column 188: Operator "<=" not allowed on reference operands
ksql>

/cc @big-andy-coates

[big-andy-coates]

How does this differ from this PR:

#1476

That suggests this does work on master, (and I tested 5.0 too)? It definitely doesn't work on 4.1.

[rmoff]

@big-andy-coates just catching up on this - it is the same issue, we both logged it :) If it works on master, then we can close this 👍