| 1 |
--source include/have_innodb_max_16k.inc |
| 2 |
|
| 3 |
--echo # |
| 4 |
--echo # Bug #27368662 PAGE_TYPE == FIL_PAGE_TYPE_ZLOB_FIRST LOB::Z_READ |
| 5 |
--echo # |
| 6 |
|
| 7 |
CREATE TABLE `ibstd_10_g` ( |
| 8 |
`a` int(11) NOT NULL, |
| 9 |
`d` int(11) NOT NULL, |
| 10 |
`b` varchar(198) NOT NULL, |
| 11 |
`c` char(88) DEFAULT NULL, |
| 12 |
`vadcol` int(11) GENERATED ALWAYS AS ((`a` + length(`d`))) STORED, |
| 13 |
`vbcol` char(2) GENERATED ALWAYS AS (substr(`b`,2,2)) VIRTUAL, |
| 14 |
`vbidxcol` char(3) GENERATED ALWAYS AS (substr(`b`,1,3)) VIRTUAL, |
| 15 |
`pkey` int(11) NOT NULL AUTO_INCREMENT, |
| 16 |
`leader` int(11) NOT NULL, |
| 17 |
`leaderpoint` point NOT NULL, |
| 18 |
`invariant` int(11) NOT NULL, |
| 19 |
`offset1` int(11) NOT NULL, |
| 20 |
`offset2` int(11) NOT NULL, |
| 21 |
`linestr` linestring NOT NULL, |
| 22 |
`pkeypoint` point NOT NULL, |
| 23 |
`geom` geometry NOT NULL, |
| 24 |
`poly` polygon NOT NULL, |
| 25 |
`mpoint` multipoint DEFAULT NULL, |
| 26 |
`mls` multilinestring DEFAULT NULL, |
| 27 |
`mpoly` multipolygon DEFAULT NULL, |
| 28 |
`mgeom` geometrycollection DEFAULT NULL, |
| 29 |
`fpoint` point DEFAULT NULL, |
| 30 |
`fipoint` point NOT NULL, |
| 31 |
`fls` linestring DEFAULT NULL, |
| 32 |
`fils` linestring NOT NULL, |
| 33 |
`fpoly` polygon DEFAULT NULL, |
| 34 |
`fipoly` polygon NOT NULL, |
| 35 |
PRIMARY KEY (`pkey`), |
| 36 |
KEY `leader` (`leader`), |
| 37 |
SPATIAL KEY `leaderpoint` (`leaderpoint`), |
| 38 |
SPATIAL KEY `linestr` (`linestr`), |
| 39 |
KEY `pkeypoint` (`pkeypoint`), |
| 40 |
SPATIAL KEY `fils` (`fils`), |
| 41 |
SPATIAL KEY `fipoint` (`fipoint`), |
| 42 |
SPATIAL KEY `fipoly` (`fipoly`), |
| 43 |
SPATIAL KEY `geom` (`geom`), |
| 44 |
SPATIAL KEY `poly` (`poly`), |
| 45 |
KEY `d` (`d`), |
| 46 |
KEY `a` (`a`), |
| 47 |
KEY `vbidxcol` (`vbidxcol`), |
| 48 |
KEY `vbidxcol_2` (`vbidxcol`,`d`) |
| 49 |
) /*!50100 TABLESPACE `innodb_file_per_table` */ ENGINE=InnoDB AUTO_INCREMENT=156 DEFAULT CHARSET=utf8mb4 STATS_PERSISTENT=0 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1; |
| 50 |
|
| 51 |
INSERT INTO `ibstd_10_g` (`a`, `d`, `b`, `c`, `pkey`, `leader`, `leaderpoint`, `invariant`, `offset1`, `offset2`, `linestr`, `pkeypoint`, `geom`, `poly`, `mpoint`, `mls`, `mpoly`, `mgeom`, `fpoint`, `fipoint`, `fls`, `fils`, `fpoly`, `fipoly`) VALUES (622,1,'bbb0.863907150322024','c0.333510577976678',1,1,0x000000000101000000000000000000F03F000000000000F03F,1,0,0,0x0000000001020000000A00000000000000002069C000000000008887C000000000006068C000000000008087C000000000002068C000000000006887C00000000000A067C000000000004087C000000000008067C000000000003087C00000000000CCB24000000000003087C00000000000CFB24000000000001887C00000000000D0B24000000000000887C00000000000D5B2400000000000E086C00000000000D5B2400000000000E886C0,0x000000000101000000000000000000F03F000000000000F03F,0x0000000001020000000600000000000000002069C000000000008887C000000000006068C000000000008087C000000000002068C000000000006887C00000000000A067C000000000004087C000000000008067C000000000003087C00000000000CCB24000000000003087C0,0x000000000103000000010000000500000000000000002069C000000000008887C00000000000D5B24000000000008887C00000000000D5B2400000000000E086C000000000002069C00000000000E086C000000000002069C000000000008887C0,0x00000000010400000003000000010100000000000000002069C000000000008887C001010000000000000000000000000000000000000001010000000000000000D5B2400000000000E886C0,0x0000000001050000000200000001020000000500000000000000002069C000000000008887C00000000000D5B24000000000008887C00000000000D5B2400000000000E086C000000000002069C00000000000E086C000000000002069C000000000008887C001020000000A00000000000000002069C000000000008887C000000000006068C000000000008087C000000000002068C000000000006887C00000000000A067C000000000004087C000000000008067C000000000003087C00000000000CCB24000000000003087C00000000000CFB24000000000001887C00000000000D0B24000000000000887C00000000000D5B2400000000000E086C00000000000D5B2400000000000E886C0,0x000000000106000000020000000103000000010000000500000000000000002069C000000000008887C00000000000D5B24000000000008887C00000000000D5B2400000000000E086C000000000002069C00000000000E086C000000000002069C000000000008887C00103000000010000000500000000000000002069C000000000008887C00000000000CCB24000000000008887C00000000000CCB24000000000003087C000000000002069C000000000003087C000000000002069C000000000008887C0,0x000000000107000000040000000101000000000000000000F03F000000000000F03F010400000003000000010100000000000000002069C000000000008887C001010000000000000000000000000000000000000001010000000000000000D5B2400000000000E886C00103000000010000000500000000000000002069C000000000008887C00000000000D5B24000000000008887C00000000000D5B2400000000000E086C000000000002069C00000000000E086C000000000002069C000000000008887C0010400000003000000010100000000000000002069C000000000008887C001010000000000000000000000000000000000000001010000000000000000D5B2400000000000E886C0,0x0000000001010000000000000000A886C00000000000006240,0x0000000001010000000000000000E077400000000000D88740,0x0000000001020000000600000000000000000063C000000000000036400000000000C062C00000000000003A400000000000A062C00000000000003C4000000000008062C00000000000003C4000000000000062C0000000000078AF4000000000000062C0000000000080AF40,0x0000000001020000000400000000000000007087C00000000000B08BC000000000006087C00000000000D08BC000000000007887C00000000000C08BC000000000005087C00000000000B08BC0,0x000000000103000000010000000500000000000000004887C00000000000E0804000000000000887C00000000000E0804000000000000887C0000000000040814000000000004887C0000000000040814000000000004887C00000000000E08040,0x00000000010300000001000000050000000000000000C07AC00000000000C069400000000000F079C00000000000C069400000000000F079C00000000000006B400000000000C07AC00000000000006B400000000000C07AC00000000000C06940); |
| 52 |
|
| 53 |
update ibstd_10_g set fpoint = st_pointfromtext('point(-186 -55)'), fipoint = st_pointfromtext('point(-418 334)'), fls = st_linefromtext(concat('linestring','(-310 -121,-306 -119,-301 -114)')), fils = st_linefromtext(concat('linestring','(-198 137,-193 2138,-194 2139)')), fpoly = st_envelope(st_linefromtext(concat('linestring','(-616 -892,-612 -891,-613 -1891,-610 -1891,-614 -1890,-614 -1890,-619 -1890)'))), fipoly = st_envelope(st_linefromtext(concat('linestring','(101 -364,102 -367,103 -363,105 -359,101 -358,103 -356,99 -351,95 -351,96 -346,93 -349)'))) where pkey = 1; |
| 54 |
|
| 55 |
drop table ibstd_10_g; |