diff options
| author | Nikita Malyavin <nikitamalyavin@gmail.com> | 2019-11-26 19:22:04 +1000 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2020-03-31 17:42:34 +0200 |
| commit | 259fb1cbed4470636ff35df83e1c4ca966bb8159 (patch) | |
| tree | ca82142d15f878ea127f8dbde783cb91a1e13652 /mysql-test/suite/perfschema | |
| parent | 0515577d128318e1b62511846d88d0c56226168d (diff) | |
| download | mariadb-git-259fb1cbed4470636ff35df83e1c4ca966bb8159.tar.gz | |
MDEV-16978 Application-time periods: WITHOUT OVERLAPS
* The overlaps check is implemented on a handler level per row command.
It creates a separate cursor (actually, another handler instance) and
caches it inside the original handler, when ha_update_row or
ha_insert_row is issued. Cursor closes on unlocking the handler.
* Containing the same key in index means unique constraint violation
even in usual terms. So we fetch left and right neighbours and check
that they have same key prefix, excluding from the key only the period part.
If it doesnt match, then there's no such neighbour, and the check passes.
Otherwise, we check if this neighbour intersects with the considered key.
* The check does not introduce new error and fails with ER_DUPP_KEY error.
This might break REPLACE workflow and should be fixed separately
Diffstat (limited to 'mysql-test/suite/perfschema')
| -rw-r--r-- | mysql-test/suite/perfschema/r/start_server_low_digest_sql_length.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/suite/perfschema/r/start_server_low_digest_sql_length.result b/mysql-test/suite/perfschema/r/start_server_low_digest_sql_length.result index 8ff2bdebd3c..9e9cb98073b 100644 --- a/mysql-test/suite/perfschema/r/start_server_low_digest_sql_length.result +++ b/mysql-test/suite/perfschema/r/start_server_low_digest_sql_length.result @@ -8,5 +8,5 @@ SELECT 1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1 #################################### SELECT event_name, digest, digest_text, sql_text FROM events_statements_history_long; event_name digest digest_text sql_text -statement/sql/select 8ad134e475b278738ee855a05d6a77cf SELECT ? + ? + SELECT ... -statement/sql/truncate 2b32156b59f41d61d9070458bce5932e TRUNCATE TABLE truncat... +statement/sql/select 230fd11f009a87fecbb87c9fc7361475 SELECT ? + ? + SELECT ... +statement/sql/truncate faf6cefb662b443f05e97b5c5ab14a59 TRUNCATE TABLE truncat... |