Post-review fixes.

1 files changed, 232 insertions, 242 deletions

diff --git a/mysql-test/r/index_intersect.result b/mysql-test/r/index_intersect.result
index fdb4885e071..9a968468757 100644
--- a/mysql-test/r/index_intersect.result
+++ b/mysql-test/r/index_intersect.result
@@ -83,98 +83,168 @@ id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 SELECT * FROM City USE INDEX ()
 WHERE Name LIKE 'C%' AND Population > 1000000;
 ID	Name	Country	Population
-71	Córdoba	ARG	1157507
-151	Chittagong	BGD	1392860
-212	Curitiba	BRA	1584232
-608	Cairo	EGY	6789479
-712	Cape Town	ZAF	2352121
-926	Conakry	GIN	1090610
 1026	Calcutta [Kolkata]	IND	4399819
 1027	Chennai (Madras)	IND	3841396
+151	Chittagong	BGD	1392860
 1892	Chongqing	CHN	6351600
 1898	Chengdu	CHN	3361500
 1900	Changchun	CHN	2812000
 1910	Changsha	CHN	1809800
+212	Curitiba	BRA	1584232
 2258	Cali	COL	2077386
 2485	Casablanca	MAR	2940623
 2515	Ciudad de México	MEX	8591309
 3539	Caracas	VEN	1975294
 3795	Chicago	USA	2896016
-SELECT * FROM City
-WHERE Name LIKE 'C%' AND Population > 1000000;
-ID	Name	Country	Population
-71	Córdoba	ARG	1157507
-151	Chittagong	BGD	1392860
-212	Curitiba	BRA	1584232
 608	Cairo	EGY	6789479
+71	Córdoba	ARG	1157507
 712	Cape Town	ZAF	2352121
 926	Conakry	GIN	1090610
+SELECT * FROM City
+WHERE Name LIKE 'C%' AND Population > 1000000;
+ID	Name	Country	Population
 1026	Calcutta [Kolkata]	IND	4399819
 1027	Chennai (Madras)	IND	3841396
+151	Chittagong	BGD	1392860
 1892	Chongqing	CHN	6351600
 1898	Chengdu	CHN	3361500
 1900	Changchun	CHN	2812000
 1910	Changsha	CHN	1809800
+212	Curitiba	BRA	1584232
 2258	Cali	COL	2077386
 2485	Casablanca	MAR	2940623
 2515	Ciudad de México	MEX	8591309
 3539	Caracas	VEN	1975294
 3795	Chicago	USA	2896016
+608	Cairo	EGY	6789479
+71	Córdoba	ARG	1157507
+712	Cape Town	ZAF	2352121
+926	Conakry	GIN	1090610
 SELECT * FROM City USE INDEX ()
 WHERE Name LIKE 'M%' AND Population > 1500000;
 ID	Name	Country	Population
-131	Melbourne	AUS	2865329
-653	Madrid	ESP	2879052
-766	Manila	PHL	1581082
-942	Medan	IDN	1843919
 1024	Mumbai (Bombay)	IND	10500000
+131	Melbourne	AUS	2865329
 1381	Mashhad	IRN	1887405
 2259	Medellín	COL	1861265
 3520	Minsk	BLR	1674000
 3580	Moscow	RUS	8389200
-SELECT * FROM City 
-WHERE Name LIKE 'M%' AND Population > 1500000;
-ID	Name	Country	Population
-131	Melbourne	AUS	2865329
 653	Madrid	ESP	2879052
 766	Manila	PHL	1581082
 942	Medan	IDN	1843919
+SELECT * FROM City 
+WHERE Name LIKE 'M%' AND Population > 1500000;
+ID	Name	Country	Population
 1024	Mumbai (Bombay)	IND	10500000
+131	Melbourne	AUS	2865329
 1381	Mashhad	IRN	1887405
 2259	Medellín	COL	1861265
 3520	Minsk	BLR	1674000
 3580	Moscow	RUS	8389200
+653	Madrid	ESP	2879052
+766	Manila	PHL	1581082
+942	Medan	IDN	1843919
 SELECT * FROM City USE INDEX ()
 WHERE Name LIKE 'M%' AND Population > 300000;
 ID	Name	Country	Population
-77	Mar del Plata	ARG	512880
-80	Merlo	ARG	463846
-83	Moreno	ARG	356993
-87	Morón	ARG	349246
+1024	Mumbai (Bombay)	IND	10500000
+1042	Madurai	IND	977856
+1051	Meerut	IND	753778
+1074	Mysore	IND	480692
+1081	Moradabad	IND	429214
+1098	Malegaon	IND	342595
 131	Melbourne	AUS	2865329
+1366	Mosul	IRQ	879000
+1381	Mashhad	IRN	1887405
+1465	Milano	ITA	1300977
+1559	Matsuyama	JPN	466133
+1560	Matsudo	JPN	461126
+1578	Machida	JPN	364197
+1595	Miyazaki	JPN	303784
+1810	Montréal	CAN	1016376
+1816	Mississauga	CAN	608072
+1882	Mombasa	KEN	461753
+1945	Mudanjiang	CHN	570000
+2005	Ma´anshan	CHN	305421
 215	Manaus	BRA	1255049
 223	Maceió	BRA	786288
+2259	Medellín	COL	1861265
+2267	Manizales	COL	337580
+2300	Mbuji-Mayi	COD	806475
+2348	Masan	KOR	441242
+2440	Monrovia	LBR	850000
+2454	Macao	MAC	437500
+2487	Marrakech	MAR	621914
+2491	Meknès	MAR	460000
 250	Mauá	BRA	375055
+2523	Monterrey	MEX	1108499
+2526	Mexicali	MEX	764902
+2530	Mérida	MEX	703324
+2537	Morelia	MEX	619958
+2554	Matamoros	MEX	416428
+2557	Mazatlán	MEX	380265
 256	Moji das Cruzes	BRA	339194
+2698	Maputo	MOZ	1018938
+2699	Matola	MOZ	424662
+2711	Mandalay	MMR	885300
+2712	Moulmein (Mawlamyine)	MMR	307900
+2734	Managua	NIC	959000
+2756	Mushin	NGA	333200
+2757	Maiduguri	NGA	320000
+2826	Multan	PAK	1182441
+2975	Marseille	FRA	798430
+3070	Munich [München]	DEU	1194560
+3086	Mannheim	DEU	307730
+3175	Mekka	SAU	965700
+3176	Medina	SAU	608300
+3214	Mogadishu	SOM	997000
+3364	Mersin (Içel)	TUR	587212
+3371	Malatya	TUR	330312
+3434	Mykolajiv	UKR	508000
+3435	Mariupol	UKR	490000
+3438	Makijivka	UKR	384000
+3492	Montevideo	URY	1236000
+3520	Minsk	BLR	1674000
+3522	Mogiljov	BLR	356000
+3540	Maracaíbo	VEN	1304776
+3545	Maracay	VEN	444443
+3547	Maturín	VEN	319726
+3580	Moscow	RUS	8389200
+3622	Magnitogorsk	RUS	427900
+3625	Murmansk	RUS	376300
+3636	Mahat?kala	RUS	332800
+3810	Memphis	USA	650100
+3811	Milwaukee	USA	596974
+3834	Mesa	USA	396375
+3837	Minneapolis	USA	382618
+3839	Miami	USA	362470
 462	Manchester	GBR	430000
 653	Madrid	ESP	2879052
 658	Málaga	ESP	530553
 661	Murcia	ESP	353504
 766	Manila	PHL	1581082
+77	Mar del Plata	ARG	512880
 778	Makati	PHL	444867
 781	Marikina	PHL	391170
 783	Muntinlupa	PHL	379310
 786	Malabon	PHL	338855
+80	Merlo	ARG	463846
+83	Moreno	ARG	356993
+87	Morón	ARG	349246
 942	Medan	IDN	1843919
 947	Malang	IDN	716862
 962	Manado	IDN	332288
 963	Mataram	IDN	306600
+SELECT * FROM City 
+WHERE Name LIKE 'M%' AND Population > 300000;
+ID	Name	Country	Population
 1024	Mumbai (Bombay)	IND	10500000
 1042	Madurai	IND	977856
 1051	Meerut	IND	753778
 1074	Mysore	IND	480692
 1081	Moradabad	IND	429214
 1098	Malegaon	IND	342595
+131	Melbourne	AUS	2865329
 1366	Mosul	IRQ	879000
 1381	Mashhad	IRN	1887405
 1465	Milano	ITA	1300977
@@ -187,6 +257,8 @@ ID	Name	Country	Population
 1882	Mombasa	KEN	461753
 1945	Mudanjiang	CHN	570000
 2005	Ma´anshan	CHN	305421
+215	Manaus	BRA	1255049
+223	Maceió	BRA	786288
 2259	Medellín	COL	1861265
 2267	Manizales	COL	337580
 2300	Mbuji-Mayi	COD	806475
@@ -195,12 +267,14 @@ ID	Name	Country	Population
 2454	Macao	MAC	437500
 2487	Marrakech	MAR	621914
 2491	Meknès	MAR	460000
+250	Mauá	BRA	375055
 2523	Monterrey	MEX	1108499
 2526	Mexicali	MEX	764902
 2530	Mérida	MEX	703324
 2537	Morelia	MEX	619958
 2554	Matamoros	MEX	416428
 2557	Mazatlán	MEX	380265
+256	Moji das Cruzes	BRA	339194
 2698	Maputo	MOZ	1018938
 2699	Matola	MOZ	424662
 2711	Mandalay	MMR	885300
@@ -235,97 +309,23 @@ ID	Name	Country	Population
 3834	Mesa	USA	396375
 3837	Minneapolis	USA	382618
 3839	Miami	USA	362470
-SELECT * FROM City 
-WHERE Name LIKE 'M%' AND Population > 300000;
-ID	Name	Country	Population
-2454	Macao	MAC	437500
-223	Maceió	BRA	786288
-1578	Machida	JPN	364197
+462	Manchester	GBR	430000
 653	Madrid	ESP	2879052
-1042	Madurai	IND	977856
-3622	Magnitogorsk	RUS	427900
-3636	Mahat?kala	RUS	332800
-2757	Maiduguri	NGA	320000
-778	Makati	PHL	444867
-3438	Makijivka	UKR	384000
-786	Malabon	PHL	338855
 658	Málaga	ESP	530553
-947	Malang	IDN	716862
-3371	Malatya	TUR	330312
-1098	Malegaon	IND	342595
-962	Manado	IDN	332288
-2734	Managua	NIC	959000
-215	Manaus	BRA	1255049
-462	Manchester	GBR	430000
-2711	Mandalay	MMR	885300
+661	Murcia	ESP	353504
 766	Manila	PHL	1581082
-2267	Manizales	COL	337580
-3086	Mannheim	DEU	307730
-2698	Maputo	MOZ	1018938
 77	Mar del Plata	ARG	512880
-3540	Maracaíbo	VEN	1304776
-3545	Maracay	VEN	444443
+778	Makati	PHL	444867
 781	Marikina	PHL	391170
-3435	Mariupol	UKR	490000
-2487	Marrakech	MAR	621914
-2975	Marseille	FRA	798430
-2348	Masan	KOR	441242
-1381	Mashhad	IRN	1887405
-2554	Matamoros	MEX	416428
-963	Mataram	IDN	306600
-2699	Matola	MOZ	424662
-1560	Matsudo	JPN	461126
-1559	Matsuyama	JPN	466133
-3547	Maturín	VEN	319726
-250	Mauá	BRA	375055
-2557	Mazatlán	MEX	380265
-2005	Ma´anshan	CHN	305421
-2300	Mbuji-Mayi	COD	806475
-942	Medan	IDN	1843919
-2259	Medellín	COL	1861265
-3176	Medina	SAU	608300
-1051	Meerut	IND	753778
-3175	Mekka	SAU	965700
-2491	Meknès	MAR	460000
-131	Melbourne	AUS	2865329
-3810	Memphis	USA	650100
-2530	Mérida	MEX	703324
+783	Muntinlupa	PHL	379310
+786	Malabon	PHL	338855
 80	Merlo	ARG	463846
-3364	Mersin (Içel)	TUR	587212
-3834	Mesa	USA	396375
-2526	Mexicali	MEX	764902
-3839	Miami	USA	362470
-1465	Milano	ITA	1300977
-3811	Milwaukee	USA	596974
-3837	Minneapolis	USA	382618
-3520	Minsk	BLR	1674000
-1816	Mississauga	CAN	608072
-1595	Miyazaki	JPN	303784
-3214	Mogadishu	SOM	997000
-3522	Mogiljov	BLR	356000
-256	Moji das Cruzes	BRA	339194
-1882	Mombasa	KEN	461753
-2440	Monrovia	LBR	850000
-2523	Monterrey	MEX	1108499
-3492	Montevideo	URY	1236000
-1810	Montréal	CAN	1016376
-1081	Moradabad	IND	429214
-2537	Morelia	MEX	619958
 83	Moreno	ARG	356993
 87	Morón	ARG	349246
-3580	Moscow	RUS	8389200
-1366	Mosul	IRQ	879000
-2712	Moulmein (Mawlamyine)	MMR	307900
-1945	Mudanjiang	CHN	570000
-2826	Multan	PAK	1182441
-1024	Mumbai (Bombay)	IND	10500000
-3070	Munich [München]	DEU	1194560
-783	Muntinlupa	PHL	379310
-661	Murcia	ESP	353504
-3625	Murmansk	RUS	376300
-2756	Mushin	NGA	333200
-3434	Mykolajiv	UKR	508000
-1074	Mysore	IND	480692
+942	Medan	IDN	1843919
+947	Malang	IDN	716862
+962	Manado	IDN	332288
+963	Mataram	IDN	306600
 SELECT * FROM City USE INDEX ()
 WHERE Name LIKE 'M%' AND Population > 5000000;
 ID	Name	Country	Population
@@ -486,30 +486,30 @@ SELECT * FROM City USE INDEX ()
 WHERE ID BETWEEN 1 AND 500 AND Population > 1000000 AND Country LIKE 'A%';
 ID	Name	Country	Population
 1	Kabul	AFG	1780000
-56	Luanda	AGO	2022000
-69	Buenos Aires	ARG	2982146
-70	La Matanza	ARG	1266461
-71	Córdoba	ARG	1157507
 126	Yerevan	ARM	1248700
 130	Sydney	AUS	3276207
 131	Melbourne	AUS	2865329
 132	Brisbane	AUS	1291117
 133	Perth	AUS	1096829
 144	Baku	AZE	1787800
-SELECT * FROM City
-WHERE ID BETWEEN 1 AND 500 AND Population > 1000000 AND Country LIKE 'A%';
-ID	Name	Country	Population
-1	Kabul	AFG	1780000
 56	Luanda	AGO	2022000
 69	Buenos Aires	ARG	2982146
 70	La Matanza	ARG	1266461
 71	Córdoba	ARG	1157507
+SELECT * FROM City
+WHERE ID BETWEEN 1 AND 500 AND Population > 1000000 AND Country LIKE 'A%';
+ID	Name	Country	Population
+1	Kabul	AFG	1780000
 126	Yerevan	ARM	1248700
 130	Sydney	AUS	3276207
 131	Melbourne	AUS	2865329
 132	Brisbane	AUS	1291117
 133	Perth	AUS	1096829
 144	Baku	AZE	1787800
+56	Luanda	AGO	2022000
+69	Buenos Aires	ARG	2982146
+70	La Matanza	ARG	1266461
+71	Córdoba	ARG	1157507
 SELECT * FROM City USE INDEX ()
 WHERE ID BETWEEN 2001 AND 2500 AND Population > 300000 AND Country LIKE 'L%';
 ID	Name	Country	Population
@@ -650,72 +650,72 @@ SELECT * FROM City
 WHERE ID BETWEEN 3001 AND 4000 AND Population > 600000
 AND Country BETWEEN 'S' AND 'Z' ;
 ID	Name	Country	Population
-3176	Medina	SAU	608300
-3363	Konya	TUR	628364
-3810	Memphis	USA	650100
-3809	Baltimore	USA	651154
-3808	Austin	USA	656562
-3543	Ciudad Guayana	VEN	663713
-3349	Tunis	TUN	690600
-3226	Sharq al-Nil	SDN	700887
-3433	Kryvyi Rig	UKR	703000
-3807	Columbus	USA	711470
-3266	Tainan	TWN	728060
-3806	Jacksonville	USA	735167
 3048	Stockholm	SWE	750348
-3805	San Francisco	USA	776733
-3771	Haiphong	VNM	783133
+3173	Riyadh	SAU	3324000
+3174	Jedda	SAU	2046300
+3175	Mekka	SAU	965700
+3176	Medina	SAU	608300
+3197	Pikine	SEN	855287
 3198	Dakar	SEN	785071
-3432	Lviv	UKR	788000
-3362	Gaziantep	TUR	789056
-3804	Indianapolis	USA	791926
-3542	Valencia	VEN	794246
-3431	Zaporizzja	UKR	848000
 3207	Freetown	SLE	850000
-3197	Pikine	SEN	855287
-3541	Barquisimeto	VEN	877239
-3425	Kampala	UGA	890800
-3803	San Jose	USA	894943
-3265	Taichung	TWN	940589
-3225	Khartum	SDN	947483
-3802	Detroit	USA	951270
-3175	Mekka	SAU	965700
+3208	Singapore	SGP	4017733
 3214	Mogadishu	SOM	997000
-3430	Odesa	UKR	1011000
-3429	Donetsk	UKR	1050000
-3361	Bursa	TUR	1095842
-3428	Dnipropetrovsk	UKR	1103000
-3360	Adana	TUR	1131198
-3801	San Antonio	USA	1144646
-3800	Dallas	USA	1188580
-3799	San Diego	USA	1223400
-3492	Montevideo	URY	1236000
-3251	Aleppo	SYR	1261983
 3224	Omdurman	SDN	1271403
-3540	Maracaíbo	VEN	1304776
-3798	Phoenix	USA	1321045
+3225	Khartum	SDN	947483
+3226	Sharq al-Nil	SDN	700887
 3250	Damascus	SYR	1347000
-3770	Hanoi	VNM	1410000
+3251	Aleppo	SYR	1261983
+3263	Taipei	TWN	2641312
 3264	Kaohsiung	TWN	1475505
-3427	Harkova [Harkiv]	UKR	1500000
-3797	Philadelphia	USA	1517550
+3265	Taichung	TWN	940589
+3266	Tainan	TWN	728060
 3305	Dar es Salaam	TZA	1747000
-3796	Houston	USA	1953631
-3539	Caracas	VEN	1975294
-3174	Jedda	SAU	2046300
-3503	Toskent	UZB	2117500
+3320	Bangkok	THA	6320174
+3349	Tunis	TUN	690600
+3357	Istanbul	TUR	8787958
+3358	Ankara	TUR	3038159
 3359	Izmir	TUR	2130359
+3360	Adana	TUR	1131198
+3361	Bursa	TUR	1095842
+3362	Gaziantep	TUR	789056
+3363	Konya	TUR	628364
+3425	Kampala	UGA	890800
 3426	Kyiv	UKR	2624000
-3263	Taipei	TWN	2641312
-3795	Chicago	USA	2896016
-3358	Ankara	TUR	3038159
-3173	Riyadh	SAU	3324000
-3794	Los Angeles	USA	3694820
+3427	Harkova [Harkiv]	UKR	1500000
+3428	Dnipropetrovsk	UKR	1103000
+3429	Donetsk	UKR	1050000
+3430	Odesa	UKR	1011000
+3431	Zaporizzja	UKR	848000
+3432	Lviv	UKR	788000
+3433	Kryvyi Rig	UKR	703000
+3492	Montevideo	URY	1236000
+3503	Toskent	UZB	2117500
+3539	Caracas	VEN	1975294
+3540	Maracaíbo	VEN	1304776
+3541	Barquisimeto	VEN	877239
+3542	Valencia	VEN	794246
+3543	Ciudad Guayana	VEN	663713
 3769	Ho Chi Minh City	VNM	3980000
-3208	Singapore	SGP	4017733
-3320	Bangkok	THA	6320174
+3770	Hanoi	VNM	1410000
+3771	Haiphong	VNM	783133
 3793	New York	USA	8008278
-3357	Istanbul	TUR	8787958
+3794	Los Angeles	USA	3694820
+3795	Chicago	USA	2896016
+3796	Houston	USA	1953631
+3797	Philadelphia	USA	1517550
+3798	Phoenix	USA	1321045
+3799	San Diego	USA	1223400
+3800	Dallas	USA	1188580
+3801	San Antonio	USA	1144646
+3802	Detroit	USA	951270
+3803	San Jose	USA	894943
+3804	Indianapolis	USA	791926
+3805	San Francisco	USA	776733
+3806	Jacksonville	USA	735167
+3807	Columbus	USA	711470
+3808	Austin	USA	656562
+3809	Baltimore	USA	651154
+3810	Memphis	USA	650100
 SET SESSION sort_buffer_size = 2048;
 EXPLAIN
 SELECT * FROM City WHERE
@@ -751,23 +751,23 @@ id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 SELECT * FROM City WHERE
 Name LIKE 'C%' AND Population > 1000000;
 ID	Name	Country	Population
-71	Córdoba	ARG	1157507
-151	Chittagong	BGD	1392860
-212	Curitiba	BRA	1584232
-608	Cairo	EGY	6789479
-712	Cape Town	ZAF	2352121
-926	Conakry	GIN	1090610
 1026	Calcutta [Kolkata]	IND	4399819
 1027	Chennai (Madras)	IND	3841396
+151	Chittagong	BGD	1392860
 1892	Chongqing	CHN	6351600
 1898	Chengdu	CHN	3361500
 1900	Changchun	CHN	2812000
 1910	Changsha	CHN	1809800
+212	Curitiba	BRA	1584232
 2258	Cali	COL	2077386
 2485	Casablanca	MAR	2940623
 2515	Ciudad de México	MEX	8591309
 3539	Caracas	VEN	1975294
 3795	Chicago	USA	2896016
+608	Cairo	EGY	6789479
+71	Córdoba	ARG	1157507
+712	Cape Town	ZAF	2352121
+926	Conakry	GIN	1090610
 SELECT * FROM City WHERE
 Name LIKE 'M%' AND Population > 1500000;
 ID	Name	Country	Population
@@ -814,72 +814,72 @@ SELECT * FROM City
 WHERE ID BETWEEN 3001 AND 4000 AND Population > 600000
 AND Country BETWEEN 'S' AND 'Z';
 ID	Name	Country	Population
-3176	Medina	SAU	608300
-3363	Konya	TUR	628364
-3810	Memphis	USA	650100
-3809	Baltimore	USA	651154
-3808	Austin	USA	656562
-3543	Ciudad Guayana	VEN	663713
-3349	Tunis	TUN	690600
-3226	Sharq al-Nil	SDN	700887
-3433	Kryvyi Rig	UKR	703000
-3807	Columbus	USA	711470
-3266	Tainan	TWN	728060
-3806	Jacksonville	USA	735167
 3048	Stockholm	SWE	750348
-3805	San Francisco	USA	776733
-3771	Haiphong	VNM	783133
+3173	Riyadh	SAU	3324000
+3174	Jedda	SAU	2046300
+3175	Mekka	SAU	965700
+3176	Medina	SAU	608300
+3197	Pikine	SEN	855287
 3198	Dakar	SEN	785071
-3432	Lviv	UKR	788000
-3362	Gaziantep	TUR	789056
-3804	Indianapolis	USA	791926
-3542	Valencia	VEN	794246
-3431	Zaporizzja	UKR	848000
 3207	Freetown	SLE	850000
-3197	Pikine	SEN	855287
-3541	Barquisimeto	VEN	877239
-3425	Kampala	UGA	890800
-3803	San Jose	USA	894943
-3265	Taichung	TWN	940589
-3225	Khartum	SDN	947483
-3802	Detroit	USA	951270
-3175	Mekka	SAU	965700
+3208	Singapore	SGP	4017733
 3214	Mogadishu	SOM	997000
-3430	Odesa	UKR	1011000
-3429	Donetsk	UKR	1050000
-3361	Bursa	TUR	1095842
-3428	Dnipropetrovsk	UKR	1103000
-3360	Adana	TUR	1131198
-3801	San Antonio	USA	1144646
-3800	Dallas	USA	1188580
-3799	San Diego	USA	1223400
-3492	Montevideo	URY	1236000
-3251	Aleppo	SYR	1261983
 3224	Omdurman	SDN	1271403
-3540	Maracaíbo	VEN	1304776
-3798	Phoenix	USA	1321045
+3225	Khartum	SDN	947483
+3226	Sharq al-Nil	SDN	700887
 3250	Damascus	SYR	1347000
-3770	Hanoi	VNM	1410000
+3251	Aleppo	SYR	1261983
+3263	Taipei	TWN	2641312
 3264	Kaohsiung	TWN	1475505
-3427	Harkova [Harkiv]	UKR	1500000
-3797	Philadelphia	USA	1517550
+3265	Taichung	TWN	940589
+3266	Tainan	TWN	728060
 3305	Dar es Salaam	TZA	1747000
-3796	Houston	USA	1953631
-3539	Caracas	VEN	1975294
-3174	Jedda	SAU	2046300
-3503	Toskent	UZB	2117500
+3320	Bangkok	THA	6320174
+3349	Tunis	TUN	690600
+3357	Istanbul	TUR	8787958
+3358	Ankara	TUR	3038159
 3359	Izmir	TUR	2130359
+3360	Adana	TUR	1131198
+3361	Bursa	TUR	1095842
+3362	Gaziantep	TUR	789056
+3363	Konya	TUR	628364
+3425	Kampala	UGA	890800
 3426	Kyiv	UKR	2624000
-3263	Taipei	TWN	2641312
-3795	Chicago	USA	2896016
-3358	Ankara	TUR	3038159
-3173	Riyadh	SAU	3324000
-3794	Los Angeles	USA	3694820
+3427	Harkova [Harkiv]	UKR	1500000
+3428	Dnipropetrovsk	UKR	1103000
+3429	Donetsk	UKR	1050000
+3430	Odesa	UKR	1011000
+3431	Zaporizzja	UKR	848000
+3432	Lviv	UKR	788000
+3433	Kryvyi Rig	UKR	703000
+3492	Montevideo	URY	1236000
+3503	Toskent	UZB	2117500
+3539	Caracas	VEN	1975294
+3540	Maracaíbo	VEN	1304776
+3541	Barquisimeto	VEN	877239
+3542	Valencia	VEN	794246
+3543	Ciudad Guayana	VEN	663713
 3769	Ho Chi Minh City	VNM	3980000
-3208	Singapore	SGP	4017733
-3320	Bangkok	THA	6320174
+3770	Hanoi	VNM	1410000
+3771	Haiphong	VNM	783133
 3793	New York	USA	8008278
-3357	Istanbul	TUR	8787958
+3794	Los Angeles	USA	3694820
+3795	Chicago	USA	2896016
+3796	Houston	USA	1953631
+3797	Philadelphia	USA	1517550
+3798	Phoenix	USA	1321045
+3799	San Diego	USA	1223400
+3800	Dallas	USA	1188580
+3801	San Antonio	USA	1144646
+3802	Detroit	USA	951270
+3803	San Jose	USA	894943
+3804	Indianapolis	USA	791926
+3805	San Francisco	USA	776733
+3806	Jacksonville	USA	735167
+3807	Columbus	USA	711470
+3808	Austin	USA	656562
+3809	Baltimore	USA	651154
+3810	Memphis	USA	650100
 SET SESSION sort_buffer_size = default;
 DROP INDEX Country ON City;
 CREATE INDEX CountryID ON City(Country,ID);
@@ -917,10 +917,10 @@ ID	Name	Country	Population
 2698	Maputo	MOZ	1018938
 2710	Rangoon (Yangon)	MMR	3361700
 SELECT * FROM City 
-WHERE Country LIKE 'M%' AND Population > 700000;
+WHERE Country LIKE 'M%' AND Population > 1000000;
 ID	Name	Country	Population
+2464	Kuala Lumpur	MYS	1297526
 2485	Casablanca	MAR	2940623
-2690	Chisinau	MDA	719900
 2515	Ciudad de México	MEX	8591309
 2516	Guadalajara	MEX	1647720
 2517	Ecatepec de Morelos	MEX	1620303
@@ -931,18 +931,8 @@ ID	Name	Country	Population
 2522	León	MEX	1133576
 2523	Monterrey	MEX	1108499
 2524	Zapopan	MEX	1002239
-2525	Naucalpan de Juárez	MEX	857511
-2526	Mexicali	MEX	764902
-2527	Culiacán	MEX	744859
-2528	Acapulco de Juárez	MEX	721011
-2529	Tlalnepantla de Baz	MEX	720755
-2530	Mérida	MEX	703324
-2482	Bamako	MLI	809552
-2710	Rangoon (Yangon)	MMR	3361700
-2711	Mandalay	MMR	885300
-2696	Ulan Bator	MNG	773700
 2698	Maputo	MOZ	1018938
-2464	Kuala Lumpur	MYS	1297526
+2710	Rangoon (Yangon)	MMR	3361700
 SELECT * FROM City USE INDEX ()
 WHERE Country='CHN' AND Population > 1500000;
 ID	Name	Country	Population