summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/t/temporary_table.test
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-13013 InnoDB unnecessarily extends data filesThirunarayanan Balathandayuthapani2022-08-171-0/+1
| | | | | | | | - While creating a new InnoDB segment, allocates the extent before allocating the inode or page allocation even though the pages are present in fragment segment. This patch does reserve the extent when InnoDB ran out of fragment pages in the tablespace.
* Merge branch 10.2 into 10.3Julius Goryavsky2021-12-231-0/+2
|\
| * MDEV-27235: Crash on SET GLOBAL innodb_encrypt_tablesMarko Mäkelä2021-12-131-0/+2
| | | | | | | | | | fil_crypt_set_encrypt_tables(): If no encryption threads have been initialized, do nothing.
| * MDEV-25457 Server crashes in row_undo_mod_clust_low upon rollback of ↵Eugene Kosov2021-04-211-0/+6
| | | | | | | | | | | | | | read-only transaction node->index was NULL. But it's possible to get dict_table_t* from another source.
* | Merge 10.2 into 10.3Marko Mäkelä2021-04-211-0/+107
|\ \ | |/
| * MDEV-22255 SIGABRT: Assertion `id' failed in trx_write_trx_id on INSERT | ↵Eugene Kosov2021-04-151-0/+102
| | | | | | | | Assertion `id > 0' failed in trx_write_trx_id | Assertion `val > 0' failed in row_upd_index_entry_sys_field | Assertion `thr_get_trx(thr)->id || index->table->no_rollback()' failed.
* | Merge 10.2 into 10.3Marko Mäkelä2018-07-261-0/+17
|\ \ | |/
| * MDEV-16713 Hangs server with repeating log entryThirunarayanan Balathandayuthapani2018-07-251-0/+17
| | | | | | | | | | | | At most one transaction can be active at a time for temporary tables. There is no need to check previous version of record for the temporary tables.
* | MDEV-16201 CREATE TABLE creates extra transactionThirunarayanan Balathandayuthapani2018-05-171-0/+9
|/ | | | | | | | | | | | | | | InnoDB does not allow FOREIGN KEY constraints to exist for TEMPORARY TABLE. InnoDB introduced a dedicated tablespace for temporary tables, and actually stopped creating persistent metadata and data for temporary tables. row_table_add_foreign_constraints(): Do not create a persistent transaction. dict_create_foreign_constraints_low(): Add the persistent transaction to the update the foreign key relation in dictionary. dict_create_foreign_constraints_low(): Remove a duplicated check for partitioned tables.
* Bug #26805833 INNODB COMPLAINS OF SYNTAX ERROR, BUT DOES NOT SAY WHICH OPTIONSachin Agarwal2018-05-111-0/+1
| | | | | | | | | | | | | | | | | Problem: when incorrect value is assigned to innodb_data_file_path or innodb_temp_data_file_path parameter, Innodb returns error and logs error message in mysqlds.err file but there is no information in error message about the parameter which causes Innodb initialization is failed. Fix: Added error message with parameter name and value, which causes Innodb initialization is failed. Reviewed by: Jimmy <Jimmy.Yang@oracle.com> RB: 18206
* MDEV-16106 Record in index was not found on rollback, trying to insert: TUPLEThirunarayanan Balathandayuthapani2018-05-081-0/+11
| | | | | During rollback of temporary table logs, secondary index should delete mark the index entry instead of removing it completely.
* Adjust a test for WindowsMarko Mäkelä2017-07-051-3/+1
| | | | | | | | | | | | On Windows, when tmpdir is not writable, there are only messages like this: 2017-07-05 14:04:25 3860 [ERROR] InnoDB: Unable to create temporary file; errno: 0 On other platforms, there would be two messages for each failure: 2017-07-05 17:23:02 140436573771648 [ERROR] mysqld: Can't create/write to file '/dev/null/nonexistent/ibaajU4U' (Errcode: 20 "Not a directory") 2017-07-05 17:23:02 140436573771648 [ERROR] InnoDB: Unable to create temporary file; errno: 20
* MDEV-13143 Server crashes in srv_init_abort_low() when started with ↵Marko Mäkelä2017-07-051-0/+31
| | | | | | | | | | | | | inaccessible tmpdir This is a regression caused by commit bb60a832ede139d24a2470a1b1217d30799d726e srv_shutdown_all_bg_threads(): If os_thread_count indicates that no threads are running, do not bother checking thread status. This avoids a crash when InnoDB startup is aborted before os_aio_init() has been invoked. (os_aio_all_slots_free() would dereference AIO::s_reads even though it is NULL.)
* Merge 10.1 into 10.2Marko Mäkelä2017-06-081-7/+0
| | | | Replace have_innodb_zip.inc with innodb_page_size_small.inc.
* search_pattern_in_file.inc changesSergei Golubchik2017-03-311-1/+0
| | | | | | | | | | | | | 1. Special mode to search in error logs: if SEARCH_RANGE is not set, the file is considered an error log and the search is performed since the last CURRENT_TEST: line 2. Number of matches is printed too. "FOUND 5 /foo/ in bar". Use greedy .* at the end of the pattern if number of matches isn't stable. If nothing is found it's still "NOT FOUND", not "FOUND 0". 3. SEARCH_ABORT specifies the prefix of the output. Can be "NOT FOUND" or "FOUND" as before, but also "FOUND 5 " if needed.
* MDEV-11816 Disallow CREATE TEMPORARY TABLE…ROW_FORMAT=COMPRESSEDMarko Mäkelä2017-01-181-0/+445
MySQL 5.7 allows temporary tables to be created in ROW_FORMAT=COMPRESSED. The usefulness of this is questionable. WL#7899 in MySQL 8.0.0 prevents the creation of such compressed tables, so that all InnoDB temporary tables will be located inside the predefined InnoDB temporary tablespace. Pick up and adjust some tests from MySQL 5.7 and 8.0. dict_tf_to_fsp_flags(): Remove the parameter is_temp. fsp_flags_init(): Remove the parameter is_temporary. row_mysql_drop_temp_tables(): Remove. There cannot be any temporary tables in InnoDB. (This never removed #sql* tables in the datadir which were created by DDL.) dict_table_t::dir_path_of_temp_table: Remove. create_table_info_t::m_temp_path: Remove. create_table_info_t::create_options_are_invalid(): Do not allow ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE for temporary tables. create_table_info_t::innobase_table_flags(): Do not unnecessarily prevent CREATE TEMPORARY TABLE with SPATIAL INDEX. (MySQL 5.7 does allow this.) fil_space_belongs_in_lru(): The only FIL_TYPE_TEMPORARY tablespace is never subjected to closing least-recently-used files.
View Lorry Controller Status