Merged PRs

dolt

8494: Fix bounds check in import scanner
fixes: #8495
The before code checks whether s.i is valid after doing the buffer access:
```
for ; unicode.IsSpace(rune(s.buf[s.i])); s.i++ {
if s.i >= s.fill {
s.read()
}
}
```
The after code inverts the check to make sure s.i is valid before indexing into the buffer.
```
for {
if s.i >= s.fill {
s.read()
}
if !unicode.IsSpace(rune(s.buf[s.i])) {
break
}
s.i++
}
```
8479: cross-schema foreign key support for doltgres tables
Depends on dolthub/go-mysql-server#2713

2717: push Distinct nodes below Sort nodes
This PR optimized queries like:
```
select distinct i from t order by i;
```
When there are many duplicate values in column i, it is much more efficient to eliminate duplicates first, then sort the results.
There are somewhat unrelated optimizations left as TODOs.
Optimize query: #8488
2716: Update Parser interface documentation
Updates documentation for the Parser interface to document the requirement that implementations must return vitess.ErrEmpty for empty queries. Without this, GMS will not handle empty queries correctly.
Related to: dolthub/doltgresql#884
2715: remove exchange node
These aren't used anywhere, so it's getting removed.
Partition still exists if we ever want to reimplement some version of this.
2713: Support for schema names in foreign key definitions
Adds schema names in many places required for foreign key operation in databases with schemas (doltgres)

Read Tests	MySQL	Dolt	Multiple
covering_index_scan	2.11	0.62	0.3
groupby_scan	13.7	17.01	1.2
index_join	1.37	2.3	1.7
index_join_scan	1.27	1.86	1.5
index_scan	34.95	54.83	1.6
oltp_point_select	0.18	0.26	1.4
oltp_read_only	3.49	5.37	1.5
select_random_points	0.34	0.61	1.8
select_random_ranges	0.39	0.62	1.6
table_scan	34.95	55.82	1.6
types_table_scan	75.82	144.97	1.9
reads_mean_multiplier			1.5

Write Tests	MySQL	Dolt	Multiple
oltp_delete_insert	8.13	5.88	0.7
oltp_insert	3.82	2.91	0.8
oltp_read_write	8.58	11.24	1.3
oltp_update_index	3.89	2.97	0.8
oltp_update_non_index	3.89	2.91	0.7
oltp_write_only	5.47	5.99	1.1
types_delete_insert	7.7	6.32	0.8
writes_mean_multiplier			0.9

TPC-C TPS Tests	MySQL	Dolt	Multiple
tpcc-scale-factor-1	99.08	40.84	2.4
tpcc_tps_multiplier			2.4

Overall Mean Multiple	1.60