[ Avaa Bypassed ]

Upload:

Command:

hmhc3928@18.190.176.244: ~ $ 
USE test;
DROP TABLE IF EXISTS t_num,t_datetime,t_string_1,t_string_2,t_gis,t_string_3,t_string_4,t_string_5;
SHOW TABLES;
Tables_in_test
t_datetime
t_gis
t_num
t_string_1
t_string_2
t_string_3
t_string_4
t_string_5
SHOW CREATE TABLE t_num;
Table	Create Table
t_num	CREATE TABLE `t_num` (
  `t_pk` int(11) NOT NULL,
  `t_test` int(11) DEFAULT NULL,
  `t_bit` bit(64) DEFAULT NULL,
  `t_tinyint` tinyint(4) DEFAULT NULL,
  `t_bool` tinyint(1) DEFAULT NULL,
  `t_smallint` smallint(6) DEFAULT NULL,
  `t_mediumint` mediumint(9) DEFAULT NULL,
  `t_int` int(11) DEFAULT NULL,
  `t_bigint` bigint(20) DEFAULT NULL,
  `t_float` float DEFAULT NULL,
  `t_double` double DEFAULT NULL,
  `t_decimal` decimal(37,16) DEFAULT NULL,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_datetime;
Table	Create Table
t_datetime	CREATE TABLE `t_datetime` (
  `t_pk` int(11) NOT NULL,
  `t_test` int(11) DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `t_datetime` datetime DEFAULT NULL,
  `t_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `t_time` time DEFAULT NULL,
  `t_year` year(4) DEFAULT NULL,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_1;
Table	Create Table
t_string_1	CREATE TABLE `t_string_1` (
  `t_pk` int(11) NOT NULL,
  `t_test` int(11) DEFAULT NULL,
  `t_char` char(255) DEFAULT NULL,
  `t_varchar` varchar(655) DEFAULT NULL,
  `t_binary` binary(255) DEFAULT NULL,
  `t_varbinary` varbinary(6553) DEFAULT NULL,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_2;
Table	Create Table
t_string_2	CREATE TABLE `t_string_2` (
  `t_pk` int(11) NOT NULL,
  `t_test` int(11) DEFAULT NULL,
  `t_tinyblob` tinyblob,
  `t_tinytext` tinytext,
  `t_blob` blob,
  `t_text` text,
  `t_mediumblob` mediumblob,
  `t_mediumtext` mediumtext,
  `t_longblob` longblob,
  `t_longtext` longtext,
  `t_enum` enum('001001','001004','001010','001018','001019','001020','001021','001027','001028','001029','001030','001031','001100','002003','002004','002005','002007') NOT NULL DEFAULT '001001',
  `t_set` set('a','B') DEFAULT NULL,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_gis;
Table	Create Table
t_gis	CREATE TABLE `t_gis` (
  `t_pk` int(11) NOT NULL,
  `t_test` int(11) DEFAULT NULL,
  `t_point` point DEFAULT NULL,
  `t_linestring` linestring DEFAULT NULL,
  `t_polygon` polygon DEFAULT NULL,
  `t_multipoint` multipoint DEFAULT NULL,
  `t_multilinestring` multilinestring DEFAULT NULL,
  `t_multipolygon` multipolygon DEFAULT NULL,
  `t_geometrycollection` geometrycollection DEFAULT NULL,
  `t_geometry` geometry DEFAULT NULL,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_3;
Table	Create Table
t_string_3	CREATE TABLE `t_string_3` (
  `t_pk` int(11) NOT NULL,
  `t_longblob` longblob,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_4;
Table	Create Table
t_string_4	CREATE TABLE `t_string_4` (
  `t_pk` int(11) NOT NULL,
  `t_test` int(11) DEFAULT NULL,
  `t_name` char(30) DEFAULT NULL,
  `t_blob` blob,
  `t_text` text,
  PRIMARY KEY (`t_pk`),
  KEY `t_pk` (`t_pk`,`t_name`)
) /*!50100 TABLESPACE ts1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_5;
Table	Create Table
t_string_5	CREATE TABLE `t_string_5` (
  `t_pk` int(11) NOT NULL,
  `t_longblob` longblob,
  `t_longtext` longtext,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SELECT * FROM t_datetime ORDER by t_pk;
t_pk	t_test	t_date	t_datetime	t_timestamp	t_time	t_year
1	1	1998-01-01	2006-08-10 10:11:12	2002-10-29 16:51:06	19:38:34	2155
2	1	1998-01-01	2006-08-10 10:11:12	2002-10-29 16:51:06	19:38:34	2155
SELECT t_pk,t_test,hex(t_bit),t_tinyint,t_bool,t_smallint,t_mediumint,t_int,t_bigint,t_float,t_double,t_decimal FROM t_num ORDER by t_pk;
t_pk	t_test	hex(t_bit)	t_tinyint	t_bool	t_smallint	t_mediumint	t_int	t_bigint	t_float	t_double	t_decimal
1	1	AAAAAAAAAAAAAAAA	125	1	32765	8388606	2147483647	9223372036854775807	1e20	1e150	331.0000000000000000
2	1	AAAAAAAAAAAAAAAA	125	1	32765	8388606	2147483647	9223372036854775807	1e20	1e150	331.0000000000000000
SELECT t_pk,t_test,t_char,t_varchar,hex(t_binary),hex(t_varbinary) FROM t_string_1 ORDER by t_pk;
t_pk	t_test	t_char	t_varchar	hex(t_binary)	hex(t_varbinary)
1	1	abcdefghijklmn	abcdefghijklmnabcdefghijklmnabcdefghijklmnabcdefghijklmn	612020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	4100
2	1	abcdefghijklmn	abcdefghijklmnabcdefghijklmnabcdefghijklmnabcdefghijklmn	612020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	4100
SELECT * FROM t_string_2 ORDER by t_pk;
t_pk	t_test	t_tinyblob	t_tinytext	t_blob	t_text	t_mediumblob	t_mediumtext	t_longblob	t_longtext	t_enum	t_set
1	1	abcdefghijklmnabcdefghijklmn	abcdefghijklmnabcdefghijklmn	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	001001	a
2	1	abcdefghijklmnabcdefghijklmn	abcdefghijklmnabcdefghijklmn	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	001001	a
SELECT t_pk,t_test,AsText(t_point), AsText(t_linestring),AsText(t_polygon) FROM t_gis ORDER by t_pk;
t_pk	t_test	AsText(t_point)	AsText(t_linestring)	AsText(t_polygon)
1	1	POINT(10 10)	LINESTRING(10 10,20 10,20 20,10 20,10 10)	POLYGON((0 0,50 0,50 50,0 50,0 0),(10 10,20 10,20 20,10 20,10 10))
2	1	POINT(10 20)	LINESTRING(10 10,40 10)	POLYGON((0 0,30 0,30 30,0 0))
3	1	POINT(10 10)	LINESTRING(10 10,20 10,20 20,10 20,10 10)	POLYGON((0 0,50 0,50 50,0 50,0 0),(10 10,20 10,20 20,10 20,10 10))
4	1	POINT(10 20)	LINESTRING(10 10,40 10)	POLYGON((0 0,30 0,30 30,0 0))
SELECT t_pk,t_test,AsText(t_multipoint), AsText(t_multilinestring),AsText(t_multipolygon) FROM t_gis ORDER by t_pk;
t_pk	t_test	AsText(t_multipoint)	AsText(t_multilinestring)	AsText(t_multipolygon)
1	1	MULTIPOINT(1 1,11 11,11 21,21 21)	MULTILINESTRING((10 48,10 21,10 0))	MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
2	1	MULTIPOINT(3 6,4 10)	MULTILINESTRING((1 2,3 5),(2 5,5 8,21 7))	MULTIPOLYGON(((0 3,3 3,3 0,0 3)))
3	1	MULTIPOINT(1 1,11 11,11 21,21 21)	MULTILINESTRING((10 48,10 21,10 0))	MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
4	1	MULTIPOINT(3 6,4 10)	MULTILINESTRING((1 2,3 5),(2 5,5 8,21 7))	MULTIPOLYGON(((0 3,3 3,3 0,0 3)))
SELECT t_pk,t_test,AsText(t_geometrycollection), AsText(t_geometry) FROM t_gis ORDER by t_pk;
t_pk	t_test	AsText(t_geometrycollection)	AsText(t_geometry)
1	1	GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))	MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
2	1	GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9))	GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9))
3	1	GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))	MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
4	1	GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9))	GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9))
SELECT COUNT(*) FROM t_string_3 ORDER BY t_pk;
COUNT(*)
5000
SELECT *  FROM t_string_4 ORDER BY t_pk;
t_pk	t_test	t_name	t_blob	t_text
1	1	name1	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789
2	1	name2	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789
SELECT t_pk,LENGTH(t_longblob),LENGTH(t_longtext) FROM t_string_5 ORDER BY t_pk;
t_pk	LENGTH(t_longblob)	LENGTH(t_longtext)
1	131072	131072
2	131072	131072
DROP TABLE IF EXISTS t_num,t_datetime,t_string_1,t_string_2,t_gis,t_string_3,t_string_4,t_string_5;
ALTER TABLESPACE ts1
DROP DATAFILE 'datafile.dat'
ENGINE = NDB;
DROP TABLESPACE ts1
ENGINE = NDB;
DROP LOGFILE GROUP lg1
ENGINE =NDB;
USE test;
SHOW TABLES;
Tables_in_test
t_datetime
t_gis
t_num
t_string_1
t_string_2
t_string_3
t_string_4
t_string_5
SHOW CREATE TABLE t_num;
Table	Create Table
t_num	CREATE TABLE `t_num` (
  `t_pk` int(11) NOT NULL,
  `t_test` int(11) DEFAULT NULL,
  `t_bit` bit(64) DEFAULT NULL,
  `t_tinyint` tinyint(4) DEFAULT NULL,
  `t_bool` tinyint(1) DEFAULT NULL,
  `t_smallint` smallint(6) DEFAULT NULL,
  `t_mediumint` mediumint(9) DEFAULT NULL,
  `t_int` int(11) DEFAULT NULL,
  `t_bigint` bigint(20) DEFAULT NULL,
  `t_float` float DEFAULT NULL,
  `t_double` double DEFAULT NULL,
  `t_decimal` decimal(37,16) DEFAULT NULL,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_datetime;
Table	Create Table
t_datetime	CREATE TABLE `t_datetime` (
  `t_pk` int(11) NOT NULL,
  `t_test` int(11) DEFAULT NULL,
  `t_date` date DEFAULT NULL,
  `t_datetime` datetime DEFAULT NULL,
  `t_timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `t_time` time DEFAULT NULL,
  `t_year` year(4) DEFAULT NULL,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_1;
Table	Create Table
t_string_1	CREATE TABLE `t_string_1` (
  `t_pk` int(11) NOT NULL,
  `t_test` int(11) DEFAULT NULL,
  `t_char` char(255) DEFAULT NULL,
  `t_varchar` varchar(655) DEFAULT NULL,
  `t_binary` binary(255) DEFAULT NULL,
  `t_varbinary` varbinary(6553) DEFAULT NULL,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_2;
Table	Create Table
t_string_2	CREATE TABLE `t_string_2` (
  `t_pk` int(11) NOT NULL,
  `t_test` int(11) DEFAULT NULL,
  `t_tinyblob` tinyblob,
  `t_tinytext` tinytext,
  `t_blob` blob,
  `t_text` text,
  `t_mediumblob` mediumblob,
  `t_mediumtext` mediumtext,
  `t_longblob` longblob,
  `t_longtext` longtext,
  `t_enum` enum('001001','001004','001010','001018','001019','001020','001021','001027','001028','001029','001030','001031','001100','002003','002004','002005','002007') NOT NULL DEFAULT '001001',
  `t_set` set('a','B') DEFAULT NULL,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_gis;
Table	Create Table
t_gis	CREATE TABLE `t_gis` (
  `t_pk` int(11) NOT NULL,
  `t_test` int(11) DEFAULT NULL,
  `t_point` point DEFAULT NULL,
  `t_linestring` linestring DEFAULT NULL,
  `t_polygon` polygon DEFAULT NULL,
  `t_multipoint` multipoint DEFAULT NULL,
  `t_multilinestring` multilinestring DEFAULT NULL,
  `t_multipolygon` multipolygon DEFAULT NULL,
  `t_geometrycollection` geometrycollection DEFAULT NULL,
  `t_geometry` geometry DEFAULT NULL,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_3;
Table	Create Table
t_string_3	CREATE TABLE `t_string_3` (
  `t_pk` int(11) NOT NULL,
  `t_longblob` longblob,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_4;
Table	Create Table
t_string_4	CREATE TABLE `t_string_4` (
  `t_pk` int(11) NOT NULL,
  `t_test` int(11) DEFAULT NULL,
  `t_name` char(30) DEFAULT NULL,
  `t_blob` blob,
  `t_text` text,
  PRIMARY KEY (`t_pk`),
  KEY `t_pk` (`t_pk`,`t_name`)
) /*!50100 TABLESPACE ts1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t_string_5;
Table	Create Table
t_string_5	CREATE TABLE `t_string_5` (
  `t_pk` int(11) NOT NULL,
  `t_longblob` longblob,
  `t_longtext` longtext,
  PRIMARY KEY (`t_pk`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SELECT * FROM t_datetime ORDER by t_pk;
t_pk	t_test	t_date	t_datetime	t_timestamp	t_time	t_year
1	1	1998-01-01	2006-08-10 10:11:12	2002-10-29 16:51:06	19:38:34	2155
2	1	1998-01-01	2006-08-10 10:11:12	2002-10-29 16:51:06	19:38:34	2155
SELECT t_pk,t_test,hex(t_bit),t_tinyint,t_bool,t_smallint,t_mediumint,t_int,t_bigint,t_float,t_double,t_decimal FROM t_num ORDER by t_pk;
t_pk	t_test	hex(t_bit)	t_tinyint	t_bool	t_smallint	t_mediumint	t_int	t_bigint	t_float	t_double	t_decimal
1	1	AAAAAAAAAAAAAAAA	125	1	32765	8388606	2147483647	9223372036854775807	1e20	1e150	331.0000000000000000
2	1	AAAAAAAAAAAAAAAA	125	1	32765	8388606	2147483647	9223372036854775807	1e20	1e150	331.0000000000000000
SELECT t_pk,t_test,t_char,t_varchar,hex(t_binary),hex(t_varbinary) FROM t_string_1 ORDER by t_pk;
t_pk	t_test	t_char	t_varchar	hex(t_binary)	hex(t_varbinary)
1	1	abcdefghijklmn	abcdefghijklmnabcdefghijklmnabcdefghijklmnabcdefghijklmn	612020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	4100
2	1	abcdefghijklmn	abcdefghijklmnabcdefghijklmnabcdefghijklmnabcdefghijklmn	612020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	4100
SELECT * FROM t_string_2 ORDER by t_pk;
t_pk	t_test	t_tinyblob	t_tinytext	t_blob	t_text	t_mediumblob	t_mediumtext	t_longblob	t_longtext	t_enum	t_set
1	1	abcdefghijklmnabcdefghijklmn	abcdefghijklmnabcdefghijklmn	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	001001	a
2	1	abcdefghijklmnabcdefghijklmn	abcdefghijklmnabcdefghijklmn	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	001001	a
SELECT t_pk,t_test,AsText(t_point), AsText(t_linestring),AsText(t_polygon) FROM t_gis ORDER by t_pk;
t_pk	t_test	AsText(t_point)	AsText(t_linestring)	AsText(t_polygon)
1	1	POINT(10 10)	LINESTRING(10 10,20 10,20 20,10 20,10 10)	POLYGON((0 0,50 0,50 50,0 50,0 0),(10 10,20 10,20 20,10 20,10 10))
2	1	POINT(10 20)	LINESTRING(10 10,40 10)	POLYGON((0 0,30 0,30 30,0 0))
3	1	POINT(10 10)	LINESTRING(10 10,20 10,20 20,10 20,10 10)	POLYGON((0 0,50 0,50 50,0 50,0 0),(10 10,20 10,20 20,10 20,10 10))
4	1	POINT(10 20)	LINESTRING(10 10,40 10)	POLYGON((0 0,30 0,30 30,0 0))
SELECT t_pk,t_test,AsText(t_multipoint), AsText(t_multilinestring),AsText(t_multipolygon) FROM t_gis ORDER by t_pk;
t_pk	t_test	AsText(t_multipoint)	AsText(t_multilinestring)	AsText(t_multipolygon)
1	1	MULTIPOINT(1 1,11 11,11 21,21 21)	MULTILINESTRING((10 48,10 21,10 0))	MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
2	1	MULTIPOINT(3 6,4 10)	MULTILINESTRING((1 2,3 5),(2 5,5 8,21 7))	MULTIPOLYGON(((0 3,3 3,3 0,0 3)))
3	1	MULTIPOINT(1 1,11 11,11 21,21 21)	MULTILINESTRING((10 48,10 21,10 0))	MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
4	1	MULTIPOINT(3 6,4 10)	MULTILINESTRING((1 2,3 5),(2 5,5 8,21 7))	MULTIPOLYGON(((0 3,3 3,3 0,0 3)))
SELECT t_pk,t_test,AsText(t_geometrycollection), AsText(t_geometry) FROM t_gis ORDER by t_pk;
t_pk	t_test	AsText(t_geometrycollection)	AsText(t_geometry)
1	1	GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))	MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
2	1	GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9))	GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9))
3	1	GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(0 0,10 10))	MULTIPOLYGON(((28 26,28 0,84 0,84 42,28 26),(52 18,66 23,73 9,48 6,52 18)),((59 18,67 18,67 13,59 13,59 18)))
4	1	GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9))	GEOMETRYCOLLECTION(POINT(44 6),LINESTRING(3 6,7 9))
SELECT COUNT(*) FROM t_string_3 ORDER BY t_pk;
COUNT(*)
5000
SELECT *  FROM t_string_4 ORDER BY t_pk;
t_pk	t_test	t_name	t_blob	t_text
1	1	name1	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789
2	1	name2	a123456789b123456789c123456789d123456789e123456789f123456789g123456789	a123456789b123456789c123456789d123456789e123456789f123456789g123456789
SELECT t_pk,LENGTH(t_longblob),LENGTH(t_longtext) FROM t_string_5 ORDER BY t_pk;
t_pk	LENGTH(t_longblob)	LENGTH(t_longtext)
1	131072	131072
2	131072	131072
DROP TABLE IF EXISTS t_num,t_datetime,t_string_1,t_string_2,t_gis,t_string_3,t_string_4,t_string_5;
ALTER TABLESPACE ts1
DROP DATAFILE 'datafile.dat'
ENGINE = NDB;
DROP TABLESPACE ts1
ENGINE = NDB;
DROP LOGFILE GROUP lg1
ENGINE =NDB;

Filemanager

DIR : / usr/ share/ mysql-test/ suite/ ndb/ r/
Name Type Size Permission Actions
bug36547.result File 455 B 0644
loaddata_autocom_ndb.result File 726 B 0644
ndb_add_partition.result File 5.91 KB 0644
ndb_alter_table.result File 10.88 KB 0644
ndb_alter_table2.result File 685 B 0644
ndb_alter_table3.result File 1.48 KB 0644
ndb_alter_table_backup.result File 1.76 KB 0644
ndb_alter_table_error.result File 648 B 0644
ndb_alter_table_online.result File 26.79 KB 0644
ndb_alter_table_online2.result File 2.62 KB 0644
ndb_alter_table_online_multi.result File 1.98 KB 0644
ndb_auto_increment.result File 9.99 KB 0644
ndb_autoinc.result File 793 B 0644
ndb_basic.result File 29.94 KB 0644
ndb_bitfield.result File 8.26 KB 0644
ndb_blob.result File 22.71 KB 0644
ndb_blob_big.result File 1.24 KB 0644
ndb_blob_partition.result File 9.03 KB 0644
ndb_bug26793.result File 257 B 0644
ndb_bug31477.result File 1.85 KB 0644
ndb_bug31754.result File 262 B 0644
ndb_bulk_delete.result File 1.87 KB 0644
ndb_cache.result File 8.68 KB 0644
ndb_cache2.result File 13.31 KB 0644
ndb_cache_multi.result File 1.67 KB 0644
ndb_cache_multi2.result File 1.68 KB 0644
ndb_cache_trans.result File 6.65 KB 0644
ndb_charset.result File 5.77 KB 0644
ndb_column_properties.result File 15.98 KB 0644
ndb_condition_pushdown.result File 72.29 KB 0644
ndb_config.result File 3.21 KB 0644
ndb_config2.result File 475 B 0644
ndb_create_table.result File 1.02 KB 0644
ndb_cursor.result File 865 B 0644
ndb_database.result File 1.23 KB 0644
ndb_dbug_lock.result File 1.64 KB 0644
ndb_dbug_tc_select.result File 5.98 KB 0644
ndb_dd_alter.result File 27.07 KB 0644
ndb_dd_basic.result File 20.67 KB 0644
ndb_dd_bug12581213.result File 334 B 0644
ndb_dd_ddl.result File 5.56 KB 0644
ndb_dd_disk2memory.result File 12.99 KB 0644
ndb_dd_dump.result File 15.97 KB 0644
ndb_dd_restore_compat.result File 3.61 KB 0644
ndb_dd_sql_features.result File 22.4 KB 0644
ndb_ddl_open_trans.result File 1.36 KB 0644
ndb_disconnect_ddl.result File 281 B 0644
ndb_discover_db.result File 1.55 KB 0644
ndb_dist_priv.result File 4.8 KB 0644
ndb_gis.result File 47.18 KB 0644
ndb_global_schema_lock.result File 3.43 KB 0644
ndb_global_schema_lock_error.result File 1.94 KB 0644
ndb_grant.result File 17.65 KB 0644
ndb_hidden_pk.result File 10.55 KB 0644
ndb_index.result File 13.93 KB 0644
ndb_index_ordered.result File 16.71 KB 0644
ndb_index_stat.result File 14.33 KB 0644
ndb_index_unique.result File 17.43 KB 0644
ndb_insert.result File 36.2 KB 0644
ndb_join_pushdown.result File 274.88 KB 0644
ndb_limit.result File 2.01 KB 0644
ndb_load.result File 2.64 KB 0644
ndb_loaddatalocal.result File 1.39 KB 0644
ndb_lock.result File 4.17 KB 0644
ndb_lock_table.result File 205 B 0644
ndb_mgm.result File 3.55 KB 0644
ndb_minmax.result File 1.47 KB 0644
ndb_multi.result File 3.7 KB 0644
ndb_multi_row.result File 1.33 KB 0644
ndb_native_default_support.result File 47.23 KB 0644
ndb_optimize_table.result File 2 KB 0644
ndb_optimized_node_selection.result File 1017 B 0644
ndb_partition_error.result File 1.41 KB 0644
ndb_partition_error2.result File 150 B 0644
ndb_partition_hash.result File 890 B 0644
ndb_partition_key.result File 8.16 KB 0644
ndb_partition_list.result File 2.31 KB 0644
ndb_partition_range.result File 7.91 KB 0644
ndb_read_multi_range.result File 14.54 KB 0644
ndb_reconnect.result File 560 B 0644
ndb_rename.result File 772 B 0644
ndb_replace.result File 3.64 KB 0644
ndb_restore_compat_downward.result File 132.43 KB 0644
ndb_restore_compat_endianness.result File 10.87 KB 0644
ndb_restore_conv_lossy_charbinary.result File 15.46 KB 0644
ndb_restore_conv_lossy_integral.result File 20.72 KB 0644
ndb_restore_conv_padding.result File 6.14 KB 0644
ndb_restore_conv_promotion.result File 23.26 KB 0644
ndb_restore_discover.result File 540 B 0644
ndb_restore_misc.result File 23.77 KB 0644
ndb_restore_print.result File 9.8 KB 0644
ndb_restore_schema_blobs.result File 6.44 KB 0644
ndb_restore_schema_partitions.result File 13.3 KB 0644
ndb_restore_schema_rewrites.result File 12.22 KB 0644
ndb_restore_schema_subsets.result File 95.9 KB 0644
ndb_restore_schema_tolerance.result File 4.57 KB 0644
ndb_restore_undolog.result File 18.66 KB 0644
ndb_row_count.result File 5.11 KB 0644
ndb_row_format.result File 1.74 KB 0644
ndb_select_count.result File 334 B 0644
ndb_share.result File 9.85 KB 0644
ndb_short_sigs.result File 2.53 KB 0644
ndb_single_user.result File 3.97 KB 0644
ndb_sp.result File 1.1 KB 0644
ndb_sql_allow_batching.result File 918 B 0644
ndb_statistics0.result File 7.78 KB 0644
ndb_statistics1.result File 8.04 KB 0644
ndb_subquery.result File 3.07 KB 0644
ndb_temporary.result File 939 B 0644
ndb_tmp_table_and_DDL.result File 3.11 KB 0644
ndb_transaction.result File 4.62 KB 0644
ndb_trigger.result File 9.38 KB 0644
ndb_truncate.result File 425 B 0644
ndb_types.result File 3.12 KB 0644
ndb_update.result File 2.76 KB 0644
ndb_update_no_read.result File 11.37 KB 0644
ndb_view.result File 597 B 0644
ndbapi.result File 734 B 0644
ndbinfo.result File 12.86 KB 0644
ndbinfo_cache.result File 423 B 0644
ndbinfo_dump.result File 95 B 0644
ps_7ndb.result File 103.12 KB 0644
strict_autoinc_5ndb.result File 651 B 0644