| 1 |
CREATE LOGFILE GROUP lg1 |
| 2 |
ADD UNDOFILE 'undofile.dat' |
| 3 |
INITIAL_SIZE 16M |
| 4 |
UNDO_BUFFER_SIZE = 1M |
| 5 |
ENGINE=NDB; |
| 6 |
CREATE TABLESPACE ts1 |
| 7 |
ADD DATAFILE 'datafile.dat' |
| 8 |
USE LOGFILE GROUP lg1 |
| 9 |
INITIAL_SIZE 12M |
| 10 |
ENGINE NDB; |
| 11 |
create table t1 ( |
| 12 |
pk int unsigned primary key |
| 13 |
, |
| 14 |
col1 binary(1) default '@' column_format dynamic, |
| 15 |
col2 binary(1) default '@' column_format dynamic, |
| 16 |
col3 varbinary(3) default 'ABC' column_format dynamic, |
| 17 |
col4 varbinary(3) default 'ABC' column_format dynamic, |
| 18 |
col5 varbinary(3) default 'ABC' column_format dynamic, |
| 19 |
col6 varbinary(3) default 'ABC' column_format dynamic, |
| 20 |
col7 varbinary(3) default 'ABC' column_format dynamic, |
| 21 |
col8 varbinary(3) default 'ABC' column_format dynamic, |
| 22 |
col9 varbinary(3) default 'ABC' column_format dynamic, |
| 23 |
col10 varbinary(3) default 'ABC' column_format dynamic, |
| 24 |
col11 varbinary(3) default 'ABC' column_format dynamic, |
| 25 |
col12 varbinary(3) default 'ABC' column_format dynamic, |
| 26 |
col13 varbinary(3) default 'ABC' column_format dynamic, |
| 27 |
col14 varbinary(3) default 'ABC' column_format dynamic, |
| 28 |
col15 varbinary(3) default 'ABC' column_format dynamic, |
| 29 |
col16 varbinary(3) default 'ABC' column_format dynamic, |
| 30 |
col17 varbinary(3) default 'ABC' column_format dynamic, |
| 31 |
col18 varbinary(3) default 'ABC' column_format dynamic, |
| 32 |
col19 varbinary(3) default 'ABC' column_format dynamic, |
| 33 |
col20 varbinary(3) default 'ABC' column_format dynamic, |
| 34 |
col21 varbinary(3) default 'ABC' column_format dynamic, |
| 35 |
col22 varbinary(3) default 'ABC' column_format dynamic, |
| 36 |
col23 varbinary(3) default 'ABC' column_format dynamic, |
| 37 |
col24 varbinary(3) default 'ABC' column_format dynamic, |
| 38 |
col25 varbinary(3) default 'ABC' column_format dynamic, |
| 39 |
col26 varbinary(3) default 'ABC' column_format dynamic, |
| 40 |
col27 varbinary(3) default 'ABC' column_format dynamic, |
| 41 |
col28 varbinary(3) default 'ABC' column_format dynamic, |
| 42 |
col29 varbinary(3) default 'ABC' column_format dynamic, |
| 43 |
col30 varbinary(3) default 'ABC' column_format dynamic, |
| 44 |
col31 varbinary(3) default 'ABC' column_format dynamic, |
| 45 |
col32 varbinary(3) default 'ABC' column_format dynamic, |
| 46 |
col33 varbinary(3) default 'ABC' column_format dynamic, |
| 47 |
col34 varbinary(3) default 'ABC' column_format dynamic, |
| 48 |
col35 varbinary(3) default 'ABC' column_format dynamic, |
| 49 |
col36 varbinary(3) default 'ABC' column_format dynamic, |
| 50 |
col37 varbinary(3) default 'ABC' column_format dynamic, |
| 51 |
col38 varbinary(3) default 'ABC' column_format dynamic, |
| 52 |
col39 varbinary(3) default 'ABC' column_format dynamic, |
| 53 |
col40 varbinary(3) default 'ABC' column_format dynamic, |
| 54 |
col41 varbinary(3) default 'ABC' column_format dynamic, |
| 55 |
col42 varbinary(3) default 'ABC' column_format dynamic, |
| 56 |
col43 varbinary(3) default 'ABC' column_format dynamic, |
| 57 |
col44 varbinary(3) default 'ABC' column_format dynamic, |
| 58 |
col45 varbinary(3) default 'ABC' column_format dynamic, |
| 59 |
col46 varbinary(3) default 'ABC' column_format dynamic, |
| 60 |
col47 varbinary(3) default 'ABC' column_format dynamic, |
| 61 |
col48 varbinary(3) default 'ABC' column_format dynamic, |
| 62 |
col49 varbinary(3) default 'ABC' column_format dynamic, |
| 63 |
col50 varbinary(3) default 'ABC' column_format dynamic, |
| 64 |
col51 varbinary(3) default 'ABC' column_format dynamic, |
| 65 |
col52 varbinary(3) default 'ABC' column_format dynamic, |
| 66 |
col53 varbinary(3) default 'ABC' column_format dynamic, |
| 67 |
col54 varbinary(3) default 'ABC' column_format dynamic, |
| 68 |
col55 varbinary(3) default 'ABC' column_format dynamic, |
| 69 |
col56 varbinary(3) default 'ABC' column_format dynamic, |
| 70 |
col57 varbinary(3) default 'ABC' column_format dynamic, |
| 71 |
col58 varbinary(3) default 'ABC' column_format dynamic, |
| 72 |
col59 varbinary(3) default 'ABC' column_format dynamic, |
| 73 |
col60 varbinary(3) default 'ABC' column_format dynamic, |
| 74 |
col61 varbinary(3) default 'ABC' column_format dynamic, |
| 75 |
col62 varbinary(3) default 'ABC' column_format dynamic, |
| 76 |
col63 varbinary(3) default 'ABC' column_format dynamic, |
| 77 |
col64 varbinary(3) default 'ABC' column_format dynamic, |
| 78 |
col65 varbinary(3) default 'ABC' column_format dynamic, |
| 79 |
col66 varbinary(3) default 'ABC' column_format dynamic, |
| 80 |
col67 varbinary(3) default 'ABC' column_format dynamic, |
| 81 |
col68 varbinary(3) default 'ABC' column_format dynamic, |
| 82 |
col69 varbinary(3) default 'ABC' column_format dynamic, |
| 83 |
col70 varbinary(3) default 'ABC' column_format dynamic, |
| 84 |
col71 varbinary(3) default 'ABC' column_format dynamic, |
| 85 |
col72 varbinary(3) default 'ABC' column_format dynamic, |
| 86 |
col73 varbinary(3) default 'ABC' column_format dynamic, |
| 87 |
col74 varbinary(3) default 'ABC' column_format dynamic, |
| 88 |
col75 varbinary(3) default 'ABC' column_format dynamic, |
| 89 |
col76 varbinary(3) default 'ABC' column_format dynamic, |
| 90 |
col77 varbinary(3) default 'ABC' column_format dynamic, |
| 91 |
col78 varbinary(3) default 'ABC' column_format dynamic, |
| 92 |
col79 varbinary(3) default 'ABC' column_format dynamic, |
| 93 |
col80 varbinary(3) default 'ABC' column_format dynamic, |
| 94 |
col81 varbinary(3) default 'ABC' column_format dynamic, |
| 95 |
col82 varbinary(3) default 'ABC' column_format dynamic, |
| 96 |
col83 varbinary(3) default 'ABC' column_format dynamic, |
| 97 |
col84 varbinary(3) default 'ABC' column_format dynamic, |
| 98 |
col85 varbinary(3) default 'ABC' column_format dynamic, |
| 99 |
col86 varbinary(3) default 'ABC' column_format dynamic, |
| 100 |
col87 varbinary(3) default 'ABC' column_format dynamic, |
| 101 |
col88 varbinary(3) default 'ABC' column_format dynamic, |
| 102 |
col89 varbinary(3) default 'ABC' column_format dynamic, |
| 103 |
col90 varbinary(3) default 'ABC' column_format dynamic, |
| 104 |
col91 varbinary(3) default 'ABC' column_format dynamic, |
| 105 |
col92 varbinary(3) default 'ABC' column_format dynamic, |
| 106 |
col93 varbinary(3) default 'ABC' column_format dynamic, |
| 107 |
col94 varbinary(3) default 'ABC' column_format dynamic, |
| 108 |
col95 varbinary(3) default 'ABC' column_format dynamic, |
| 109 |
col96 varbinary(3) default 'ABC' column_format dynamic, |
| 110 |
col97 varbinary(3) default 'ABC' column_format dynamic, |
| 111 |
col98 varbinary(3) default 'ABC' column_format dynamic, |
| 112 |
col99 varbinary(3) default 'ABC' column_format dynamic, |
| 113 |
col100 varbinary(3) default 'ABC' column_format dynamic, |
| 114 |
col101 varbinary(3) default 'ABC' column_format dynamic, |
| 115 |
col102 varbinary(3) default 'ABC' column_format dynamic, |
| 116 |
col103 varbinary(3) default 'ABC' column_format dynamic, |
| 117 |
col104 varbinary(3) default 'ABC' column_format dynamic, |
| 118 |
col105 varbinary(3) default 'ABC' column_format dynamic, |
| 119 |
col106 varbinary(3) default 'ABC' column_format dynamic, |
| 120 |
col107 varbinary(3) default 'ABC' column_format dynamic, |
| 121 |
col108 varbinary(3) default 'ABC' column_format dynamic, |
| 122 |
col109 varbinary(3) default 'ABC' column_format dynamic, |
| 123 |
col110 varbinary(3) default 'ABC' column_format dynamic, |
| 124 |
col111 varbinary(3) default 'ABC' column_format dynamic, |
| 125 |
col112 varbinary(3) default 'ABC' column_format dynamic, |
| 126 |
col113 varbinary(3) default 'ABC' column_format dynamic, |
| 127 |
col114 varbinary(3) default 'ABC' column_format dynamic, |
| 128 |
col115 varbinary(3) default 'ABC' column_format dynamic, |
| 129 |
col116 varbinary(3) default 'ABC' column_format dynamic, |
| 130 |
col117 varbinary(3) default 'ABC' column_format dynamic, |
| 131 |
col118 varbinary(3) default 'ABC' column_format dynamic, |
| 132 |
col119 varbinary(3) default 'ABC' column_format dynamic, |
| 133 |
col120 varbinary(3) default 'ABC' column_format dynamic, |
| 134 |
col121 varbinary(3) default 'ABC' column_format dynamic, |
| 135 |
col122 varbinary(3) default 'ABC' column_format dynamic, |
| 136 |
col123 varbinary(3) default 'ABC' column_format dynamic, |
| 137 |
col124 varbinary(3) default 'ABC' column_format dynamic, |
| 138 |
col125 varbinary(3) default 'ABC' column_format dynamic, |
| 139 |
col126 varbinary(3) default 'ABC' column_format dynamic, |
| 140 |
col127 varbinary(3) default 'ABC' column_format dynamic, |
| 141 |
col128 varbinary(3) default 'ABC' column_format dynamic, |
| 142 |
col129 varbinary(3) default 'ABC' column_format dynamic, |
| 143 |
col130 varbinary(3) default 'ABC' column_format dynamic, |
| 144 |
col131 varbinary(3) default 'ABC' column_format dynamic, |
| 145 |
col132 varbinary(3) default 'ABC' column_format dynamic, |
| 146 |
col133 varbinary(3) default 'ABC' column_format dynamic, |
| 147 |
col134 varbinary(3) default 'ABC' column_format dynamic, |
| 148 |
col135 varbinary(3) default 'ABC' column_format dynamic, |
| 149 |
col136 varbinary(3) default 'ABC' column_format dynamic, |
| 150 |
col137 varbinary(3) default 'ABC' column_format dynamic, |
| 151 |
col138 varbinary(3) default 'ABC' column_format dynamic, |
| 152 |
col139 varbinary(3) default 'ABC' column_format dynamic, |
| 153 |
col140 varbinary(3) default 'ABC' column_format dynamic, |
| 154 |
col141 varbinary(3) default 'ABC' column_format dynamic, |
| 155 |
col142 varbinary(3) default 'ABC' column_format dynamic, |
| 156 |
col143 varbinary(3) default 'ABC' column_format dynamic, |
| 157 |
col144 varbinary(3) default 'ABC' column_format dynamic, |
| 158 |
col145 varbinary(3) default 'ABC' column_format dynamic, |
| 159 |
col146 varbinary(3) default 'ABC' column_format dynamic, |
| 160 |
col147 varbinary(3) default 'ABC' column_format dynamic, |
| 161 |
col148 varbinary(3) default 'ABC' column_format dynamic, |
| 162 |
col149 varbinary(3) default 'ABC' column_format dynamic, |
| 163 |
col150 varbinary(3) default 'ABC' column_format dynamic, |
| 164 |
col151 varbinary(3) default 'ABC' column_format dynamic, |
| 165 |
col152 varbinary(3) default 'ABC' column_format dynamic, |
| 166 |
col153 varbinary(3) default 'ABC' column_format dynamic, |
| 167 |
col154 varbinary(3) default 'ABC' column_format dynamic, |
| 168 |
col155 varbinary(3) default 'ABC' column_format dynamic, |
| 169 |
col156 varbinary(3) default 'ABC' column_format dynamic, |
| 170 |
col157 varbinary(3) default 'ABC' column_format dynamic, |
| 171 |
col158 varbinary(3) default 'ABC' column_format dynamic, |
| 172 |
col159 varbinary(3) default 'ABC' column_format dynamic, |
| 173 |
col160 varbinary(3) default 'ABC' column_format dynamic, |
| 174 |
col161 varbinary(3) default 'ABC' column_format dynamic, |
| 175 |
col162 varbinary(3) default 'ABC' column_format dynamic, |
| 176 |
col163 varbinary(3) default 'ABC' column_format dynamic, |
| 177 |
col164 varbinary(3) default 'ABC' column_format dynamic, |
| 178 |
col165 varbinary(3) default 'ABC' column_format dynamic, |
| 179 |
col166 varbinary(3) default 'ABC' column_format dynamic, |
| 180 |
col167 varbinary(3) default 'ABC' column_format dynamic, |
| 181 |
col168 varbinary(3) default 'ABC' column_format dynamic, |
| 182 |
col169 varbinary(3) default 'ABC' column_format dynamic, |
| 183 |
col170 varbinary(3) default 'ABC' column_format dynamic, |
| 184 |
col171 varbinary(3) default 'ABC' column_format dynamic, |
| 185 |
col172 varbinary(3) default 'ABC' column_format dynamic, |
| 186 |
col173 varbinary(3) default 'ABC' column_format dynamic, |
| 187 |
col174 varbinary(3) default 'ABC' column_format dynamic, |
| 188 |
col175 varbinary(3) default 'ABC' column_format dynamic, |
| 189 |
col176 varbinary(3) default 'ABC' column_format dynamic, |
| 190 |
col177 varbinary(3) default 'ABC' column_format dynamic, |
| 191 |
col178 varbinary(3) default 'ABC' column_format dynamic, |
| 192 |
col179 varbinary(3) default 'ABC' column_format dynamic, |
| 193 |
col180 varbinary(3) default 'ABC' column_format dynamic, |
| 194 |
col181 varbinary(3) default 'ABC' column_format dynamic, |
| 195 |
col182 varbinary(3) default 'ABC' column_format dynamic, |
| 196 |
col183 varbinary(3) default 'ABC' column_format dynamic, |
| 197 |
col184 varbinary(3) default 'ABC' column_format dynamic, |
| 198 |
col185 varbinary(3) default 'ABC' column_format dynamic, |
| 199 |
col186 varbinary(3) default 'ABC' column_format dynamic, |
| 200 |
col187 varbinary(3) default 'ABC' column_format dynamic, |
| 201 |
col188 varbinary(3) default 'ABC' column_format dynamic, |
| 202 |
col189 varbinary(3) default 'ABC' column_format dynamic, |
| 203 |
col190 varbinary(3) default 'ABC' column_format dynamic, |
| 204 |
col191 varbinary(3) default 'ABC' column_format dynamic, |
| 205 |
col192 varbinary(3) default 'ABC' column_format dynamic, |
| 206 |
col193 varbinary(3) default 'ABC' column_format dynamic, |
| 207 |
col194 varbinary(3) default 'ABC' column_format dynamic, |
| 208 |
col195 varbinary(3) default 'ABC' column_format dynamic, |
| 209 |
col196 varbinary(3) default 'ABC' column_format dynamic, |
| 210 |
col197 varbinary(3) default 'ABC' column_format dynamic, |
| 211 |
col198 varbinary(3) default 'ABC' column_format dynamic, |
| 212 |
col199 varbinary(3) default 'ABC' column_format dynamic, |
| 213 |
col200 varbinary(3) default 'ABC' column_format dynamic, |
| 214 |
col201 varbinary(3) default 'ABC' column_format dynamic, |
| 215 |
col202 varbinary(3) default 'ABC' column_format dynamic, |
| 216 |
col203 varbinary(3) default 'ABC' column_format dynamic, |
| 217 |
col204 varbinary(3) default 'ABC' column_format dynamic, |
| 218 |
col205 varbinary(3) default 'ABC' column_format dynamic, |
| 219 |
col206 varbinary(3) default 'ABC' column_format dynamic, |
| 220 |
col207 varbinary(3) default 'ABC' column_format dynamic, |
| 221 |
col208 varbinary(3) default 'ABC' column_format dynamic, |
| 222 |
col209 varbinary(3) default 'ABC' column_format dynamic, |
| 223 |
col210 varbinary(3) default 'ABC' column_format dynamic, |
| 224 |
col211 varbinary(3) default 'ABC' column_format dynamic, |
| 225 |
col212 varbinary(3) default 'ABC' column_format dynamic, |
| 226 |
col213 varbinary(3) default 'ABC' column_format dynamic, |
| 227 |
col214 varbinary(3) default 'ABC' column_format dynamic, |
| 228 |
col215 varbinary(3) default 'ABC' column_format dynamic, |
| 229 |
col216 varbinary(3) default 'ABC' column_format dynamic, |
| 230 |
col217 varbinary(3) default 'ABC' column_format dynamic, |
| 231 |
col218 varbinary(3) default 'ABC' column_format dynamic, |
| 232 |
col219 varbinary(3) default 'ABC' column_format dynamic, |
| 233 |
col220 varbinary(3) default 'ABC' column_format dynamic, |
| 234 |
col221 varbinary(3) default 'ABC' column_format dynamic, |
| 235 |
col222 varbinary(3) default 'ABC' column_format dynamic, |
| 236 |
col223 varbinary(3) default 'ABC' column_format dynamic, |
| 237 |
col224 varbinary(3) default 'ABC' column_format dynamic, |
| 238 |
col225 varbinary(3) default 'ABC' column_format dynamic, |
| 239 |
col226 varbinary(3) default 'ABC' column_format dynamic, |
| 240 |
col227 varbinary(3) default 'ABC' column_format dynamic, |
| 241 |
col228 varbinary(3) default 'ABC' column_format dynamic, |
| 242 |
col229 varbinary(3) default 'ABC' column_format dynamic, |
| 243 |
col230 varbinary(3) default 'ABC' column_format dynamic, |
| 244 |
col231 varbinary(3) default 'ABC' column_format dynamic, |
| 245 |
col232 varbinary(3) default 'ABC' column_format dynamic, |
| 246 |
col233 varbinary(3) default 'ABC' column_format dynamic, |
| 247 |
col234 varbinary(3) default 'ABC' column_format dynamic, |
| 248 |
col235 varbinary(3) default 'ABC' column_format dynamic, |
| 249 |
col236 varbinary(3) default 'ABC' column_format dynamic, |
| 250 |
col237 varbinary(3) default 'ABC' column_format dynamic, |
| 251 |
col238 varbinary(3) default 'ABC' column_format dynamic, |
| 252 |
col239 varbinary(3) default 'ABC' column_format dynamic, |
| 253 |
col240 varbinary(3) default 'ABC' column_format dynamic, |
| 254 |
col241 varbinary(3) default 'ABC' column_format dynamic, |
| 255 |
col242 varbinary(3) default 'ABC' column_format dynamic, |
| 256 |
col243 varbinary(3) default 'ABC' column_format dynamic, |
| 257 |
col244 varbinary(3) default 'ABC' column_format dynamic, |
| 258 |
col245 varbinary(3) default 'ABC' column_format dynamic, |
| 259 |
col246 varbinary(3) default 'ABC' column_format dynamic, |
| 260 |
col247 varbinary(3) default 'ABC' column_format dynamic, |
| 261 |
col248 varbinary(3) default 'ABC' column_format dynamic, |
| 262 |
col249 varbinary(3) default 'ABC' column_format dynamic, |
| 263 |
col250 varbinary(3) default 'ABC' column_format dynamic, |
| 264 |
col251 varbinary(3) default 'ABC' column_format dynamic, |
| 265 |
col252 varbinary(3) default 'ABC' column_format dynamic, |
| 266 |
col253 varbinary(3) default 'ABC' column_format dynamic, |
| 267 |
col254 varbinary(3) default 'ABC' column_format dynamic, |
| 268 |
col255 varbinary(3) default 'ABC' column_format dynamic, |
| 269 |
col256 varbinary(3) default 'ABC' column_format dynamic, |
| 270 |
col257 varbinary(3) default 'ABC' column_format dynamic, |
| 271 |
col258 varbinary(3) default 'ABC' column_format dynamic, |
| 272 |
col259 varbinary(3) default 'ABC' column_format dynamic, |
| 273 |
col260 varbinary(3) default 'ABC' column_format dynamic, |
| 274 |
col261 varbinary(3) default 'ABC' column_format dynamic, |
| 275 |
col262 varbinary(3) default 'ABC' column_format dynamic, |
| 276 |
col263 varbinary(3) default 'ABC' column_format dynamic, |
| 277 |
col264 varbinary(3) default 'ABC' column_format dynamic, |
| 278 |
col265 varbinary(3) default 'ABC' column_format dynamic, |
| 279 |
col266 varbinary(3) default 'ABC' column_format dynamic, |
| 280 |
col267 varbinary(3) default 'ABC' column_format dynamic, |
| 281 |
col268 varbinary(3) default 'ABC' column_format dynamic, |
| 282 |
col269 varbinary(3) default 'ABC' column_format dynamic, |
| 283 |
col270 varbinary(3) default 'ABC' column_format dynamic, |
| 284 |
col271 varbinary(3) default 'ABC' column_format dynamic, |
| 285 |
col272 varbinary(3) default 'ABC' column_format dynamic, |
| 286 |
col273 varbinary(3) default 'ABC' column_format dynamic, |
| 287 |
col274 varbinary(3) default 'ABC' column_format dynamic, |
| 288 |
col275 varbinary(3) default 'ABC' column_format dynamic, |
| 289 |
col276 varbinary(3) default 'ABC' column_format dynamic, |
| 290 |
col277 varbinary(3) default 'ABC' column_format dynamic, |
| 291 |
col278 varbinary(3) default 'ABC' column_format dynamic, |
| 292 |
col279 varbinary(3) default 'ABC' column_format dynamic, |
| 293 |
col280 varbinary(3) default 'ABC' column_format dynamic, |
| 294 |
col281 varbinary(3) default 'ABC' column_format dynamic, |
| 295 |
col282 varbinary(3) default 'ABC' column_format dynamic, |
| 296 |
col283 varbinary(3) default 'ABC' column_format dynamic, |
| 297 |
col284 varbinary(3) default 'ABC' column_format dynamic, |
| 298 |
col285 varbinary(3) default 'ABC' column_format dynamic, |
| 299 |
col286 varbinary(3) default 'ABC' column_format dynamic, |
| 300 |
col287 varbinary(3) default 'ABC' column_format dynamic, |
| 301 |
col288 varbinary(3) default 'ABC' column_format dynamic, |
| 302 |
col289 varbinary(3) default 'ABC' column_format dynamic, |
| 303 |
col290 varbinary(3) default 'ABC' column_format dynamic, |
| 304 |
col291 varbinary(3) default 'ABC' column_format dynamic, |
| 305 |
col292 varbinary(3) default 'ABC' column_format dynamic, |
| 306 |
col293 varbinary(3) default 'ABC' column_format dynamic, |
| 307 |
col294 varbinary(3) default 'ABC' column_format dynamic, |
| 308 |
col295 varbinary(3) default 'ABC' column_format dynamic, |
| 309 |
col296 varbinary(3) default 'ABC' column_format dynamic, |
| 310 |
col297 varbinary(3) default 'ABC' column_format dynamic, |
| 311 |
col298 varbinary(3) default 'ABC' column_format dynamic, |
| 312 |
col299 varbinary(3) default 'ABC' column_format dynamic, |
| 313 |
col300 varbinary(3) default 'ABC' column_format dynamic, |
| 314 |
col301 varbinary(3) default 'ABC' column_format dynamic, |
| 315 |
col302 varbinary(3) default 'ABC' column_format dynamic, |
| 316 |
col303 varbinary(3) default 'ABC' column_format dynamic, |
| 317 |
col304 varbinary(3) default 'ABC' column_format dynamic, |
| 318 |
col305 varbinary(3) default 'ABC' column_format dynamic, |
| 319 |
col306 varbinary(3) default 'ABC' column_format dynamic, |
| 320 |
col307 varbinary(3) default 'ABC' column_format dynamic, |
| 321 |
col308 varbinary(3) default 'ABC' column_format dynamic, |
| 322 |
col309 varbinary(3) default 'ABC' column_format dynamic, |
| 323 |
col310 varbinary(3) default 'ABC' column_format dynamic, |
| 324 |
col311 varbinary(3) default 'ABC' column_format dynamic, |
| 325 |
col312 varbinary(3) default 'ABC' column_format dynamic, |
| 326 |
col313 varbinary(3) default 'ABC' column_format dynamic, |
| 327 |
col314 varbinary(3) default 'ABC' column_format dynamic, |
| 328 |
col315 varbinary(3) default 'ABC' column_format dynamic, |
| 329 |
col316 varbinary(3) default 'ABC' column_format dynamic, |
| 330 |
col317 varbinary(3) default 'ABC' column_format dynamic, |
| 331 |
col318 varbinary(3) default 'ABC' column_format dynamic, |
| 332 |
col319 varbinary(3) default 'ABC' column_format dynamic, |
| 333 |
col320 varbinary(3) default 'ABC' column_format dynamic, |
| 334 |
col321 varbinary(3) default 'ABC' column_format dynamic, |
| 335 |
col322 varbinary(3) default 'ABC' column_format dynamic, |
| 336 |
col323 varbinary(3) default 'ABC' column_format dynamic, |
| 337 |
col324 varbinary(3) default 'ABC' column_format dynamic, |
| 338 |
col325 varbinary(3) default 'ABC' column_format dynamic, |
| 339 |
col326 varbinary(3) default 'ABC' column_format dynamic, |
| 340 |
col327 varbinary(3) default 'ABC' column_format dynamic, |
| 341 |
col328 varbinary(3) default 'ABC' column_format dynamic, |
| 342 |
col329 varbinary(3) default 'ABC' column_format dynamic, |
| 343 |
col330 varbinary(3) default 'ABC' column_format dynamic, |
| 344 |
col331 varbinary(3) default 'ABC' column_format dynamic, |
| 345 |
col332 varbinary(3) default 'ABC' column_format dynamic, |
| 346 |
col333 varbinary(3) default 'ABC' column_format dynamic, |
| 347 |
col334 varbinary(3) default 'ABC' column_format dynamic, |
| 348 |
col335 varbinary(3) default 'ABC' column_format dynamic, |
| 349 |
col336 varbinary(3) default 'ABC' column_format dynamic, |
| 350 |
col337 varbinary(3) default 'ABC' column_format dynamic, |
| 351 |
col338 varbinary(3) default 'ABC' column_format dynamic, |
| 352 |
col339 varbinary(3) default 'ABC' column_format dynamic, |
| 353 |
col340 varbinary(3) default 'ABC' column_format dynamic, |
| 354 |
col341 varbinary(3) default 'ABC' column_format dynamic, |
| 355 |
col342 varbinary(3) default 'ABC' column_format dynamic, |
| 356 |
col343 varbinary(3) default 'ABC' column_format dynamic, |
| 357 |
col344 varbinary(3) default 'ABC' column_format dynamic, |
| 358 |
col345 varbinary(3) default 'ABC' column_format dynamic, |
| 359 |
col346 varbinary(3) default 'ABC' column_format dynamic, |
| 360 |
col347 varbinary(3) default 'ABC' column_format dynamic, |
| 361 |
col348 varbinary(3) default 'ABC' column_format dynamic, |
| 362 |
col349 varbinary(3) default 'ABC' column_format dynamic, |
| 363 |
col350 varbinary(3) default 'ABC' column_format dynamic, |
| 364 |
col351 varbinary(3) default 'ABC' column_format dynamic, |
| 365 |
col352 varbinary(3) default 'ABC' column_format dynamic, |
| 366 |
col353 varbinary(3) default 'ABC' column_format dynamic, |
| 367 |
col354 varbinary(3) default 'ABC' column_format dynamic, |
| 368 |
col355 varbinary(3) default 'ABC' column_format dynamic, |
| 369 |
col356 varbinary(3) default 'ABC' column_format dynamic, |
| 370 |
col357 varbinary(3) default 'ABC' column_format dynamic, |
| 371 |
col358 varbinary(3) default 'ABC' column_format dynamic, |
| 372 |
col359 varbinary(3) default 'ABC' column_format dynamic, |
| 373 |
col360 varbinary(3) default 'ABC' column_format dynamic, |
| 374 |
col361 varbinary(3) default 'ABC' column_format dynamic, |
| 375 |
col362 varbinary(3) default 'ABC' column_format dynamic, |
| 376 |
col363 varbinary(3) default 'ABC' column_format dynamic, |
| 377 |
col364 varbinary(3) default 'ABC' column_format dynamic, |
| 378 |
col365 varbinary(3) default 'ABC' column_format dynamic, |
| 379 |
col366 varbinary(3) default 'ABC' column_format dynamic, |
| 380 |
col367 varbinary(3) default 'ABC' column_format dynamic, |
| 381 |
col368 varbinary(3) default 'ABC' column_format dynamic, |
| 382 |
col369 varbinary(3) default 'ABC' column_format dynamic, |
| 383 |
col370 varbinary(3) default 'ABC' column_format dynamic, |
| 384 |
col371 varbinary(3) default 'ABC' column_format dynamic, |
| 385 |
col372 varbinary(3) default 'ABC' column_format dynamic, |
| 386 |
col373 varbinary(3) default 'ABC' column_format dynamic, |
| 387 |
col374 varbinary(3) default 'ABC' column_format dynamic, |
| 388 |
col375 varbinary(3) default 'ABC' column_format dynamic, |
| 389 |
col376 varbinary(3) default 'ABC' column_format dynamic, |
| 390 |
col377 varbinary(3) default 'ABC' column_format dynamic, |
| 391 |
col378 varbinary(3) default 'ABC' column_format dynamic, |
| 392 |
col379 varbinary(3) default 'ABC' column_format dynamic, |
| 393 |
col380 varbinary(3) default 'ABC' column_format dynamic, |
| 394 |
col381 varbinary(3) default 'ABC' column_format dynamic, |
| 395 |
col382 varbinary(3) default 'ABC' column_format dynamic, |
| 396 |
col383 varbinary(3) default 'ABC' column_format dynamic, |
| 397 |
col384 varbinary(3) default 'ABC' column_format dynamic, |
| 398 |
col385 varbinary(3) default 'ABC' column_format dynamic, |
| 399 |
col386 varbinary(3) default 'ABC' column_format dynamic, |
| 400 |
col387 varbinary(3) default 'ABC' column_format dynamic, |
| 401 |
col388 varbinary(3) default 'ABC' column_format dynamic, |
| 402 |
col389 varbinary(3) default 'ABC' column_format dynamic, |
| 403 |
col390 varbinary(3) default 'ABC' column_format dynamic, |
| 404 |
col391 varbinary(3) default 'ABC' column_format dynamic, |
| 405 |
col392 varbinary(3) default 'ABC' column_format dynamic, |
| 406 |
col393 varbinary(3) default 'ABC' column_format dynamic, |
| 407 |
col394 varbinary(3) default 'ABC' column_format dynamic, |
| 408 |
col395 varbinary(3) default 'ABC' column_format dynamic, |
| 409 |
col396 varbinary(3) default 'ABC' column_format dynamic, |
| 410 |
col397 varbinary(3) default 'ABC' column_format dynamic, |
| 411 |
col398 varbinary(3) default 'ABC' column_format dynamic, |
| 412 |
col399 varbinary(3) default 'ABC' column_format dynamic, |
| 413 |
col400 varbinary(3) default 'ABC' column_format dynamic, |
| 414 |
col401 varbinary(3) default 'ABC' column_format dynamic, |
| 415 |
col402 varbinary(3) default 'ABC' column_format dynamic, |
| 416 |
col403 varbinary(3) default 'ABC' column_format dynamic, |
| 417 |
col404 varbinary(3) default 'ABC' column_format dynamic, |
| 418 |
col405 varbinary(3) default 'ABC' column_format dynamic, |
| 419 |
col406 varbinary(3) default 'ABC' column_format dynamic, |
| 420 |
col407 varbinary(3) default 'ABC' column_format dynamic, |
| 421 |
col408 varbinary(3) default 'ABC' column_format dynamic, |
| 422 |
col409 varbinary(3) default 'ABC' column_format dynamic, |
| 423 |
col410 varbinary(3) default 'ABC' column_format dynamic, |
| 424 |
col411 varbinary(3) default 'ABC' column_format dynamic, |
| 425 |
col412 varbinary(3) default 'ABC' column_format dynamic, |
| 426 |
col413 varbinary(3) default 'ABC' column_format dynamic, |
| 427 |
col414 varbinary(3) default 'ABC' column_format dynamic, |
| 428 |
col415 varbinary(3) default 'ABC' column_format dynamic, |
| 429 |
col416 varbinary(3) default 'ABC' column_format dynamic, |
| 430 |
col417 varbinary(3) default 'ABC' column_format dynamic, |
| 431 |
col418 varbinary(3) default 'ABC' column_format dynamic, |
| 432 |
col419 varbinary(3) default 'ABC' column_format dynamic, |
| 433 |
col420 varbinary(3) default 'ABC' column_format dynamic, |
| 434 |
col421 varbinary(3) default 'ABC' column_format dynamic, |
| 435 |
col422 varbinary(3) default 'ABC' column_format dynamic, |
| 436 |
col423 varbinary(3) default 'ABC' column_format dynamic, |
| 437 |
col424 varbinary(3) default 'ABC' column_format dynamic, |
| 438 |
col425 varbinary(3) default 'ABC' column_format dynamic, |
| 439 |
col426 varbinary(3) default 'ABC' column_format dynamic, |
| 440 |
col427 varbinary(3) default 'ABC' column_format dynamic, |
| 441 |
col428 varbinary(3) default 'ABC' column_format dynamic, |
| 442 |
col429 varbinary(3) default 'ABC' column_format dynamic, |
| 443 |
col430 varbinary(3) default 'ABC' column_format dynamic, |
| 444 |
col431 varbinary(3) default 'ABC' column_format dynamic, |
| 445 |
col432 varbinary(3) default 'ABC' column_format dynamic, |
| 446 |
col433 varbinary(3) default 'ABC' column_format dynamic, |
| 447 |
col434 varbinary(3) default 'ABC' column_format dynamic, |
| 448 |
col435 varbinary(3) default 'ABC' column_format dynamic, |
| 449 |
col436 varbinary(3) default 'ABC' column_format dynamic, |
| 450 |
col437 varbinary(3) default 'ABC' column_format dynamic, |
| 451 |
col438 varbinary(3) default 'ABC' column_format dynamic, |
| 452 |
col439 varbinary(3) default 'ABC' column_format dynamic, |
| 453 |
col440 varbinary(3) default 'ABC' column_format dynamic, |
| 454 |
col441 varbinary(3) default 'ABC' column_format dynamic, |
| 455 |
col442 varbinary(3) default 'ABC' column_format dynamic, |
| 456 |
col443 varbinary(3) default 'ABC' column_format dynamic, |
| 457 |
col444 varbinary(3) default 'ABC' column_format dynamic, |
| 458 |
col445 varbinary(3) default 'ABC' column_format dynamic, |
| 459 |
col446 varbinary(3) default 'ABC' column_format dynamic, |
| 460 |
col447 varbinary(3) default 'ABC' column_format dynamic, |
| 461 |
col448 varbinary(3) default 'ABC' column_format dynamic, |
| 462 |
col449 varbinary(3) default 'ABC' column_format dynamic, |
| 463 |
col450 varbinary(3) default 'ABC' column_format dynamic, |
| 464 |
col451 varbinary(3) default 'ABC' column_format dynamic, |
| 465 |
col452 varbinary(3) default 'ABC' column_format dynamic, |
| 466 |
col453 varbinary(3) default 'ABC' column_format dynamic, |
| 467 |
col454 varbinary(3) default 'ABC' column_format dynamic, |
| 468 |
col455 varbinary(3) default 'ABC' column_format dynamic, |
| 469 |
col456 varbinary(3) default 'ABC' column_format dynamic, |
| 470 |
col457 varbinary(3) default 'ABC' column_format dynamic, |
| 471 |
col458 varbinary(3) default 'ABC' column_format dynamic, |
| 472 |
col459 varbinary(3) default 'ABC' column_format dynamic, |
| 473 |
col460 varbinary(3) default 'ABC' column_format dynamic, |
| 474 |
col461 varbinary(3) default 'ABC' column_format dynamic, |
| 475 |
col462 varbinary(3) default 'ABC' column_format dynamic, |
| 476 |
col463 varbinary(3) default 'ABC' column_format dynamic, |
| 477 |
col464 varbinary(3) default 'ABC' column_format dynamic, |
| 478 |
col465 varbinary(3) default 'ABC' column_format dynamic, |
| 479 |
col466 varbinary(3) default 'ABC' column_format dynamic, |
| 480 |
col467 varbinary(3) default 'ABC' column_format dynamic, |
| 481 |
col468 varbinary(3) default 'ABC' column_format dynamic, |
| 482 |
col469 varbinary(3) default 'ABC' column_format dynamic, |
| 483 |
col470 varbinary(3) default 'ABC' column_format dynamic, |
| 484 |
col471 varbinary(3) default 'ABC' column_format dynamic, |
| 485 |
col472 varbinary(3) default 'ABC' column_format dynamic, |
| 486 |
col473 varbinary(3) default 'ABC' column_format dynamic, |
| 487 |
col474 varbinary(3) default 'ABC' column_format dynamic, |
| 488 |
col475 varbinary(3) default 'ABC' column_format dynamic, |
| 489 |
col476 varbinary(3) default 'ABC' column_format dynamic, |
| 490 |
col477 varbinary(3) default 'ABC' column_format dynamic, |
| 491 |
col478 varbinary(3) default 'ABC' column_format dynamic, |
| 492 |
col479 varbinary(3) default 'ABC' column_format dynamic, |
| 493 |
col480 varbinary(3) default 'ABC' column_format dynamic, |
| 494 |
col481 varbinary(3) default 'ABC' column_format dynamic, |
| 495 |
col482 varbinary(3) default 'ABC' column_format dynamic, |
| 496 |
col483 varbinary(3) default 'ABC' column_format dynamic, |
| 497 |
col484 varbinary(3) default 'ABC' column_format dynamic, |
| 498 |
col485 varbinary(3) default 'ABC' column_format dynamic, |
| 499 |
col486 varbinary(3) default 'ABC' column_format dynamic, |
| 500 |
col487 varbinary(3) default 'ABC' column_format dynamic, |
| 501 |
col488 varbinary(3) default 'ABC' column_format dynamic, |
| 502 |
col489 varbinary(3) default 'ABC' column_format dynamic, |
| 503 |
col490 varbinary(3) default 'ABC' column_format dynamic, |
| 504 |
col491 varbinary(3) default 'ABC' column_format dynamic, |
| 505 |
col492 varbinary(3) default 'ABC' column_format dynamic, |
| 506 |
col493 varbinary(3) default 'ABC' column_format dynamic, |
| 507 |
col494 varbinary(3) default 'ABC' column_format dynamic, |
| 508 |
col495 varbinary(3) default 'ABC' column_format dynamic, |
| 509 |
col496 varbinary(3) default 'ABC' column_format dynamic, |
| 510 |
col497 varbinary(3) default 'ABC' column_format dynamic, |
| 511 |
col498 varbinary(3) default 'ABC' column_format dynamic, |
| 512 |
col499 varbinary(3) default 'ABC' column_format dynamic, |
| 513 |
col500 varbinary(3) default 'ABC' column_format dynamic, |
| 514 |
col501 varbinary(3) default 'ABC' column_format dynamic, |
| 515 |
col502 varbinary(3) default 'ABC' column_format dynamic, |
| 516 |
col503 varbinary(3) default 'ABC' column_format dynamic, |
| 517 |
col504 varbinary(3) default 'ABC' column_format dynamic, |
| 518 |
col505 varbinary(3) default 'ABC' column_format dynamic, |
| 519 |
col506 binary(1) default '@' column_format fixed, |
| 520 |
col507 binary(1) default '@' column_format fixed, |
| 521 |
col508 varbinary(3) null default 'ABC' column_format fixed, |
| 522 |
col509 varbinary(3) null default 'ABC' column_format fixed, |
| 523 |
col510 varbinary(3) null default 'ABC' storage disk |
| 524 |
) engine = ndb |
| 525 |
tablespace ts1 |
| 526 |
storage memory |
| 527 |
partition by key(pk) partitions 1; |
| 528 |
insert into t1 (pk) values (0x12345678); |
| 529 |
insert into t1 (pk) values (0x87654321); |
| 530 |
alter table t1 algorithm=inplace, |
| 531 |
add column col511 varbinary(27954) column_format dynamic; |
| 532 |
update t1 set col511 = repeat('-', 27954); |
| 533 |
drop table t1; |
| 534 |
alter tablespace ts1 |
| 535 |
drop datafile 'datafile.dat'; |
| 536 |
drop tablespace ts1; |
| 537 |
drop logfile group lg1 engine ndb; |