init_connect.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:1k
- #
- # Test of init_connect variable
- #
- connect (con0,localhost,root,,);
- connection con0;
- select hex(@a);
- connect (con1,localhost,user_1,,);
- connection con1;
- select hex(@a);
- connection con0;
- set global init_connect="set @a=2;set @b=3";
- connect (con2,localhost,user_1,,);
- connection con2;
- select @a, @b;
- connection con0;
- set GLOBAL init_connect=DEFAULT;
- connect (con3,localhost,user_1,,);
- connection con3;
- select @a;
- connection con0;
- set global init_connect="create table t1(a char(10));
- insert into t1 values (' ');insert into t1 values('abc')";
- connect (con4,localhost,user_1,,);
- connection con4;
- select hex(a) from t1;
- connection con0;
- set GLOBAL init_connect="adsfsdfsdfs";
- connect (con5,localhost,user_1,,);
- connection con5;
- --error 2013,2006
- select @a;
- connection con0;
- drop table t1;
- # End of 4.1 tests