Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem with Bangladesh, country id 17 #5

Open
abedeenpro opened this issue Jan 7, 2018 · 2 comments
Open

Problem with Bangladesh, country id 17 #5

abedeenpro opened this issue Jan 7, 2018 · 2 comments

Comments

@abedeenpro
Copy link

I found two problems.
1. SELECT * FROM regions WHERE regions.country_id=17
image
Bangladesh has 7 Division, though soon it may be 8. But U seen first row Name is empty.

2. SELECT *FROM cities INNER JOIN regions ON cities.region_id = regions.id WHERE cities.name = 'Dumuria'
image
City Dumuria has repeated 3 times. Though there is only one Dumuria, it is in Khulna. And same problem, One region name missed. Tough Dumuria is not city but it can be considered.

I have not checked any other.

@vodnicearv
Copy link

vodnicearv commented Apr 4, 2018

and for Moldova, Republic of, same problems

@Warafux
Copy link

Warafux commented Nov 7, 2018

If you search for this pattern:
\((\d+\, \'\')\, \'.+'\, .+\)\,
You will find 502 occurrences matching the pattern:
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants