You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@streampark.apache.org by be...@apache.org on 2022/11/19 01:11:41 UTC
[incubator-streampark] branch dev updated: [bug] fix 'Error Code: 1064. You have an error in your SQL syntax' (#2060)
This is an automated email from the ASF dual-hosted git repository.
benjobs pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/incubator-streampark.git
The following commit(s) were added to refs/heads/dev by this push:
new 9d66291ab [bug] fix 'Error Code: 1064. You have an error in your SQL syntax' (#2060)
9d66291ab is described below
commit 9d66291ab4ca786e511993cb0ce9708f4b6aa4f8
Author: lvlin241 <lv...@163.com>
AuthorDate: Sat Nov 19 09:11:33 2022 +0800
[bug] fix 'Error Code: 1064. You have an error in your SQL syntax' (#2060)
* [bug] sql script comment bug fixed
Co-authored-by: benjobs <be...@apache.org>
---
.../src/assembly/script/data/mysql-data.sql | 6 +++---
.../src/assembly/script/data/pgsql-data.sql | 6 +++---
.../streampark-console-service/src/main/resources/db/data-h2.sql | 6 +++---
3 files changed, 9 insertions(+), 9 deletions(-)
diff --git a/streampark-console/streampark-console-service/src/assembly/script/data/mysql-data.sql b/streampark-console/streampark-console-service/src/assembly/script/data/mysql-data.sql
index 726a92634..d80bceab1 100644
--- a/streampark-console/streampark-console-service/src/assembly/script/data/mysql-data.sql
+++ b/streampark-console/streampark-console-service/src/assembly/script/data/mysql-data.sql
@@ -67,7 +67,7 @@ insert into `t_menu` values (100015, 100013, 'menu.application', '/flink/app', '
insert into `t_menu` values (100016, 100015, 'add', '/flink/app/add', 'flink/app/Add', 'app:create', '', '0', 0, null, now(), now());
insert into `t_menu` values (100017, 100014, 'add', '/flink/project/add', 'flink/project/Add', 'project:create', '', '0', 0, null, now(), now());
insert into `t_menu` values (100018, 100015, 'detail app', '/flink/app/detail', 'flink/app/Detail', 'app:detail', '', '0', 0, null, now(), now());
---insert into `t_menu` values (100019, 100013, 'Notebook', '/flink/notebook/view', 'flink/notebook/Submit', 'notebook:submit', 'read', '0', 1, 4, now(), now());
+-- insert into `t_menu` values (100019, 100013, 'Notebook', '/flink/notebook/view', 'flink/notebook/Submit', 'notebook:submit', 'read', '0', 1, 4, now(), now());
insert into `t_menu` values (100020, 100015, 'edit flink', '/flink/app/edit_flink', 'flink/app/EditFlink', 'app:update', '', '0', 0, null, now(), now());
insert into `t_menu` values (100021, 100015, 'edit streampark', '/flink/app/edit_streampark', 'flink/app/EditStreamPark', 'app:update', '', '0', 0, null, now(), now());
insert into `t_menu` values (100022, 100014, 'build', null, null, 'project:build', null, '1', 1, null, now(), now());
@@ -132,7 +132,7 @@ insert into `t_role_menu` values (100041, 100001, 100014);
insert into `t_role_menu` values (100042, 100001, 100016);
insert into `t_role_menu` values (100043, 100001, 100017);
insert into `t_role_menu` values (100044, 100001, 100018);
---insert into `t_role_menu` values (100045, 100001, 100019);
+-- insert into `t_role_menu` values (100045, 100001, 100019);
insert into `t_role_menu` values (100046, 100001, 100020);
insert into `t_role_menu` values (100047, 100001, 100021);
insert into `t_role_menu` values (100048, 100001, 100022);
@@ -151,7 +151,7 @@ insert into `t_role_menu` values (100060, 100002, 100014);
insert into `t_role_menu` values (100061, 100002, 100016);
insert into `t_role_menu` values (100062, 100002, 100017);
insert into `t_role_menu` values (100063, 100002, 100018);
---insert into `t_role_menu` values (100064, 100002, 100019);
+-- insert into `t_role_menu` values (100064, 100002, 100019);
insert into `t_role_menu` values (100065, 100002, 100020);
insert into `t_role_menu` values (100066, 100002, 100021);
insert into `t_role_menu` values (100067, 100002, 100022);
diff --git a/streampark-console/streampark-console-service/src/assembly/script/data/pgsql-data.sql b/streampark-console/streampark-console-service/src/assembly/script/data/pgsql-data.sql
index c621ebd86..4b83e0f64 100644
--- a/streampark-console/streampark-console-service/src/assembly/script/data/pgsql-data.sql
+++ b/streampark-console/streampark-console-service/src/assembly/script/data/pgsql-data.sql
@@ -63,7 +63,7 @@ insert into "public"."t_menu" values (100015, 100013, 'menu.application', '/flin
insert into "public"."t_menu" values (100016, 100015, 'add', '/flink/app/add', 'flink/app/Add', 'app:create', '', '0', 0, null, now(), now());
insert into "public"."t_menu" values (100017, 100014, 'add', '/flink/project/add', 'flink/project/Add', 'project:create', '', '0', 0, null, now(), now());
insert into "public"."t_menu" values (100018, 100015, 'detail app', '/flink/app/detail', 'flink/app/Detail', 'app:detail', '', '0', 0, null, now(), now());
---insert into "public"."t_menu" values (100019, 100013, 'Notebook', '/flink/notebook/view', 'flink/notebook/Submit', 'notebook:submit', 'read', '0', 1, 4, now(), now());
+-- insert into "public"."t_menu" values (100019, 100013, 'Notebook', '/flink/notebook/view', 'flink/notebook/Submit', 'notebook:submit', 'read', '0', 1, 4, now(), now());
insert into "public"."t_menu" values (100020, 100015, 'edit flink', '/flink/app/edit_flink', 'flink/app/EditFlink', 'app:update', '', '0', 0, null, now(), now());
insert into "public"."t_menu" values (100021, 100015, 'edit streampark', '/flink/app/edit_streampark', 'flink/app/EditStreamPark', 'app:update', '', '0', 0, null, now(), now());
insert into "public"."t_menu" values (100022, 100014, 'build', null, null, 'project:build', null, '1', 1, null, now(), now());
@@ -128,7 +128,7 @@ insert into "public"."t_role_menu" values (100041, 100001, 100014);
insert into "public"."t_role_menu" values (100042, 100001, 100016);
insert into "public"."t_role_menu" values (100043, 100001, 100017);
insert into "public"."t_role_menu" values (100044, 100001, 100018);
---insert into "public"."t_role_menu" values (100045, 100001, 100019);
+-- insert into "public"."t_role_menu" values (100045, 100001, 100019);
insert into "public"."t_role_menu" values (100046, 100001, 100020);
insert into "public"."t_role_menu" values (100047, 100001, 100021);
insert into "public"."t_role_menu" values (100048, 100001, 100022);
@@ -147,7 +147,7 @@ insert into "public"."t_role_menu" values (100060, 100002, 100014);
insert into "public"."t_role_menu" values (100061, 100002, 100016);
insert into "public"."t_role_menu" values (100062, 100002, 100017);
insert into "public"."t_role_menu" values (100063, 100002, 100018);
---insert into "public"."t_role_menu" values (100064, 100002, 100019);
+-- insert into "public"."t_role_menu" values (100064, 100002, 100019);
insert into "public"."t_role_menu" values (100065, 100002, 100020);
insert into "public"."t_role_menu" values (100066, 100002, 100021);
insert into "public"."t_role_menu" values (100067, 100002, 100022);
diff --git a/streampark-console/streampark-console-service/src/main/resources/db/data-h2.sql b/streampark-console/streampark-console-service/src/main/resources/db/data-h2.sql
index 51856aaee..4cad11b90 100644
--- a/streampark-console/streampark-console-service/src/main/resources/db/data-h2.sql
+++ b/streampark-console/streampark-console-service/src/main/resources/db/data-h2.sql
@@ -62,7 +62,7 @@ insert into `t_menu` values (100015, 100013, 'menu.application', '/flink/app', '
insert into `t_menu` values (100016, 100015, 'add', '/flink/app/add', 'flink/app/Add', 'app:create', '', '0', 0, null, now(), now());
insert into `t_menu` values (100017, 100014, 'add', '/flink/project/add', 'flink/project/Add', 'project:create', '', '0', 0, null, now(), now());
insert into `t_menu` values (100018, 100015, 'detail app', '/flink/app/detail', 'flink/app/Detail', 'app:detail', '', '0', 0, null, now(), now());
---insert into `t_menu` values (100019, 100013, 'Notebook', '/flink/notebook/view', 'flink/notebook/Submit', 'notebook:submit', 'read', '0', 1, 4, now(), now());
+-- insert into `t_menu` values (100019, 100013, 'Notebook', '/flink/notebook/view', 'flink/notebook/Submit', 'notebook:submit', 'read', '0', 1, 4, now(), now());
insert into `t_menu` values (100020, 100015, 'edit flink', '/flink/app/edit_flink', 'flink/app/EditFlink', 'app:update', '', '0', 0, null, now(), now());
insert into `t_menu` values (100021, 100015, 'edit streampark', '/flink/app/edit_streampark', 'flink/app/EditStreamPark', 'app:update', '', '0', 0, null, now(), now());
insert into `t_menu` values (100022, 100014, 'build', null, null, 'project:build', null, '1', 1, null, now(), now());
@@ -127,7 +127,7 @@ insert into `t_role_menu` values (100041, 100001, 100014);
insert into `t_role_menu` values (100042, 100001, 100016);
insert into `t_role_menu` values (100043, 100001, 100017);
insert into `t_role_menu` values (100044, 100001, 100018);
---insert into `t_role_menu` values (100045, 100001, 100019);
+-- insert into `t_role_menu` values (100045, 100001, 100019);
insert into `t_role_menu` values (100046, 100001, 100020);
insert into `t_role_menu` values (100047, 100001, 100021);
insert into `t_role_menu` values (100048, 100001, 100022);
@@ -146,7 +146,7 @@ insert into `t_role_menu` values (100060, 100002, 100014);
insert into `t_role_menu` values (100061, 100002, 100016);
insert into `t_role_menu` values (100062, 100002, 100017);
insert into `t_role_menu` values (100063, 100002, 100018);
---insert into `t_role_menu` values (100064, 100002, 100019);
+-- insert into `t_role_menu` values (100064, 100002, 100019);
insert into `t_role_menu` values (100065, 100002, 100020);
insert into `t_role_menu` values (100066, 100002, 100021);
insert into `t_role_menu` values (100067, 100002, 100022);