From 28020fae2eebfc83e5050b5d167307c10cc23bcb Mon Sep 17 00:00:00 2001 From: =?utf8?q?Radek=20=C5=A0iman?= Date: Thu, 8 Mar 2018 22:28:37 +0100 Subject: [PATCH] Bug 20245: Wrong language code for Slovak This patch updates iso639_2_code value for Slovak language Test plan: 1) Obtain a biblio record having 'slo' value in its language code (marc field 041a) 2) Try to find it through Advanced search + more options with language set to Slovak 3) Nothing is found 4) Apply this patch 5) Repeat steps 1 and 2 6) Record is found now Signed-off-by: Mark Tompsett Signed-off-by: Marcel de Rooy Signed-off-by: Jonathan Druart --- .../data/mysql/atomicupdate/bug_20245-update_slovak-language-code.sql | 1 + installer/data/mysql/mandatory/subtag_registry.sql | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_20245-update_slovak-language-code.sql diff --git a/installer/data/mysql/atomicupdate/bug_20245-update_slovak-language-code.sql b/installer/data/mysql/atomicupdate/bug_20245-update_slovak-language-code.sql new file mode 100644 index 0000000000..871f5f0866 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_20245-update_slovak-language-code.sql @@ -0,0 +1 @@ +UPDATE language_rfc4646_to_iso639 SET iso639_2_code = 'slo' WHERE iso639_2_code = 'slk' AND rfc4646_subtag = 'sk'; diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql index ebcdedcc29..87858d78dd 100755 --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ b/installer/data/mysql/mandatory/subtag_registry.sql @@ -922,7 +922,7 @@ INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'sk', 'language', 'Slovak','2014-10-30'); INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES ( 'sk','slk'); +VALUES ( 'sk','slo'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'sk', 'language', 'sk', 'Slovenčina'); -- 2.11.4.GIT