You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@eagle.apache.org by "Michael Wu (JIRA)" <ji...@apache.org> on 2016/05/27 06:43:13 UTC
[jira] [Created] (EAGLE-318) db entity column name "user" happens
to be a reserved keyword of derby DB
Michael Wu created EAGLE-318:
--------------------------------
Summary: db entity column name "user" happens to be a reserved keyword of derby DB
Key: EAGLE-318
URL: https://issues.apache.org/jira/browse/EAGLE-318
Project: Eagle
Issue Type: Bug
Reporter: Michael Wu
Assignee: Hao Chen
Priority: Minor
Phenomenon: when derby DB is configured for eagle service, table "mlmodel_mlmodel" is not created successfully because one of its columns "user" happens to be a reserved keyword of derby DB.
Action required: need to re-name the column with other word than "user", and modify relevant code if necessary.
DB logs for reference:
*****************************
2016-05-27 06:26:29,215 DEBUG [http-bio-9099-exec-9] derby.DerbyPlatform[305]: About to execute SQL -- -----------------------------------------------------------------------
-- mlmodel_mlmodel
-- -----------------------------------------------------------------------
CREATE TABLE mlmodel_mlmodel
(
uuid VARCHAR(254) NOT NULL,
timestamp BIGINT,
site VARCHAR(8192),
user VARCHAR(8192),
algorithm VARCHAR(8192),
content LONG VARCHAR,
version BIGINT,
PRIMARY KEY (uuid)
)
2016-05-27 06:26:29,236 WARN [http-bio-9099-exec-9] derby.DerbyPlatform[322]: SQL Command -- -----------------------------------------------------------------------
-- mlmodel_mlmodel
-- -----------------------------------------------------------------------
CREATE TABLE mlmodel_mlmodel
(
uuid VARCHAR(254) NOT NULL,
timestamp BIGINT,
site VARCHAR(8192),
user VARCHAR(8192),
algorithm VARCHAR(8192),
content LONG VARCHAR,
version BIGINT,
PRIMARY KEY (uuid)
) failed with: Syntax error: Encountered "user" at line 10, column 5.
2016-05-27 06:26:29,237 DEBUG [http-bio-9099-exec-9] derby.DerbyPlatform[325]: java.sql.SQLSyntaxErrorException: Syntax error: Encountered "user" at line 10, column 5.
*****************************
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)