Christian Himpe

SQL: Field access for sub-query in projection

6

### ArcadeDB Version: v23.1.2 (build 9dbe3ce451430f27ae747ab99781d18c65e0e7ac/1675373316135/main) ### JDK Version: openjdk 11.0.18 2023-01-17 ### OS: MacOS 12.6 Accessing a field from a sub-query in a projection, like: ``` SELECT (SELECT name...

Adding an `array` method to bloblang

1

Dear All, I would like to propose adding a method `array` to bloblang, which returns always an array. Specifically, every non-array input is returned as single element array, while an...

These changes add an `array` type coercion **bloblang** method similar to the `bytes` method: If the caller is already of type array the the input is returned. If it is...

Added ArcadeDB to the graph database section.

## What does this PR do? This change fixes and tests the case of comparing two empty strings `""` with `LIKE`, ie: `SELECT ("" LIKE "")`, see https://sqlfiddle.com/postgresql/online-compiler?id=357ca34a-0b9f-428d-8f17-10d3202e8a38 for comparison....

### ArcadeDB Version: `ArcadeDB Server v24.5.1-SNAPSHOT (build 11db1796a17bfccb23d22cfa73906fbae9f46338/1714568271787/main)` ### OS and JDK Version: `Running on Mac OS X 12.7.4 - OpenJDK 64-Bit Server VM 17.0.11 (Homebrew)` Predicate testing empty with...

### ArcadeDB Version: `ArcadeDB Server v24.5.1-SNAPSHOT (build 11db1796a17bfccb23d22cfa73906fbae9f46338/1714568271787/main)` ### OS and JDK Version: `Running on Mac OS X 12.7.4 - OpenJDK 64-Bit Server VM 17.0.11 (Homebrew)` If a projection is...

SQL: semantic negation of LIKE and ILIKE

1

### ArcadeDB Version: `ArcadeDB Server v24.5.1-SNAPSHOT (build 11db1796a17bfccb23d22cfa73906fbae9f46338/1714568271787/main)` ### OS and JDK Version: `Running on Mac OS X 12.7.4 - OpenJDK 64-Bit Server VM 17.0.11 (Homebrew)` To negate a `LIKE`...

Importer: url and id type problems

2

### ArcadeDB Version: `ArcadeDB Server v24.2.1 (build 5c4448730af1f607dec0b7dfb2e8dffc6b33b3cb/1713169925164/main)` ### OS and JDK Version: `Running on Mac OS X 12.7.4 - OpenJDK 64-Bit Server VM 17.0.10 (Homebrew)` I found two problems...

## What does this PR do? This new boolean property attribute called `hidden` excludes properties from a projection containing a `*` (star). ## Motivation [ZetaSQL](https://github.com/google/zetasql/blob/master/docs/data-definition-language.md?plain=1#L204) ## Related issues https://github.com/ArcadeData/arcadedb/discussions/1439 ##...