* 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>

* 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.

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]

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

MariaDB 10.3 adds support for temporal data tables. The JDBC driver
picks up this support in 2.6.0.

Update to latest JDBC driver, and add a test that a SYSTEM VERSIONED
table appears in Metabase after a sync.

Resolves #9887

[ci mysql]

* Slack tweaks for orgs with large numbers of channels/users

* Test fix 

This will better handle queries with expressions like [Discount] *
[Quantity]

Snowflake stores warehouse, database and schema names in uppper case.
When creating the connection details, uppercase them.

Adds a forced-US Locale upper-case function to avoids potential bugs with languages that don't use Latin characters

Resolves #9511

[ci snowflake]

In Redshift (and other databases), foreign tables show up as "EXTERNAL
TABLE" - allow those to be synced in with Metabase.

Updates the Redshift JDBC driver due to changelog entry from Amazon that
was occurring and causing immense slowdowns in running the Redshift
driver tests:

    When the Java application uses com.amazon.redshift.api.PGTimestamp directly, an exception occurs.

Resolves #7833

Fixes an error generating query descriptions with named aggregations and
multiple parameters in a aggregation.

Resolves #13022

Adding the missing docstrings to make the linter complain a little less.

adds test for coercing all temporal types

[ci all]

* Fix :user-login activity not being recorded during setup (#12933)

* Test fixes 

* Fix Database sync not happening at setup (#12826)

* Test cleanup. Wow!

* More test cleanup

* Test/lint fix 

* test fix 

* Test fix

* Remove unneeded wait

* Some more tests & don't instrument log forms

* Exclude defmulti/defonce forms from instrumentation; more tests

* Test refactoring [ci drivers]

* Lint fix

During startup, we keywordize the name of the Java temporal classes, and
during that, we lower-case them. In Turkish, this means minute-of-hour
becomes mınute-of-hour (note the i is different) - which causes failures
downstream.

This moves a test helper into the common test code, and does the
lower-casing of the Temporal class names using Locale/US.

Resolves #12623

[ci all]

* Fix Slack integration

* metabase.pulse-test cleanup  

* Fixes 

* Lint fix 

Don't loose metadata 

Druid: use placeholder types so we can reuse more code

Unambigious default

Refactor fallback

Add test for 1 and 0 values

Create fresh transducer every time

Add e2e test for native queries 

[ci drivers]

* Fix insights not working on cached results

* Make test more robust

Comparing a LocalDateTime to any other time requires assigning a
timezone to the datetime. This change removes any reference to the query
processor store during the fingerprinting.

Adds tests that the fingerprints are also present in the database.

[ci all]

* Test fix 

 [ci mysql] [ci mariadb] [ci postgres]

* object-defaults should always remove created_at/updated_at
[ci mysql] [ci mariadb] [ci postgres]

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

* Handle comparing ChronoLocalDateTime and Instants

During fingerprinting, we can end up trying to compare two datatypes
that are not comparable - ChronoLocalDateTime and Instant. Coerce the
ChronoLocalDateTime to a proper Instant for the comparison to work.

When earliest / latest are called, the acc parameter must be coerced to
a Temporal object also.

Resolves #12311

[ci all]

* making ->temporal recursive

* Get the timezone in an precedence order

When converting a LocalTime for fingerprinting, convert to an Instant
using the following precedence order:

* report timezone
* database timezone
* system timezone

[ci all]

* use UTC for timezones

* Remove Table.rows entirely

* Lots of test updates/modernization

* Test fixes 

Co-authored-by: Cam Saul <github@camsaul.com>
Co-authored-by: Maz Ameli <maz@metabase.com>