summaryrefslogtreecommitdiff
path: root/mysql-test/suite/plugins
Commit message (Collapse)AuthorAgeFilesLines
* Merge branch '10.3' into 10.4Oleksandr Byelkin2022-01-301-18/+18
|\
| * Merge branch '10.2' into 10.3mariadb-10.3.33Oleksandr Byelkin2022-01-291-18/+18
| |\
| | * Bug#31374305 - FORMAT() NOT DISPLAYING WHOLE NUMBER SIDE CORRECTLY FOR ES_MX ↵Maheedhar PV2022-01-211-18/+18
| | | | | | | | | | | | | | | | | | | | | | | | | | | AND ES_ES LOCALES Changed the grouping and decimal separator for spanish locales as per ICU. Change-Id: I5d80fa59d3e66372d904e17c22c532d4dd2c565b
* | | MDEV-27341 Use SET PASSWORD to change PAM serviceSergei Golubchik2022-01-172-1/+33
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | SET PASSWORD = PASSWORD('foo') would fail for pam plugin with ERROR HY000: SET PASSWORD is ignored for users authenticating via pam plugin but SET PASSWORD = 'foo' would not. Now it will.
* | | MDEV-26339 Account specifics to be handled before proxyingSergei Golubchik2022-01-172-0/+59
| | |
* | | Merge 10.3 into 10.4Marko Mäkelä2021-10-282-0/+6
|\ \ \ | |/ /
| * | Merge 10.2 into 10.3Marko Mäkelä2021-10-282-0/+6
| |\ \ | | |/
| | * MDEV-26556 An improper locking bug(s) due to unreleased lock.bb-10.2-mdev-26556-hfAlexey Botchkov2021-10-252-0/+6
| | | | | | | | | | | | Get rid of the global big_buffer.
* | | MDEV-26650: Failed ALTER USER/GRANT statement removes the password from the ↵bb-10.4-MDEV-26650-2Oleksandr Byelkin2021-10-182-0/+34
| | | | | | | | | | | | | | | | | | | | | cache Starting from 10.4 AUTH is not part of ACL_USER so changes have to be done over a copy, and bring in the cache only in case of success.
* | | Merge 10.3 into 10.4Marko Mäkelä2021-10-132-3/+19
|\ \ \ | |/ /
| * | Merge 10.2 into 10.3Marko Mäkelä2021-10-132-3/+19
| |\ \ | | |/
| | * MDEV-24454 fixup: Fix plugins.feedback_plugin_sendMarko Mäkelä2021-10-112-3/+19
| | | | | | | | | | | | | | | In commit 3690c549c6e72646ba74f6b4c83813ee4ac3aea4 this test was not adjusted.
* | | Merge 10.3 into 10.4Marko Mäkelä2021-09-292-0/+23
|\ \ \ | |/ /
| * | Merge 10.2 into 10.3Marko Mäkelä2021-09-292-0/+23
| |\ \ | | |/
| | * MDEV-24454 Crash at change_item_treebb-10.2-MDEV-24454Oleksandr Byelkin2021-09-272-0/+23
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Use in_sum_func (and so nest_level) only in LEX to which SELECT lex belong to Reduce usage of current_select (because it does not always point on the correct SELECT_LEX, for example with prepare. Change context for all classes inherited from Item_ident (was only for Item_field) in case of pushing down it to HAVING. Now name resolution context have to have SELECT_LEX reference if the context is present. Fixed feedback plugin stack usage.
* | | mtr: plugin.multiauth aix fixDaniel Black2021-07-022-0/+15
| | | | | | | | | | | | The error loading the client module is different
* | | Merge 10.3 into 10.4Marko Mäkelä2021-06-212-8/+8
|\ \ \ | |/ /
| * | Merge 10.2 into 10.3Marko Mäkelä2021-06-212-8/+8
| |\ \ | | |/
| | * MDEV-25884 Tests use environment $USER variable without quotesElena Stepanova2021-06-102-8/+8
| | |
* | | MDEV-25884 Tests use environment $USER variable without quotesElena Stepanova2021-06-102-26/+26
| | | | | | | | | | | | | | | These are only 10.4+ tests. 10.2+ tests are pushed into 10.2 and will be merged into 10.4+ independently
* | | Fix all warnings given by UBSANMonty2021-04-201-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The easiest way to compile and test the server with UBSAN is to run: ./BUILD/compile-pentium64-ubsan and then run mysql-test-run. After this commit, one should be able to run this without any UBSAN warnings. There is still a few compiler warnings that should be fixed at some point, but these do not expose any real bugs. The 'special' cases where we disable, suppress or circumvent UBSAN are: - ref10 source (as here we intentionally do some shifts that UBSAN complains about. - x86 version of optimized int#korr() methods. UBSAN do not like unaligned memory access of integers. Fixed by using byte_order_generic.h when compiling with UBSAN - We use smaller thread stack with ASAN and UBSAN, which forced me to disable a few tests that prints the thread stack size. - Verifying class types does not work for shared libraries. I added suppression in mysql-test-run.pl for this case. - Added '#ifdef WITH_UBSAN' when using integer arithmetic where it is safe to have overflows (two cases, in item_func.cc). Things fixed: - Don't left shift signed values (byte_order_generic.h, mysqltest.c, item_sum.cc and many more) - Don't assign not non existing values to enum variables. - Ensure that bool and enum values are properly initialized in constructors. This was needed as UBSAN checks that these types has correct values when one copies an object. (gcalc_tools.h, ha_partition.cc, item_sum.cc, partition_element.h ...) - Ensure we do not called handler functions on unallocated objects or deleted objects. (events.cc, sql_acl.cc). - Fixed bugs in Item_sp::Item_sp() where we did not call constructor on Query_arena object. - Fixed several cast of objects to an incompatible class! (Item.cc, Item_buff.cc, item_timefunc.cc, opt_subselect.cc, sql_acl.cc, sql_select.cc ...) - Ensure we do not do integer arithmetic that causes over or underflows. This includes also ++ and -- of integers. (Item_func.cc, Item_strfunc.cc, item_timefunc.cc, sql_base.cc ...) - Added JSON_VALUE_UNITIALIZED to json_value_types and ensure that value_type is initialized to this instead of to -1, which is not a valid enum value for json_value_types. - Ensure we do not call memcpy() when second argument could be null. - Fixed that Item_func_str::make_empty_result() creates an empty string instead of a null string (safer as it ensures we do not do arithmetic on null strings). Other things: - Changed struct st_position to an OBJECT and added an initialization function to it to ensure that we do not copy or use uninitialized members. The change to a class was also motived that we used "struct st_position" and POSITION randomly trough the code which was confusing. - Notably big rewrite in sql_acl.cc to avoid using deleted objects. - Changed in sql_partition to use '^' instead of '-'. This is safe as the operator is either 0 or 0x8000000000000000ULL. - Added check for select_nr < INT_MAX in JOIN::build_explain() to avoid bug when get_select() could return NULL. - Reordered elements in POSITION for better alignment. - Changed sql_test.cc::print_plan() to use pointers instead of objects. - Fixed bug in find_set() where could could execute '1 << -1'. - Added variable have_sanitizer, used by mtr. (This variable was before only in 10.5 and up). It can now have one of two values: ASAN or UBSAN. - Moved ~Archive_share() from ha_archive.cc to ha_archive.h and marked it virtual. This was an effort to get UBSAN to work with loaded storage engines. I kept the change as the new place is better. - Added in CONNECT engine COLBLK::SetName(), to get around a wrong cast in tabutil.cpp. - Added HAVE_REPLICATION around usage of rgi_slave, to get embedded server to compile with UBSAN. (Patch from Marko). - Added #ifdef for powerpc64 to avoid a bug in old gcc versions related to integer arithmetic. Changes that should not be needed but had to be done to suppress warnings from UBSAN: - Added static_cast<<uint16_t>> around shift to get rid of a LOT of compiler warnings when using UBSAN. - Had to change some '/' of 2 base integers to shift to get rid of some compile time warnings. Reviewed by: - Json changes: Alexey Botchkov - Charset changes in ctype-uca.c: Alexander Barkov - InnoDB changes & Embedded server: Marko Mäkelä - sql_acl.cc changes: Vicențiu Ciorbaru - build_explain() changes: Sergey Petrunia
* | | Merge 10.3 into 10.4Marko Mäkelä2021-03-312-0/+31
|\ \ \ | |/ /
| * | Merge 10.2 into 10.3Marko Mäkelä2021-03-312-0/+8
| |\ \ | | |/
| | * MDEV-25457 CREATE / DROP PROCEDURE not logged with audit plugin.Alexey Botchkov2021-03-292-0/+25
| | | | | | | | | | | | CREATE/DROP PROCEDIRE/FUNCTION is now treated as DDL.
| * | MDEV-25457 CREATE / DROP PROCEDURE not logged with audit plugin.Alexey Botchkov2021-03-272-0/+23
| | | | | | | | | | | | CREATE/DROP PROCEDIRE/FUNCTION is now treated as DDL.
* | | Merge 10.3 into 10.4Marko Mäkelä2021-03-052-0/+4
|\ \ \ | |/ /
| * | MDEV-24965 With ALTER USER ...IDENTIFIED BY command, password doesn't ↵Alexey Botchkov2021-03-011-1/+1
| | | | | | | | | | | | | | | | | | replaced by asterisks in audit log. Test result fixed.
| * | MDEV-24965 With ALTER USER ...IDENTIFIED BY command, password doesn't ↵Alexey Botchkov2021-02-262-0/+4
| | | | | | | | | | | | | | | | | | replaced by asterisks in audit log. Check for the ALTER USER command added.
* | | Merge 10.3 into 10.4Marko Mäkelä2021-01-112-1/+5
|\ \ \ | |/ /
| * | Merge 10.2 into 10.3 (except MDEV-17556)Marko Mäkelä2021-01-112-1/+5
| |\ \ | | |/ | | | | | | | | | | | | The fix of MDEV-17556 (commit e25623e78a3efde05e30070dc7362f8dc0d8c459 and commit 61a362c9493df63dc588fcb71409537ae56ab9c8) has been omitted due to conflicts and will have to be applied separately later.
| | * MDEV-19442 server_audit plugin doesn't consider proxy users in ↵Alexey Botchkov2020-12-282-1/+5
| | | | | | | | | | | | | | | | | | | | | server_audit_excl_users/server_audit_incl_users. Check the proxy user just as the connection user against the incl_users_list and excl_users_list.
* | | Merge 10.3 into 10.4Marko Mäkelä2020-12-231-1/+1
|\ \ \ | |/ /
| * | Merge 10.2 into 10.3Marko Mäkelä2020-12-231-1/+1
| |\ \ | | |/
| | * MDEV-24318 server_audit doesn't respect filters for PROXY_CONNECTAlexey Botchkov2020-12-011-1/+1
| | | | | | | | | | | | | | | | | | events. The log line should be added behind the filters.
| | * MDEV-19443 server_audit plugin doesn't log proxy users.Alexey Botchkov2020-10-232-1/+75
| | | | | | | | | | | | PROXY_USER event added.
* | | Merge 10.3 into 10.4Marko Mäkelä2020-10-292-1/+75
|\ \ \ | |/ /
| * | MDEV-19443 server_audit plugin doesn't log proxy users.Alexey Botchkov2020-10-232-1/+75
| | | | | | | | | | | | | | | | | | | | | PROXY_USER event added. Conflicts: plugin/server_audit/server_audit.c
* | | Merge 10.3 into 10.4Marko Mäkelä2020-07-312-1/+3
|\ \ \ | |/ /
| * | Merge 10.2 into 10.3Marko Mäkelä2020-07-312-1/+3
| |\ \ | | |/
| | * MDEV-21258: Can't uninstall plugin if the library file doesn't existOleksandr Byelkin2020-07-292-1/+3
| | | | | | | | | | | | Removing plugin from the mysql.plugin even if the plugin is not loaded
* | | MDEV-21928 ALTER USER doesn't remove excess authentication plugins from ↵Sergei Golubchik2020-04-272-0/+24
| | | | | | | | | | | | | | | | | | | | | mysql.global_priv only use auth1 update (no "auth_or":[]) array, if there was no "auth_or" array in the json yet.
* | | more verbose testsSergei Golubchik2020-04-271-0/+2
| | |
* | | Merge 10.3 into 10.4Marko Mäkelä2020-04-162-21/+28
|\ \ \ | |/ / | | | | | | | | | | | | | | | In main.index_merge_myisam we remove the test that was added in commit a2d24def8cc42d27c72d833abfb39ef24a2b96ba because it duplicates the test case that was added in commit 5af12e463549e4bbc2ce6ab720d78937d5e5db4e.
| * | Merge 10.2 into 10.3Marko Mäkelä2020-04-152-21/+31
| |\ \ | | |/
| | * MDEV-21599 - plugins.server_audit fails sporadically in buildbotSergey Vojtovich2020-04-102-19/+29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed a couple of race conditions in the test case to ensure stable order of events. Also removed all sleeps. Test execution time is down from 18s to 0.15s. On disconnect audit event is triggered after control is returned to mysqltest client. Which means mysqltest may issue more commands concurrently before disconnect is actually logged. Similar problem happens with regular query execution: an event is triggered after control is returner to the client. Which may end up with unstable order of events in different connections. Delayed insert rows are enqueued separately and can either be combined into single event or go as separate events. Reduced number of inserted rows to 1 to stabilize result. Also backported 2b3f6ab from 10.5.
| | * MDEV-20604: Duplicate key value is silently truncated to 64 characters in ↵Oleksandr Byelkin2020-04-011-2/+2
| | | | | | | | | | | | | | | | | | print_keydup_error Added indication of truncated string for "s" and "M" formats
* | | MDEV-21599 plugins.server_audit fails sporadically in buildbotSergei Golubchik2020-03-141-0/+3
| | |
* | | Merge branch '10.3' into 10.4Oleksandr Byelkin2020-02-112-19/+19
|\ \ \ | |/ /
| * | MDEV-20076: SHOW GRANTS does not quote role names properlybb-10.3-MDEV-20076Oleksandr Byelkin2020-02-051-1/+1
| | | | | | | | | | | | Quotes added to output.
* | | Fixed that mtr --extern works againMonty2020-01-061-1/+1
| | |