Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 3.144.178.82
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
innodb_gis /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
0.test
911
B
-rw-r--r--
1.test
49.62
KB
-rw-r--r--
alter_spatial_index.test
24.38
KB
-rw-r--r--
bug16236208.test
3.07
KB
-rw-r--r--
bug16266012.test
873
B
-rw-r--r--
bug17057168.test
1.15
KB
-rw-r--r--
check_rtree.test
781
B
-rw-r--r--
create_spatial_index.test
42.08
KB
-rw-r--r--
geometry.test
25.68
KB
-rw-r--r--
gis.test
48.77
KB
-rw-r--r--
gis_split_inf.test
9.81
KB
-rw-r--r--
gis_split_nan.test
19.28
KB
-rw-r--r--
kill_server.test
1.2
KB
-rw-r--r--
multi_pk.test
2.38
KB
-rw-r--r--
point_basic.test
34.66
KB
-rw-r--r--
point_big.test
14.58
KB
-rw-r--r--
precise.test
9.13
KB
-rw-r--r--
repeatable_spatial.test
6.75
KB
-rw-r--r--
rollback.test
226.33
KB
-rw-r--r--
row_format.test
749
B
-rw-r--r--
rt_precise.test
1.71
KB
-rw-r--r--
rtree.test
100.99
KB
-rw-r--r--
rtree_compress.test
1.84
KB
-rw-r--r--
rtree_compress2.test
1.25
KB
-rw-r--r--
rtree_concurrent_srch.test
13.26
KB
-rw-r--r--
rtree_concurrent_srch_2.test
1.52
KB
-rw-r--r--
rtree_create_inplace.test
2.01
KB
-rw-r--r--
rtree_debug.test
1.5
KB
-rw-r--r--
rtree_drop_index.test
140.96
KB
-rw-r--r--
rtree_estimate.test
2.51
KB
-rw-r--r--
rtree_multi_pk.test
4.79
KB
-rw-r--r--
rtree_old.test
46.97
KB
-rw-r--r--
rtree_purge.test
1.31
KB
-rw-r--r--
rtree_recovery.test
1.74
KB
-rw-r--r--
rtree_rollback1.test
1.54
KB
-rw-r--r--
rtree_rollback2.test
717
B
-rw-r--r--
rtree_search.test
3.76
KB
-rw-r--r--
rtree_split.test
4.19
KB
-rw-r--r--
rtree_undo.test
847
B
-rw-r--r--
types.test
2.58
KB
-rw-r--r--
update_root.test
862
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : rtree_create_inplace.test
# This is to test create GIS index with algorithm=inplace. --source include/have_innodb.inc --source include/have_debug.inc --source include/no_valgrind_without_big.inc # Create table with geometry column CREATE TABLE t1 (c1 INT, c2 GEOMETRY NOT NULL, c3 GEOMETRY NOT NULL) ENGINE=INNODB; # Insert enough values INSERT INTO t1 VALUES(1, Point(1,1), ST_GeomFromText('POLYGON (( 0 -1, 0 1, 2 1, 2 -1, 0 -1))')); INSERT INTO t1 VALUES(2, Point(2,2), ST_GeomFromText('POLYGON (( 0 -3, 0 -1, 2 -1, 2 -3, 0 -3))')); INSERT INTO t1 VALUES(3, Point(3,3), ST_GeomFromText('POLYGON (( 1 0, 1 2, 3 2, 3 0, 1 0))')); INSERT INTO t1 VALUES(4, Point(4,4), ST_GeomFromText('POLYGON (( -3 0, -3 2, -1 2, -1 0, -3 0))')); INSERT INTO t1 VALUES(5, Point(5,5), ST_GeomFromText('POLYGON (( 0 0, 0 1, 1 1, 1 0, 0 0))')); INSERT INTO t1 VALUES(6, Point(6,6), ST_GeomFromText('POLYGON (( 2 0, 2 2, 4 2, 4 0, 2 0))')); INSERT INTO t1 VALUES(7, Point(7,7), ST_GeomFromText('POLYGON (( 0 3, 0 5, 2 5, 2 3, 0 3))')); INSERT INTO t1 VALUES(8, Point(8,8), ST_GeomFromText('POLYGON (( 0 1, 0 3, 2 3, 2 1, 0 1))')); INSERT INTO t1 VALUES(9, Point(9,9), ST_GeomFromText('POLYGON (( 0 0, 0 3, 3 3, 3 0, 0 0))')); INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; INSERT INTO t1 SELECT * FROM t1; # create spatial index CREATE SPATIAL INDEX idx ON t1(c2); SELECT COUNT(*) FROM t1; SET @g1 = ST_GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))'); SELECT COUNT(*) FROM t1 WHERE MBRWithin(t1.c2, @g1); SET @g1 = ST_GeomFromText('Polygon((10 10,10 800,800 800,800 10,10 10))'); SELECT COUNT(*) FROM t1 WHERE MBRWithin(t1.c2, @g1); ALTER TABLE t1 DROP INDEX idx, ADD SPATIAL INDEX idx3(c2); SET SESSION debug="+d,row_merge_instrument_log_check_flush"; ALTER TABLE t1 DROP INDEX idx3, ADD SPATIAL INDEX idx4(c2), ADD SPATIAL INDEX idx5(c3); # Clean up. DROP TABLE t1;
Close
