An error occurred fetching the project authors.
- 06 Feb, 2006 2 commits
-
-
unknown authored
mysql-test/t/rpl_create_database.test: Updated to pass when other default engines are being used mysql-test/r/rpl_create_database.result: Updated to pass when other default engines are being used mysql-test/t/rpl_row_func003-slave.opt: new opt file to enusre innodb on slave mysql-test/t/rpl_replicate_do.test: Updated with order by for use during ndb testing mysql-test/r/rpl_replicate_do.result: Updated with order by for use during ndb testing mysql-test/t/rpl_redirect.test: updated with order by mysql-test/r/rpl_redirect.result: updated with order by mysql-test/t/rpl_ndb_func003.test: New func003 wrapper to use NDB engine for table creation mysql-test/r/rpl_ndb_func003.result: New func003 wrapper to use NDB engine for table creation mysql-test/r/rpl_row_sp001.result: updated with order by mysql-test/t/rpl_row_sp001.test: updated with order by BitKeeper/deleted/.del-rpl_row_log.test~f6ed1be9e3ca110f: Delete: mysql-test/extra/rpl_tests/rpl_row_log.test mysql-test/extra/rpl_tests/rpl_log.test: Updated test to ensure that MyISAM, and innodb engines passed even if NDB was used as default engine. Due to diff in bin log output between MyISAM, InnoDB and NDB the file had to use different wrappers and results files. mysql-test/t/rpl_row_log.test: part of rpl_log.test check in mysql-test/r/rpl_row_log.result: part of rpl_log.test check in mysql-test/r/rpl_row_log_innodb.result: part of rpl_log.test check in mysql-test/t/rpl_row_log_innodb-master.opt: part of rpl_log.test check in mysql-test/t/rpl_row_log_innodb-slave.opt: part of rpl_log.test check in mysql-test/t/rpl_row_log_innodb.test: part of rpl_log.test check in mysql-test/r/rpl_ndb_log.result: part of rpl_log.test check in mysql-test/t/rpl_ndb_log.test: part of rpl_log.test check in mysql-test/t/rpl_ndb_log-master.opt: part of rpl_log.test check in mysql-test/t/disabled.def: Updated with MySQL Bugs: #17158
-
unknown authored
mysql-test/r/trigger-grant.result: Updated result file: use TRIGGER instead of SUPER for BUG#15166/15196 tests. sql/item.cc: Updated according to the 5.1 data structures.
-
- 05 Feb, 2006 1 commit
-
-
unknown authored
mysql-test/t/disabled.def: ndb_blob.test works again, sort of storage/ndb/include/ndbapi/NdbBlob.hpp: better getNull & replace+tinyblob forward-patch from 5.0 storage/ndb/src/ndbapi/NdbBlob.cpp: better getNull & replace+tinyblob forward-patch from 5.0 storage/ndb/test/ndbapi/test_event.cpp: getEvent()->getTable() sql/ha_ndbcluster.cc: return more error codes from blob calls sql/ha_ndbcluster_binlog.cc: return more error codes from blob calls storage/ndb/src/ndbapi/NdbEventOperationImpl.cpp: return more error codes from blob calls storage/ndb/src/ndbapi/NdbDictionaryImpl.cpp: copy and invalidate blob tables as part of main table. TODO: do not cache blob tables storage/ndb/src/ndbapi/NdbDictionaryImpl.hpp: copy and invalidate blob tables as part of main table. TODO: do not cache blob tables
-
- 03 Feb, 2006 3 commits
-
-
unknown authored
-
unknown authored
mysql-test/t/rpl_relay_space_myisam.test: Added Comment mysql-test/t/rpl_ndb_relay_space.test: Added more comments BitKeeper/deleted/.del-rpl_relay_space_ndb.result~4d6013c0afef9b5e: Delete: mysql-test/r/rpl_relay_space_ndb.result mysql-test/t/rpl_relay_space_innodb.test: Added Comment BitKeeper/deleted/.del-rpl000006.test~6da9f1808deb79c7: Delete: mysql-test/t/rpl000006.test BitKeeper/deleted/.del-rpl000004.test~61532b03f9ad2734: Delete: mysql-test/t/rpl000004.test BitKeeper/deleted/.del-rpl000004.result~a3147834a662043a: Delete: mysql-test/r/rpl000004.result mysql-test/t/rpl_mixed_ddl_dml.test: Rename: mysql-test/t/rpl000002.test -> mysql-test/t/rpl_mixed_ddl_dml.test mysql-test/r/rpl_mixed_ddl_dml.result: Rename: mysql-test/r/rpl000002.result -> mysql-test/r/rpl_mixed_ddl_dml.result mysql-test/t/rpl_ignore_table_update.test: Rename: mysql-test/t/rpl000008.test -> mysql-test/t/rpl_ignore_table_update.test mysql-test/t/rpl_ignore_table_update-slave.opt: Rename: mysql-test/t/rpl000008-slave.opt -> mysql-test/t/rpl_ignore_table_update-slave.opt mysql-test/r/rpl_ignore_table_update.result: Rename: mysql-test/r/rpl000008.result -> mysql-test/r/rpl_ignore_table_update.result mysql-test/t/rpl_load_table_from_master.test: Fixing test since test where combined mysql-test/r/rpl_load_table_from_master.result: Updated results file BitKeeper/deleted/.del-rpl000004.a.result~3415f066cb91c460: Delete: mysql-test/r/rpl000004.a.result BitKeeper/deleted/.del-rpl000004.b.result~352b35351551485: Delete: mysql-test/r/rpl000004.b.result mysql-test/t/disabled.def: added rpl_ndb_relay_space Results are not deterministic mysql-test/t/rpl_load_from_master.test: Rename: mysql-test/t/rpl000009.test -> mysql-test/t/rpl_load_from_master.test mysql-test/t/rpl_load_from_master-slave.opt: Rename: mysql-test/t/rpl000009-slave.opt -> mysql-test/t/rpl_load_from_master-slave.opt mysql-test/r/rpl_load_from_master.result: Rename: mysql-test/r/rpl000009.result -> mysql-test/r/rpl_load_from_master.result mysql-test/t/rpl_temp_table.test: Rename: mysql-test/t/rpl_000012.test -> mysql-test/t/rpl_temp_table.test mysql-test/r/rpl_temp_table.result: Rename: mysql-test/r/rpl_000012.result -> mysql-test/r/rpl_temp_table.result
-
unknown authored
mysql-test/t/rpl000004.test: Updated test so it would not fail when MyISAM was not default Engine mysql-test/r/rpl000004.result: Updated test so it would not fail when MyISAM was not default Engine mysql-test/extra/rpl_tests/rpl000006.test: Updated test so that it would not fail when other engines are set as default engine mysql-test/r/rpl000006.result: Updated test so that it would not fail when other engines are set as default engine mysql-test/r/rpl_relay_space_myisam.result: Rename: mysql-test/r/rpl000005.result -> mysql-test/r/rpl_relay_space_myisam.result mysql-test/extra/rpl_tests/rpl_sv_relay_space.test: Had to split the test cases out to use for each engine. Reason being that the data goes applies to ndb in different order. So it has to have its own result file and I want to ensure that it is not used for other tests when ndb is used as default engine. Old test case was called rpl000009.test, so it was renamed as well to give the test more meaning mysql-test/t/rpl_relay_space_innodb-master.opt: Wrapper for old test case called rpl000009.test mysql-test/t/rpl_relay_space_innodb-slave.opt: Wrapper for old test case called rpl000009.test mysql-test/t/rpl_relay_space_innodb.test: Wrapper for old test case called rpl000009.test mysql-test/t/rpl_relay_space_myisam.test: Wrapper for old test case called rpl000009.test mysql-test/t/rpl_ndb_relay_space.test: Wrapper for old test case called rpl000009.test mysql-test/r/rpl_ndb_relay_space.result: Result file for wrapper for old test case called rpl000009.test mysql-test/r/rpl_relay_space_innodb.result: Result file for wrapper for old test case called rpl000009.test mysql-test/r/rpl_relay_space_ndb.result: Result file for wrapper for old test case called rpl000009.test mysql-test/t/rpl000009.test: updated to work when ndb is default engine mysql-test/r/rpl000009.result: updated to work when ndb is default engine mysql-test/t/rpl_LD_INFILE.test: Plan test cleanup mysql-test/r/rpl_LD_INFILE.result: Plan test cleanup mysql-test/t/rpl_auto_increment-slave.opt: needed to ensure test does not fail if default engine is specified mysql-test/extra/rpl_tests/rpl_auto_increment.test: Sorry, forgot to cleanup from debugging mysql-test/t/rpl_ndb_auto_inc.test: New wrapper for NDB mysql-test/t/rpl_ndb_auto_inc-master.opt: New wrapper for NDB mysql-test/r/rpl_ndb_auto_inc.result: New wrapper for NDB mysql-test/t/disabled.def: Updated
-
- 02 Feb, 2006 6 commits
-
-
unknown authored
enable extra logging in ndb handler during test runs mysql-test/mysql-test-run.pl: enable extra logging in ndb handler during test runs sql/ha_ndbcluster_binlog.cc: added more logging in ndb handler
-
unknown authored
-
unknown authored
-
unknown authored
privilege". Corrected addition of TRIGGER privilege by "mysql_fix_privilege_tables" script. Problem with it should have been caught by system_mysql_db/system_mysql_db_fix tests but they were disabled. Enabled them back. mysql-test/r/system_mysql_db.result: Updated test results after addition of TRIGGER privilege. mysql-test/t/disabled.def: Enabled back test system_mysql_db/system_mysql_db_fix tests. scripts/mysql_fix_privilege_tables.sql: Corrected addition of TRIGGER privilege.
-
unknown authored
-
unknown authored
mysql-test/t/disabled.def: disabling new test that was added during null-merge from 5.0 the new test innodb_unsafe_binlog will be re-enabled when the 5.1 snapshot for InnoDB is applied. Disabling test rather than removing files to make future merges easier (removing the files would cause merge conflicts when the files are re-added in the 5.1 snapshot).
-
- 01 Feb, 2006 11 commits
-
-
unknown authored
mysql-test/r/ndb_dd_dump.result: New BitKeeper file ``mysql-test/r/ndb_dd_dump.result'' mysql-test/t/ndb_dd_dump.test: New BitKeeper file ``mysql-test/t/ndb_dd_dump.test''
-
unknown authored
-
unknown authored
When we add new privilege we should update mysql-test/lib/init_db.sql accordingly. mysql-test/lib/init_db.sql: Added TRIGGER privilege. sql/sql_acl.h: Updated comment describing process of addition of new privileges - added yet another script place which should be modified when new privilege is added.
-
unknown authored
fix up test cases. mysql-test/r/information_schema.result: update result for INFORMATION_SCHEMA.FILES mysql-test/r/information_schema_db.result: update result for INFORMATION_SCHEMA.FILES sql/ha_ndbcluster.cc: in fill_files_table, use my_snprintf instead of snprintf sql/sql_show.cc: correct DBUG_ENTER for fill_schema_files sql/table.h: add SCH_FILES to information schema enum
-
unknown authored
-
unknown authored
corrected test case
-
unknown authored
-
unknown authored
Implement table-level TRIGGER privilege to control access to triggers. Before this path global SUPER privilege was used for this purpose, that was the big security problem. In details, before this patch SUPER privilege was required: - for the user at CREATE TRIGGER time to create a new trigger; - for the user at DROP TRIGGER time to drop the existing trigger; - for the definer at trigger activation time to execute the trigger (if the definer loses SUPER privilege, all its triggers become unavailable); This patch changes the behaviour in the following way: - TRIGGER privilege on the subject table for trigger is required: - for the user at CREATE TRIGGER time to create a new trigger; - for the user at DROP TRIGGER time to drop the existing trigger; - for the definer at trigger activation time to execute the trigger (if the definer loses TRIGGER privilege on the subject table, all its triggers on this table become unavailable). - SUPER privilege is still required: - for the user at CREATE TRIGGER time to explicitly set the trigger definer to the user other than CURRENT_USER(). When the server works with database of the previous version (w/o TRIGGER privilege), or if the database is being upgraded from the previous versions, TRIGGER privilege is granted to whose users, who have CREATE privilege. mysql-test/r/grant.result: Updated the result file after adding TRIGGER privilege. mysql-test/r/information_schema.result: Updated the result file after adding TRIGGER privilege. mysql-test/r/lowercase_table_grant.result: Updated the result file after adding TRIGGER privilege. mysql-test/r/ps.result: Updated the result file after adding TRIGGER privilege. mysql-test/r/sp.result: Updated the result file after adding TRIGGER privilege. mysql-test/r/trigger-compat.result: Updated the result file after adding TRIGGER privilege. mysql-test/r/trigger-grant.result: Updated the result file after adding TRIGGER privilege. mysql-test/t/trigger-compat.test: Grant table-level TRIGGER privilege instead of global SUPER one. mysql-test/t/trigger-grant.test: 1. Grant table-level TRIGGER privilege instead of global SUPER one. 2. Updated the test case to check that SUPER is required to specify the user other than the current as a definer. scripts/mysql_create_system_tables.sh: Added TRIGGER privilege. scripts/mysql_fix_privilege_tables.sql: Added TRIGGER privilege. sql/sql_acl.cc: Added TRIGGER privilege. sql/sql_acl.h: Added TRIGGER privilege. sql/sql_show.cc: Added TRIGGER privilege. sql/sql_trigger.cc: Check TRIGGER privilege instead of SUPER. sql/sql_yacc.yy: Added TRIGGER privilege.
-
unknown authored
-
unknown authored
-
unknown authored
mysql-test/r/ndb_binlog_ddl_multi.result: New BitKeeper file ``mysql-test/r/ndb_binlog_ddl_multi.result'' mysql-test/t/ndb_binlog_ddl_multi.test: New BitKeeper file ``mysql-test/t/ndb_binlog_ddl_multi.test''
-
- 31 Jan, 2006 5 commits
-
-
unknown authored
-
unknown authored
-
unknown authored
add sql_mode to mysql.event WL#1034 (Internal CRON) mysql-test/lib/init_db.sql: partial fix for bug#16407 (sql_mode not regarded) add sql_mode to mysql.event mysql-test/r/system_mysql_db.result: partial fix for bug#16407 (sql_mode not regarded) add sql_mode to mysql.event scripts/mysql_create_system_tables.sh: partial fix for bug#16407 (sql_mode not regarded) add sql_mode to mysql.event scripts/mysql_fix_privilege_tables.sql: partial fix for bug#16407 (sql_mode not regarded) add sql_mode to mysql.event
-
unknown authored
-
unknown authored
-
- 30 Jan, 2006 5 commits
-
-
unknown authored
WL#1034 (Internal CRON) mysql-test/r/events.result: fix result of t/events (post-merge fix of bug #16642) mysql-test/r/system_mysql_db.result: fix result(post-merge fix of bug #16642) mysql-test/t/events.test: fix test, use --echo instead of select, fix failing create event statement sql/event_timed.cc: add a bit more debug information
-
unknown authored
This bug was fixed through other patches. This test case just shows that it is fixed. mysql-test/r/partition_hash.result: result block for bug #14524 mysql-test/t/partition_hash.test: test block for bug# 14524
-
unknown authored
mysql-test/r/ndb_restore.result: removed test printout not used mysql-test/t/ndb_restore.test: removed test printout not used
-
unknown authored
when executed using the Perl version of mysql-test-run. mysql-test/t/rpl_row_basic_11bugs-master.opt: Removing extreneous semicolon
-
unknown authored
post-review change - use pointer instead of copy on the stack. WL#1034 (Internal CRON) This patch adds INFORMATION_SCHEMA.EVENTS table with the following format: EVENT_CATALOG - MYSQL_TYPE_STRING (Always NULL) EVENT_SCHEMA - MYSQL_TYPE_STRING (the database) EVENT_NAME - MYSQL_TYPE_STRING (the name) DEFINER - MYSQL_TYPE_STRING (user@host) EVENT_BODY - MYSQL_TYPE_STRING (the body from mysql.event) EVENT_TYPE - MYSQL_TYPE_STRING ("ONE TIME" | "RECURRING") EXECUTE_AT - MYSQL_TYPE_TIMESTAMP (set for "ONE TIME" otherwise NULL) INTERVAL_VALUE - MYSQL_TYPE_LONG (set for RECURRING otherwise NULL) INTERVAL_FIELD - MYSQL_TYPE_STRING (set for RECURRING otherwise NULL) SQL_MODE - MYSQL_TYPE_STRING (for now NULL) STARTS - MYSQL_TYPE_TIMESTAMP (starts from mysql.event) ENDS - MYSQL_TYPE_TIMESTAMP (ends from mysql.event) STATUS - MYSQL_TYPE_STRING (ENABLED | DISABLED) ON_COMPLETION - MYSQL_TYPE_STRING (NOT PRESERVE | PRESERVE) CREATED - MYSQL_TYPE_TIMESTAMP LAST_ALTERED - MYSQL_TYPE_TIMESTAMP LAST_EXECUTED - MYSQL_TYPE_TIMESTAMP EVENT_COMMENT - MYSQL_TYPE_STRING SQL_MODE is NULL for now, because the value is still not stored in mysql.event . Support will be added as a fix for another bug. This patch also adds SHOW [FULL] EVENTS [FROM db] [LIKE pattern] 1. SHOW EVENTS shows always only the events on the same user, because the PK of mysql.event is (definer, db, name) several users may have event with the same name -> no information disclosure. 2. SHOW FULL EVENTS - shows the events (in the current db as SHOW EVENTS) of all users. The user has to have PROCESS privilege, if not then SHOW FULL EVENTS behave like SHOW EVENTS. 3. If [FROM db] is specified then this db is considered. 4. Event names can be filtered with LIKE pattern. SHOW EVENTS returns table with the following columns, which are subset of the data which is returned by SELECT * FROM I_S.EVENTS Db Name Definer Type Execute at Interval value Interval field Starts Ends Status mysql-test/lib/init_db.sql: change the PK - (definer, db, name) quicker searches when SHOW EVENTS; allow also different users to have events with the same name -> no information disclosure mysql-test/r/events.result: result of new tests mysql-test/r/information_schema.result: result of new tests mysql-test/r/information_schema_db.result: result of new tests mysql-test/r/system_mysql_db.result: result of new tests mysql-test/t/events.test: new tests for information_schema.events scripts/mysql_create_system_tables.sh: change the PK of mysql.event to (definer, db, name) scripts/mysql_fix_privilege_tables.sql: change the PK of mysql.event to (definer, db, name) sql/event.cc: pass around the definer of the event because of the new PK which is (definer, db, name). It's needed for index searching. sql/event.h: - make enum evex_table_field again public so it can be used in sql_show.cc - make created and modified ulonglong, because they should be such - make public evex_open_event_table so it can be used in sql_show.cc sql/event_executor.cc: - cosmetics sql/event_priv.h: - moved enum evex_table_field and evex_open_event_table() to event.h (made them therefore public) sql/event_timed.cc: - in event_timed::init_definer() always fill this.definer with the concatenated value of definer_user@definer_host. Makes later the work easier. - pass around the definer wherever is needed for searching (new prototype of evex_db_find_evex_aux) sql/mysqld.cc: - add counter for SHOW EVENTS sql/sql_lex.h: - register SHOW EVENTS as command sql/sql_parse.cc: - handle SCH_EVENTS (I_S.EVENTS like SCH_TRIGGERS) - make additional check in case of SHOW EVENTS (check for EVENT on the current database. if it is null check_access() gives appropriate message back. sql/sql_show.cc: - add INFORMATION_SCHEMA.EVENTS and SHOW EVENTS - I_S.EVENTS.SQL_MODE is NULL for now -> not implemented. Trudy asked to be added so bug #16642 can be completely closed. There is another bug report which will fix the lack of storage of SQL_MODE during event creation. sql/sql_yacc.yy: - always call event_timed::init_definer() when CREATE/ALTER/DROP EVENT but not when just compiling the body of the event because in this case this operation is not needed, it takes memory and CPU time and at the end the result is not used. event_timed::definer is used only on SQLCOM_CREATE/ALTER/DROP_EVENT execution not on statement compilation. - add SHOW [FULL] EVENTS [FROM db] [LIKE pattern] in case of FULL and the user has PROCESS privilege then he will see also others' events in the current database, otherwise the output is the same as of SHOW EVENTS. Because the events are per DB only the events from the current database are shown. pattern is applied against event name. FROM db is self explanatory. sql/table.h: add SCH_EVENTS as part of INFORMATION_SCHEMA
-
- 29 Jan, 2006 1 commit
-
-
unknown authored
Final patch ----------- This WL is about using this bitmap in all parts of the partition handler. Thus for: rnd_init/rnd_next index_init/index_next and all other variants of index scans read_range_... the various range scans implemented in the partition handler. Also use those bitmaps in the various other calls that currently loop over all partitions. mysql-test/r/partition_pruning.result: WL# 2986 New results reflecting bitmap being used to determine if a partition is to be included mysql-test/t/partition_pruning.test: WL# 2986 New tests to show bitmap being used in ha_partition sql/ha_partition.cc: WL# 2986 Used work from 2682 and removed the partition select code. Added do {} while loop to any iteration over partitions to now utilise m_part_info->used_partitions bitmap to determine if a partition should be used. sql/ha_partition.h: WL# 2986 Removed unused member sql/handler.h: WL# 2986 Removed unused member sql/opt_range.cc: WL# 2986 Added bitmap_clear_all to clear bitmap prior to pruning DBUG code for testing sql/sql_partition.cc: WL# 2986 Changed < to <=, which fixes the problem with edge cases going awry.
-
- 27 Jan, 2006 2 commits
-
-
unknown authored
mysql-test/t/disabled.def: blobs: set_null is not enough, must also set empty buffer sql/ha_ndbcluster.cc: blobs: set_null is not enough, must also set empty buffer
-
unknown authored
It is ok for a partitioned table to have only 1 partition. This test is just to show that doing the ALTER TABLE ADD PARTITION doesn't crash the server. partition_mgm_err.result: Added result block for test of bug #15820 partition_mgm_err.test: Added test block for bug #15820 mysql-test/t/partition_mgm_err.test: Added test block for bug #15820 mysql-test/r/partition_mgm_err.result: Added result block for test of bug #15820
-
- 26 Jan, 2006 4 commits
-
-
unknown authored
WL#1034 (Internal CRON) mysql-test/lib/init_db.sql: fix for bug #16401, varchar -> char mysql-test/r/system_mysql_db.result: fix the result of the test after pull (currently system_mysql_db is disabled)
-
unknown authored
WL#1034 (Internal CRON) (not interesting for the Changelog) mysql-test/r/events.result: update result mysql-test/t/events.test: update test after pull after comit of fix for bug 16419
-
unknown authored
WL #1034 (Internal CRON) mysql-test/r/events.result: update test result mysql-test/t/events.test: add tests sql/event_timed.cc: - remove stupid check of val_int() - fix for bug #16419 (Events: can't use timestamp in the schedule) => don't use val_int() but only get_date() and use the date! sql/share/errmsg.txt: - fix an error message, one more "einen" sql/sql_yacc.yy: - handle new return value of event_timed::init_execute_at()
-
unknown authored
Remove implicit limit for query word number. mysql-test/r/fulltext.result: Reoder results. storage/myisam/ft_boolean_search.c: Remove implicit limit for query word number. Instead compute number of elements and allocate exactly needed memory.
-