Open brentgriffin opened 8 years ago
Issue by wezell Thursday Mar 03, 2016 at 21:48 GMT Originally opened as https://github.com/dotCMS/core/issues/8711
postgres and oracle have 500 chars for permission.permission_type
Postgres and Oracle: https://github.com/dotCMS/core/blob/master-3.5/src-conf/oracle.sql#L1590 https://github.com/dotCMS/core/blob/master-3.5/src-conf/postgres.sql#L1527
Mysql and MSSQL have 100 https://github.com/dotCMS/core/blob/master-3.5/src-conf/mysql.sql#L1532 https://github.com/dotCMS/core/blob/master-3.5/src-conf/mssql.sql#L1758
We need to change the sql files to all have varchar(100) and have a startup task that will alter the postgres and oracle tables
Also, I think we need to make sure we have working indices on both
permission.permission_type and permission_references.permission_type
We need to make sure that these indices are getting picked up by the query planners
postgres and oracle have 500 chars for permission.permission_type
Postgres and Oracle: https://github.com/dotCMS/core/blob/master-3.5/src-conf/oracle.sql#L1590 https://github.com/dotCMS/core/blob/master-3.5/src-conf/postgres.sql#L1527
Mysql and MSSQL have 100 https://github.com/dotCMS/core/blob/master-3.5/src-conf/mysql.sql#L1532 https://github.com/dotCMS/core/blob/master-3.5/src-conf/mssql.sql#L1758
We need to change the sql files to all have varchar(100) and have a startup task that will alter the postgres and oracle tables
Also, I think we need to make sure we have working indices on both
permission.permission_type and permission_references.permission_type
We need to make sure that these indices are getting picked up by the query planners