Na Li created SENTRY-1894:
-----------------------------
Summary: Update field size in package.jdo for dataNucleus to match
size in sql
Key: SENTRY-1894
URL: https://issues.apache.org/jira/browse/SENTRY-1894
Project: Sentry
Issue Type: Bug
Components: Sentry
Affects Versions: 2.0.0
Reporter: Na Li
Assignee: Na Li
The unique index
(`SERVER_NAME`,`DB_NAME`,`TABLE_NAME`,`COLUMN_NAME`,`URI`,`ACTION`,`WITH_GRANT_OPTION`)"
in `SENTRY_DB_PRIVILEGE` at package.jdo file is too large. When running
datanucleus schema tool, it complains
"com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was
too long; max key length is 767 bytes"
The size of the fields `SERVER_NAME`,`DB_NAME`,`TABLE_NAME`,`COLUMN_NAME` are
4000, but the corresponding size in sql is only 128.
We should match the size defined in package.jdo to what's in sql script, and
remove `URI` from being part of the unique id. After those change, the
datanucleus schema tool finishes successfully with command "mvn
datanucleus:schema-create -X -e"
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
