{"action":"created","issue":{"url":"https://api.github.com/repos/piwik/piwik/issues/8584","labels_url":"https://api.github.com/repos/piwik/piwik/issues/8584/labels{/name}","comments_url":"https://api.github.com/repos/piwik/piwik/issues/8584/comments","events_url":"https://api.github.com/repos/piwik/piwik/issues/8584/events","html_url":"https://github.com/piwik/piwik/pull/8584","id":101315551,"number":8584,"title":"ensure case insensitivity of the the Page URL segment type","user":{"login":"halabuda","id":6530489,"avatar_url":"https://avatars.githubusercontent.com/u/6530489?v=3","gravatar_id":"","url":"https://api.github.com/users/halabuda","html_url":"https://github.com/halabuda","followers_url":"https://api.github.com/users/halabuda/followers","following_url":"https://api.github.com/users/halabuda/following{/other_user}","gists_url":"https://api.github.com/users/halabuda/gists{/gist_id}","starred_url":"https://api.github.com/users/halabuda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/halabuda/subscriptions","organizations_url":"https://api.github.com/users/halabuda/orgs","repos_url":"https://api.github.com/users/halabuda/repos","events_url":"https://api.github.com/users/halabuda/events{/privacy}","received_events_url":"https://api.github.com/users/halabuda/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-08-17T01:05:22Z","updated_at":"2015-08-18T07:43:27Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/piwik/piwik/pulls/8584","html_url":"https://github.com/piwik/piwik/pull/8584","diff_url":"https://github.com/piwik/piwik/pull/8584.diff","patch_url":"https://github.com/piwik/piwik/pull/8584.patch"},"body":"hello hello! the case sensitivity of the the Page URL segment type was not an issue with the field itself, which actually is of type utf8_general_ci, but rather with the CRC32 hashing of the field. upper/lower case variations of the same fundamental URL will produce unique hashes. this is a simple conditional fix to ignore the hash field when retrieving records for the Page URL segment type."},"comment":{"url":"https://api.github.com/repos/piwik/piwik/issues/comments/132108351","html_url":"https://github.com/piwik/piwik/pull/8584#issuecomment-132108351","issue_url":"https://api.github.com/repos/piwik/piwik/issues/8584","id":132108351,"user":{"login":"tsteur","id":273120,"avatar_url":"https://avatars.githubusercontent.com/u/273120?v=3","gravatar_id":"","url":"https://api.github.com/users/tsteur","html_url":"https://github.com/tsteur","followers_url":"https://api.github.com/users/tsteur/followers","following_url":"https://api.github.com/users/tsteur/following{/other_user}","gists_url":"https://api.github.com/users/tsteur/gists{/gist_id}","starred_url":"https://api.github.com/users/tsteur/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tsteur/subscriptions","organizations_url":"https://api.github.com/users/tsteur/orgs","repos_url":"https://api.github.com/users/tsteur/repos","events_url":"https://api.github.com/users/tsteur/events{/privacy}","received_events_url":"https://api.github.com/users/tsteur/received_events","type":"User","site_admin":false},"created_at":"2015-08-18T07:43:27Z","updated_at":"2015-08-18T07:43:27Z","body":"It would be nice if we did not have to create the hash based on lowercase as there will be no way back. I mean once we change the URL to lowercase we won't be possible to get the originally used URL at some point. Eg in the UI we would display the URL lowercase as well but this might not be what everyone wants. \r\n\r\nAlso I think we would possibly create many duplicated actions and would have to modify some reports maybe to merge duplicated urls to one url. Otherwise in the report there might appear eg a `/Test` and a `/test` when requesting eg week, month, year, range and on the day of the update. \r\n\r\nAlso not sure how this would affect `label` feature etc. Would be nice to find a solution that only modifies the segment query but that's probably not possible. Not sure how to fix"}}