First asksql bug:
From shell:
mysql> select a.cur_id,b.cur_id from cur as a, cur as b limit 5 -> ; +--------+--------+ | cur_id | cur_id | +--------+--------+ | 1 | 1 | | 2 | 1 | | 3 | 1 | | 4 | 1 | | 5 | 1 | +--------+--------+ 5 rows in set (0.02 sec)
From asksql:
cur_id cur_id
1 1 1 1 1 1 1 1 1 1
Now the problem: select a.cur_title,a.cur_id,b.cur_id from cur as a, cur as b where a.cur_namespace=0 and b.cur_namespace=0 and a.cur_title=b.cur_title and a.cur_id > b.cur_id;
That is - select all articles which have duplicated titles:
+------------------------------------------------+--------+--------+ | cur_title | cur_id | cur_id | +------------------------------------------------+--------+--------+ | 1936 | 8302 | 7278 | | 1937 | 8303 | 7279 | | 1941 | 8304 | 7282 | | 1949 | 8305 | 7291 | | 1961 | 8306 | 7304 | | 1978 | 8307 | 7320 | | 1996 | 8308 | 7336 | | Afganistan | 8309 | 155 | | Afryka | 8310 | 250 | | Alexander_Hamilton | 8311 | 135 | | Ameby | 8312 | 456 | | Ameryka_�aci�ska | 8313 | 187 | | Aminokwas | 8314 | 9 | | Anders_Angstrom | 8315 | 272 | | Anglia | 8316 | 388 | | Archeany | 8317 | 454 | | Bakterie | 8318 | 736 | | Beniamin_Franklin | 8319 | 543 | | Bia�ko | 8320 | 466 | | Bia�oru� | 8321 | 499 | | Bia�ystok | 8322 | 465 | | Biochemia | 8324 | 482 | | Biologia | 8325 | 470 | | Boles�aw_II_�mia�y | 8327 | 604 | | Boles�aw_I_Chrobry | 8328 | 531 | | Botanika | 8329 | 520 | | Celtowie | 8330 | 844 | | Chromosom | 8332 | 843 | | Cytoplazma | 8333 | 802 | | Czes�aw_Ta�ski | 8334 | 1060 | | Drezno | 8335 | 1235 | | Drzewo_Życia | 8336 | 1129 | | Edwin_Aldrin | 8337 | 1419 | | Egipt | 8338 | 1405 | | Erytrocyt | 8339 | 1442 | | Europa | 8340 | 1368 | | Francja | 8341 | 1539 | | Gen | 8342 | 1717 | | Genom | 8343 | 1719 | | Gwara | 8344 | 1813 | | I_Wojna_�wiatowa | 8345 | 2435 | | Intron | 8347 | 2311 | | Irlandia | 8348 | 2319 | | Izrael | 8349 | 2323 | | Jaros�aw | 8351 | 2472 | | Jezioro_Żarnowieckie | 8352 | 2731 | | Joannici | 8353 | 2638 | | John_Kennedy | 8354 | 2527 | | K2 | 8355 | 3083 | | Kana�_Panamski | 8356 | 3197 | | Karol_Darwin | 8357 | 2846 | | Kazimierz_III_Wielki | 8358 | 3245 | | Komórka | 8359 | 2839 | | Kongres_Wiede�ski | 8360 | 2974 | | Konstytucja_3_Maja | 8361 | 3056 | | Kraków | 8363 | 2968 | | Litwa | 8364 | 3296 | | Ludwik_Zamenhof | 8365 | 3347 | | Marek_Kota�ski | 8366 | 3812 | | Miasto | 8368 | 3721 | | Michael_Faraday | 8369 | 3787 | | Miko�aj_Kopernik | 8370 | 3813 | | Mit | 8371 | 3728 | | Mitochondrium | 8372 | 3599 | | Mors | 8373 | 3575 | | My_Pierwsza_Brygada | 8374 | 3827 | | NATO | 8375 | 4060 | | Neil_Armstrong | 8376 | 4113 | | Niemcy | 8377 | 4027 | | Nizina_Podlaska | 8378 | 4107 | | Organellum | 8379 | 4227 | | Owady | 8380 | 4415 | | Palestyna | 8381 | 4558 | | Peklenc | 8382 | 4811 | | Politechnika_Warszawska | 8383 | 4524 | | Polska | 8384 | 4455 | | Polskie_Transatlantyckie_Towarzystwo_Okr�towe | 8385 | 4980 | | Prawos�awie | 8386 | 4695 | | Przemys� | 8387 | 4706 | | Puszcza_Knyszy�ska | 8388 | 4825 | | Rodezja_Po�udniowa | 8389 | 5366 | | Rosja | 8390 | 5170 | | Rozmnażanie | 8391 | 5241 | | Ro�iny | 8392 | 5417 | | Rybosom | 8393 | 5173 | | Rybozym | 8394 | 5186 | | Ssaki | 8397 | 5670 | | Stanis�aw_August_Poniatowski | 8398 | 5788 | | Stanis�aw_Kasznica | 8399 | 5949 | | Stawonogi | 8400 | 5545 | | Systematyka | 8402 | 5535 | | Szimon_Peres | 8403 | 5993 | | S�owianie | 8404 | 5777 | | Tatry_Niżne | 8405 | 6132 | | Tkanka | 8406 | 6356 | | Uk�ad_SI | 8407 | 6424 | | Uk�ad_Warszawski | 8409 | 6446 | | Uniwersytet_Jagiello�ski | 8410 | 6482 | | Uniwersytet_Wroc�awski | 8411 | 6458 | | Vision | 8412 | 6543 | | Volkssturm | 8413 | 6518 | | Wielkie_Ksi�stwo_Litewskie | 8414 | 7000 | | Wilno | 8416 | 6733 | | Wirusy | 8417 | 6705 | | Wroc�aw | 8418 | 6755 | | Wszech�iat | 8419 | 6798 | | W�adys�aw_II_Jagie��o | 8420 | 6888 | | W�ochy | 8421 | 6648 | | ZSRR | 8422 | 7106 | | Zwierz�ta | 8423 | 7082 | | Zygmunt_I_Stary | 8424 | 7146 | | �limaki | 8425 | 7362 | | �l�sk | 8426 | 8292 | | Meksyk | 9574 | 8367 | +------------------------------------------------+--------+--------+ 114 rows in set (1.27 sec)
Why is it so ?