Bug #112292 Typo spotted

• Submitted: 7 Sep 2023 12:37
• Modified: 11 Sep 2023 22:06
• Reporter: Alex -----
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: all
• OS: Any
• CPU Architecture: Any
• Tags: world-db.zip

[7 Sep 2023 12:37] Alex -----

Description:
1.
Please change in world.sql next lines

INSERT INTO `city` VALUES (144,'Baku','AZE','Baki',1787800);
INSERT INTO `city` VALUES (145,'Gäncä','AZE','Gäncä',299300);
INSERT INTO `city` VALUES (146,'Sumqayit','AZE','Sumqayit',283000);
INSERT INTO `city` VALUES (147,'Mingäçevir','AZE','Mingäçevir',93900);

INSERT INTO `country` VALUES ('AZE','Azerbaijan','Asia','Middle East',86600.00,1991,7734000,62.9,4127.00,4100.00,'Azärbaycan','Federal Republic','Heydär Äliyev',144,'AZ');

to

INSERT INTO `city` VALUES (144,'Bakı','AZE','Bakı',1787800);
INSERT INTO `city` VALUES (145,'Gəncə','AZE','Gəncə',299300);
INSERT INTO `city` VALUES (146,'Sumqayıt','AZE','Sumqayıt',283000);
INSERT INTO `city` VALUES (147,'Mingəçevir','AZE','Mingəçevir',93900);

INSERT INTO `country` VALUES ('AZE','Azerbaijan','Asia','Middle East',86600.00,1991,7734000,62.9,4127.00,4100.00,'Azərbaycan','Republic','İlham Əliyev',144,'AZ');

2.
Remove next line
INSERT INTO `countrylanguage` VALUES ('AZE','Armenian','F',2.0);

How to repeat:
please fix typo

Suggested fix:
please fix typo

[7 Sep 2023 12:55] MySQL Verification Team

Thank you for the report and feedback.

[11 Sep 2023 18:05] Philip Olson

Posted by developer:
 
Thank you for the bug report, this is fixed in the source. I did not implement point #2 as wikipedia still references it as such.