SQL: `not like` is not working

[darpan-vyas]

ArcadeDB Version: ArcadeDB Server v23.3.1-SNAPSHOT (build 143b1a6/1677646375828/main)

JDK Version: JMX Metrics

OS: MacOS Ventura 13.2.1

Expected behavior

Filter all nodes where node property 'name' doesn't starts with 'tier'

Actual behavior

Query 1: select *,bothE() from tag where name not like 'tier%'
Query 2: match{type:tag, as:a, where: (name not like 'tier%')} return a

Getting an error. Please refer to the below images.

Background:
Tag is a node type with name (string) as a property.

Steps to reproduce

• I've created a few nodes of type 'tag'. Each node has a unique string type name.
• I connected the database in console and queried it to check the working.

[lvca]

This looks like a console issue: it has trouble to decipher the % character. If you run the same in Studio should work. This is a bug, working on it.

[darpan-vyas]

Getting errors on the console too!

[lvca]

There are 2 issues here: the console doesn't handle the % character properly and the not like seems not accepted. Checking the SQL grammar to see if there is something missing there.

[lvca]

I see. This is working:

select *,bothE() from tag where not( name like 'tier% )

The NOT must be used before an expression, not the operator it self. I'm continuing checking if there are some exceptions.

[lvca]

The only exception I see defined in the grammar is the usage of NOT IN operator, otherwise the not must be before the expression.

[lvca]

I just fixed the issue with the console, not it works in the last main branch.