* Fix `snippet` Cypress error

- this was very annoying flake responsible for a lot of failed builds => it shouldn't fail again
- added "hack" function for typing inside autocomplete fields
- added simple math in the second case with altered assertion

Co-authored-by: Paul Rosenzweig  

Merge release 0.36.6 into master

* Apply new format to the issue references in tests and other "affected" files across the code base

* Add previously deleted issue references back to their test

* Migrate `Button` unit test from enzyme to react-testing-library
* Delete 2 obsolete `Button` snapshots

* skip db migration test for lowercase email edge-case on mysql and mariadb [ci all]

* remove offending test [ci all]

* Add --keep-existing flag to dump-to-h2 command

* Explain --keep-existing flag in docstrings

* Don't log db password

Changes the app db to lowercase all emails, and queries to default to the lowercased version of emails. This fixes the problem of users logging in with emails where one or more characters could be capitalized. Resolves #3047

[ci postgres] [ci mysql]

* Add `role` and `aria-label` to icons

* Expand `Icon` unit tests

* Simplify `NON_STANDARD_VIEWBOX_ICON`

* Update snapshots related to a11y improvements to icons

* Pass `aria-label` directly as an icon attribute

* MBQL: make mbql.u/field-clause->id-or-field work with expressions

* Update docs

* Fix test

Merge 0.36.5.1 back into master

This test fails when the app db is postgres / mysql / mariadb because
the database isn't setup when it runs.

For now, skip this test on anything but H2 to fix a broken master build.

* Support IPv6 for LDAP connections

Adds support for IPv6 LDAP connections. The underlying clj-ldap library
requires a different format of the host parameter to support IPv6.

IPv6 addresses must be wrapped in [], like:
[2601:600:967f:88d4:b476:56a8:c364:94da]

Converted the LDAP expect tests to clojure.test also.

Resolves #12879

* Update LDAP IPv6 test to handle CircleCI not supporting IPv6

Co-authored-by: Cam Saul <github@camsaul.com>

Excel will not parse an ISO8601 date, so add a new version of
FormatValue specifically made for Excel.

The Docjure library used has formatting helpers for a few Java classes,
but specifically java.util.Date and not the newer Java 8 Time classes.
In this case, it formats any java.util.Date as m/d/yy.

Resolves #10803

* convert tests to deftest

convert more expectations based tests to deftest

* Remove orphaned sync jobs from the database

If a database is deleted, make sure that any applicable sync jobs are
removed upon the next sync run.

Resolves #11813

* rename mdb to database for convention

* Convert ID Integer columns to strings

Converts any ID (PK or FK) column that's derived from a :type/Integer to
a string in query middleware (at the end of query processing.)

JavaScript treats all numbers as floats, with a 52 bit mantissa. Any
integer larger than 52 bits ends up looking like a strange floating
point number.

This will allow the UI to properly display a number n where n > 2^52 or
n < -2^52

Resolves #5816

[ci all]

* code review feedback

* skip the reduce phase if there are no columns to update

* handle joins properly

joins have two :field-id values in them. handle them appropriately

* update cloverage build

* update tools.namespace for newer cloverage

* handle all query types more gracefully

Only in cases where we have an explicit :field-id do we try to do the
coercions to strings. It's important to not filter the :fields clause in
such a way that anything is left out - if they were, the keep-indexed
call would modify the wrong values in the result.

java-time has an upstream bug where it lowercases the built-in Java
timezone formatters to be able to look them up by keyword later. This
breaks under Turkish (and possibly other locales)

See dm3/clojure.java-time#60 for the upstream fix.

Resolves #13102

Previously, if your Metabase account for a Google login was disabled,
you would be returned to the login box with no indication as to what was
wrong. Now we return to the page with a red error that says "Your
account is disabled."

Resolves #3245

* Lift dimensions from nested queries

* Don't try to lift native queries

* Fix tests

* Minor refactor

* Use actual field IDs in tests

* Touchups

* More tests

* Better names

* Add missing require

* add end-to-end test

* Remove stale

* Add breakout support

* Add e2e test for breakout

* Update test [ci drivers]

* Change order [ci drivers]

* Ignore name case [ci drivers]

* make tests portable [ci drivers]

* Ensure vector [ci drivers]

* Test: stable ordering [ci drivers]

* Upgrade React Testing Library to the latest version

* Remove `cleanup` after each test

Further read: https://kentcdodds.com/blog/common-mistakes-with-react-testing-library#using-cleanup

Since we specifically mention the character set required for MySQL, we should provide examples of how to create those databases.

Instead of using assert, which throws an exception with confusing detail
for the users, use a more user-friendly error.

Old error:

    Error: Assert failed: Invalid site URL: "https://localhost:3000!"
(u/url? s)

New error:

    Error: Invalid site URL: "http://localhost:3000!"

Resolves #4506