This is an automated email from the ASF dual-hosted git repository.

smolnar pushed a commit to branch trunk
in repository https://gitbox.apache.org/repos/asf/ambari.git


The following commit(s) were added to refs/heads/trunk by this push:
     new 8c0452e  AMBARI-24054. Making queries against 
kerberos_principal.principal_name and kerberos_keytab_principal.principal name 
case sensitive in MySQL/MariaDB (#1490)
8c0452e is described below

commit 8c0452e100c2d5eea043bf9afdecb7693722c3df
Author: Sandor Molnar <smol...@apache.org>
AuthorDate: Thu Jun 7 23:16:32 2018 +0200

    AMBARI-24054. Making queries against kerberos_principal.principal_name and 
kerberos_keytab_principal.principal name case sensitive in MySQL/MariaDB (#1490)
---
 ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql 
b/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql
index af64142..e028957 100644
--- a/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql
+++ b/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql
@@ -969,7 +969,7 @@ ALTER TABLE clusters ADD CONSTRAINT FK_clusters_upgrade_id 
FOREIGN KEY (upgrade_
 
 -- Kerberos
 CREATE TABLE kerberos_principal (
-  principal_name VARCHAR(255) NOT NULL,
+  principal_name VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   is_service SMALLINT NOT NULL DEFAULT 1,
   cached_keytab_path VARCHAR(255),
   CONSTRAINT PK_kerberos_principal PRIMARY KEY (principal_name)
@@ -989,7 +989,7 @@ CREATE TABLE kerberos_keytab (
 CREATE TABLE kerberos_keytab_principal (
   kkp_id BIGINT NOT NULL DEFAULT 0,
   keytab_path VARCHAR(255) NOT NULL,
-  principal_name VARCHAR(255) NOT NULL,
+  principal_name VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   host_id BIGINT,
   is_distributed SMALLINT NOT NULL DEFAULT 0,
   CONSTRAINT PK_kkp PRIMARY KEY (kkp_id),

-- 
To stop receiving notification emails like this one, please contact
smol...@apache.org.

Reply via email to