| 1 |
--source include/have_innodb_max_16k.inc |
| 2 |
|
| 3 |
--echo # |
| 4 |
--echo # Bug #19077964 ASSERT PAGE_SIZE.EQUALS_TO SPACE_PAGE_SIZE |
| 5 |
--echo # BTR_COPY_BLOB_PREFIX |
| 6 |
--echo # |
| 7 |
|
| 8 |
# |
| 9 |
# TODO: The column 'f3' should have the SRID attribute when bug#27021029 has been |
| 10 |
# fixed. |
| 11 |
# |
| 12 |
create table t1 (f1 int primary key, f3 linestring not null, |
| 13 |
spatial key(f3)) engine=innodb row_format=compressed key_block_size=1; |
| 14 |
show create table t1; |
| 15 |
|
| 16 |
let $points = 80; |
| 17 |
let $x = 0; |
| 18 |
let $y = 0; |
| 19 |
let $linestr = (; |
| 20 |
|
| 21 |
while ($points) |
| 22 |
{ |
| 23 |
let $linestr = $linestr $x $y,; |
| 24 |
dec $points; |
| 25 |
inc $x; |
| 26 |
inc $y; |
| 27 |
} |
| 28 |
|
| 29 |
let $linestr = $linestr 9999 9999); |
| 30 |
|
| 31 |
--eval insert into t1 values (1, ST_linefromtext(concat('linestring', '$linestr'))); |
| 32 |
|
| 33 |
alter table t1 row_format=dynamic, key_block_size=0, algorithm=inplace; |
| 34 |
|
| 35 |
drop table t1; |