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)
