~vkolesnikov/pbxt/pbxt-07-diskfull : revision 1

1

stop slave;

2

drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;

3

reset master;

4

reset slave;

5

drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;

6

start slave;

7

set timestamp=1000000000;

8

drop database if exists mysqltest2;

9

drop database if exists mysqltest3;

10

create database mysqltest2 character set latin2;

11

set @@character_set_server=latin5;

12

create database mysqltest3;

13

14

--- --master--

15

show create database mysqltest2;

16

Database Create Database

17

mysqltest2 CREATE DATABASE `mysqltest2` /*!40100 DEFAULT CHARACTER SET latin2 */

18

show create database mysqltest3;

19

Database Create Database

20

mysqltest3 CREATE DATABASE `mysqltest3` /*!40100 DEFAULT CHARACTER SET latin5 */

21

22

--- --slave--

23

show create database mysqltest2;

24

Database Create Database

25

mysqltest2 CREATE DATABASE `mysqltest2` /*!40100 DEFAULT CHARACTER SET latin2 */

26

show create database mysqltest3;

27

Database Create Database

28

mysqltest3 CREATE DATABASE `mysqltest3` /*!40100 DEFAULT CHARACTER SET latin5 */

29

set @@collation_server=armscii8_bin;

30

drop database mysqltest3;

31

create database mysqltest3;

32

33

--- --master--

34

show create database mysqltest3;

35

Database Create Database

36

mysqltest3 CREATE DATABASE `mysqltest3` /*!40100 DEFAULT CHARACTER SET armscii8 COLLATE armscii8_bin */

37

38

--- --slave--

39

show create database mysqltest3;

40

Database Create Database

41

mysqltest3 CREATE DATABASE `mysqltest3` /*!40100 DEFAULT CHARACTER SET armscii8 COLLATE armscii8_bin */

42

use mysqltest2;

43

create table t1 (a int auto_increment primary key, b varchar(100));

44

set character_set_client=cp850, collation_connection=latin2_croatian_ci;

45

insert into t1 (b) values(@@character_set_server);

46

insert into t1 (b) values(@@collation_server);

47

insert into t1 (b) values(@@character_set_client);

48

insert into t1 (b) values(@@character_set_connection);

49

insert into t1 (b) values(@@collation_connection);

50

51

--- --master--

52

select * from t1 order by a;

53

a b

54

1 armscii8

55

2 armscii8_bin

56

3 cp850

57

4 latin2

58

5 latin2_croatian_ci

59

60

--- --slave--

61

select * from mysqltest2.t1 order by a;

62

a b

63

1 armscii8

64

2 armscii8_bin

65

3 cp850

66

4 latin2

67

5 latin2_croatian_ci

68

set character_set_client=latin1, collation_connection=latin1_german1_ci;

69

truncate table t1;

70

insert into t1 (b) values(@@collation_connection);

71

insert into t1 (b) values(LEAST("M�ller","Muffler"));

72

set collation_connection=latin1_german2_ci;

73

insert into t1 (b) values(@@collation_connection);

74

insert into t1 (b) values(LEAST("M�ller","Muffler"));

75

76

--- --master--

77

select * from t1 order by a;

78

a b

79

1 latin1_german1_ci

80

2 Muffler

81

3 latin1_german2_ci

82

4 M�ller

83

84

--- --slave--

85

select * from mysqltest2.t1 order by a;

86

a b

87

1 latin1_german1_ci

88

2 Muffler

89

3 latin1_german2_ci

90

4 M�ller

91

set @a= _cp850 'M�ller' collate cp850_general_ci;

92

truncate table t1;

93

insert into t1 (b) values(collation(@a));

94

95

--- --master--

96

select * from t1 order by a;

97

a b

98

1 cp850_general_ci

99

100

--- --slave--

101

select * from mysqltest2.t1 order by a;

102

a b

103

1 cp850_general_ci

104

drop database mysqltest2;

105

drop database mysqltest3;

106

show binlog events from 102;

107

Log_name Pos Event_type Server_id End_log_pos Info

108

master-bin.000001 # Query 1 # drop database if exists mysqltest2

109

master-bin.000001 # Query 1 # drop database if exists mysqltest3

110

master-bin.000001 # Query 1 # create database mysqltest2 character set latin2

111

master-bin.000001 # Query 1 # create database mysqltest3

112

master-bin.000001 # Query 1 # drop database mysqltest3

113

master-bin.000001 # Query 1 # create database mysqltest3

114

master-bin.000001 # Query 1 # use `mysqltest2`; create table t1 (a int auto_increment primary key, b varchar(100))

115

master-bin.000001 # Intvar 1 # INSERT_ID=1

116

master-bin.000001 # Query 1 # use `mysqltest2`; insert into t1 (b) values(@@character_set_server)

117

master-bin.000001 # Intvar 1 # INSERT_ID=2

118

master-bin.000001 # Query 1 # use `mysqltest2`; insert into t1 (b) values(@@collation_server)

119

master-bin.000001 # Intvar 1 # INSERT_ID=3

120

master-bin.000001 # Query 1 # use `mysqltest2`; insert into t1 (b) values(@@character_set_client)

121

master-bin.000001 # Intvar 1 # INSERT_ID=4

122

master-bin.000001 # Query 1 # use `mysqltest2`; insert into t1 (b) values(@@character_set_connection)

123

master-bin.000001 # Intvar 1 # INSERT_ID=5

124

master-bin.000001 # Query 1 # use `mysqltest2`; insert into t1 (b) values(@@collation_connection)

125

master-bin.000001 # Query 1 # use `mysqltest2`; truncate table t1

126

master-bin.000001 # Intvar 1 # INSERT_ID=1

127

master-bin.000001 # Query 1 # use `mysqltest2`; insert into t1 (b) values(@@collation_connection)

128

master-bin.000001 # Intvar 1 # INSERT_ID=2

129

master-bin.000001 # Query 1 # use `mysqltest2`; insert into t1 (b) values(LEAST("M�ller","Muffler"))

130

master-bin.000001 # Intvar 1 # INSERT_ID=3

131

master-bin.000001 # Query 1 # use `mysqltest2`; insert into t1 (b) values(@@collation_connection)

132

master-bin.000001 # Intvar 1 # INSERT_ID=4

133

master-bin.000001 # Query 1 # use `mysqltest2`; insert into t1 (b) values(LEAST("M�ller","Muffler"))

134

master-bin.000001 # Query 1 # use `mysqltest2`; truncate table t1

135

master-bin.000001 # Intvar 1 # INSERT_ID=1

136

master-bin.000001 # User var 1 # @`a`=_cp850 0x4DFC6C6C6572 COLLATE cp850_general_ci

137

master-bin.000001 # Query 1 # use `mysqltest2`; insert into t1 (b) values(collation(@a))

138

master-bin.000001 # Query 1 # drop database mysqltest2

139

master-bin.000001 # Query 1 # drop database mysqltest3

140

set global character_set_server=latin2;

141

set global character_set_server=latin1;

142

set global character_set_server=latin2;

143

set global character_set_server=latin1;

144

set one_shot @@character_set_server=latin5;

145

set @@max_join_size=1000;

146

select @@character_set_server;

147

@@character_set_server

148

latin5

149

select @@character_set_server;

150

@@character_set_server

151

latin1

152

set @@character_set_server=latin5;

153

select @@character_set_server;

154

@@character_set_server

155

latin5

156

select @@character_set_server;

157

@@character_set_server

158

latin5

159

set one_shot max_join_size=10;

160

ERROR HY000: The 'SET ONE_SHOT' syntax is reserved for purposes internal to the MySQL server

161

set character_set_client=9999999;

162

ERROR 42000: Unknown character set: '9999999'

163

set collation_server=9999998;

164

ERROR HY000: Unknown collation: '9999998'

165

use test;

166

CREATE TABLE t1 (c1 VARBINARY(255), c2 VARBINARY(255));

167

SET CHARACTER_SET_CLIENT=koi8r,

168

CHARACTER_SET_CONNECTION=cp1251,

169

CHARACTER_SET_RESULTS=koi8r;

170

INSERT INTO t1 (c1, c2) VALUES ('��, �� ','��, �� ');

171

select hex(c1), hex(c2) from t1;

172

hex(c1) hex(c2)

173

CDF32C20E7E020F0FBE1E0EBEAF3 CDF32C20E7E020F0FBE1E0EBEAF3

174

select hex(c1), hex(c2) from t1;

175

hex(c1) hex(c2)

176

CDF32C20E7E020F0FBE1E0EBEAF3 CDF32C20E7E020F0FBE1E0EBEAF3

177

/*!40019 SET @@session.max_insert_delayed_threads=0*/;

178

/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;

179

ROLLBACK;

180

SET TIMESTAMP=1000000000;

181

SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1;

182

SET @@session.sql_mode=0;

183

/*!\C latin1 */;

184

SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8;

185

drop database if exists mysqltest2;

186

SET TIMESTAMP=1000000000;

187

drop database if exists mysqltest3;

188

SET TIMESTAMP=1000000000;

189

create database mysqltest2 character set latin2;

190

SET TIMESTAMP=1000000000;

191

/*!\C latin1 */;

192

SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=30;

193

create database mysqltest3;

194

SET TIMESTAMP=1000000000;

195

/*!\C latin1 */;

196

SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=64;

197

drop database mysqltest3;

198

SET TIMESTAMP=1000000000;

199

create database mysqltest3;

200

use mysqltest2;

201

SET TIMESTAMP=1000000000;

202

create table t1 (a int auto_increment primary key, b varchar(100));

203

SET INSERT_ID=1;

204

SET TIMESTAMP=1000000000;

205

/*!\C cp850 */;

206

SET @@session.character_set_client=4,@@session.collation_connection=27,@@session.collation_server=64;

207

insert into t1 (b) values(@@character_set_server);

208

SET INSERT_ID=2;

209

SET TIMESTAMP=1000000000;

210

insert into t1 (b) values(@@collation_server);

211

SET INSERT_ID=3;

212

SET TIMESTAMP=1000000000;

213

insert into t1 (b) values(@@character_set_client);

214

SET INSERT_ID=4;

215

SET TIMESTAMP=1000000000;

216

insert into t1 (b) values(@@character_set_connection);

217

SET INSERT_ID=5;

218

SET TIMESTAMP=1000000000;

219

insert into t1 (b) values(@@collation_connection);

220

SET TIMESTAMP=1000000000;

221

/*!\C latin1 */;

222

SET @@session.character_set_client=8,@@session.collation_connection=5,@@session.collation_server=64;

223

truncate table t1;

224

SET INSERT_ID=1;

225

SET TIMESTAMP=1000000000;

226

insert into t1 (b) values(@@collation_connection);

227

SET INSERT_ID=2;

228

SET TIMESTAMP=1000000000;

229

insert into t1 (b) values(LEAST("M�ller","Muffler"));

230

SET INSERT_ID=3;

231

SET TIMESTAMP=1000000000;

232

/*!\C latin1 */;

233

SET @@session.character_set_client=8,@@session.collation_connection=31,@@session.collation_server=64;

234

insert into t1 (b) values(@@collation_connection);

235

SET INSERT_ID=4;

236

SET TIMESTAMP=1000000000;

237

insert into t1 (b) values(LEAST("M�ller","Muffler"));

238

SET TIMESTAMP=1000000000;

239

truncate table t1;

240

SET INSERT_ID=1;

241

SET @`a`:=_cp850 0x4DFC6C6C6572 COLLATE `cp850_general_ci`;

242

SET TIMESTAMP=1000000000;

243

insert into t1 (b) values(collation(@a));

244

SET TIMESTAMP=1000000000;

245

drop database mysqltest2;

246

SET TIMESTAMP=1000000000;

247

drop database mysqltest3;

248

use test;

249

SET TIMESTAMP=1000000000;

250

/*!\C latin1 */;

251

SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=30;

252

CREATE TABLE t1 (c1 VARBINARY(255), c2 VARBINARY(255));

253

SET TIMESTAMP=1000000000;

254

/*!\C koi8r */;

255

SET @@session.character_set_client=7,@@session.collation_connection=51,@@session.collation_server=30;

256

INSERT INTO t1 (c1, c2) VALUES ('��, �� ','��, �� ');

257

# End of log file

258

ROLLBACK /* added by mysqlbinlog */;

259

/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

260

drop table t1;

261

create table `t1` (

262

`pk` varchar(10) not null default '',

263

primary key (`pk`)

264

) engine=myisam default charset=latin1;

265

set @p=_latin1 'test';

266

update t1 set pk='test' where pk=@p;

267

drop table t1;