Repository navigation
SQL: not like is not working #958
Description
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.
Activity
lvca commentedon Mar 20, 2023
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 commentedon Mar 20, 2023
Getting errors on the console too!
lvca commentedon Mar 20, 2023
There are 2 issues here: the console doesn't handle the
%character properly and thenot likeseems not accepted. Checking the SQL grammar to see if there is something missing there.lvca commentedon Mar 20, 2023
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 commentedon Mar 20, 2023
The only exception I see defined in the grammar is the usage of
NOT INoperator, otherwise the not must be before the expression.fix: console does not support correctly outputs with `%` character
lvca commentedon Mar 20, 2023
I just fixed the issue with the console, not it works in the last
mainbranch.chore(deps): bump actions/dependency-review-action from 4.7.1 to 4.7.…
chore(deps): bump the github-actions group with 2 updates [skip ci]
fix: console does not support correctly outputs with `%` character
chore(deps): bump actions/dependency-review-action from 4.7.1 to 4.7.…
chore(deps): bump the github-actions group with 2 updates [skip ci]
chore(deps-dev): bump org.apache.maven.plugins:maven-enforcer-plugin …
build(deps-dev): bump org.apache.maven.plugins:maven-enforcer-plugin …