Gecko [ www.jdcpatala.org ]

Name	Size	Permission
all_sys_objects_exist.result	4.66 KB	-rw-r--r--
fn_extract_schema_from_file_na...	261 B	-rw-r--r--
fn_extract_table_from_file_nam...	256 B	-rw-r--r--
fn_format_bytes.result	993 B	-rw-r--r--
fn_format_path.result	1.04 KB	-rw-r--r--
fn_format_statement.result	627 B	-rw-r--r--
fn_format_time.result	1.45 KB	-rw-r--r--
fn_list_add.result	1 KB	-rw-r--r--
fn_list_drop.result	1.27 KB	-rw-r--r--
fn_ps_is_account_enabled.resul...	541 B	-rw-r--r--
fn_ps_is_consumer_enabled.resu...	1.94 KB	-rw-r--r--
fn_ps_is_instrument_default_en...	2.28 KB	-rw-r--r--
fn_ps_is_instrument_default_ti...	2.22 KB	-rw-r--r--
fn_ps_is_thread_instrumented.r...	558 B	-rw-r--r--
fn_ps_thread_account.result	370 B	-rw-r--r--
fn_ps_thread_id.result	273 B	-rw-r--r--
fn_ps_thread_trx_info.result	4.58 KB	-rw-r--r--
fn_quote_identifier.result	531 B	-rw-r--r--
fn_sys_get_config.result	294 B	-rw-r--r--
mysqldump.result	2.4 KB	-rw-r--r--
pr_create_synonym_db.result	1.66 KB	-rw-r--r--
pr_diagnostics.result	883 B	-rw-r--r--
pr_execute_prepared_stmt.resul...	674 B	-rw-r--r--
pr_ps_setup_reset_to_default.r...	2.58 KB	-rw-r--r--
pr_ps_setup_show_disabled.resu...	6.77 KB	-rw-r--r--
pr_ps_setup_show_disabled_cons...	612 B	-rw-r--r--
pr_ps_setup_show_disabled_inst...	1.75 KB	-rw-r--r--
pr_ps_setup_show_enabled.resul...	14.27 KB	-rw-r--r--
pr_ps_setup_show_enabled_consu...	751 B	-rw-r--r--
pr_ps_setup_show_enabled_instr...	5.8 KB	-rw-r--r--
pr_ps_trace_statement_digest.r...	1.28 KB	-rw-r--r--
pr_statement_performance_analy...	12.39 KB	-rw-r--r--
pr_table_exists.result	822 B	-rw-r--r--
t_sys_config.result	1.69 KB	-rw-r--r--
v_host_summary.result	1.06 KB	-rw-r--r--
v_host_summary_by_file_io.resu...	403 B	-rw-r--r--
v_host_summary_by_file_io_type...	586 B	-rw-r--r--
v_host_summary_by_stages.resul...	562 B	-rw-r--r--
v_host_summary_by_statement_la...	889 B	-rw-r--r--
v_host_summary_by_statement_ty...	998 B	-rw-r--r--
v_innodb_buffer_stats_by_schem...	658 B	-rw-r--r--
v_innodb_buffer_stats_by_table...	710 B	-rw-r--r--
v_innodb_lock_waits.result	2.23 KB	-rw-r--r--
v_io_by_thread_by_latency.resu...	794 B	-rw-r--r--
v_io_global_by_file_by_bytes.r...	821 B	-rw-r--r--
v_io_global_by_file_by_latency...	915 B	-rw-r--r--
v_io_global_by_wait_by_bytes.r...	1.12 KB	-rw-r--r--
v_io_global_by_wait_by_latency...	1.21 KB	-rw-r--r--
v_latest_file_io.result	495 B	-rw-r--r--
v_memory_by_host_by_current_by...	704 B	-rw-r--r--
v_memory_by_thread_by_current_...	794 B	-rw-r--r--
v_memory_by_user_by_current_by...	704 B	-rw-r--r--
v_memory_global_by_current_byt...	730 B	-rw-r--r--
v_memory_global_total.result	283 B	-rw-r--r--
v_metrics.result	202 B	-rw-r--r--
v_processlist.result	2.21 KB	-rw-r--r--
v_ps_check_lost_instrumentatio...	199 B	-rw-r--r--
v_ps_digest_95th_percentile_by...	718 B	-rw-r--r--
v_ps_digest_avg_latency_distri...	652 B	-rw-r--r--
v_ps_schema_table_statistics_i...	1.96 KB	-rw-r--r--
v_schema_auto_increment_column...	8.04 KB	-rw-r--r--
v_schema_index_statistics.resu...	1.06 KB	-rw-r--r--
v_schema_object_overview.resul...	189 B	-rw-r--r--
v_schema_redundant_indexes.res...	1.29 KB	-rw-r--r--
v_schema_table_lock_waits.resu...	2.73 KB	-rw-r--r--
v_schema_table_statistics.resu...	1.64 KB	-rw-r--r--
v_schema_table_statistics_with...	2.2 KB	-rw-r--r--
v_schema_tables_with_full_tabl...	2.2 KB	-rw-r--r--
v_schema_unused_indexes.result	213 B	-rw-r--r--
v_session.result	2.19 KB	-rw-r--r--
v_session_ssl_status.result	259 B	-rw-r--r--
v_statement_analysis.result	1.93 KB	-rw-r--r--
v_statements_with_errors_or_wa...	998 B	-rw-r--r--
v_statements_with_full_table_s...	4.18 KB	-rw-r--r--
v_statements_with_runtimes_in_...	1.45 KB	-rw-r--r--
v_statements_with_sorting.resu...	1.22 KB	-rw-r--r--
v_statements_with_temp_tables....	1.09 KB	-rw-r--r--
v_user_summary.result	1.06 KB	-rw-r--r--
v_user_summary_by_file_io.resu...	403 B	-rw-r--r--
v_user_summary_by_file_io_type...	574 B	-rw-r--r--
v_user_summary_by_stages.resul...	562 B	-rw-r--r--
v_user_summary_by_statement_la...	883 B	-rw-r--r--
v_user_summary_by_statement_ty...	998 B	-rw-r--r--
v_version.result	55 B	-rw-r--r--
v_wait_classes_global_by_avg_l...	681 B	-rw-r--r--
v_wait_classes_global_by_laten...	665 B	-rw-r--r--
v_waits_by_host_by_latency.res...	630 B	-rw-r--r--
v_waits_by_user_by_latency.res...	630 B	-rw-r--r--
v_waits_global_by_latency.resu...	572 B	-rw-r--r--
version_functions.result	222 B	-rw-r--r--

Code Editor : pr_create_synonym_db.result

CREATE TABLE t1 (t1_id int PRIMARY KEY, t1_val varchar(10));
CREATE TABLE t2 (t2_id int PRIMARY KEY, t1_id int, t2_val int, INDEX (t1_id));
CREATE TABLE `is` (t1_id int PRIMARY KEY, t1_val varchar(10));
CREATE TABLE `ab``c` (t1_id int PRIMARY KEY, t1_val varchar(10));
CREATE SQL SECURITY INVOKER VIEW myview AS SELECT * FROM t1 NATURAL JOIN t2;
CALL sys.create_synonym_db('test', 'test1');
summary
Created 5 views in the `test1` database
SELECT TABLE_NAME, SECURITY_TYPE FROM information_schema.VIEWS WHERE TABLE_SCHEMA = 'test1' ORDER BY TABLE_NAME;
TABLE_NAME	SECURITY_TYPE
ab`c	INVOKER
is	INVOKER
myview	INVOKER
t1	INVOKER
t2	INVOKER
CALL sys.create_synonym_db('test', 'test1');
ERROR HY000: Can't create database test1; database exists
CREATE SCHEMA test2;
CALL sys.create_synonym_db('test', 'test2');
ERROR HY000: Can't create database test2; database exists
SELECT COUNT(*) FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'test2';
COUNT(*)
0
CALL sys.create_synonym_db('test', 'is');
summary
Created 5 views in the `is` database
SELECT TABLE_NAME, SECURITY_TYPE FROM information_schema.VIEWS WHERE TABLE_SCHEMA = 'is' ORDER BY TABLE_NAME;
TABLE_NAME	SECURITY_TYPE
ab`c	INVOKER
is	INVOKER
myview	INVOKER
t1	INVOKER
t2	INVOKER
CALL sys.create_synonym_db('is', 'i`s');
summary
Created 5 views in the `i``s` database
SELECT TABLE_NAME, SECURITY_TYPE FROM information_schema.VIEWS WHERE TABLE_SCHEMA = 'i`s' ORDER BY TABLE_NAME;
TABLE_NAME	SECURITY_TYPE
ab`c	INVOKER
is	INVOKER
myview	INVOKER
t1	INVOKER
t2	INVOKER
DROP SCHEMA test1;
DROP SCHEMA test2;
DROP SCHEMA `is`;
DROP SCHEMA `i``s`;
DROP VIEW test.myview;
DROP TABLE test.t1;
DROP TABLE test.t2;
DROP TABLE `is`;
DROP TABLE `ab``c`;

${this.title}

Code Editor : pr_create_synonym_db.result