* Fix pivot table queries w/o data permissions

* Text fix 

* Refactor

* Ns sorting

* obey those number separator settings

* make it lint

* Fix nested queries with joins and expressions (#14969)

* Re-enable cypress tests

* Test fix 

* Test fixes 

* Fix Cypress test

* Remove check for "Grand totals" from Cypress test

* Test fixes 



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

* Add custom Cypress log function

Shoutout to @filiphric for the original idea and inspiration.

* Update all occurrences of `cy.log`

* Remove `.only` from a test left by mistake

* Reset log counter for each test

There was a bug where we were reusing source query metadata with multiple levels of nesting which was actually incorrect with breakouts/aggregations were used in the nested levels. Simple fix, should eliminate a whole class of bugs around nesting multiple levels deep

This will make the JVM output more details as it crashes for running out of memory.

New output:

```text
rroland@tardis:~/src/metabase/target/uberjar$ java -Xmx50m -XX:+CrashOnOutOfMemoryError -jar metabase.jar
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2021-02-25 11:38:31,689 INFO metabase.util :: Maximum memory available to JVM: 50.0 MB
Aborting due to java.lang.OutOfMemoryError: Java heap space
\#
\# A fatal error has been detected by the Java Runtime Environment:
\#
\#  Internal Error (debug.cpp:338), pid=40255, tid=40256
\#  fatal error: OutOfMemory encountered: Java heap space
\#
\# JRE version: OpenJDK Runtime Environment (11.0.10+9) (build 11.0.10+9-post-Debian-1)
\# Java VM: OpenJDK 64-Bit Server VM (11.0.10+9-post-Debian-1, mixed mode, sharing, tiered, compressed oops, g1 gc, linux-amd64)
\# No core dump will be written. Core dumps have been disabled. To enable core dumping, try "ulimit -c unlimited" before starting Java again
\#
\# An error report file with more information is saved as:
\# /home/rroland/src/metabase/target/uberjar/hs_err_pid40255.log
\#
\# If you would like to submit a bug report, please visit:
\#   https://bugs.debian.org/openjdk-11
\#
Aborted
```

Previous output:

```text
rroland@tardis:~/src/metabase/target/uberjar$ java -Xmx50m -XX:+ExitOnOutOfMemoryError -jar metabase.jar
WARNING: sun.reflect.Reflection.getCallerClass is not supported. This will impact performance.
2021-02-25 11:38:46,898 INFO metabase.util :: Maximum memory available to JVM: 50.0 MB
Terminating due to java.lang.OutOfMemoryError: Java heap space
```

* Change string-operations-from-subquery to use test-data instead of sample-data, because the latter currently is incompatible with Redshift (see #14784)

* Add MSSQL_MEMORY_LIMIT_MB: 1024 to CircleCI config (cherry pick of https://github.com/metabase/metabase/commit/4a714f3e21fb06fdb73b11fa7812f417b38a069e)

* Fix regex-match-first operator for Postgres to work properly when run against subqueries

Capture col-name at beginning of fn for :regex-match-first operator in Postgres driver to work around laziness problem (see PR #14858)

Adding test

* Unskip Cypress test for #14873

* Add `updatePermissionsGraph` custom command

* Add `updatePermissionsSchema` custom command

* Add `updateCollectionGraph` custom command

* Update `updatePermissionsSchemas` command

This accounts for a different case sensitivity that different DBs have.

* add cypress test

* actions now parse int

Co-authored-by: Paul Rosenzweig <paul.a.rosenzweig@gmail.com>

#14515 Repro: Slack-based dashboard subscriptions should have a "Send to Slack now" button (#14968) [ci skip]

* Extract common repro steps in `beforeEach`

* Add repro for #14515

#13455 Repro: Order of rearranged columns not preserved after column removal via sidebar [ci skip] (#14967)

#14957 Repro: Saving a question before query has been executed can be slow with UI "hanging" [ci skip] (#14965)

* Fix:Native question filter widget reordering doesn't work #9357

* Add  Cypress test to native.cy.spec.js

* Rebase and adjust the Cypress test (repro for #9357)

Co-authored-by: sun <776766759@qq.com>

* Enable running a single spec in Cypress

* Rename flag name to run Cypress files from a specific folder

#14919 Repro: "Reset to defaults" on dashboard card "Visualization settings" removes all "Click behavior" [ci skip] (#14920)

* fix crash in InputWithSelectPrefix on null site-url

* #14900 Repro: Admin > Settings > General not working, when setup using environment variable `MB_SITE_URL` (#14903)

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

#14178 Repro: "Saved Questions" dialog doesn't respect nested collections structure [ci skip] (#14902)

Revert "#14757 Repro: New collection saved inside "My personal collection" not available in "New collection" modal [ci skip] (#14899)" (#14901)

This reverts commit 86048b1e.

#14757 Repro: New collection saved inside "My personal collection" not available in "New collection" modal [ci skip] (#14899)

Closes #14879.

* Add first Cypress custom command for selecting icons

* Use new `cy.icon()` command in all Cypress files in the project

* clarify pivot tables only work with simple and custom questions

* typo

* Maz edit

Co-authored-by: Maz Ameli <maz@metabase.com>

* picking your starting data

Co-authored-by: Maz Ameli <maz@metabase.com>

* Revert test-data-loading tweaks for now

* Test fix 

* Test fix

* Test fixes

* Unskip repro for #14859

* Test fix 



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

* Revert "Mb db connection uri parsing (#14716)"

This reverts commit b779333f.

* Readd the parsing of connection strings for db.env

#14854 Repro: Custom Expression using `case()` function fails when referencing the same column names [ci skip] (#14857)