summaryrefslogtreecommitdiff
path: root/mysql-test/suite/versioning/r/truncate.result
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-18727 improve DML operation of System Versioning (10.4)Aleksey Midenkov2019-11-251-156/+0
| | | | | | | UPDATE, DELETE: replace linear search of current/historical records with vers_setup_conds(). Additional DML cases in view.test
* Merge 10.3 into 10.4Marko Mäkelä2019-10-101-1/+2
|\
| * versioning test suite fixesAleksey Midenkov2019-10-101-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Preparation for MDEV-16210: replace.test: key_type combinations: PK and UNIQUE. foreign.test: Preparation for key_type combinations. Other fixes: * Merged versioning.update2 into versioning.update; * Removed test2 database and done individual drop instead.
* | Merge branch '10.3' into 10.4Sergei Golubchik2019-09-061-3/+1
|\ \ | |/
| * Merge branch '10.2' into 10.3Monty2019-09-031-3/+1
| |
* | Merge 10.3 into 10.4Eugene Kosov2019-07-261-0/+11
|\ \ | |/
| * MDEV-20186 Wrong result or Assertion on INSERT after DELETE HISTORYAleksey Midenkov2019-07-261-0/+11
| | | | | | | | Fix reinitialize vers_write on table reopen.
* | Merge 10.3 into 10.4Eugene Kosov2019-07-261-0/+12
|\ \ | |/
| * MDEV-19814 Assertion `update->n_fields < ulint(table->n_cols + ↵Aleksey Midenkov2019-07-251-0/+12
| | | | | | | | | | | | table->n_v_cols)' on DELETE HISTORY Turn off versioned_write for DELETE HISTORY.
* | generalize the error messageSergei Golubchik2019-05-181-3/+3
| |
* | MDEV-15966 Behavior for TRUNCATE versioned table is not documented and not ↵Sergei Golubchik2019-05-181-0/+24
|/ | | | | | | | | | covered by tests * add error for truncation of versioned tables: `ER_TRUNCATE_ILLEGAL_VERS` * make a full table open with `tdc_aquire_share` instead of just `ha_table_exists` check test suites run: main, parts, versioning Closes #785
* MDEV-16783 Assertion `!conds' failed in mysql_delete upon 2nd execution of ↵Nikita Malyavin2018-08-241-0/+6
| | | | | | | | | SP with DELETE HISTORY * remove assertion * do not setup `conds` if it's already cached Fixes #823
* MDEV-15979 DELETE HISTORY from a table with transaction-precise versioning ↵Aleksey Midenkov2018-05-171-4/+20
| | | | | | | causes Assertion `table_list->vers_conditions.type == SYSTEM_TIME_BEFORE' failure * Fix versioning.truncate,trx_id to create transaction-based tables * Fix SYSTEM_TIME_BEFORE condition for VERS_TRX_ID
* unify error messages a bitSergei Golubchik2018-02-241-2/+12
|
* PARTITION BY SYSTEM_TIME INTERVAL ...Sergei Golubchik2018-02-231-2/+0
| | | | | | | | | | | | | | | | | | | Lots of changes: * calculate the current history partition in ::external_lock(), not in ::write_row() or ::update_row() * remove dynamically collected per-partition row_end stats * no full table scan in open_table_from_share to calculate these stats, no manual MDL/thr_locks in open_table_from_share * no shared stats in TABLE_SHARE = no mutexes or condition waits when calculating current history partition * always compare timestamps, don't convert them to MYSQL_TIME (avoid DST ambiguity, and it's faster too) * correct interval handling, 1 month = 1 month, not 30 * 24 * 3600 seconds * save/restore first partition start time, and count intervals from there * only allow to drop first partitions if INTERVAL * when adding new history partitions, split the data in the last history parition, if it was overflowed * show partition boundaries in INFORMATION_SCHEMA.PARTITIONS
* SQL: Truncate history of partitioned table [fixes #399, closes #403]Sergei Golubchik2018-02-231-3/+12
| | | | | | also, don't rotate versioning partitions for DELETE HISTORY originally by: Aleksey Midenkov
* Parser: default SYSTEM_TIME ALL for DELETE HISTORYAleksey Midenkov2017-12-211-8/+8
|
* MDEV-14687 DELETE HISTORY in prepared stmt crash [fixes #421]Aleksey Midenkov2017-12-201-6/+16
| | | | Also fixes broken truncate after 617e108fb6e2bc24e5c9badb94e7d8eaa65d8851
* MDEV-14676 Redundancy in error codesAleksey Midenkov2017-12-191-2/+2
| | | | ER_VERS_NOT_VERSIONED vs ER_VERSIONING_REQUIRED
* s/TRUNCATE ... TO/DELETE HISTORY FROM ... BEFORE/Sergei Golubchik2017-12-191-9/+12
|
* MDEV-14684 Assertion `table' failed in mysql_deleteEugene Kosov2017-12-191-0/+12
| | | SQL: disable TRUNCATE table_name TO statement for VIEWs
* Timestamp-based versioning for InnoDB [closes #209]Aleksey Midenkov2017-12-181-1/+1
| | | | | | | | | | | | | | | | | | | * Removed integer_fields check * Reworked Vers_parse_info::check_sys_fields() * Misc renames * versioned as vers_sys_type_t * Removed versioned_by_sql(), versioned_by_engine() versioned() works as before; versioned(VERS_TIMESTAMP) is versioned_by_sql(); versioned(VERS_TRX_ID) is versioned_by_engine(). * create_tmp_table() fix * Foreign constraints for timestamp-based * Range auto-specifier fix * SQL: 1-row partition rotation fix [fixes #260] * Fix 'drop system versioning, algorithm=inplace'
* System Versioning 1.0 pre6Aleksey Midenkov2017-12-151-2/+2
|\ | | | | | | Merge remote-tracking branch 'mariadb/bb-10.3-temporal-serg' into trunk
* | SQL: disable truncate history on partitioned [fixes #399]Aleksey Midenkov2017-12-141-0/+9
|/
* SQL: truncate syntax and privilege [closes #229]Eugene Kosov2017-09-081-142/+6
|
* SQL, Parser: system_time logic and syntax fixes [closes #237]Aleksey Midenkov2017-08-081-10/+10
|
* SQL: compare TRX_ID fields against timestamps [closes #231]Aleksey Midenkov2017-08-031-1/+1
|
* Tests: truncate.test: get rid of transaction numberEugene Kosov2017-07-201-1/+5
|
* Parser: syntax for query system_time [closes #230]Aleksey Midenkov2017-07-121-0/+169
Eliminated `QUERY FOR`.
View Lorry Controller Status