diff options
Diffstat (limited to 'mysql-test/suite/sql_sequence/rebuild.result')
-rw-r--r-- | mysql-test/suite/sql_sequence/rebuild.result | 147 |
1 files changed, 1 insertions, 146 deletions
diff --git a/mysql-test/suite/sql_sequence/rebuild.result b/mysql-test/suite/sql_sequence/rebuild.result index 80ac6fa34f3..6348d1775ab 100644 --- a/mysql-test/suite/sql_sequence/rebuild.result +++ b/mysql-test/suite/sql_sequence/rebuild.result @@ -5,159 +5,14 @@ CREATE SEQUENCE s1 ENGINE=InnoDB; ALTER TABLE s1 FORCE; CREATE TABLE t1 (a INT) ENGINE=MyISAM; CREATE TABLE t2 (b VARCHAR(64)) ENGINE=MyISAM; -CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 SELECT TABLE_NAME FROM INFORMATION_SCHEMA.PARTITIONS; +CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 SELECT TABLE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA='test'; INSERT INTO t1 VALUES (1); select * from t1; a 1 select * from t2; b -ALL_PLUGINS -APPLICABLE_ROLES -CHARACTER_SETS -CHECK_CONSTRAINTS -CLIENT_STATISTICS -COLLATIONS -COLLATION_CHARACTER_SET_APPLICABILITY -COLUMNS -COLUMN_PRIVILEGES -ENABLED_ROLES -ENGINES -EVENTS -FILES -GEOMETRY_COLUMNS -GLOBAL_STATUS -GLOBAL_VARIABLES -INDEX_STATISTICS -INNODB_BUFFER_PAGE -INNODB_BUFFER_PAGE_LRU -INNODB_BUFFER_POOL_STATS -INNODB_CMPMEM -INNODB_CMP_PER_INDEX -INNODB_LOCKS -INNODB_LOCK_WAITS -INNODB_METRICS -INNODB_SYS_COLUMNS -INNODB_SYS_FIELDS -INNODB_SYS_FOREIGN -INNODB_SYS_FOREIGN_COLS -INNODB_SYS_INDEXES -INNODB_SYS_TABLES -INNODB_SYS_VIRTUAL -INNODB_TRX -KEYWORDS -KEY_CACHES -KEY_COLUMN_USAGE -OPTIMIZER_TRACE -PARAMETERS -PARTITIONS -PLUGINS -PROCESSLIST -PROFILING -REFERENTIAL_CONSTRAINTS -ROUTINES -SCHEMATA -SCHEMA_PRIVILEGES -SESSION_STATUS -SESSION_VARIABLES -SPATIAL_REF_SYS -SQL_FUNCTIONS -STATISTICS -SYSTEM_VARIABLES -TABLES -TABLESPACES -TABLE_CONSTRAINTS -TABLE_PRIVILEGES -TABLE_STATISTICS -TRIGGERS -USER_PRIVILEGES -USER_STATISTICS -VIEWS -accounts -column_stats -columns_priv -cond_instances -db -event -events_stages_current -events_stages_history -events_stages_history_long -events_stages_summary_by_account_by_event_name -events_stages_summary_by_host_by_event_name -events_stages_summary_by_thread_by_event_name -events_stages_summary_by_user_by_event_name -events_stages_summary_global_by_event_name -events_statements_current -events_statements_history -events_statements_history_long -events_statements_summary_by_account_by_event_name -events_statements_summary_by_digest -events_statements_summary_by_host_by_event_name -events_statements_summary_by_thread_by_event_name -events_statements_summary_by_user_by_event_name -events_statements_summary_global_by_event_name -events_waits_current -events_waits_history -events_waits_history_long -events_waits_summary_by_account_by_event_name -events_waits_summary_by_host_by_event_name -events_waits_summary_by_instance -events_waits_summary_by_thread_by_event_name -events_waits_summary_by_user_by_event_name -events_waits_summary_global_by_event_name -file_instances -file_summary_by_event_name -file_summary_by_instance -func -general_log -global_priv -global_suppressions -gtid_slave_pos -help_category -help_keyword -help_relation -help_topic -host_cache -hosts -index_stats -innodb_index_stats -innodb_table_stats -mutex_instances -objects_summary_global_by_type -performance_timers -plugin -proc -procs_priv -proxies_priv -roles_mapping -rwlock_instances s1 -servers -session_account_connect_attrs -session_connect_attrs -setup_actors -setup_consumers -setup_instruments -setup_objects -setup_timers -slow_log -socket_instances -socket_summary_by_event_name -socket_summary_by_instance t1 t2 -table_io_waits_summary_by_index_usage -table_io_waits_summary_by_table -table_lock_waits_summary_by_table -table_stats -tables_priv -test_suppressions -threads -time_zone -time_zone_leap_second -time_zone_name -time_zone_transition -time_zone_transition_type -transaction_registry -users DROP TABLE t1, t2, s1; |