a summary row does not have a subtable, so we can simply get the rows without summary row and avoid creating many new arrays

Shorten unit test names as fixture file has too long filename on some version of linux

Rename test_AttributeHistoricalDataWithLocationsTest_testExecute_ShouldReturnLogAfterWorkingWithSomeData_IfThereAreData__UserCountry.getCity_month.xml to test_AttributeHistoricalDataWithLocationsTest_testExecute_ShouldReturnLogAfterWorkingWithSomeData__UserCountry.getCity_month.xml

Rename test_AttributeHistoricalDataWithLocationsTest_testExecute_ShouldReturnLogAfterWorkingWithSomeData_IfThereAreData__UserCountry.getContinent_month.xml to test_AttributeHistoricalDataWithLocationsTest_testExecute_ShouldReturnLogAfterWorkingWithSomeData__UserCountry.getContinent_month.xml

Rename test_AttributeHistoricalDataWithLocationsTest_testExecute_ShouldReturnLogAfterWorkingWithSomeData_IfThereAreData__UserCountry.getCountry_month.xml to test_AttributeHistoricalDataWithLocationsTest_testExecute_ShouldReturnLogAfterWorkingWithSomeData__UserCountry.getCountry_month.xml

Rename test_AttributeHistoricalDataWithLocationsTest_testExecute_ShouldReturnLogAfterWorkingWithSomeData_IfThereAreData__UserCountry.getRegion_month.xml to test_AttributeHistoricalDataWithLocationsTest_testExecute_ShouldReturnLogAfterWorkingWithSomeData__UserCountry.getRegion_month.xml

error: cannot stat 'plugins/UserCountry/tests/System/expected/test_AttributeHistoricalDataWithLocationsTest_testExecute_ShouldReturnLogAfterWorkingWithSomeData_IfThereAreData__UserCountry.getContinent_month.xml': File name too long
error: cannot stat 'plugins/UserCountry/tests/System/expected/test_AttributeHistoricalDataWithLocationsTest_testExecute_ShouldReturnLogAfterWorkingWithSomeData_IfThereAreData__UserCountry.getCountry_month.xml': File name too long
error: cannot stat 'plugins/UserCountry/tests/System/expected/test_AttributeHistoricalDataWithLocationsTest_testExecute_ShouldReturnLogAfterWorkingWithSomeData_IfThereAreData__UserCountry.getRegion_month.xml': File name too long
error: The following untracked working tree files would be overwritten by merge:

Various performance improvements and bugfixes.

Fixes #7462, optimize InnoDB tables if MariaDB v10.1.1 or greater is used.

Imporves performance for Archiving and Range dates. Makes all kind of
reports faster as well. Fixed bugs in labelFilter, reports total calculation
and more.

Adding command to attribute or re-attribute existing visits w/ geolocated location info. Includes small refactor to location dimensions and new UserCountry service, VisitorGeolocator. Also includes new DAO class in Piwik core.

Adding diagnostics for location provider selection (so users will be made aware of configuration issues), move all verbose logging to VisitorGeolocator, change some arguments to options, add --force option to force even if location provider is not working.

Fixes #7163, removing misc/log-analytics directory and replace w/ submodule.

PEAR is installed through Composer with the latest version of piwik/decompress anyway. I've removed it from the libs folder after comparing the files. `is_a()` is not deprecated anymore, and I couldn't find any usage of the modified methods `raiseError()` and `isError()` in HTML_Quickform.

I had to require pear/pear-core-minimal on top of pear/pear_exception because there is no transitive dependency. I have opened https://github.com/pear/PEAR_Exception/issues/8

Fix Sort filters are sometimes applied multiple times

Fixes #7276 display update progress in core:archive command. Includes Updater refactor: deprecate static methods in Updates in favor of instance methods that are passed an Updater instance, use instance methods in Updater, move methods in CoreUpdater that perform updates to Updater class, add observer class that can be used within Updater to hook into single updater run.

Conflicts:
	CHANGELOG.md

Dependency injection in API classes

Conflicts:
	plugins/CoreUpdater/Commands/Update.php

A new minified piwik.js should not be needed as it is only jsdoc

Correct floating point comparison for latitude/longitude in VisitorGeolocator when determining visit fields to update.

Make sure core:update fails if an Updates class executes queries manually by catching them and re-throwing them.