~ubuntu-branches/ubuntu/saucy/drizzle/saucy-proposed

START TRANSACTION ; CREATE TEMPORARY TABLE IF NOT EXISTS stall ( `f1` INTEGER , `connection_id` INTEGER ) ENGINE = Falcon ; INSERT INTO stall VALUES (_digit, CONNECTION_ID()) ; UPDATE stall SET f1 = f1 + 1 WHERE connection_id = CONNECTION_ID() ; SELECT IF( CONNECTION_ID() = 10 , SLEEP(1800) , 1 ) ;

serial_log_event:

blob_delete |

blob_update |

checkpoint |

commit |

create_index |

create_section |

create_tablespace |

data |

data_page |

delete |

delete_index |

drop_table |

drop_tablespace |

free_page |

index_add |

index_delete |

index_page |

index_update |

inversion_page |

overflow_pages |

prepare |

record_locator |

record_stub |

rollback |

savepoint_rollback |

section_line |

section_page |

section_promotion |

sequence |

sequence_page |

session |

switch_log |

update_blob |

update_index |

update_records |

version |

word_update

;

blob_delete:

DELETE FROM _table WHERE `col_int` = CONNECTION_ID() LIMIT 1 ;

blob_update:

INSERT INTO _table ( `col_int` , `blob` ) VALUES ( CONNECTION_ID() , _data ) |

UPDATE _table SET `blob` = _data WHERE `col_int` = CONNECTION_ID() LIMIT _digit ;

checkpoint: ;

commit:

START TRANSACTION | COMMIT | COMMIT | COMMIT | COMMIT ;

create_index:

ALTER TABLE _table ADD key_type _letter ( `col_int` ) |

ALTER TABLE _table ADD key_type _letter ( `col_char_255` ) |

ALTER TABLE _table ADD key_type _letter ( `col_char_255` ) ;

key_type:

INDEX | UNIQUE | PRIMARY KEY ;

create_section:

CREATE TABLE IF NOT EXISTS _letter (`f1` VARCHAR(255) ) ENGINE = FALCON TABLESPACE _letter ; INSERT INTO _letter SELECT _field FROM _table ;

create_tablespace:

CREATE TABLESPACE _letter ADD DATAFILE file_name ENGINE = FALCON ;

100

data: ;

101

102

data_page: ;

103

104

delete:

105

DELETE FROM _table LIMIT 1;

106

107

delete_index:

108

ALTER TABLE _table DROP INDEX _letter ;

109

110

drop_table:

111

DROP TABLE IF EXISTS _letter ;

112

113

114

# This is disabled because of bug 39138

115

116

drop_tablespace:

117

# DROP TABLESPACE _letter ENGINE = FALCON

118

;

119

120

free_page:

121

TRUNCATE TABLE _letter ;

122

123

index_add:

124

INSERT INTO _table ( `col_int` ) VALUES ( _digit ) |

125

INSERT INTO _table ( `col_char_255` ) VALUES ( _english ) ;

126

127

index_delete:

128

DELETE FROM _table LIMIT 1;

129

130

index_page:

131

INSERT INTO _table ( `col_int` ) SELECT `col_int` FROM _table LIMIT _tinyint_unsigned ;

132

133

index_update: ;

134

135

inversion_page: ;

136

137

overflow_pages:

138

insert_big_record ; insert_big_record ; insert_big_record ; insert_big_record ; insert_big_record ; insert_big_record ; insert_big_record ;

139

140

prepare: ;

141

142

record_locator: ;

143

144

record_stub: ;

145

146

rollback:

147

ROLLBACK ;

148

149

savepoint_rollback:

150

SAVEPOINT A | SAVEPOINT A | SAVEPOINT A | SAVEPOINT A |

151

ROLLBACK TO SAVEPOINT A ;

152

153

section_line: ;

154

155

section_page: ;

156

157

section_promotion: ;

158

159

sequence:

160

INSERT INTO _table (`pk`) VALUE ( NULL ) ;

161

162

sequence_page: ;

163

164

session: ;

165

166

switch_log: ;

167

168

update_blob:

169

UPDATE _table SET `blob` = _data WHERE `col_int` = CONNECTION_ID() LIMIT _digit |

170

INSERT INTO _table (`col_int`, `blob`) VALUES ( CONNECTION_ID(), _data ) ;

171

172

update_index:

173

INSERT INTO _table (`col_int`) VALUES ( _digit ) ;

174

175

update_records:

176

UPDATE _table SET `col_int` = `col_int` + 1 LIMIT 1 ;

177

178

version: ;

179

180

word_update: ;

181

182

insert_big_record:

183

INSERT INTO _table ( `col_char_255` ) VALUES ( REPEAT('x', 255) ) ;

184

185

file_name:

186

''f1'' | ''f2'' | ''f3'' | ''f4'' | ''f5'' | ''f6'' | ''f7'' | ''f8'' | ''f9'' | ''f10'' |

187

''f11'' | ''f12'' | ''f13'' | ''f14'' | ''f15'' | ''f16'' | ''f17'' | ''f18'' | ''f19'' | ''f20'' ;

Older »