Avoid ansi output from log4j2 so that the environment variable NO_COLOR
behaves as expected.

- once related issue is fixed, please remove `.skip` part (unskip the test completely)
- make sure test is passing and
- merge it together with the fix

Note: although the related issue is also concerned with "Does not contain" filter, this test is testing only "Is not" for simplicity sake. 

Switching the automagic dashboard messaging from info to debug to reduce
logging - these log messages are multiple lines and detailed.

* Fixing of TIME breakouts in MySQL

Reworks :hour and :minute breakouts to function on MySQL 5.5+ and
MariaDB 10.2+

Older versions of MySQL and newer versions of MariaDB do not accept a
date of 0000-00-00, which date_format was generating. In the cases where
we're attempting to truncate the date and normalize them all to group by
hours or minutes, this will cast the TIME to DATETIME, which will make
it possible to convert it back to the proper type after truncation.

Adds an additional two test cases for grouping on a TIME column (both
:hour and :minute)

Resolves #12846

[ci mysql]

* Switch to hx/cast instead of a custom cast defn

[ci mysql]

Merge release 0.36.x into master 10-19-2020

[ci all]

Even though this Appender wasn't referenced anywhere, it still
initialized. Commented out this appender so it can be used as an
example, but it won't create a folder called ${logfile.path} now

Resolves #13422

* checkbox should define its own border radius

* update snapshot test

* Mark state fields by fingerprint fixes #2735 [ci drivers]

* fix tests for pg, ns sort, and docstring lint

* Expectations -> clojure.test

* minor alignment in test

* Allow fingerprint classifiers to override prev classifier special_type

if another classifier threw on a special type due to name or the
number of items in the collection, this should override it as it is
introspecting values.

States previously were marked ":type/State" based on the column
name. Now use a fingerprinter looking for state names. Owing to the
fact that there might be more things in the state column (US
territory, canadian states, Washington DC, etc) lowered the threshold
for recognizing a state column from 95% of values down to 70% of
values.

* Cleanup [ci drivers]

- remark about original field in metadata
- docstring on `can-edit-special-field?`
- cleanup and check for string in `state?`
- add tests that nils and other types don't break `state?`

* Include test file

Reduce maxWorkers count for jest, which should reduce how often we get
ENOMEM errors in the frontend tests

When your app db is H2, this test will fail with a NumberFormatException
trying to parse the "not-an-integer" but the MySQL JDBC driver does not
behave the same. It is sufficient to test exception conditions return a
{} query description only under the H2 app-db, since it's a catch-all
handler.

* Add repro for #13504 [ci skip]

* Add repro for #12568
* Fix outdated query (use `withSampleDataset()`)

Co-authored-by: Nemanja <31325167+nemanjaglumac@users.noreply.github.com>

* add type components

* [styleguide] - reflow layout to make browsing easier

* [styleguide] - default to open example code

* [styleguide] - separate out icons page for better nav control

* [styleguide] - make colors easier to work with in nav

* [styleguide] - simplify components app

* [styleguide] - leave note

* [styleguide] - remove color variant controls

* [styleguide] - move welcome to own page to clean up routes file

* [styleguide] - use typograpghy components in sidebar

* [styleguide] - extract props display into own component

* [styleguide] - use type components on welcome

* [styleguide] - extract example to own component, apply

* [styleguide] - remove old sourcepane

* [styleguide] - use type components on component page, misc cleanup

* [styleguide] - clean up sidebar padding

* [styleguide] - display props as table

* [styleguide] - tweak left nav a bit

* [styleguide] - begin to categorize components, list in nav

* [styleguide] - use link elements

* [styleguide] - add heading to icons page

* [styleguide] - add category to EntityMenu

* [styleguide] - add more categories and apply to info files

* [styleguide] - few more categories

* [styleguide] - fix typo on feedback category

* [styleguide] - add label type example

* [styleguide] - remove props table placeholder

* add basic UserAvatar example

* prettier

* Update frontend/src/metabase/internal/components/Layout.jsx

Co-authored-by: Paul Rosenzweig <paulrosenzweig@users.noreply.github.com>

* restore old legacy app routes

Co-authored-by: Paul Rosenzweig <paulrosenzweig@users.noreply.github.com>

* catch query description errors and improve client error message

* add test

Update jetty version due to https://nvd.nist.gov/vuln/detail/CVE-2019-17638

* MBQL: handle nils in SQL filters more intuitively. #13332 [ci drivers]

* Refactor [ci drivers]

* Correctly handle value literals [ci drivers]

* Make `correct-null-behaviour` work with `Field` instances [ci drivers]

* Alphabet is hard

* Add test for #12496

* Update test file location and description [ci skip]
Previously rebased on top of the current `master`.

* Update and fix the failing query

Co-authored-by: Nemanja <31325167+nemanjaglumac@users.noreply.github.com>

* Add repro for #9759

* Unskip tests

Previously rebased on top of the latest master.

* Update test file location and description

Co-authored-by: Nemanja <31325167+nemanjaglumac@users.noreply.github.com>

* Handle LocalDate values in Excel export

Adds an additional handler for LocalDate objects and a graceful
degradation of any other errors converting date/time objects to Java
Instants.

Resolves #13271
Resolves #10803
Resolves #13298

* adding a test case for the exceptional case

We don't handle JapaneseDate objects internally, but they make a good
example for what happens in an exceptional case in generating Excel
files.

* More updates for #10803

Making sure formatting to strings isn't enabled on CSV and XLSX exports
on cards and datasets.

Update formatting of the Excel document to handle the difference between
dates and date-times.

* card exports should not convert integers to strings

* not working, but the general approach to reusing cell styles

* Use a dynamic in the right place to hold CellStyles

* appease the linter bots

* refactor set-cell! duplication

set the time on a LocalDate to midnight UTC, which truncates the decimal
portion of a date-only object to 0 in Excel

* replace reset! with swap!

* appease the bikeshedder

* Initial repro for #12585

* Add positive assertion

* Fix failing test

Co-authored-by: Nemanja <31325167+nemanjaglumac@users.noreply.github.com>

* Add repro for #8472 
* Update test file location
* Add additional XHR assertion for "nodata" user

Co-authored-by: Nemanja <31325167+nemanjaglumac@users.noreply.github.com>