summaryrefslogtreecommitdiff
path: root/mysql-test
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-6924 : Server crashed on CREATE TABLE ... SELECTNirbhay Choubey2014-11-175-0/+79
| | | | | | | Do not allow server to start if binlog_format is set to a format other than ROW. Also restrict the change of GLOBAL/SESSION binlog_format value at runtime.
* bzr merge -r4015..4026 codership/5.5Nirbhay Choubey2014-10-091-5/+18
|
* bzr merge -rtag:mariadb-5.5.40 maria/5.5Nirbhay Choubey2014-10-0943-20/+882
|\
| * don't run privilege checking tests in embeddedSergei Golubchik2014-10-081-0/+1
| |
| * decimal: *correct* implementation of ROUND_UP at lastSergei Golubchik2014-10-082-0/+5
| |
| * MDEV-5553 A view or procedure with a non existing definer can block "SHOW ↵Sergei Golubchik2014-10-072-0/+24
| | | | | | | | | | | | | | TABLE STATUS" with an unclear error message Don't double-check privileges for a column in the GROUP BY that refers to the same column in SELECT clause. Privileges were already checked for SELECT clause.
| * MDEV-4813 Replication fails on updating a MEMORY table with an index using btreeSergei Golubchik2014-10-072-0/+13
| | | | | | | | skip NULL VARCHAR key parts like it's done elsewhere
| * fixes for decimal typeSergei Golubchik2014-10-072-0/+15
| |
| * post-merge fixesSergei Golubchik2014-10-073-5/+9
| |
| * mysql-5.5.40Sergei Golubchik2014-10-066-0/+181
| |\
| | * Adding patch for security bug 19471516mysql-5.5.40Murthy Narkedimilli2014-09-082-0/+42
| | |
| | * Bug #11755818 : LIKE DOESN'T MATCH WHEN CP932_BIN/SJIS_BINmithun2014-08-122-0/+64
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | COLLATIONS ARE USED. ISSUE : ------- Code points of HALF WIDTH KATAKANA in SJIS/CP932 range from A1 to DF. In function my_wildcmp_mb_bin_impl while comparing such single byte code points, there is a code which compares signed character with unsigned character. Because of this, comparisons of two same code points representing a HALF WIDTH KATAKANA character always fails. Solution: --------- A code point of HALF WIDTH KATAKANA at-least need 8 bits. Promoting the variable from uchar to int will fix the issue. mysql-test/t/ctype_cp932.test: Tests which have conditions LIKE 'STRING PATTERN WITH HALF WIDTH KATAKANA'. strings/ctype-mb.c: A code point of HALF WIDTH KATAKANA at-least need 8 bits. Promoting the variable from uchar to int will fix the issue.
| | * Bug#14757009: WHEN THE GENERAL_LOG IS A SOCKET AND THE READERPraveenkumar Hulakund2014-07-172-0/+75
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | GOES AWAY, MYSQL QUITS WORKING. Analysis: ----------------- Issue in this bug and in bug 11907705 is, the socket file or fifo file is set for general log at command line while starting the server. But currently, only regular file can be set for the general log. Instead of reporting any error, the provided files are opened for writing and continued. Because of this issues mentioned in the bug reports are seen. As mentioned, only when any non-regular file is set for general log at command line while starting the server, these issues are seen. If general log file is set to non-regular file from CLI using system variable general_log_file then error is reported. These issues can also be faced with slow query log file, if it is set to non-regular file. Fix: ----------------- Currently while starting the server if we fail to open log file then we report an error, disable logging to file and continue. To fix issue reported code is modified to check whether file is regular file or not before opening it. If file is not a regular file then error is logged to error log and logging to file is disabled.
| * | MDEV-5707 MTR fails on kfreebsdSergei Golubchik2014-10-021-0/+2
| | | | | | | | | | | | apply debian's patch to workaround kfreebsd bug
| * | MDEV-6528 review debian patches for mysqlSergei Golubchik2014-10-027-10/+10
| | | | | | | | | | | | and apply whatever was reasonable
| * | MDEV-6592 Assertion `ltime->day == 0' failed with TIMESTAMP, MAKETIMEAlexander Barkov2014-10-032-0/+22
| | |
| * | MDEV-6743 crash in GROUP_CONCAT(IF () ORDER BY 1)Michael Widenius2014-09-232-2/+70
| | | | | | | | | | | | | | | | | | | | | | | | | | | mysql-test/r/func_group.result: Test case mysql-test/t/func_group.test: Test case sql/item_sum.cc: Restore ORDER for prepared statements
| * | for mysql-test: fix mysqlhotcopy script to return a predictable exit codeSergei Golubchik2014-09-161-1/+1
| | |
| * | 5.3 mergeSergei Golubchik2014-09-126-4/+463
| |\ \
| | * | Fixed bug mdev-6292.Igor Babaev2014-09-094-4/+282
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Avoided exponential recursive calls of JOIN_CACHE::join_records() in the case of non-nested outer joins. A different solution is required to resolve this performance problem for nested outer joins.
| | * | Merge.Igor Babaev2014-08-042-0/+181
| | |\ \
| | | * | Fixed bug mdev-5721.Igor Babaev2014-07-312-0/+181
| | | | | | | | | | | | | | | | | | | | | | | | | Do not define a look-up key for a temporary table if its length exceeds the maximum length of such keys.
| * | | | MDEV-6526 INFO_SRC and INFO_BIN installed wrongSergei Golubchik2014-09-121-0/+1
| | | | | | | | | | | | | | | | | | | | don't install them at all
| * | | | MDEV-6619 SHOW PROCESSLIST returns empty result set after KILL QUERYSergei Golubchik2014-09-122-0/+31
| | | | | | | | | | | | | | | | | | | | don't send an OK packet if the SHOW PROCESSLIST was killed
| * | | | MDEV-6682 innodb.innodb_simulate_comp_failures_small is too slow Jan Lindström2014-09-032-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | if it's run on a real disk Made test smaller.
| * | | | MDEV-6673 I_S.SESSION_VARIABLES shows global valuesSergei Golubchik2014-08-312-0/+17
| | | | | | | | | | | | | | | | | | | | only look at lex->option_type if it's a SHOW command, not a SELECT
| * | | | MDEV-6601 Assertion `!thd->in_active_multi_stmt_transa ction() || ↵Sergei Golubchik2014-08-252-0/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | thd->in_multi_stmt_transaction_mode()' failed on executing a stored procedure with commit Don't restore the whole of thd->server_status after a routine invocation, only restore SERVER_STATUS_CURSOR_EXISTS and SERVER_STATUS_LAST_ROW_SENT, as --ps --embedded needs. In particular, don't restore SERVER_STATUS_IN_TRANS.
| * | | | Change a couple of permissions that cause lintian warnings in .deb packaging ↵Kristian Nielsen2014-08-133-0/+0
| | | | | | | | | | | | | | | | | | | | and don't really hurt to fix.
| * | | | MDEV-6546: innodb.innodb_simulate_comp_failures_small failsJan Lindström2014-08-131-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | sporadically Fix: Modify test to be smaller so that testcase timeout does not trigger. We already have a test for --big-test setup (innodb.innodb_simulate_comp_failures).
* | | | | MDEV-6447: Galera: Enable QCNirbhay Choubey2014-09-172-0/+2647
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Added galera/query_cache test * Merged patch for lp:1296403
* | | | | Updated mysqld--help test and result (MDEV-6717, MDEV-6659).Nirbhay Choubey2014-09-162-3/+3
| | | | |
* | | | | Minor improvements in mtr and wsrep test files.Nirbhay Choubey2014-09-097-41/+69
| | | | |
* | | | | MDEV-6717 : wsrep_data_home_dir should default to @@datadirNirbhay Choubey2014-09-092-28/+47
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Used mysql_real_data_home as wsrep_data_home_dir's default. Added a test case.
* | | | | MDEV-6699 : wsrep_node_name not automatically set to hostnameNirbhay Choubey2014-09-092-18/+41
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed by using hostname (glob_hostname) as default value for wsrep_node_name system variable. Added a test case.
* | | | | MDEV-6651: MariaDB galera cluster crashes in file row0mysql.cc line 684Jan Lindström2014-09-032-0/+212
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | DELETE FROM ports WHERE ports.id = 'f37aa3fe-ab99-4d0f-a566-6cd3169d7516' where table ports have foreign keys. Verified that current 5.5-galera is not affected and added test case to regression set.
* | | | | Switched wsrep_causal_reads ON for galera test suite.Nirbhay Choubey2014-08-261-0/+4
| | | | |
* | | | | Fix for binlog tests.mariadb-galera-5.5.39Nirbhay Choubey2014-08-153-9/+9
| | | | |
* | | | | Updated file_contents.test with correct file location.Nirbhay Choubey2014-08-131-1/+1
| | | | |
* | | | | Added a basic test for wsrep_sync_wait system variable.Nirbhay Choubey2014-08-133-2/+111
| | | | | | | | | | | | | | | | | | | | | | | | | Also made some coding style related changes.
* | | | | Fix for some failing tests.Nirbhay Choubey2014-08-1114-2/+314
| | | | |
* | | | | Local merge of mariadb-5.5.39Nirbhay Choubey2014-08-0679-34/+2445
|\ \ \ \ \ | |/ / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | bzr merge -r4264 maria/5.5 Text conflict in sql/mysqld.cc Text conflict in storage/xtradb/btr/btr0cur.c Text conflict in storage/xtradb/buf/buf0buf.c Text conflict in storage/xtradb/buf/buf0lru.c Text conflict in storage/xtradb/handler/ha_innodb.cc 5 conflicts encountered.
| * | | | Bug#17638477 UNINSTALL AND INSTALL SEMI-SYNC PLUGIN CAUSES SLAVES TO BREAKSergei Golubchik2014-08-033-55/+64
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fix the bug properly (plugin cannot be unloaded as long as it's locked). Enable and fix the test case. Significantly reduce number of LOCK_plugin locks for semisync (practically all locks were removed)
| * | | | mysql-5.5.39 mergeSergei Golubchik2014-08-0238-24/+1141
| |\ \ \ \ | | | |_|/ | | |/| | | | | | | | | | | | | | | | | | | | | | ~40% bugfixed(*) applied ~40$ bugfixed reverted (incorrect or we're not buggy) ~20% bugfixed applied, despite us being not buggy (*) only changes in the server code, e.g. not cmakefiles
| | * | | Bug #17357528 BACKPORT BUG#16513435 TO 5.5 AND 5.6Venkata Sidagam2014-06-301-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | Description: Backporting BUG#16513435 to 5.5 and 5.6 This is a fix for REMOTE PREAUTH USER ENUMERATION FLAW bug
| | * | | Bug#18903155: BACKPORT BUG-18008907 TO 5.5+ VERSIONS.Praveenkumar Hulakund2014-06-272-0/+187
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Backporting patch committed for bug 18008907 to 5.5 and 5.6.
| | * | | Bug#16395459 TEST AND RESULT FILES WITH EXECUTE BITTerje Rosten2014-06-271-0/+0
| | | | | | | | | | | | | | | | | | | | | | | | | Post push fix: add execute bit on perl script.
| | * | | BUG#13874553: rpl.rpl_stop_slave fails sporadically on pb2Luis Soares2014-06-263-4/+38
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The test case makes use of the fine DEBUG_SYNC facility. Furthermore, since it needs synchronization on internal threads (dump and SQL threads) the server code has DEBUG_SYNC commands internally deployed and activated through the DBUG_EXECUTE_IF macro. The internal DBUG_SYNC commands are then controlled from the test case through the DEBUG variable. There were three problems around the DEBUG + DEBUG_SYNC facility usage: 1. When signaling the SQL thread to continue, the test would reset immediately the DEBUG_SYNC variable. This could mean that the SQL thread might loose the signal and continue to wait forever; 2. A similar scenario was happening with the dump thread on the master. This thread was instructed to wait, and later it would be signaled to continue, but immediately after the DEBUG_SYNC would be reset. This could lead to the dump thread missing the signal and wait forever; 3. The test was not cleaning itself up with respect to the instrumentation of the dump thread. This would leave the conditional execution of an internal DEBUG_SYNC command active (through the usage of DBUG_EXECUTE_IF). We fix #1 and #2 by waiting for the threads to receive the signal and only then issue the reset. We fix #3 by reseting the DEBUG variable, thus deactivating the dump thread internal DEBUG_SYNC command.
| | * | | BUG#18405221: SHOW CREATE VIEW OUTPUT INCORRECTNisha Gopalakrishnan2014-06-252-0/+74
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fix: --- The issue reported is same as the BUG#14117018. Hence backporting the patch from mysql-trunk to mysql-5.5 and mysql-5.6
| | * | | Bug#16395459 TEST AND RESULT FILES WITH EXECUTE BITTerje Rosten2014-06-2511-2/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Bug#16415173 CRLF INSTEAD OF LF IN SQL-BENCH SCRIPTS Correct perms and converts from Windows style to UNIX style line endings on some files. Fix perms on installed ini files. (MySQL 5.5 version)
| | * | | BUG#18618561: FAILED ALTER TABLE ENGINE CHANGE WITH PARTITIONSNisha Gopalakrishnan2014-06-242-0/+44
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | CORRUPTS FRM Analysis: --------- ALTER TABLE on a partitioned table resulted in the wrong engine being written into the table's FRM file and displayed in SHOW CREATE TABLE. The prep_alter_part_table() modifies the partition_info object for TABLE instance representing the old version of table. If the ALTER TABLE ENGINE statement fails, the partition_info object for the TABLE contains the altered storage engine name. The SHOW CREATE TABLE uses the TABLE object to display the table information, hence displays incorrect storage engine for the table. Also a subsequent successful ALTER TABLE operation will write the incorrect engine information into the FRM file. Fix: --- A copy of the partition_info object is created before modification so that any changes would not cause the the original partition_info object to be modified if the ALTER TABLE fails.(Backported part of the code provided as fix for bug#14156617 in mysql-5.6.6).
View Lorry Controller Status