summaryrefslogtreecommitdiff
path: root/mysql-test/r/mysqlcheck.result
Commit message (Collapse)AuthorAgeFilesLines
* 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
| | | | |
* | | | | merge with 5.3Sergei Golubchik2011-10-191-0/+1
|\ \ \ \ \ | | |_|/ / | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | sql/sql_insert.cc: CREATE ... IF NOT EXISTS may do nothing, but it is still not a failure. don't forget to my_ok it. ****** CREATE ... IF NOT EXISTS may do nothing, but it is still not a failure. don't forget to my_ok it. sql/sql_table.cc: small cleanup ****** small cleanup
| * | | | MWL#55 : cherrypick MySQL 5.5 CMake/build improvements in orderVladislav Vaintroub2011-01-291-0/+1
| | |_|/ | |/| | | | | | | | | | to be able to build MSI based installer
* | | | post-merge fixes.Sergei Golubchik2011-07-021-2/+1
| | | | | | | | | | | | | | | | | | | | most tests pass. 5.3 merge is next
* | | | 5.5-mergeSergei Golubchik2011-07-021-13/+131
|\ \ \ \ | | |/ / | |/| |
| * | | Bug #11755431 (former 47205)Jon Olav Hauglid2011-03-081-13/+77
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MAP 'REPAIR TABLE' TO RECREATE +ANALYZE FOR ENGINES NOT SUPPORTING NATIVE REPAIR Executing 'mysqlcheck --check-upgrade --auto-repair ...' will first issue 'CHECK TABLE FOR UPGRADE' for all tables in the database in order to check if the tables are compatible with the current version of MySQL. Any tables that are found incompatible are then upgraded using 'REPAIR TABLE'. The problem was that some engines (e.g. InnoDB) do not support 'REPAIR TABLE'. This caused any such tables to be left incompatible. As a result such tables were not properly fixed by the mysql_upgrade tool. This patch fixes the problem by first changing 'CHECK TABLE FOR UPGRADE' to return a different error message if the engine does not support REPAIR. Instead of "Table upgrade required. Please do "REPAIR TABLE ..." it will report "Table rebuild required. Please do "ALTER TABLE ... FORCE ..." Second, the patch changes mysqlcheck to do 'ALTER TABLE ... FORCE' instead of 'REPAIR TABLE' in these cases. This patch also fixes 'ALTER TABLE ... FORCE' to actually rebuild the table. This change should be reflected in the documentation. Before this patch, 'ALTER TABLE ... FORCE' was unused (See Bug#11746162) Test case added to mysqlcheck.test client/mysqlcheck.c: Changed mysqlcheck to do 'ALTER TABLE ... FORCE' if 'CHECK TABLE FOR UPGRADE' reports ER_TABLE_NEEDS_REBUILD and not ER_TABLE_NEEDS_UPGRADE. mysql-test/r/mysqlcheck.result: Added regression test. mysql-test/std_data/bug47205.frm: InnoDB 5.0 FRM which contains a varchar primary key using utf8_general_ci. This is an incompatible FRM for 5.5. mysql-test/t/mysqlcheck.test: Added regression test. sql/handler.h: Added new HA_CAN_REPAIR flag. sql/share/errmsg-utf8.txt: Added new error message ER_TABLE_NEEDS_REBUILD sql/sql_admin.cc: Changed 'CHECK TABLE FOR UPDATE' to give ER_TABLE_NEEDS_REBUILD instead of ER_TABLE_NEEDS_UPGRADE if the engine does not support REPAIR (as indicated by the new HA_CAN_REPAIR flag). sql/sql_lex.h: Remove unused ALTER_FORCE flag. sql/sql_yacc.yy: Make sure ALTER TABLE ... FORCE recreates the table by setting the ALTER_RECREATE flag as the ALTER_FORCE flag was unused. storage/archive/ha_archive.h: Added new HA_CAN_REPAIR flag to Archive storage/csv/ha_tina.h: Added new HA_CAN_REPAIR flag to CSV storage/federated/ha_federated.h: Added new HA_CAN_REPAIR flag to Federated storage/myisam/ha_myisam.cc: Added new HA_CAN_REPAIR flag to MyISAM
| * | | Bug #57916: Fix the naming of the proxy_priv tableGeorgi Kodinov2010-11-021-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1. Fixed the name of the table to proxies_priv 2. Fixed the column names to be of the form Capitalized_lowecarse instead of Capitalized_Capitalized 3. Added Timestamp and Grantor columns 4. Added tests to plugin_auth to check the table structure 5. Updated the existing tests
| * | | Bug#35269 mysqlcheck behaves different depending on order of parametersAlexey Botchkov2010-10-081-2/+62
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Issue an error if user specifies multiple commands to run. Also there was an unnoticed bug that DO_CHECK was actually 0 which lead to wrong actions in some cases. The mysqlcheck.test contained commands with the suspicious meaning for the above reason. Extra commands removed from there. per-file commands: client/mysqlcheck.c Bug#35269 mysqlcheck behaves different depending on order of parameters Drop with an error if multiple commands. mysql-test/r/mysqlcheck.result Bug#35269 mysqlcheck behaves different depending on order of parameters result completed. mysql-test/t/mysqlcheck.test Bug#35269 mysqlcheck behaves different depending on order of parameters testcase added. not-working commands removed from some mysqlcheck calls.
View Lorry Controller Status