Multiple line support in console

[TangMonk]

This issue should not be closed #220

[zhanghuidinah]

This issue should not be closed #220

Hi, Please comment if you have any new updates, and you are welcome to reopen this issue at any time.#220

[sarit-pop]

I got the solution. You have to use backslash without comment. You can jump to the last section for solution.

Running with docker compose file
nebula-metad:v3.8.0
docker.io/vesoft/nebula-storaged:v3.8.0
docker.io/vesoft/nebula-graphd:v3.8.0
docker.io/vesoft/nebula-console:v3.8.0

Ubuntu 24.04
Linux administrator-System-Product-Name 6.17.0-35-generic #35~24.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 19:30:42 UTC 2 x86_64 x86_64 x86_64 GNU/Linux

First method not work. now.

nebula-console-linux-amd64-v3.8.0 -addr 127.0.0.1 -port 9669 -u root -p nebula -f <(cat person.sql | sed -e 's/^[ \t]*//' | sed '/^--/ d' | sed '/\/\*.*\*\// d' | sed '/\/\*/,/\*\// d' | tr '\n' ' ' | sed -E 's/;\ /;\n/g' | sed -e 's/^[ \t]*//' | envsubst)
(root@nebula) [(none)]> CREATE TAG IF NOT EXISTS person( \ name string NOT NULL, \ gender string,  \-- "M" / "F" birth_year int, \ death_year int, \-- null = still alive side    string, \--"paternal" / "maternal" / "nuclear" generation int, \--0 = self, 1 = parents, 2 = grandparents, ... );
[ERROR (-1004)]: SyntaxError: syntax error near `\ name s'

Tue, 16 Jun 2026 14:05:52 +07



Bye root!
Tue, 16 Jun 2026 14:05:52 +07

Second method use backslash mixing with comment. Also not work.
person.sql

CREATE TAG IF NOT EXISTS person( \
    name string NOT NULL, \
    gender string,  \-- "M" / "F"
    birth_year int, \
    death_year int, \-- null = still alive
    side    string, \--"paternal" / "maternal" / "nuclear"
    generation int, \--0 = self, 1 = parents, 2 = grandparents, ...
);

nebula-console-linux-amd64-v3.8.0 -addr 127.0.0.1 -port 9669 -u root -p nebula -f person.sql                                                                                                                         ─╯
(root@nebula) [(none)]> CREATE TAG IF NOT EXISTS person( \
                     ->     name string NOT NULL, \
                     ->     gender string,  \-- "M" / "F"
[ERROR (-1004)]: SyntaxError: syntax error near `\-- "M" '

Tue, 16 Jun 2026 14:08:49 +07

(root@nebula) [(none)]>     birth_year int, \
                     ->     death_year int, \-- null = still alive
[ERROR (-1004)]: SyntaxError: syntax error near `birth_year'

Tue, 16 Jun 2026 14:08:49 +07

(root@nebula) [(none)]>     side    string, \--"paternal" / "maternal" / "nuclear"
[ERROR (-1004)]: SyntaxError: syntax error near `side'

Tue, 16 Jun 2026 14:08:49 +07

(root@nebula) [(none)]>     generation int, \--0 = self, 1 = parents, 2 = grandparents, ...
[ERROR (-1004)]: SyntaxError: syntax error near `generation'

Tue, 16 Jun 2026 14:08:49 +07

(root@nebula) [(none)]> );
[ERROR (-1004)]: SyntaxError: syntax error near `);'

Tue, 16 Jun 2026 14:08:49 +07



Bye root!
Tue, 16 Jun 2026 14:08:49 +07

However, backslash without any comment WORKS.

USE family_tree;
CREATE TAG IF NOT EXISTS person( \
    name string NOT NULL, \
    gender string,  \
    birth_year int, \
    death_year int, \
    side    string, \
    generation int, \
);

(root@nebula) [family_tree]> CREATE TAG IF NOT EXISTS person( \
                          ->     name string NOT NULL, \
                          ->     gender string,  \
                          ->     birth_year int, \
                          ->     death_year int, \
                          ->     side    string, \
                          ->     generation int, \
                          -> );
Execution succeeded (time spent 1.79ms/2.075549ms)

Tue, 16 Jun 2026 14:12:23 +07



Bye root!
Tue, 16 Jun 2026 14:12:23 +07