summaryrefslogtreecommitdiff
path: root/mysql-test/r/mysqlcheck.result
Commit message (Collapse)AuthorAgeFilesLines
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-483/+0
|
* Scripts: VTMD_TEMPLATE removed [#286]Aleksey Midenkov2017-12-171-11/+0
|
* rephrase error messages, fix quotingSergei Golubchik2017-12-081-2/+2
|
* SQL: versioning_alter_history ERROR mode [closes #350]Aleksey Midenkov2017-11-271-2/+4
| | | | Disabled DROP and SURVIVE modes.
* SQL: don't update TRT when altered [#305, #302]Aleksey Midenkov2017-11-171-0/+9
| | | | Tests affected: main.mysqlcheck
* Scripts: VTMD table [closes #122]kevg2017-05-241-0/+9
|
* MDEV-6112 multiple triggers per tableMonty2016-10-051-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This is similar to MysQL Worklog 3253, but with a different implementation. The disk format and SQL syntax is identical with MySQL 5.7. Fetures supported: - "Any" ammount of any trigger - Supports FOLLOWS and PRECEDES to be able to put triggers in a certain execution order. Implementation details: - Class Trigger added to hold information about a trigger. Before this trigger information was stored in a set of lists in Table_triggers_list and in Table_triggers_list::bodies - Each Trigger has a next field that poinst to the next Trigger with the same action and time. - When accessing a trigger, we now always access all linked triggers - The list are now only used to load and save trigger files. - MySQL trigger test case (trigger_wl3253) added and we execute these identically. - Even more gracefully handling of wrong trigger files than before. This is useful if a trigger file uses functions or syntax not provided by the server. - Each trigger now has a "Created" field that shows when the trigger was created, with 2 decimals. Other comments: - Many of the changes in test files was done because of the new "Created" field in the trigger file. This shows up in SHOW ... TRIGGER and when using information_schema.trigger. - Don't check if all memory is released if on uses --gdb; This is needed to be able to get a list from safemalloc of not freed memory while debugging. - Added option to trim_whitespace() to know how many prefix characters was skipped. - Changed a few ulonglong sql_mode to sql_mode_t, to find some wrong usage of sql_mode.
* Merge branch '10.0' into 10.1Sergei Golubchik2016-08-251-2/+80
|\
| * Merge branch '5.5' into 10.0Sergei Golubchik2016-08-101-2/+80
| |\
| | * MDEV-6128:[PATCH] mysqlcheck wrongly escapes '.' in table namesSergei Golubchik2016-08-081-2/+74
| | | | | | | | | | | | | | | | | | | | | a correct fix: * store properly quoted table names in tables4repair/etc lists * tell handle_request_for_tables whether the name is aalready properly quoted * test cases for all uses of fix_table_name()
* | | Merge branch '10.0' into 10.1Sergei Golubchik2016-06-281-0/+5
|\ \ \ | |/ /
| * | Merge branch '5.5' into bb-10.0Sergei Golubchik2016-06-211-0/+5
| |\ \ | | |/
| | * fix a mysql-5.5.50 merge: mysqlcheckSergei Golubchik2016-06-201-0/+5
| | | | | | | | | | | | quote identifiers correctly
* | | MDEV-9590: Always print "Engine-independent statistic" warnings and might be ↵Oleksandr Byelkin2016-03-211-50/+10
| | | | | | | | | | | | | | | | | | filtering columns unintentionally from engines Do not issue the warning in case we are not going to collect the statistics.
* | | MDEV-9118 ANALYZE TABLE for Engine independent status fetchs blob/text ↵Oleksandr Byelkin2016-01-221-10/+50
| | | | | | | | | | | | | | | | | | columns without use Do not include BLOB fields by default.
* | | Merge branch '10.0' into 10.1Sergei Golubchik2015-12-211-0/+19
|\ \ \ | |/ /
| * | MDEV-7384: Add --persistent option for mysqlcheckDaniel Black2015-12-181-0/+19
| | | | | | | | | | | | | | | | | | | | | | | | 10.0 has an "analyze table .. persistent for all" syntax. This adds --persistent to mysqlcheck(mysqlanalyize) to perform this extended analyze table option. Signed-off-by: Vicențiu Ciorbaru <vicentiu@mariadb.org>
* | | Merge tag 'mariadb-10.0.20' into 10.1Sergei Golubchik2015-06-271-0/+23
|\ \ \ | |/ /
| * | Merge branch '5.5' into 10.0Sergei Golubchik2015-06-111-0/+23
| |\ \ | | |/
| | * MDEV-8124 mysqlcheck: --auto-repair runs REPAIR TABLE instead of REPAIR VIEW ↵Sergei Golubchik2015-06-031-0/+9
| | | | | | | | | | | | | | | | | | | | | on views create a separate list of views to repair, and repair them in a separate loop.
| | * MDEV-8123 mysqlcheck: new --process-views option conflicts with --quick, ↵Sergei Golubchik2015-06-031-0/+14
| | | | | | | | | | | | --extended and such
* | | generalize ER_TABLE_NEEDS_UPGRADE to work for views tooSergei Golubchik2015-06-011-1/+1
|/ /
* | 5.5 mergeSergei Golubchik2015-01-291-2/+9
|\ \ | |/
| * MDEV-6128:[PATCH] mysqlcheck wrongly escapes '.' in table namesunknown2015-01-281-2/+9
| | | | | | | | Backport from mysql 5.7. The patch reviewed, test added.
* | merge of "BUG# 13975227: ONLINE OPTIMIZE TABLE FOR INNODB TABLES"Sergei Golubchik2014-05-071-3/+0
| | | | | | | | | | | | | | | | | | revno: 5820 committer: Nisha Gopalakrishnan <nisha.gopalakrishnan@oracle.com> branch nick: mysql-5.6-13975225 timestamp: Mon 2014-02-17 15:12:16 +0530 message: BUG# 13975227: ONLINE OPTIMIZE TABLE FOR INNODB TABLES
* | 10.0-base mergeSergei Golubchik2013-11-041-0/+1
|\ \
| * | MDEV-5080 Assertion `strcmp(share->unique_file_name,filename) || ↵Sergei Golubchik2013-11-041-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | share->last_version' fails at /storage/myisam/mi_open.c:67 extend table names discovery (ha_discover_table_names() and Discovered_table_list) to return or optionally filter out temporary tables ("#sql..."). SHOW commands and I_S tables typically want temp table filtered out, while DROP DATABASE wants to see them too. additonally, remove the supression for the warning "Invalid (old?) table or database name" from mtr, and add it to .test files as needed (we need to test that this warning does *not* happen in drop.test)
* | | 10.0-base merge (roles)Sergei Golubchik2013-10-291-0/+4
|\ \ \ | |/ /
| * | Fixes for mysql-test failuresSergei Golubchik2013-10-181-0/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | mysql-test/r/acl_roles_show_grants.result: one can do SHOW GRANTS for himself mysql-test/t/acl_roles_set_role-table-column-priv.test: correct error message mysql-test/t/acl_roles_show_grants.test: one can SHOW GRANTS for himself sql/sql_acl.cc: bugfixing: * don't assign with && - it can shortcut and the second assignment won't be executed * correct the test in check_grant_all_columns() - want_access should not be modified * sql/sql_cmd.h.OTHER: add new commands at the end sql/sql_db.cc: don't call acl_get() if all privileges are already satisfied (crashes when run with --skip-grants, because acl data stuctures aren't initialized) sql/sql_parse.cc: * test for current_user in get_current_user() * map explicitly specified user@host to current_user
* | | 10.0-monty mergeSergei Golubchik2013-07-211-16/+0
|\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | includes: * remove some remnants of "Bug#14521864: MYSQL 5.1 TO 5.5 BUGS PARTITIONING" * introduce LOCK_share, now LOCK_ha_data is strictly for engines * rea_create_table() always creates .par file (even in "frm-only" mode) * fix a 5.6 bug, temp file leak on dummy ALTER TABLE
| * | | Fix a number of tests:Sergey Petrunya2013-07-051-16/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | - MariaDB does not have mysql.slave_master_info, mysql.slave_relay_log_info ,mysql.slave_worker_info or mysql.ndb_binlog_index tables. - Some tests expected to have these tables (this was an incorrect merge from 5.6, which merged necessary tables like mysql.innodb*stats, but also got these tables)
* | | | Merge 10.0-base -> 10.0unknown2013-05-281-4/+4
|\ \ \ \ | | |/ / | |/| |
| * | | MDEV-26: Global transaction ID.unknown2013-05-221-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Change of user interface to be more logical and more in line with expectations to work similar to old-style replication. User can now explicitly choose in CHANGE MASTER whether binlog position is taken into account (master_gtid_pos=current_pos) or not (master_gtid_pos= slave_pos) when slave connects to master. @@gtid_pos is replaced by three separate variables @@gtid_slave_pos (can be set by user, replicated GTIDs only), @@gtid_binlog_pos (read only), and @@gtid_current_pos (a combination of the two, most recent GTID within each domain). mysql.rpl_slave_state is renamed to mysql.gtid_slave_pos to match. This fixes MDEV-4474.
* | | | Merge 10.0-base -> 10.0 (GTID).unknown2013-04-171-0/+4
|\ \ \ \ | |/ / /
| * | | MDEV-26: Global transaction ID. First alpha release.unknown2013-04-151-0/+4
| |\ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Merge of 10.0-mdev26 feature tree into 10.0-base. Global transaction ID is prepended to each event group in the binlog. Slave connect can request to start from GTID position instead of specifying file name/offset of master binlog. This facilitates easy switch to a new master. Slave GTID state is stored in a table mysql.rpl_slave_state, which can be InnoDB to get crash-safe slave state. GTID includes a replication domain ID, allowing to keep track of distinct positions for each of multiple masters.
| | * | | MDEV-26: Global transaction IDunknown2013-03-261-0/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Adjust full test suite to work with GTID. Huge patch, mainly due to having to update .result file for all SHOW BINLOG EVENTS and mysqlbinlog outputs, where the new GTID events pop up. Everything was painstakingly checked to be still correct and valid .result file updates.
* | | | | 10.0-base mergeSergei Golubchik2013-04-151-2/+3
|\ \ \ \ \ | |/ / / / | | | / / | |_|/ / |/| | |
| * | | * don't use 1-8 numbers for open_table_error codes, use an enum.Sergei Golubchik2013-04-091-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * print "table doesn't exist in engine" when a table doesn't exist in the engine, instead of "file not found" (if no file was involved) * print a complete filename that cannot be found ('t1.MYI', not 't1') * it's not an error for a DROP if a table doesn't exist in the engine (or some table files cannot be found) - if the DROP succeeded regardless
| * | | find_files(): don't sort files in my_dir(), sort table namesSergei Golubchik2013-04-071-2/+2
| |/ / | | | | | | | | | | | | | | | | | | | | | | | | after all engines have discovered their tables side effect: correct alphabetical sorting as in ORDER BY ... COLLATE utf8_bin, information_schema is no longer the first after find_files(), tables like #mysql50#zzz are sorted first (as per table name), not last (as per file name zzz).
* | | Merge 10.0-base -> 10.0.Igor Babaev2013-01-101-0/+12
|\ \ \ | |/ / | | | | | | | | | Also fixed a bug in sql_update.cc: the code of mysql_update() lacked a call of set_statistics_for_table().
| * | Changed the names of the system tables for statistical data:Igor Babaev2012-12-051-12/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | table_stat -> table_stats column_stat -> column_stats index_stat -> index_stats to be in line with the names of innodb statistical tables from mysql-5.6: innodb_table_stats and innodb_index_stats.
| * | Merge maria-5.3-mwl248 -> 5.5 = maria-5.5-mwl248.Igor Babaev2012-03-191-0/+12
| |\ \ | | |/ | |/|
| | * Merged 5.3 changes into the mwl #248 tree.Igor Babaev2012-03-091-0/+1
| | |\
| | | * Merge with MariaDB 5.1 and MySQL 5.1.61Michael Widenius2012-02-201-0/+1
| | | |\
| | | | * Merge with MYSQL 5.1.61Michael Widenius2012-02-201-0/+1
| | | | |\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed README with link to source Merged InnoDB change to XtraDB README: Added information of where to find MariaDB code storage/archive/ha_archive.cc: Removed memset() of rows, a MariaDB checksum's doesn't touch not used data.
| | * | | | The main patch for the MWL#248 back-ported from Igor Babaev2012-01-041-0/+6
| | |/ / / | | | | | | | | | | | | | | | lp:~igorb-seattle/mysql-server/mysql-azalea-wl4777.
* | | | | Fixing test casesMichael Widenius2012-08-231-0/+28
|/ / / / | | | | | | | | | | | | Added missing system tables used in 5.6
* | | | Merge MySQL 5.5.20 into MariaDB 5.5.unknown2012-02-141-0/+1
|\ \ \ \
| * \ \ \ merge. Disabled the added test in merge.test from 5.1.Mattias Jonsson2011-12-151-0/+1
| |\ \ \ \ | | | |_|/ | | |/| |
| | * | | Post push fix for merge.test and mysqlcheck.test on windowsMattias Jonsson2011-12-151-0/+1
| | | | |
View Lorry Controller Status