hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From r..@apache.org
Subject [03/51] [partial] incubator-hawq git commit: SGA import
Date Sat, 19 Sep 2015 00:35:46 GMT
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_9/test_ao_zlib_9.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_9/test_ao_zlib_9.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_9/test_ao_zlib_9.sql
new file mode 100644
index 0000000..3de1d7f
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_9/test_ao_zlib_9.sql
@@ -0,0 +1,502 @@
+DROP TABLE IF EXISTS test_ao_zlib_9;
+CREATE TABLE test_ao_zlib_9 (c0 int4, c1 text) with (appendonly=true, orientation=row, compresstype=zlib, blocksize=32768, checksum=false, compresslevel=9);
+INSERT INTO test_ao_zlib_9 values (-2147483648, null),
+(2147483647, 'z'),
+(-2147483648, ''),
+(0, 'z'),
+(-128, repeat('b',1000)),
+(0, 'z'),
+(-2147483648, 'hello world'),
+(null, ''),
+(null, 'hello world'),
+(-128, null),
+(-32768, repeat('b',1000)),
+(32767, 'hello world'),
+(-2147483648, repeat('b',1000)),
+(0, ''),
+(-128, 'hello world'),
+(2147483647, 'z'),
+(32767, ''),
+(0, null),
+(-32768, null),
+(null, null),
+(-2147483648, ''),
+(128, ''),
+(0, null),
+(-2147483648, ''),
+(-128, 'z'),
+(-2147483648, repeat('b',1000)),
+(32767, 'z'),
+(0, null),
+(-128, 'z'),
+(128, 'hello world'),
+(2147483647, 'z'),
+(null, 'hello world'),
+(0, repeat('b',1000)),
+(-128, 'z'),
+(-128, 'z'),
+(128, null),
+(null, 'z'),
+(-2147483648, 'z'),
+(128, 'z'),
+(-32768, repeat('b',1000)),
+(-2147483648, null),
+(128, 'hello world'),
+(32767, ''),
+(null, ''),
+(0, repeat('b',1000)),
+(128, 'z'),
+(null, null),
+(128, ''),
+(-128, repeat('b',1000)),
+(-2147483648, ''),
+(-2147483648, null),
+(0, 'hello world'),
+(0, null),
+(32767, null),
+(-128, 'hello world'),
+(32767, ''),
+(32767, repeat('b',1000)),
+(-128, ''),
+(-128, 'hello world'),
+(-32768, 'hello world'),
+(-32768, repeat('b',1000)),
+(-128, repeat('b',1000)),
+(128, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(null, ''),
+(32767, 'hello world'),
+(128, null),
+(-2147483648, 'z'),
+(-32768, 'z'),
+(2147483647, null),
+(null, 'z'),
+(32767, ''),
+(-128, repeat('b',1000)),
+(null, repeat('b',1000)),
+(2147483647, 'hello world'),
+(2147483647, 'z'),
+(-128, 'hello world'),
+(32767, ''),
+(2147483647, repeat('b',1000)),
+(32767, repeat('b',1000)),
+(-2147483648, ''),
+(-2147483648, 'z'),
+(32767, null),
+(32767, 'z'),
+(-128, repeat('b',1000)),
+(null, null),
+(2147483647, 'hello world'),
+(128, repeat('b',1000)),
+(null, 'hello world'),
+(-2147483648, 'z'),
+(2147483647, 'z'),
+(-32768, null),
+(2147483647, 'z'),
+(128, 'z'),
+(-128, ''),
+(-32768, null),
+(0, 'z'),
+(128, ''),
+(0, 'z'),
+(-32768, 'hello world'),
+(2147483647, repeat('b',1000)),
+(0, ''),
+(128, 'hello world'),
+(-2147483648, ''),
+(-128, ''),
+(null, 'hello world'),
+(null, ''),
+(0, 'z'),
+(0, 'hello world'),
+(2147483647, 'z'),
+(null, 'hello world'),
+(-2147483648, 'z'),
+(-32768, 'z'),
+(0, ''),
+(-32768, repeat('b',1000)),
+(128, null),
+(128, repeat('b',1000)),
+(-128, 'hello world'),
+(128, 'hello world'),
+(2147483647, repeat('b',1000)),
+(0, 'hello world'),
+(-128, 'hello world'),
+(-128, null),
+(-2147483648, repeat('b',1000)),
+(128, 'hello world'),
+(0, 'hello world'),
+(2147483647, ''),
+(0, repeat('b',1000)),
+(128, null),
+(128, 'z'),
+(null, repeat('b',1000)),
+(null, null),
+(-32768, 'z'),
+(32767, repeat('b',1000)),
+(-2147483648, 'hello world'),
+(0, 'z'),
+(-32768, 'z'),
+(-32768, ''),
+(128, ''),
+(-128, ''),
+(32767, 'hello world'),
+(null, null),
+(-2147483648, null),
+(-128, 'hello world'),
+(-2147483648, 'z'),
+(32767, 'hello world'),
+(32767, repeat('b',1000)),
+(null, 'z'),
+(128, 'hello world'),
+(null, 'z'),
+(-128, 'z'),
+(128, repeat('b',1000)),
+(2147483647, 'z'),
+(-128, ''),
+(0, null),
+(2147483647, 'z'),
+(2147483647, null),
+(2147483647, repeat('b',1000)),
+(128, ''),
+(-2147483648, 'z'),
+(-32768, 'z'),
+(null, null),
+(32767, 'hello world'),
+(128, repeat('b',1000)),
+(0, 'z'),
+(-32768, null),
+(-32768, ''),
+(null, null),
+(null, repeat('b',1000)),
+(0, 'hello world'),
+(-128, ''),
+(-128, ''),
+(-128, null),
+(0, repeat('b',1000)),
+(2147483647, 'z'),
+(-2147483648, null),
+(null, ''),
+(32767, 'z'),
+(-128, repeat('b',1000)),
+(-2147483648, ''),
+(-32768, 'hello world'),
+(-2147483648, repeat('b',1000)),
+(-128, 'hello world'),
+(128, null),
+(0, null),
+(null, ''),
+(2147483647, null),
+(32767, 'z'),
+(-32768, 'hello world'),
+(2147483647, null),
+(null, null),
+(-2147483648, repeat('b',1000)),
+(-128, ''),
+(0, null),
+(32767, null),
+(32767, null),
+(0, 'z'),
+(128, null),
+(null, null),
+(-2147483648, null),
+(2147483647, 'z'),
+(-2147483648, 'z'),
+(null, ''),
+(-2147483648, 'hello world'),
+(-2147483648, 'z'),
+(32767, 'z'),
+(32767, 'z'),
+(-32768, ''),
+(0, null),
+(2147483647, 'hello world'),
+(2147483647, 'z'),
+(128, repeat('b',1000)),
+(0, repeat('b',1000)),
+(2147483647, null),
+(0, null),
+(32767, 'hello world'),
+(128, repeat('b',1000)),
+(-128, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(128, 'z'),
+(0, repeat('b',1000)),
+(32767, null),
+(2147483647, null),
+(32767, 'z'),
+(-128, 'z'),
+(null, ''),
+(0, 'hello world'),
+(-128, repeat('b',1000)),
+(-32768, 'z'),
+(32767, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(-32768, 'hello world'),
+(128, repeat('b',1000)),
+(-2147483648, 'z'),
+(-2147483648, 'z'),
+(128, repeat('b',1000)),
+(32767, repeat('b',1000)),
+(32767, null),
+(-32768, 'hello world'),
+(128, 'hello world'),
+(-2147483648, repeat('b',1000)),
+(128, ''),
+(-128, 'z'),
+(-2147483648, repeat('b',1000)),
+(0, repeat('b',1000)),
+(0, 'z'),
+(null, 'z'),
+(null, repeat('b',1000)),
+(null, 'hello world'),
+(-2147483648, ''),
+(-32768, repeat('b',1000)),
+(null, ''),
+(null, 'z'),
+(-128, null),
+(-128, ''),
+(-128, 'z'),
+(128, ''),
+(32767, null),
+(-2147483648, 'z'),
+(32767, ''),
+(-128, 'hello world'),
+(2147483647, 'hello world'),
+(32767, 'hello world'),
+(-32768, repeat('b',1000)),
+(32767, 'hello world'),
+(-32768, repeat('b',1000)),
+(-128, null),
+(2147483647, 'z'),
+(32767, 'z'),
+(2147483647, null),
+(0, 'z'),
+(-32768, null),
+(2147483647, 'z'),
+(0, null),
+(null, 'hello world'),
+(2147483647, null),
+(128, ''),
+(0, repeat('b',1000)),
+(0, repeat('b',1000)),
+(32767, 'hello world'),
+(-32768, repeat('b',1000)),
+(-128, null),
+(128, repeat('b',1000)),
+(0, repeat('b',1000)),
+(32767, ''),
+(0, 'hello world'),
+(-32768, 'hello world'),
+(null, ''),
+(null, 'z'),
+(2147483647, ''),
+(null, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(32767, 'hello world'),
+(0, ''),
+(128, null),
+(-32768, 'hello world'),
+(-32768, repeat('b',1000)),
+(2147483647, ''),
+(-2147483648, null),
+(-2147483648, repeat('b',1000)),
+(32767, 'z'),
+(2147483647, 'z'),
+(-2147483648, repeat('b',1000)),
+(-32768, 'z'),
+(2147483647, ''),
+(128, ''),
+(null, null),
+(32767, null),
+(0, 'hello world'),
+(32767, repeat('b',1000)),
+(-128, 'z'),
+(-128, ''),
+(-2147483648, 'hello world'),
+(null, ''),
+(-2147483648, null),
+(128, ''),
+(2147483647, 'hello world'),
+(-128, null),
+(0, repeat('b',1000)),
+(0, ''),
+(-2147483648, 'hello world'),
+(2147483647, 'z'),
+(2147483647, 'hello world'),
+(-128, 'hello world'),
+(32767, 'z'),
+(32767, 'z'),
+(2147483647, repeat('b',1000)),
+(32767, 'z'),
+(0, 'z'),
+(-128, 'hello world'),
+(-128, repeat('b',1000)),
+(-32768, 'z'),
+(128, null),
+(2147483647, null),
+(-2147483648, ''),
+(null, 'hello world'),
+(2147483647, 'z'),
+(32767, repeat('b',1000)),
+(128, repeat('b',1000)),
+(32767, repeat('b',1000)),
+(-32768, 'z'),
+(-2147483648, 'z'),
+(-2147483648, ''),
+(null, repeat('b',1000)),
+(-32768, 'hello world'),
+(0, 'z'),
+(2147483647, null),
+(32767, null),
+(null, ''),
+(-2147483648, repeat('b',1000)),
+(-2147483648, repeat('b',1000)),
+(-128, null),
+(null, 'hello world'),
+(128, ''),
+(2147483647, repeat('b',1000)),
+(null, 'hello world'),
+(2147483647, 'z'),
+(32767, 'hello world'),
+(-2147483648, 'hello world'),
+(128, 'hello world'),
+(null, null),
+(128, null),
+(2147483647, 'z'),
+(-128, repeat('b',1000)),
+(2147483647, null),
+(0, ''),
+(null, ''),
+(2147483647, 'hello world'),
+(-32768, 'hello world'),
+(-32768, 'z'),
+(2147483647, null),
+(128, null),
+(32767, null),
+(128, repeat('b',1000)),
+(-2147483648, 'z'),
+(2147483647, repeat('b',1000)),
+(32767, ''),
+(-32768, 'z'),
+(2147483647, null),
+(-32768, null),
+(0, ''),
+(0, null),
+(-32768, null),
+(2147483647, repeat('b',1000)),
+(-128, repeat('b',1000)),
+(2147483647, ''),
+(32767, ''),
+(-2147483648, repeat('b',1000)),
+(-128, null),
+(-128, 'hello world'),
+(2147483647, 'z'),
+(null, 'hello world'),
+(0, 'hello world'),
+(null, 'z'),
+(2147483647, repeat('b',1000)),
+(0, repeat('b',1000)),
+(32767, repeat('b',1000)),
+(32767, null),
+(null, 'z'),
+(-2147483648, null),
+(0, null),
+(-2147483648, 'hello world'),
+(0, 'z'),
+(32767, 'z'),
+(-128, ''),
+(2147483647, repeat('b',1000)),
+(null, null),
+(-2147483648, null),
+(null, null),
+(-2147483648, repeat('b',1000)),
+(2147483647, null),
+(null, null),
+(2147483647, ''),
+(2147483647, ''),
+(128, repeat('b',1000)),
+(-2147483648, 'hello world'),
+(0, 'hello world'),
+(-2147483648, null),
+(-32768, ''),
+(null, ''),
+(0, 'z'),
+(2147483647, ''),
+(-32768, null),
+(-32768, repeat('b',1000)),
+(0, null),
+(-128, 'hello world'),
+(2147483647, ''),
+(-128, repeat('b',1000)),
+(32767, 'z'),
+(-32768, null),
+(2147483647, null),
+(-32768, null),
+(128, repeat('b',1000)),
+(128, ''),
+(-32768, null),
+(-128, 'hello world'),
+(0, repeat('b',1000)),
+(32767, 'hello world'),
+(-2147483648, 'hello world'),
+(-32768, null),
+(-32768, null),
+(-2147483648, ''),
+(2147483647, repeat('b',1000)),
+(null, ''),
+(-128, 'z'),
+(-2147483648, repeat('b',1000)),
+(0, ''),
+(32767, repeat('b',1000)),
+(2147483647, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(0, ''),
+(-32768, 'z'),
+(-2147483648, 'hello world'),
+(null, 'z'),
+(-2147483648, 'hello world'),
+(-2147483648, 'hello world'),
+(-32768, repeat('b',1000)),
+(2147483647, null),
+(0, ''),
+(0, 'z'),
+(null, 'hello world'),
+(128, null),
+(128, repeat('b',1000)),
+(null, repeat('b',1000)),
+(0, null),
+(32767, null),
+(32767, ''),
+(32767, repeat('b',1000)),
+(-32768, repeat('b',1000)),
+(-128, 'hello world'),
+(-2147483648, ''),
+(-2147483648, ''),
+(null, 'hello world'),
+(-128, ''),
+(0, ''),
+(-32768, 'z'),
+(128, 'z'),
+(0, ''),
+(0, 'z'),
+(-32768, repeat('b',1000)),
+(128, null),
+(-32768, null),
+(2147483647, ''),
+(-128, 'hello world'),
+(0, ''),
+(32767, 'z'),
+(32767, null),
+(-32768, 'hello world'),
+(-2147483648, null),
+(null, 'z'),
+(0, 'z'),
+(-32768, 'hello world'),
+(2147483647, ''),
+(128, null),
+(32767, 'z'),
+(32767, ''),
+(2147483647, null),
+(-2147483648, 'z'),
+(32767, 'z'),
+(-32768, 'hello world');
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_9/test_ao_zlib_9.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_9/test_ao_zlib_9.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_9/test_ao_zlib_9.yaml
new file mode 100644
index 0000000..0e76a3a
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_ao_zlib_9/test_ao_zlib_9.yaml
@@ -0,0 +1,23 @@
+AO_FileLocations:
+  Blocksize: 32768
+  Checksum: false
+  CompressionLevel: 9
+  CompressionType: zlib
+  Files:
+  - path: test-data/hawq-data/gpseg0/16385/179545/179591.1
+    size: 704
+  - path: test-data/hawq-data/gpseg1/16385/179545/179591.1
+    size: 2856
+AO_Schema:
+- name: c0
+  type: int4
+- name: c1
+  type: text
+DBVersion: PostgreSQL 8.2.15 (Greenplum Database 4.2.0 build 1) (HAWQ 1.2.0.0 build
+  dev) on i386-apple-darwin11.4.2, compiled by GCC gcc (GCC) 4.4.2 compiled on Feb
+  28 2014 09:52:04 (with assert checking)
+DFS_URL: hdfs://127.0.0.1:9000
+Encoding: UTF8
+FileFormat: AO
+TableName: public.test_ao_zlib_9
+Version: 1.0.0

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_parquet_alltypes/test_parquet_alltypes.ans
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_parquet_alltypes/test_parquet_alltypes.ans b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_parquet_alltypes/test_parquet_alltypes.ans
new file mode 100644
index 0000000..cca81c4
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_parquet_alltypes/test_parquet_alltypes.ans
@@ -0,0 +1,100 @@
+false|0|000000000011100|aaaaaaaaaaaaaaaaaaa|-32768|-128|0|null|null|123456789a|z|2014-03-02|04:05:06|2004-10-19 10:23:54.0|178000000 years|(100,200)|[(1,1),(2,2)]|(2,3),(0,1)|<(100,200),300>|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|null
+false|0|1111|aaaaaaaaaaaaaaaaaaa|-128|null|128|0.0001|aaaa      |aaaa|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4277-12-31|00:00:00|4713-01-01 00:00:00.0|178000000 years|(1,2)|null|null|<(1,2),3>|null|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|172.20.143.0/24|null
+false|0|1111|aaaaaaaaaaaaaaaaaaa|-32768|-2147483648|128|0.0001|aaaa      |bbccddeeff|hello world|4277-12-31|23:59:59|null|null|null|[(0,0),(6,6)]|null|<(100,200),300>|((1,1))|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|172.20.143.0|null|null
+false|0|1111|hello world|-128|-128|-9223372036854775808|0.0001|aaaa      |aaaa|null|4277-12-31|null|1999-01-08 04:05:06.0|178000000 years|(100,200)|[(1,1),(2,2)]|(200,400),(100,200)|null|((1,1))|null|ff:89:71:45:ae:01|192.168.1.255/24|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<aa>bb</aa>
+false|0|1111|hello world|0|32767|0|6.54|bbccddeeff|aaaa||null|23:59:59|1999-01-08 04:05:06.0|null|(1,2)|[(0,0),(6,6)]|(2,3),(0,1)|null|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|2001::7344|172.20.143.0/24|null
+false|0|1111|null|-128|128|-9223372036854775808|0.0001|aaaa      |123456789a|z|null|00:00:00|2004-10-19 10:23:54.0|-178000000 years|null|null|(2,3),(0,1)|<(1,2),3>|((1,1))|((1,1),(3,2),(4,5))|null|null|null|null
+false|0|null|aaaaaaaaaaaaaaaaaaa|-128|-2147483648|-2147483648|null|123456789a|bbccddeeff|null|4713-01-01|23:59:59|2004-10-19 10:23:54.0|178000000 years|(1000,2000)|null|null|null|null|((1,1),(3,2),(4,5))|null|192.168.1.255/24|172.20.143.0/24|<name>wj</name>
+false|0|null|aaaaaaaaaaaaaaaaaaa|128|-2147483648|2147483647|6.54|123456789a|bbccddeeff|null|4713-01-01|00:00:00|null|-178000000 years|null|[(0,0),(6,6)]|(200,400),(100,200)|<(1,2),3>|((1,1))|((100,123),(5,10),(7,2),(4,5))|null|172.20.143.0|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+false|0|null|aaaaaaaaaaaaaaaaaaa|32767|-2147483648|128|0.0001|bbccddeeff|null||4713-01-01|00:00:00|null|178000000 years|(1000,2000)|[(1,1),(2,2)]|null|<(1,2),3>|((1,1),(2,3),(4,5))|((100,123),(5,10),(7,2),(4,5))|null|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+false|0|null|null|0|128|32767|0.0001|null|null|z|4277-12-31|null|2942-12-31 00:00:00.0|178000000 years|(1000,2000)|[(1,1),(2,2)]|null|null|((1,1))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|2001::7344|null|<name>wj</name>
+false|0|null|null|0|2147483647|null|null|123456789a|bbccddeeff|null|null|23:59:59|4713-01-01 00:00:00.0|null|(1,2)|[(1,1),(2,2)]|(2,3),(0,1)|null|((1,1),(2,3),(4,5))|null|null|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+false|1|000000000011100|aaaaaaaaaaaaaaaaaaa|0|-128|-9223372036854775808|6.54|aaaa      |bbccddeeff||null|null|1999-01-08 04:05:06.0|178000000 years|(100,200)|[(1,1),(2,2)]|(2,3),(0,1)|<(1,2),3>|((1,1))|null|null|null|192.168.1.255/32|<aa>bb</aa>
+false|1|000000000011100|aaaaaaaaaaaaaaaaaaa|128|0|9223372036854775807|6.54|123456789a|aaaa|z|4277-12-31|00:00:00|4713-01-01 00:00:00.0|178000000 years|(100,200)|[(0,0),(6,6)]|(2,3),(0,1)|null|((1,1),(2,3),(4,5))|null|ff:89:71:45:ae:01|null|192.168.1.255/32|<aa>bb</aa>
+false|1|000000000011100|hello world|0|2147483647|9223372036854775807|6.54|aaaa      |bbccddeeff|null|4713-01-01|23:59:59|null|null|(1000,2000)|null|(2,3),(0,1)|null|((1,1))|((100,123),(5,10),(7,2),(4,5))|null|null|null|<name>wj</name>
+false|1|000000000011100|hello world|128|null|-9223372036854775808|6.54|aaaa      |bbccddeeff|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4277-12-31|04:05:06|2004-10-19 10:23:54.0|178000000 years|(1,2)|[(0,0),(6,6)]|null|<(100,200),300>|((1,1))|((100,123),(5,10),(7,2),(4,5))|null|172.20.143.0|192.168.1.255/32|<name>wj</name>
+false|1|000000000011100|null|-32768|0|0|null|bbccddeeff|123456789a|hello world|4713-01-01|00:00:00|null|178000000 years|(1,2)|[(0,0),(6,6)]|null|<(1,2),3>|null|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|192.168.1.255/32|<name>wj</name>
+false|1|000000000011100|null|32767|-32768|9223372036854775807|6.54|aaaa      |123456789a||2014-03-02|04:05:06|2942-12-31 00:00:00.0|-178000000 years|null|[(1,1),(2,2)]|(200,400),(100,200)|<(100,200),300>|((1,1))|((1,1),(3,2),(4,5))|null|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|null
+false|1|1111|hello world|null|128|null|null|bbccddeeff|null||2014-03-02|23:59:59|4713-01-01 00:00:00.0|178000000 years|(100,200)|[(1,1),(2,2)]|(2,3),(0,1)|<(1,2),3>|((1,1),(2,3),(4,5))|((100,123),(5,10),(7,2),(4,5))|null|192.168.1.255/24|null|null
+false|1|1111|null|-128|-32768|null|0.0001|123456789a|123456789a|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4277-12-31|04:05:06|1999-01-08 04:05:06.0|-178000000 years|(100,200)|null|null|<(1,2),3>|null|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<aa>bb</aa>
+false|1|1111|null|-32768|-128|-128|6.54|bbccddeeff|bbccddeeff|z|null|00:00:00|2004-10-19 10:23:54.0|-178000000 years|(100,200)|[(1,1),(2,2)]|(200,400),(100,200)|<(100,200),300>|((1,1))|null|ff:89:71:45:ae:01|172.20.143.0|192.168.1.255/32|<name>wj</name>
+false|1|1111|null|128|-2147483648|-32768|null|bbccddeeff|aaaa||null|04:05:06|null|178000000 years|(1,2)|[(1,1),(2,2)]|(2,3),(0,1)|<(1,2),3>|((1,1))|null|null|172.20.143.0|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+false|1|1111|null|128|-32768|0|6.54|bbccddeeff|aaaa|null|2014-03-02|null|2942-12-31 00:00:00.0|-178000000 years|(100,200)|[(0,0),(6,6)]|(200,400),(100,200)|<(100,200),300>|null|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|192.168.1.255/24|192.168.1.255/32|null
+false|1|1111|null|null|-32768|9223372036854775807|0.0001|null|aaaa|null|2014-03-02|23:59:59|1999-01-08 04:05:06.0|178000000 years|(1000,2000)|[(0,0),(6,6)]|(2,3),(0,1)|<(100,200),300>|((1,1))|null|ff:89:71:45:ae:01|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|null
+false|1|null|aaaaaaaaaaaaaaaaaaa|-128|-32768|2147483647|null|bbccddeeff|aaaa|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4277-12-31|00:00:00|2004-10-19 10:23:54.0|null|null|[(0,0),(6,6)]|(200,400),(100,200)|<(1,2),3>|((1,1),(2,3),(4,5))|null|null|172.20.143.0|null|null
+false|1|null|aaaaaaaaaaaaaaaaaaa|null|128|-128|null|bbccddeeff|123456789a|null|4713-01-01|00:00:00|null|null|(1,2)|[(1,1),(2,2)]|null|<(100,200),300>|null|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|null|<name>wj</name>
+false|1|null|hello world|0|128|32767|6.54|123456789a|aaaa|null|4277-12-31|23:59:59|null|-178000000 years|null|null|(200,400),(100,200)|<(1,2),3>|((1,1))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|172.20.143.0|172.20.143.0/24|null
+false|1|null|hello world|null|-32768|128|0.0001|bbccddeeff|aaaa|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4277-12-31|00:00:00|2004-10-19 10:23:54.0|178000000 years|(1,2)|[(0,0),(6,6)]|null|<(1,2),3>|((1,1))|null|null|2001::7344|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|null
+false|1|null|null|0|-32768|9223372036854775807|6.54|123456789a|null|z|4277-12-31|null|4713-01-01 00:00:00.0|null|(1000,2000)|[(0,0),(6,6)]|null|<(1,2),3>|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+false|1|null|null|0|0|-32768|0.0001|123456789a|null|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4277-12-31|04:05:06|1999-01-08 04:05:06.0|null|null|[(1,1),(2,2)]|(2,3),(0,1)|<(100,200),300>|((1,1))|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|192.168.1.255/24|192.168.1.255/32|<aa>bb</aa>
+false|null|000000000011100|aaaaaaaaaaaaaaaaaaa|-32768|-32768|0|null|bbccddeeff|null|null|null|null|2942-12-31 00:00:00.0|-178000000 years|null|null|(2,3),(0,1)|null|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|null|192.168.1.255/24|null|null
+false|null|000000000011100|hello world|-32768|2147483647|9223372036854775807|6.54|123456789a|bbccddeeff|null|null|null|4713-01-01 00:00:00.0|-178000000 years|null|null|null|null|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|null|192.168.1.255/24|null|<aa>bb</aa>
+false|null|000000000011100|hello world|null|-2147483648|2147483647|6.54|123456789a|null|z|4713-01-01|00:00:00|2942-12-31 00:00:00.0|-178000000 years|(1000,2000)|[(1,1),(2,2)]|(2,3),(0,1)|<(100,200),300>|null|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|2001::7344|172.20.143.0/24|<name>wj</name>
+false|null|000000000011100|null|-128|null|2147483647|0.0001|123456789a|null|z|null|null|4713-01-01 00:00:00.0|178000000 years|(100,200)|null|(2,3),(0,1)|<(100,200),300>|((1,1),(2,3),(4,5))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|172.20.143.0|null|<name>wj</name>
+false|null|000000000011100|null|-32768|0|-9223372036854775808|6.54|123456789a|aaaa|hello world|4713-01-01|null|2942-12-31 00:00:00.0|null|null|[(1,1),(2,2)]|(200,400),(100,200)|<(100,200),300>|((1,1))|null|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+false|null|1111|hello world|128|32767|9223372036854775807|null|bbccddeeff|aaaa||4713-01-01|04:05:06|4713-01-01 00:00:00.0|-178000000 years|(1,2)|[(1,1),(2,2)]|(2,3),(0,1)|<(100,200),300>|null|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|192.168.1.255/32|<aa>bb</aa>
+false|null|1111|null|null|128|-2147483648|null|null|aaaa|z|4277-12-31|23:59:59|2942-12-31 00:00:00.0|null|(100,200)|[(1,1),(2,2)]|(200,400),(100,200)|<(100,200),300>|((1,1))|((100,123),(5,10),(7,2),(4,5))|null|172.20.143.0|172.20.143.0/24|<name>wj</name>
+false|null|null|hello world|-128|-128|null|null|123456789a|123456789a||4277-12-31|null|1999-01-08 04:05:06.0|178000000 years|(100,200)|[(0,0),(6,6)]|(200,400),(100,200)|null|null|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|192.168.1.255/32|<name>wj</name>
+false|null|null|hello world|32767|128|-32768|0.0001|123456789a|aaaa||4713-01-01|00:00:00|null|null|null|[(1,1),(2,2)]|null|<(1,2),3>|((1,1))|((1,1),(3,2),(4,5))|null|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<aa>bb</aa>
+false|null|null|hello world|null|null|null|null|null|bbccddeeff||4277-12-31|23:59:59|1999-01-08 04:05:06.0|null|(1000,2000)|[(1,1),(2,2)]|(200,400),(100,200)|<(1,2),3>|((1,1),(2,3),(4,5))|null|ff:89:71:45:ae:01|2001::7344|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+false|null|null|null|128|128|9223372036854775807|0.0001|null|null|hello world|4277-12-31|00:00:00|2004-10-19 10:23:54.0|178000000 years|null|[(0,0),(6,6)]|(2,3),(0,1)|<(100,200),300>|null|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|192.168.1.255/24|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+null|0|000000000011100|aaaaaaaaaaaaaaaaaaa|32767|32767|32767|6.54|123456789a|bbccddeeff||null|23:59:59|1999-01-08 04:05:06.0|null|null|null|(200,400),(100,200)|null|((1,1))|((100,123),(5,10),(7,2),(4,5))|null|2001::7344|192.168.1.255/32|<aa>bb</aa>
+null|0|000000000011100|hello world|-128|-128|-9223372036854775808|null|aaaa      |aaaa|z|null|00:00:00|2004-10-19 10:23:54.0|null|(1000,2000)|[(1,1),(2,2)]|(200,400),(100,200)|<(100,200),300>|((1,1))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|172.20.143.0|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|null
+null|0|000000000011100|hello world|null|null|-128|null|aaaa      |null|z|4277-12-31|null|1999-01-08 04:05:06.0|178000000 years|(1,2)|[(0,0),(6,6)]|null|null|((1,1))|null|null|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<aa>bb</aa>
+null|0|1111|aaaaaaaaaaaaaaaaaaa|null|0|9223372036854775807|0.0001|aaaa      |123456789a|null|null|04:05:06|2942-12-31 00:00:00.0|null|(1000,2000)|[(1,1),(2,2)]|(200,400),(100,200)|<(100,200),300>|((1,1))|null|ff:89:71:45:ae:01|192.168.1.255/24|172.20.143.0/24|null
+null|0|null|hello world|-128|null|-2147483648|null|null|bbccddeeff|hello world|4713-01-01|null|2942-12-31 00:00:00.0|null|(1000,2000)|[(0,0),(6,6)]|null|null|((1,1))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|2001::7344|172.20.143.0/24|<name>wj</name>
+null|0|null|null|-128|-128|128|null|123456789a|aaaa|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4277-12-31|04:05:06|null|-178000000 years|(100,200)|[(0,0),(6,6)]|(2,3),(0,1)|<(1,2),3>|null|null|ff:89:71:45:ae:01|2001::7344|192.168.1.255/32|null
+null|0|null|null|32767|0|-128|6.54|null|bbccddeeff|null|4713-01-01|23:59:59|4713-01-01 00:00:00.0|178000000 years|(1000,2000)|[(0,0),(6,6)]|null|null|((1,1),(2,3),(4,5))|null|ff:89:71:45:ae:01|192.168.1.255/24|172.20.143.0/24|<name>wj</name>
+null|0|null|null|null|128|0|0.0001|aaaa      |aaaa|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4277-12-31|23:59:59|1999-01-08 04:05:06.0|-178000000 years|(100,200)|null|(200,400),(100,200)|null|((1,1))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|192.168.1.255/24|192.168.1.255/32|null
+null|1|000000000011100|aaaaaaaaaaaaaaaaaaa|32767|-32768|0|6.54|null|aaaa||2014-03-02|00:00:00|4713-01-01 00:00:00.0|178000000 years|(100,200)|[(0,0),(6,6)]|(2,3),(0,1)|<(100,200),300>|((1,1))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|172.20.143.0|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+null|1|000000000011100|hello world|128|null|-128|0.0001|null|null|hello world|2014-03-02|00:00:00|2004-10-19 10:23:54.0|178000000 years|null|null|(200,400),(100,200)|<(1,2),3>|((1,1))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|null|192.168.1.255/32|<aa>bb</aa>
+null|1|000000000011100|hello world|32767|32767|128|0.0001|bbccddeeff|123456789a||null|null|2942-12-31 00:00:00.0|null|(100,200)|null|(200,400),(100,200)|<(1,2),3>|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|2001::7344|null|<name>wj</name>
+null|1|000000000011100|null|0|32767|-9223372036854775808|6.54|bbccddeeff|aaaa|null|2014-03-02|23:59:59|null|null|(1000,2000)|null|(200,400),(100,200)|<(1,2),3>|((1,1))|null|null|192.168.1.255/24|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+null|1|000000000011100|null|32767|-32768|-9223372036854775808|6.54|aaaa      |bbccddeeff|null|2014-03-02|04:05:06|null|null|null|[(1,1),(2,2)]|(200,400),(100,200)|<(100,200),300>|((1,1))|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|172.20.143.0|172.20.143.0/24|null
+null|1|000000000011100|null|null|2147483647|-128|0.0001|123456789a|bbccddeeff|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4277-12-31|04:05:06|null|178000000 years|(1,2)|null|null|<(1,2),3>|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|null|172.20.143.0|192.168.1.255/32|<name>wj</name>
+null|1|1111|aaaaaaaaaaaaaaaaaaa|-128|128|128|0.0001|bbccddeeff|123456789a||4277-12-31|null|2004-10-19 10:23:54.0|-178000000 years|(1000,2000)|[(1,1),(2,2)]|null|null|((1,1))|null|ff:89:71:45:ae:01|192.168.1.255/24|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<aa>bb</aa>
+null|1|1111|aaaaaaaaaaaaaaaaaaa|null|-128|0|6.54|bbccddeeff|aaaa||4713-01-01|00:00:00|1999-01-08 04:05:06.0|178000000 years|(100,200)|[(0,0),(6,6)]|(2,3),(0,1)|<(1,2),3>|((1,1))|null|null|2001::7344|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|null
+null|1|null|aaaaaaaaaaaaaaaaaaa|128|-2147483648|9223372036854775807|0.0001|123456789a|null|hello world|null|04:05:06|2004-10-19 10:23:54.0|178000000 years|null|[(1,1),(2,2)]|null|null|null|((1,1),(3,2),(4,5))|null|172.20.143.0|192.168.1.255/32|<name>wj</name>
+null|1|null|null|128|128|0|6.54|123456789a|null|z|2014-03-02|04:05:06|2942-12-31 00:00:00.0|null|null|null|(200,400),(100,200)|<(100,200),300>|null|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|192.168.1.255/24|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<aa>bb</aa>
+null|null|000000000011100|hello world|-32768|null|-2147483648|null|123456789a|bbccddeeff|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4277-12-31|04:05:06|2942-12-31 00:00:00.0|-178000000 years|null|null|(2,3),(0,1)|<(1,2),3>|((1,1))|((1,1),(3,2),(4,5))|null|172.20.143.0|192.168.1.255/32|null
+null|null|000000000011100|hello world|128|2147483647|null|0.0001|aaaa      |123456789a|null|4277-12-31|04:05:06|1999-01-08 04:05:06.0|178000000 years|(1000,2000)|[(1,1),(2,2)]|(2,3),(0,1)|<(100,200),300>|null|null|ff:89:71:45:ae:01|2001::7344|null|<aa>bb</aa>
+null|null|000000000011100|hello world|null|2147483647|0|6.54|123456789a|bbccddeeff|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4277-12-31|04:05:06|1999-01-08 04:05:06.0|null|(1,2)|null|null|<(100,200),300>|null|((1,1),(3,2),(4,5))|null|172.20.143.0|192.168.1.255/32|<name>wj</name>
+null|null|000000000011100|null|-32768|32767|32767|6.54|aaaa      |bbccddeeff|hello world|4713-01-01|23:59:59|4713-01-01 00:00:00.0|178000000 years|(1,2)|[(1,1),(2,2)]|null|<(100,200),300>|null|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+null|null|000000000011100|null|null|-2147483648|2147483647|null|aaaa      |bbccddeeff||2014-03-02|null|2942-12-31 00:00:00.0|-178000000 years|(1,2)|[(1,1),(2,2)]|null|null|null|((1,1),(3,2),(4,5))|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|null|null
+null|null|1111|aaaaaaaaaaaaaaaaaaa|-32768|-2147483648|9223372036854775807|6.54|bbccddeeff|null|z|4713-01-01|00:00:00|null|null|(1000,2000)|[(0,0),(6,6)]|null|null|null|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|2001::7344|192.168.1.255/32|<name>wj</name>
+null|null|1111|aaaaaaaaaaaaaaaaaaa|32767|-128|2147483647|0.0001|123456789a|null|hello world|null|00:00:00|2942-12-31 00:00:00.0|-178000000 years|(1000,2000)|null|(2,3),(0,1)|null|((1,1))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|172.20.143.0|null|null
+null|null|1111|hello world|-32768|32767|null|0.0001|null|bbccddeeff||4713-01-01|23:59:59|null|178000000 years|(1,2)|[(1,1),(2,2)]|null|null|null|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|2001::7344|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<aa>bb</aa>
+null|null|null|aaaaaaaaaaaaaaaaaaa|-128|2147483647|-9223372036854775808|null|123456789a|123456789a||4277-12-31|00:00:00|null|178000000 years|(1,2)|null|null|null|((1,1),(2,3),(4,5))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|192.168.1.255/24|192.168.1.255/32|null
+null|null|null|aaaaaaaaaaaaaaaaaaa|128|null|-128|null|null|null|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|2014-03-02|23:59:59|2942-12-31 00:00:00.0|178000000 years|null|[(1,1),(2,2)]|null|null|null|null|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|172.20.143.0/24|null
+null|null|null|aaaaaaaaaaaaaaaaaaa|32767|null|null|null|aaaa      |null||4713-01-01|23:59:59|null|null|(1,2)|[(1,1),(2,2)]|(2,3),(0,1)|<(1,2),3>|null|null|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|172.20.143.0/24|<aa>bb</aa>
+null|null|null|null|null|-128|0|null|123456789a|bbccddeeff|z|4277-12-31|null|4713-01-01 00:00:00.0|-178000000 years|(1000,2000)|null|(2,3),(0,1)|<(1,2),3>|((1,1),(2,3),(4,5))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|null|null
+true|0|000000000011100|hello world|128|-32768|128|6.54|bbccddeeff|123456789a|z|4277-12-31|00:00:00|1999-01-08 04:05:06.0|-178000000 years|(100,200)|[(0,0),(6,6)]|null|<(100,200),300>|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|null|192.168.1.255/24|192.168.1.255/32|<aa>bb</aa>
+true|0|000000000011100|hello world|32767|-32768|null|6.54|123456789a|123456789a|hello world|4713-01-01|23:59:59|4713-01-01 00:00:00.0|-178000000 years|null|null|null|<(100,200),300>|((1,1))|((100,123),(5,10),(7,2),(4,5))|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|null
+true|0|1111|hello world|null|-128|-32768|null|bbccddeeff|123456789a||4713-01-01|00:00:00|2004-10-19 10:23:54.0|178000000 years|null|null|(200,400),(100,200)|<(100,200),300>|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|192.168.1.255/24|null|<name>wj</name>
+true|0|1111|null|null|2147483647|128|0.0001|null|bbccddeeff||4277-12-31|null|2004-10-19 10:23:54.0|null|(1000,2000)|[(1,1),(2,2)]|(200,400),(100,200)|<(100,200),300>|null|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|192.168.1.255/24|172.20.143.0/24|<aa>bb</aa>
+true|0|null|null|-128|128|-9223372036854775808|0.0001|aaaa      |null|hello world|2014-03-02|04:05:06|null|-178000000 years|(100,200)|[(1,1),(2,2)]|(2,3),(0,1)|null|((1,1),(2,3),(4,5))|null|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+true|0|null|null|0|null|32767|null|bbccddeeff|aaaa|z|null|23:59:59|1999-01-08 04:05:06.0|null|(1,2)|null|null|null|((1,1))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|192.168.1.255/24|172.20.143.0/24|null
+true|1|000000000011100|aaaaaaaaaaaaaaaaaaa|-32768|-2147483648|null|null|123456789a|null|null|4713-01-01|23:59:59|2942-12-31 00:00:00.0|-178000000 years|(1000,2000)|[(1,1),(2,2)]|null|<(100,200),300>|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|null|172.20.143.0/24|null
+true|1|000000000011100|hello world|-128|128|32767|null|123456789a|123456789a|z|4277-12-31|04:05:06|2942-12-31 00:00:00.0|null|(100,200)|[(0,0),(6,6)]|(200,400),(100,200)|<(1,2),3>|null|((1,1),(3,2),(4,5))|null|172.20.143.0|172.20.143.0/24|null
+true|1|000000000011100|hello world|32767|0|128|null|bbccddeeff|null||4277-12-31|23:59:59|4713-01-01 00:00:00.0|null|(100,200)|[(1,1),(2,2)]|null|null|null|((100,123),(5,10),(7,2),(4,5))|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|172.20.143.0/24|<name>wj</name>
+true|1|000000000011100|null|-32768|-128|-9223372036854775808|0.0001|null|123456789a|hello world|null|00:00:00|4713-01-01 00:00:00.0|-178000000 years|null|[(1,1),(2,2)]|(2,3),(0,1)|<(1,2),3>|((1,1),(2,3),(4,5))|((100,123),(5,10),(7,2),(4,5))|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<aa>bb</aa>
+true|1|000000000011100|null|-32768|-2147483648|-9223372036854775808|null|123456789a|123456789a|hello world|2014-03-02|23:59:59|null|178000000 years|(1,2)|null|(2,3),(0,1)|null|((1,1))|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|172.20.143.0|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<name>wj</name>
+true|1|1111|aaaaaaaaaaaaaaaaaaa|-32768|-32768|0|null|null|null||4713-01-01|23:59:59|1999-01-08 04:05:06.0|-178000000 years|(100,200)|[(1,1),(2,2)]|null|<(1,2),3>|null|((100,123),(5,10),(7,2),(4,5))|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|null
+true|1|1111|hello world|-128|0|-2147483648|6.54|123456789a|aaaa|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4713-01-01|00:00:00|1999-01-08 04:05:06.0|178000000 years|(1000,2000)|[(1,1),(2,2)]|null|null|null|((100,123),(5,10),(7,2),(4,5))|null|192.168.1.255/24|172.20.143.0/24|null
+true|1|1111|null|0|2147483647|128|null|null|123456789a|null|null|23:59:59|2004-10-19 10:23:54.0|null|(100,200)|null|null|<(100,200),300>|((1,1))|null|ff:89:71:45:ae:01|2001::7344|192.168.1.255/32|null
+true|1|null|aaaaaaaaaaaaaaaaaaa|32767|0|32767|0.0001|null|bbccddeeff|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|4713-01-01|23:59:59|4713-01-01 00:00:00.0|null|(1000,2000)|null|null|<(100,200),300>|null|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|192.168.1.255/24|null|<name>wj</name>
+true|1|null|hello world|32767|0|9223372036854775807|null|bbccddeeff|aaaa|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|null|04:05:06|null|-178000000 years|(1000,2000)|null|null|<(1,2),3>|null|((1,1),(3,2),(4,5))|null|2001::7344|172.20.143.0/24|null
+true|1|null|hello world|null|-128|0|0.0001|aaaa      |aaaa|bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
 bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb|null|04:05:06|null|null|(1000,2000)|[(1,1),(2,2)]|null|<(100,200),300>|((1,1))|((100,123),(5,10),(7,2),(4,5))|null|2001::7344|172.20.143.0/24|null
+true|null|000000000011100|aaaaaaaaaaaaaaaaaaa|0|32767|9223372036854775807|0.0001|123456789a|aaaa|hello world|4277-12-31|00:00:00|4713-01-01 00:00:00.0|null|(1,2)|null|null|<(1,2),3>|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|null|2001::7344|192.168.1.255/32|<aa>bb</aa>
+true|null|000000000011100|aaaaaaaaaaaaaaaaaaa|128|-32768|2147483647|null|123456789a|bbccddeeff|null|null|04:05:06|2004-10-19 10:23:54.0|-178000000 years|(1,2)|null|(200,400),(100,200)|<(100,200),300>|null|((1,1),(3,2),(4,5))|null|null|null|<aa>bb</aa>
+true|null|000000000011100|aaaaaaaaaaaaaaaaaaa|32767|-128|0|0.0001|null|bbccddeeff||4713-01-01|23:59:59|null|null|(1,2)|null|null|<(1,2),3>|null|null|null|null|172.20.143.0/24|null
+true|null|000000000011100|aaaaaaaaaaaaaaaaaaa|null|128|128|0.0001|null|aaaa|hello world|null|00:00:00|4713-01-01 00:00:00.0|-178000000 years|(1000,2000)|[(0,0),(6,6)]|(200,400),(100,200)|null|((1,1))|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|2001::7344|192.168.1.255/32|<name>wj</name>
+true|null|000000000011100|hello world|null|-128|32767|6.54|aaaa      |null||4713-01-01|04:05:06|4713-01-01 00:00:00.0|-178000000 years|(1,2)|[(0,0),(6,6)]|(200,400),(100,200)|<(1,2),3>|((1,1))|null|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<aa>bb</aa>
+true|null|1111|aaaaaaaaaaaaaaaaaaa|-32768|-32768|9223372036854775807|0.0001|123456789a|bbccddeeff|null|null|04:05:06|null|-178000000 years|null|[(1,1),(2,2)]|(200,400),(100,200)|<(1,2),3>|((1,1),(2,3),(4,5))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|null
+true|null|1111|hello world|0|null|0|null|aaaa      |aaaa|z|2014-03-02|null|2942-12-31 00:00:00.0|null|(100,200)|[(1,1),(2,2)]|null|<(100,200),300>|null|null|null|2001::7344|192.168.1.255/32|<name>wj</name>
+true|null|1111|null|-128|-2147483648|9223372036854775807|null|123456789a|null|null|4713-01-01|23:59:59|1999-01-08 04:05:06.0|null|(1000,2000)|[(1,1),(2,2)]|null|null|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|null|2001::7344|null|<aa>bb</aa>
+true|null|1111|null|32767|2147483647|9223372036854775807|0.0001|123456789a|aaaa|z|4713-01-01|04:05:06|2942-12-31 00:00:00.0|null|(1,2)|null|(200,400),(100,200)|<(100,200),300>|((1,1))|((100,123),(5,10),(7,2),(4,5))|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|<aa>bb</aa>
+true|null|1111|null|null|128|-9223372036854775808|0.0001|123456789a|null|z|null|23:59:59|null|null|null|[(1,1),(2,2)]|null|<(1,2),3>|((1,1))|((100,123),(5,10),(7,2),(4,5))|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|172.20.143.0/24|null
+true|null|null|aaaaaaaaaaaaaaaaaaa|0|-32768|-32768|0.0001|null|null|null|4713-01-01|null|4713-01-01 00:00:00.0|178000000 years|(1000,2000)|null|(200,400),(100,200)|<(100,200),300>|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|null|<aa>bb</aa>
+true|null|null|aaaaaaaaaaaaaaaaaaa|0|2147483647|0|null|123456789a|aaaa||null|04:05:06|2004-10-19 10:23:54.0|178000000 years|(100,200)|[(0,0),(6,6)]|(200,400),(100,200)|<(100,200),300>|((1,1),(2,3),(4,5))|((1,1),(3,2),(4,5))|null|2001:db8:85a3:8d3:1319:8a2e:370:7344/64|192.168.1.255/32|<name>wj</name>
+true|null|null|null|-32768|-32768|9223372036854775807|0.0001|null|123456789a|z|null|23:59:59|1999-01-08 04:05:06.0|-178000000 years|(1,2)|[(1,1),(2,2)]|null|null|null|((1,1),(3,2),(4,5))|ff:89:71:45:ae:01|2001::7344|2001:db8:85a3:8d3:1319:8a2e:370:7344/128|null
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_parquet_alltypes/test_parquet_alltypes.sql
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_parquet_alltypes/test_parquet_alltypes.sql b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_parquet_alltypes/test_parquet_alltypes.sql
new file mode 100644
index 0000000..ff1ab72
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_parquet_alltypes/test_parquet_alltypes.sql
@@ -0,0 +1,102 @@
+DROP TABLE IF EXISTS test_parquet_alltypes;
+CREATE TABLE test_parquet_alltypes (c0 bool, c1 bit, c2 varbit, c3 bytea, c4 int2, c5 int4, c6 int8, c7 numeric, c8 char(10), c9 varchar(10), c10 text, c11 date, c12 time, c13 timestamp, c14 interval, c15 point, c16 lseg, c17 box, c18 circle, c19 path, c20 polygon, c21 macaddr, c22 inet, c23 cidr, c24 xml) with (appendonly=true, orientation=parquet, compresstype=none, rowgroupsize=8388608, pagesize=1048576, compresslevel=0);
+INSERT INTO test_parquet_alltypes values (null, null, null, 'aaaaaaaaaaaaaaaaaaa', -128, 2147483647, -9223372036854775808, null, '123456789a', '123456789a', '', '4277-12-31 AD', '00:00:00', null, '178000000 years', POINT(1,2), null, null, null, '(1,1),(2,3),(4,5)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '192.168.1.255/24', '192.168.1.255/32', null),
+('true', null, '000000000011100', 'aaaaaaaaaaaaaaaaaaa', 0, 32767, 9223372036854775807, 0.0001, '123456789a', 'aaaa', 'hello world', '4277-12-31 AD', '00:00:00', '4713-01-01 BC', null, POINT(1,2), null, null, '<(1,2),3>', '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', null, '2001::7344', '192.168.1.255/32', '<aa>bb</aa>'),
+('false', null, null, 'hello world', 32767, 128, -32768, 0.0001, '123456789a', 'aaaa', '', '4713-01-01 BC', '00:00:00', null, null, null, '[(1,1),(2,2)]', null, '<(1,2),3>', '(1,1)', '((1,1),(3,2),(4,5))', null, null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<aa>bb</aa>'),
+('true', '1', '000000000011100', 'hello world', 32767, 0, 128, null, 'bbccddeeff', null, '', '4277-12-31 AD', '23:59:59', '4713-01-01 BC', null, POINT(100,200), '[(1,1),(2,2)]', null, null, null, '((100,123),(5,10),(7,2),(4,5))', null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '172.20.143.0/24', '<name>wj</name>'),
+(null, null, '000000000011100', 'hello world', null, 2147483647, 0, 6.54, '123456789a', 'bbccddeeff', repeat('b',1000), '4277-12-31 AD', '04:05:06', '1999-01-08 04:05:06', null, POINT(1,2), null, null, '<(100,200),300>', null, '((1,1),(3,2),(4,5))', null, '172.20.143.0', '192.168.1.255/32', '<name>wj</name>'),
+('false', '1', '000000000011100', 'aaaaaaaaaaaaaaaaaaa', 0, -128, -9223372036854775808, 6.54, 'aaaa', 'bbccddeeff', '', null, null, '1999-01-08 04:05:06', '178000000 years', POINT(100,200), '[(1,1),(2,2)]', '((0,1),(2,3))', '<(1,2),3>', '(1,1)', null, null, null, '192.168.1.255/32', '<aa>bb</aa>'),
+(null, null, null, 'aaaaaaaaaaaaaaaaaaa', 128, null, -128, null, null, null, repeat('b',1000), '2014-03-02', '23:59:59', '2942-12-31 AD', '178000000 years', null, '[(1,1),(2,2)]', null, null, null, null, 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '172.20.143.0/24', null),
+('true', '1', null, 'aaaaaaaaaaaaaaaaaaa', 32767, 0, 32767, 0.0001, null, 'bbccddeeff', repeat('b',1000), '4713-01-01 BC', '23:59:59', '4713-01-01 BC', null, POINT(1000,2000), null, null, '<(100,200),300>', null, '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '192.168.1.255/24', null, '<name>wj</name>'),
+(null, '0', null, 'hello world', -128, null, -2147483648, null, null, 'bbccddeeff', 'hello world', '4713-01-01 BC', null, '2942-12-31 AD', null, POINT(1000,2000), '[(0,0),(6,6)]', null, null, '(1,1)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '2001::7344', '172.20.143.0/24', '<name>wj</name>'),
+('false', '0', '1111', 'aaaaaaaaaaaaaaaaaaa', -128, null, 128, 0.0001, 'aaaa', 'aaaa', repeat('b',1000), '4277-12-31 AD', '00:00:00', '4713-01-01 BC', '178000000 years', POINT(1,2), null, null, '<(1,2),3>', null, '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '172.20.143.0/24', null),
+('true', '0', '000000000011100', 'hello world', 128, -32768, 128, 6.54, 'bbccddeeff', '123456789a', 'z', '4277-12-31 AD', '00:00:00', '1999-01-08 04:05:06', '-178000000 years', POINT(100,200), '[(0,0),(6,6)]', null, '<(100,200),300>', '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', null, '192.168.1.255/24', '192.168.1.255/32', '<aa>bb</aa>'),
+('false', '1', null, 'aaaaaaaaaaaaaaaaaaa', -128, -32768, 2147483647, null, 'bbccddeeff', 'aaaa', repeat('b',1000), '4277-12-31 AD', '00:00:00', '2004-10-19 10:23:54', null, null, '[(0,0),(6,6)]', '((100,200),(200,400))', '<(1,2),3>', '(1,1),(2,3),(4,5)', null, null, '172.20.143.0', null, null),
+('false', '1', '1111', null, null, -32768, 9223372036854775807, 0.0001, null, 'aaaa', null, '2014-03-02', '23:59:59', '1999-01-08 04:05:06', '178000000 years', POINT(1000,2000), '[(0,0),(6,6)]', '((0,1),(2,3))', '<(100,200),300>', '(1,1)', null, 'FF:89:71:45:AE:01', null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', null),
+(null, '0', '000000000011100', 'aaaaaaaaaaaaaaaaaaa', 32767, 32767, 32767, 6.54, '123456789a', 'bbccddeeff', '', null, '23:59:59', '1999-01-08 04:05:06', null, null, null, '((100,200),(200,400))', null, '(1,1)', '((100,123),(5,10),(7,2),(4,5))', null, '2001::7344', '192.168.1.255/32', '<aa>bb</aa>'),
+('false', '1', '000000000011100', 'hello world', 0, 2147483647, 9223372036854775807, 6.54, 'aaaa', 'bbccddeeff', null, '4713-01-01 BC', '23:59:59', null, null, POINT(1000,2000), null, '((0,1),(2,3))', null, '(1,1)', '((100,123),(5,10),(7,2),(4,5))', null, null, null, '<name>wj</name>'),
+('false', '1', null, 'hello world', null, -32768, 128, 0.0001, 'bbccddeeff', 'aaaa', repeat('b',1000), '4277-12-31 AD', '00:00:00', '2004-10-19 10:23:54', '178000000 years', POINT(1,2), '[(0,0),(6,6)]', null, '<(1,2),3>', '(1,1)', null, null, '2001::7344', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', null),
+(null, '1', '000000000011100', 'hello world', 32767, 32767, 128, 0.0001, 'bbccddeeff', '123456789a', '', null, null, '2942-12-31 AD', null, POINT(100,200), null, '((100,200),(200,400))', '<(1,2),3>', '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '2001::7344', null, '<name>wj</name>'),
+(null, null, '1111', 'hello world', -32768, 32767, null, 0.0001, null, 'bbccddeeff', '', '4713-01-01 BC', '23:59:59', null, '178000000 years', POINT(1,2), '[(1,1),(2,2)]', null, null, null, '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '2001::7344', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<aa>bb</aa>'),
+('true', null, '1111', null, -128, -2147483648, 9223372036854775807, null, '123456789a', null, null, '4713-01-01 BC', '23:59:59', '1999-01-08 04:05:06', null, POINT(1000,2000), '[(1,1),(2,2)]', null, null, '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', null, '2001::7344', null, '<aa>bb</aa>'),
+('false', '1', '1111', null, -128, -32768, null, 0.0001, '123456789a', '123456789a', repeat('b',1000), '4277-12-31 AD', '04:05:06', '1999-01-08 04:05:06', '-178000000 years', POINT(100,200), null, null, '<(1,2),3>', null, '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<aa>bb</aa>'),
+('false', null, '000000000011100', 'hello world', null, -2147483648, 2147483647, 6.54, '123456789a', null, 'z', '4713-01-01 BC', '00:00:00', '2942-12-31 AD', '-178000000 years', POINT(1000,2000), '[(1,1),(2,2)]', '((0,1),(2,3))', '<(100,200),300>', null, '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '2001::7344', '172.20.143.0/24', '<name>wj</name>'),
+('true', '0', '1111', null, null, 2147483647, 128, 0.0001, null, 'bbccddeeff', '', '4277-12-31 AD', null, '2004-10-19 10:23:54', null, POINT(1000,2000), '[(1,1),(2,2)]', '((100,200),(200,400))', '<(100,200),300>', null, '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '192.168.1.255/24', '172.20.143.0/24', '<aa>bb</aa>'),
+('false', '1', '1111', null, 128, -2147483648, -32768, null, 'bbccddeeff', 'aaaa', '', null, '04:05:06', null, '178000000 years', POINT(1,2), '[(1,1),(2,2)]', '((0,1),(2,3))', '<(1,2),3>', '(1,1)', null, null, '172.20.143.0', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+('true', null, '000000000011100', 'aaaaaaaaaaaaaaaaaaa', 128, -32768, 2147483647, null, '123456789a', 'bbccddeeff', null, null, '04:05:06', '2004-10-19 10:23:54', '-178000000 years', POINT(1,2), null, '((100,200),(200,400))', '<(100,200),300>', null, '((1,1),(3,2),(4,5))', null, null, null, '<aa>bb</aa>'),
+(null, '1', '000000000011100', null, 32767, -32768, -9223372036854775808, 6.54, 'aaaa', 'bbccddeeff', null, '2014-03-02', '04:05:06', null, null, null, '[(1,1),(2,2)]', '((100,200),(200,400))', '<(100,200),300>', '(1,1)', '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '172.20.143.0', '172.20.143.0/24', null),
+('false', '1', '000000000011100', 'hello world', 128, null, -9223372036854775808, 6.54, 'aaaa', 'bbccddeeff', repeat('b',1000), '4277-12-31 AD', '04:05:06', '2004-10-19 10:23:54', '178000000 years', POINT(1,2), '[(0,0),(6,6)]', null, '<(100,200),300>', '(1,1)', '((100,123),(5,10),(7,2),(4,5))', null, '172.20.143.0', '192.168.1.255/32', '<name>wj</name>'),
+('true', null, null, 'aaaaaaaaaaaaaaaaaaa', 0, -32768, -32768, 0.0001, null, null, null, '4713-01-01 BC', null, '4713-01-01 BC', '178000000 years', POINT(1000,2000), null, '((100,200),(200,400))', '<(100,200),300>', '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', null, '<aa>bb</aa>'),
+('false', '0', '1111', null, -128, 128, -9223372036854775808, 0.0001, 'aaaa', '123456789a', 'z', null, '00:00:00', '2004-10-19 10:23:54', '-178000000 years', null, null, '((0,1),(2,3))', '<(1,2),3>', '(1,1)', '((1,1),(3,2),(4,5))', null, null, null, null),
+('false', '0', null, 'aaaaaaaaaaaaaaaaaaa', -128, -2147483648, -2147483648, null, '123456789a', 'bbccddeeff', null, '4713-01-01 BC', '23:59:59', '2004-10-19 10:23:54', '178000000 years', POINT(1000,2000), null, null, null, null, '((1,1),(3,2),(4,5))', null, '192.168.1.255/24', '172.20.143.0/24', '<name>wj</name>'),
+('false', null, '000000000011100', null, -32768, 0, -9223372036854775808, 6.54, '123456789a', 'aaaa', 'hello world', '4713-01-01 BC', null, '2942-12-31 AD', null, null, '[(1,1),(2,2)]', '((100,200),(200,400))', '<(100,200),300>', '(1,1)', null, null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+('true', '0', '1111', 'hello world', null, -128, -32768, null, 'bbccddeeff', '123456789a', '', '4713-01-01 BC', '00:00:00', '2004-10-19 10:23:54', '178000000 years', null, null, '((100,200),(200,400))', '<(100,200),300>', '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '192.168.1.255/24', null, '<name>wj</name>'),
+('true', '1', null, 'hello world', null, -128, 0, 0.0001, 'aaaa', 'aaaa', repeat('b',1000), null, '04:05:06', null, null, POINT(1000,2000), '[(1,1),(2,2)]', null, '<(100,200),300>', '(1,1)', '((100,123),(5,10),(7,2),(4,5))', null, '2001::7344', '172.20.143.0/24', null),
+(null, '1', null, 'aaaaaaaaaaaaaaaaaaa', 128, -2147483648, 9223372036854775807, 0.0001, '123456789a', null, 'hello world', null, '04:05:06', '2004-10-19 10:23:54', '178000000 years', null, '[(1,1),(2,2)]', null, null, null, '((1,1),(3,2),(4,5))', null, '172.20.143.0', '192.168.1.255/32', '<name>wj</name>'),
+(null, null, null, 'aaaaaaaaaaaaaaaaaaa', 32767, null, null, null, 'aaaa', null, '', '4713-01-01 BC', '23:59:59', null, null, POINT(1,2), '[(1,1),(2,2)]', '((0,1),(2,3))', '<(1,2),3>', null, null, null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '172.20.143.0/24', '<aa>bb</aa>'),
+('false', '0', null, null, 0, 2147483647, null, null, '123456789a', 'bbccddeeff', null, null, '23:59:59', '4713-01-01 BC', null, POINT(1,2), '[(1,1),(2,2)]', '((0,1),(2,3))', null, '(1,1),(2,3),(4,5)', null, null, null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+('false', null, '000000000011100', null, -128, null, 2147483647, 0.0001, '123456789a', null, 'z', null, null, '4713-01-01 BC', '178000000 years', POINT(100,200), null, '((0,1),(2,3))', '<(100,200),300>', '(1,1),(2,3),(4,5)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '172.20.143.0', null, '<name>wj</name>'),
+(null, '1', '000000000011100', null, null, 2147483647, -128, 0.0001, '123456789a', 'bbccddeeff', repeat('b',1000), '4277-12-31 AD', '04:05:06', null, '178000000 years', POINT(1,2), null, null, '<(1,2),3>', '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', null, '172.20.143.0', '192.168.1.255/32', '<name>wj</name>'),
+('false', '1', null, 'hello world', 0, 128, 32767, 6.54, '123456789a', 'aaaa', null, '4277-12-31 AD', '23:59:59', null, '-178000000 years', null, null, '((100,200),(200,400))', '<(1,2),3>', '(1,1)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '172.20.143.0', '172.20.143.0/24', null),
+('true', null, '1111', null, 32767, 2147483647, 9223372036854775807, 0.0001, '123456789a', 'aaaa', 'z', '4713-01-01 BC', '04:05:06', '2942-12-31 AD', null, POINT(1,2), null, '((100,200),(200,400))', '<(100,200),300>', '(1,1)', '((100,123),(5,10),(7,2),(4,5))', null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<aa>bb</aa>'),
+('false', '1', '1111', 'hello world', null, 128, null, null, 'bbccddeeff', null, '', '2014-03-02', '23:59:59', '4713-01-01 BC', '178000000 years', POINT(100,200), '[(1,1),(2,2)]', '((0,1),(2,3))', '<(1,2),3>', '(1,1),(2,3),(4,5)', '((100,123),(5,10),(7,2),(4,5))', null, '192.168.1.255/24', null, null),
+('true', '1', '000000000011100', null, -32768, -128, -9223372036854775808, 0.0001, null, '123456789a', 'hello world', null, '00:00:00', '4713-01-01 BC', '-178000000 years', null, '[(1,1),(2,2)]', '((0,1),(2,3))', '<(1,2),3>', '(1,1),(2,3),(4,5)', '((100,123),(5,10),(7,2),(4,5))', null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<aa>bb</aa>'),
+(null, '1', '000000000011100', 'hello world', 128, null, -128, 0.0001, null, null, 'hello world', '2014-03-02', '00:00:00', '2004-10-19 10:23:54', '178000000 years', null, null, '((100,200),(200,400))', '<(1,2),3>', '(1,1)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', null, '192.168.1.255/32', '<aa>bb</aa>'),
+(null, '1', '000000000011100', 'aaaaaaaaaaaaaaaaaaa', 32767, -32768, 0, 6.54, null, 'aaaa', '', '2014-03-02', '00:00:00', '4713-01-01 BC', '178000000 years', POINT(100,200), '[(0,0),(6,6)]', '((0,1),(2,3))', '<(100,200),300>', '(1,1)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '172.20.143.0', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+('true', '1', '1111', 'hello world', -128, 0, -2147483648, 6.54, '123456789a', 'aaaa', repeat('b',1000), '4713-01-01 BC', '00:00:00', '1999-01-08 04:05:06', '178000000 years', POINT(1000,2000), '[(1,1),(2,2)]', null, null, null, '((100,123),(5,10),(7,2),(4,5))', null, '192.168.1.255/24', '172.20.143.0/24', null),
+(null, '0', '000000000011100', 'hello world', -128, -128, -9223372036854775808, null, 'aaaa', 'aaaa', 'z', null, '00:00:00', '2004-10-19 10:23:54', null, POINT(1000,2000), '[(1,1),(2,2)]', '((100,200),(200,400))', '<(100,200),300>', '(1,1)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '172.20.143.0', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', null),
+('true', null, null, 'aaaaaaaaaaaaaaaaaaa', 0, 2147483647, 0, null, '123456789a', 'aaaa', '', null, '04:05:06', '2004-10-19 10:23:54', '178000000 years', POINT(100,200), '[(0,0),(6,6)]', '((100,200),(200,400))', '<(100,200),300>', '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '192.168.1.255/32', '<name>wj</name>'),
+('false', '1', null, null, 0, 0, -32768, 0.0001, '123456789a', null, repeat('b',1000), '4277-12-31 AD', '04:05:06', '1999-01-08 04:05:06', null, null, '[(1,1),(2,2)]', '((0,1),(2,3))', '<(100,200),300>', '(1,1)', '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '192.168.1.255/24', '192.168.1.255/32', '<aa>bb</aa>'),
+('true', '1', null, 'hello world', 32767, 0, 9223372036854775807, null, 'bbccddeeff', 'aaaa', repeat('b',1000), null, '04:05:06', null, '-178000000 years', POINT(1000,2000), null, null, '<(1,2),3>', null, '((1,1),(3,2),(4,5))', null, '2001::7344', '172.20.143.0/24', null),
+(null, '1', '1111', 'aaaaaaaaaaaaaaaaaaa', null, -128, 0, 6.54, 'bbccddeeff', 'aaaa', '', '4713-01-01 BC', '00:00:00', '1999-01-08 04:05:06', '178000000 years', POINT(100,200), '[(0,0),(6,6)]', '((0,1),(2,3))', '<(1,2),3>', '(1,1)', null, null, '2001::7344', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', null),
+('false', '0', '1111', 'hello world', 0, 32767, 0, 6.54, 'bbccddeeff', 'aaaa', '', null, '23:59:59', '1999-01-08 04:05:06', null, POINT(1,2), '[(0,0),(6,6)]', '((0,1),(2,3))', null, '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '2001::7344', '172.20.143.0/24', null),
+('true', '1', '1111', 'aaaaaaaaaaaaaaaaaaa', -32768, -32768, 0, null, null, null, '', '4713-01-01 BC', '23:59:59', '1999-01-08 04:05:06', '-178000000 years', POINT(100,200), '[(1,1),(2,2)]', null, '<(1,2),3>', null, '((100,123),(5,10),(7,2),(4,5))', null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', null),
+(null, null, '000000000011100', null, -32768, 32767, 32767, 6.54, 'aaaa', 'bbccddeeff', 'hello world', '4713-01-01 BC', '23:59:59', '4713-01-01 BC', '178000000 years', POINT(1,2), '[(1,1),(2,2)]', null, '<(100,200),300>', null, '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+('false', '0', null, 'aaaaaaaaaaaaaaaaaaa', 128, -2147483648, 2147483647, 6.54, '123456789a', 'bbccddeeff', null, '4713-01-01 BC', '00:00:00', null, '-178000000 years', null, '[(0,0),(6,6)]', '((100,200),(200,400))', '<(1,2),3>', '(1,1)', '((100,123),(5,10),(7,2),(4,5))', null, '172.20.143.0', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+('false', '1', '1111', null, 128, -32768, 0, 6.54, 'bbccddeeff', 'aaaa', null, '2014-03-02', null, '2942-12-31 AD', '-178000000 years', POINT(100,200), '[(0,0),(6,6)]', '((100,200),(200,400))', '<(100,200),300>', null, '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '192.168.1.255/24', '192.168.1.255/32', null),
+(null, '0', null, null, null, 128, 0, 0.0001, 'aaaa', 'aaaa', repeat('b',1000), '4277-12-31 AD', '23:59:59', '1999-01-08 04:05:06', '-178000000 years', POINT(100,200), null, '((100,200),(200,400))', null, '(1,1)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '192.168.1.255/24', '192.168.1.255/32', null),
+(null, '0', '000000000011100', 'hello world', null, null, -128, null, 'aaaa', null, 'z', '4277-12-31 AD', null, '1999-01-08 04:05:06', '178000000 years', POINT(1,2), '[(0,0),(6,6)]', null, null, '(1,1)', null, null, null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<aa>bb</aa>'),
+('false', '0', '1111', 'hello world', -128, -128, -9223372036854775808, 0.0001, 'aaaa', 'aaaa', null, '4277-12-31 AD', null, '1999-01-08 04:05:06', '178000000 years', POINT(100,200), '[(1,1),(2,2)]', '((100,200),(200,400))', null, '(1,1)', null, 'FF:89:71:45:AE:01', '192.168.1.255/24', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<aa>bb</aa>'),
+(null, null, '000000000011100', 'hello world', 128, 2147483647, null, 0.0001, 'aaaa', '123456789a', null, '4277-12-31 AD', '04:05:06', '1999-01-08 04:05:06', '178000000 years', POINT(1000,2000), '[(1,1),(2,2)]', '((0,1),(2,3))', '<(100,200),300>', null, null, 'FF:89:71:45:AE:01', '2001::7344', null, '<aa>bb</aa>'),
+(null, null, '1111', 'aaaaaaaaaaaaaaaaaaa', -32768, -2147483648, 9223372036854775807, 6.54, 'bbccddeeff', null, 'z', '4713-01-01 BC', '00:00:00', null, null, POINT(1000,2000), '[(0,0),(6,6)]', null, null, null, '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '2001::7344', '192.168.1.255/32', '<name>wj</name>'),
+(null, '0', null, null, -128, -128, 128, null, '123456789a', 'aaaa', repeat('b',1000), '4277-12-31 AD', '04:05:06', null, '-178000000 years', POINT(100,200), '[(0,0),(6,6)]', '((0,1),(2,3))', '<(1,2),3>', null, null, 'FF:89:71:45:AE:01', '2001::7344', '192.168.1.255/32', null),
+('false', null, '1111', null, null, 128, -2147483648, null, null, 'aaaa', 'z', '4277-12-31 AD', '23:59:59', '2942-12-31 AD', null, POINT(100,200), '[(1,1),(2,2)]', '((100,200),(200,400))', '<(100,200),300>', '(1,1)', '((100,123),(5,10),(7,2),(4,5))', null, '172.20.143.0', '172.20.143.0/24', '<name>wj</name>'),
+('true', '1', '1111', null, 0, 2147483647, 128, null, null, '123456789a', null, null, '23:59:59', '2004-10-19 10:23:54', null, POINT(100,200), null, null, '<(100,200),300>', '(1,1)', null, 'FF:89:71:45:AE:01', '2001::7344', '192.168.1.255/32', null),
+(null, '0', null, null, 32767, 0, -128, 6.54, null, 'bbccddeeff', null, '4713-01-01 BC', '23:59:59', '4713-01-01 BC', '178000000 years', POINT(1000,2000), '[(0,0),(6,6)]', null, null, '(1,1),(2,3),(4,5)', null, 'FF:89:71:45:AE:01', '192.168.1.255/24', '172.20.143.0/24', '<name>wj</name>'),
+('false', '0', null, 'aaaaaaaaaaaaaaaaaaa', 32767, -2147483648, 128, 0.0001, 'bbccddeeff', null, '', '4713-01-01 BC', '00:00:00', null, '178000000 years', POINT(1000,2000), '[(1,1),(2,2)]', null, '<(1,2),3>', '(1,1),(2,3),(4,5)', '((100,123),(5,10),(7,2),(4,5))', null, null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+('false', null, null, 'hello world', -128, -128, null, null, '123456789a', '123456789a', '', '4277-12-31 AD', null, '1999-01-08 04:05:06', '178000000 years', POINT(100,200), '[(0,0),(6,6)]', '((100,200),(200,400))', null, null, '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '192.168.1.255/32', '<name>wj</name>'),
+('true', null, '000000000011100', 'aaaaaaaaaaaaaaaaaaa', null, 128, 128, 0.0001, null, 'aaaa', 'hello world', null, '00:00:00', '4713-01-01 BC', '-178000000 years', POINT(1000,2000), '[(0,0),(6,6)]', '((100,200),(200,400))', null, '(1,1)', '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '2001::7344', '192.168.1.255/32', '<name>wj</name>'),
+('false', null, '000000000011100', 'aaaaaaaaaaaaaaaaaaa', -32768, -32768, 0, null, 'bbccddeeff', null, null, null, null, '2942-12-31 AD', '-178000000 years', null, null, '((0,1),(2,3))', null, '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', null, '192.168.1.255/24', null, null),
+('true', '0', null, null, 0, null, 32767, null, 'bbccddeeff', 'aaaa', 'z', null, '23:59:59', '1999-01-08 04:05:06', null, POINT(1,2), null, null, null, '(1,1)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '192.168.1.255/24', '172.20.143.0/24', null),
+('true', '0', null, null, -128, 128, -9223372036854775808, 0.0001, 'aaaa', null, 'hello world', '2014-03-02', '04:05:06', null, '-178000000 years', POINT(100,200), '[(1,1),(2,2)]', '((0,1),(2,3))', null, '(1,1),(2,3),(4,5)', null, 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+('false', null, null, 'hello world', null, null, null, null, null, 'bbccddeeff', '', '4277-12-31 AD', '23:59:59', '1999-01-08 04:05:06', null, POINT(1000,2000), '[(1,1),(2,2)]', '((100,200),(200,400))', '<(1,2),3>', '(1,1),(2,3),(4,5)', null, 'FF:89:71:45:AE:01', '2001::7344', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+('true', null, '000000000011100', 'hello world', null, -128, 32767, 6.54, 'aaaa', null, '', '4713-01-01 BC', '04:05:06', '4713-01-01 BC', '-178000000 years', POINT(1,2), '[(0,0),(6,6)]', '((100,200),(200,400))', '<(1,2),3>', '(1,1)', null, 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<aa>bb</aa>'),
+('false', '0', null, null, 0, 128, 32767, 0.0001, null, null, 'z', '4277-12-31 AD', null, '2942-12-31 AD', '178000000 years', POINT(1000,2000), '[(1,1),(2,2)]', null, null, '(1,1)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '2001::7344', null, '<name>wj</name>'),
+('false', '1', '000000000011100', 'aaaaaaaaaaaaaaaaaaa', 128, 0, 9223372036854775807, 6.54, '123456789a', 'aaaa', 'z', '4277-12-31 AD', '00:00:00', '4713-01-01 BC', '178000000 years', POINT(100,200), '[(0,0),(6,6)]', '((0,1),(2,3))', null, '(1,1),(2,3),(4,5)', null, 'FF:89:71:45:AE:01', null, '192.168.1.255/32', '<aa>bb</aa>'),
+('false', '0', '000000000011100', 'aaaaaaaaaaaaaaaaaaa', -32768, -128, 0, null, null, '123456789a', 'z', '2014-03-02', '04:05:06', '2004-10-19 10:23:54', '178000000 years', POINT(100,200), '[(1,1),(2,2)]', '((0,1),(2,3))', '<(100,200),300>', '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', null),
+('true', null, null, null, -32768, -32768, 9223372036854775807, 0.0001, null, '123456789a', 'z', null, '23:59:59', '1999-01-08 04:05:06', '-178000000 years', POINT(1,2), '[(1,1),(2,2)]', null, null, null, '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '2001::7344', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', null),
+('false', '1', null, null, 0, -32768, 9223372036854775807, 6.54, '123456789a', null, 'z', '4277-12-31 AD', null, '4713-01-01 BC', null, POINT(1000,2000), '[(0,0),(6,6)]', null, '<(1,2),3>', '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+('false', '1', '000000000011100', null, 32767, -32768, 9223372036854775807, 6.54, 'aaaa', '123456789a', '', '2014-03-02', '04:05:06', '2942-12-31 AD', '-178000000 years', null, '[(1,1),(2,2)]', '((100,200),(200,400))', '<(100,200),300>', '(1,1)', '((1,1),(3,2),(4,5))', null, null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', null),
+(null, '1', null, null, 128, 128, 0, 6.54, '123456789a', null, 'z', '2014-03-02', '04:05:06', '2942-12-31 AD', null, null, null, '((100,200),(200,400))', '<(100,200),300>', null, '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '192.168.1.255/24', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<aa>bb</aa>'),
+('true', null, '1111', 'aaaaaaaaaaaaaaaaaaa', -32768, -32768, 9223372036854775807, 0.0001, '123456789a', 'bbccddeeff', null, null, '04:05:06', null, '-178000000 years', null, '[(1,1),(2,2)]', '((100,200),(200,400))', '<(1,2),3>', '(1,1),(2,3),(4,5)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', null),
+('false', '1', null, 'aaaaaaaaaaaaaaaaaaa', null, 128, -128, null, 'bbccddeeff', '123456789a', null, '4713-01-01 BC', '00:00:00', null, null, POINT(1,2), '[(1,1),(2,2)]', null, '<(100,200),300>', null, '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', null, '<name>wj</name>'),
+('false', null, '1111', 'hello world', 128, 32767, 9223372036854775807, null, 'bbccddeeff', 'aaaa', '', '4713-01-01 BC', '04:05:06', '4713-01-01 BC', '-178000000 years', POINT(1,2), '[(1,1),(2,2)]', '((0,1),(2,3))', '<(100,200),300>', null, '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '192.168.1.255/32', '<aa>bb</aa>'),
+('false', '0', '1111', 'aaaaaaaaaaaaaaaaaaa', -32768, -2147483648, 128, 0.0001, 'aaaa', 'bbccddeeff', 'hello world', '4277-12-31 AD', '23:59:59', null, null, null, '[(0,0),(6,6)]', null, '<(100,200),300>', '(1,1)', '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '172.20.143.0', null, null),
+('false', null, null, null, 128, 128, 9223372036854775807, 0.0001, null, null, 'hello world', '4277-12-31 AD', '00:00:00', '2004-10-19 10:23:54', '178000000 years', null, '[(0,0),(6,6)]', '((0,1),(2,3))', '<(100,200),300>', null, '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '192.168.1.255/24', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+('true', null, '1111', null, null, 128, -9223372036854775808, 0.0001, '123456789a', null, 'z', null, '23:59:59', null, null, null, '[(1,1),(2,2)]', null, '<(1,2),3>', '(1,1)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '172.20.143.0/24', null),
+('true', '1', '000000000011100', 'hello world', -128, 128, 32767, null, '123456789a', '123456789a', 'z', '4277-12-31 AD', '04:05:06', '2942-12-31 AD', null, POINT(100,200), '[(0,0),(6,6)]', '((100,200),(200,400))', '<(1,2),3>', null, '((1,1),(3,2),(4,5))', null, '172.20.143.0', '172.20.143.0/24', null),
+('false', '1', '1111', null, -32768, -128, -128, 6.54, 'bbccddeeff', 'bbccddeeff', 'z', null, '00:00:00', '2004-10-19 10:23:54', '-178000000 years', POINT(100,200), '[(1,1),(2,2)]', '((100,200),(200,400))', '<(100,200),300>', '(1,1)', null, 'FF:89:71:45:AE:01', '172.20.143.0', '192.168.1.255/32', '<name>wj</name>'),
+('true', '1', '000000000011100', 'aaaaaaaaaaaaaaaaaaa', -32768, -2147483648, null, null, '123456789a', null, null, '4713-01-01 BC', '23:59:59', '2942-12-31 AD', '-178000000 years', POINT(1000,2000), '[(1,1),(2,2)]', null, '<(100,200),300>', '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', null, '172.20.143.0/24', null),
+('true', null, '1111', 'hello world', 0, null, 0, null, 'aaaa', 'aaaa', 'z', '2014-03-02', null, '2942-12-31 AD', null, POINT(100,200), '[(1,1),(2,2)]', null, '<(100,200),300>', null, null, null, '2001::7344', '192.168.1.255/32', '<name>wj</name>'),
+(null, '1', '000000000011100', null, 0, 32767, -9223372036854775808, 6.54, 'bbccddeeff', 'aaaa', null, '2014-03-02', '23:59:59', null, null, POINT(1000,2000), null, '((100,200),(200,400))', '<(1,2),3>', '(1,1)', null, null, '192.168.1.255/24', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+(null, '0', '1111', 'aaaaaaaaaaaaaaaaaaa', null, 0, 9223372036854775807, 0.0001, 'aaaa', '123456789a', null, null, '04:05:06', '2942-12-31 AD', null, POINT(1000,2000), '[(1,1),(2,2)]', '((100,200),(200,400))', '<(100,200),300>', '(1,1)', null, 'FF:89:71:45:AE:01', '192.168.1.255/24', '172.20.143.0/24', null),
+('true', '1', '000000000011100', null, -32768, -2147483648, -9223372036854775808, null, '123456789a', '123456789a', 'hello world', '2014-03-02', '23:59:59', null, '178000000 years', POINT(1,2), null, '((0,1),(2,3))', null, '(1,1)', '((1,1),(3,2),(4,5))', 'FF:89:71:45:AE:01', '172.20.143.0', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<name>wj</name>'),
+('true', null, '000000000011100', 'aaaaaaaaaaaaaaaaaaa', 32767, -128, 0, 0.0001, null, 'bbccddeeff', '', '4713-01-01 BC', '23:59:59', null, null, POINT(1,2), null, null, '<(1,2),3>', null, null, null, null, '172.20.143.0/24', null),
+(null, null, '000000000011100', 'hello world', -32768, null, -2147483648, null, '123456789a', 'bbccddeeff', repeat('b',1000), '4277-12-31 AD', '04:05:06', '2942-12-31 AD', '-178000000 years', null, null, '((0,1),(2,3))', '<(1,2),3>', '(1,1)', '((1,1),(3,2),(4,5))', null, '172.20.143.0', '192.168.1.255/32', null),
+('true', '0', '000000000011100', 'hello world', 32767, -32768, null, 6.54, '123456789a', '123456789a', 'hello world', '4713-01-01 BC', '23:59:59', '4713-01-01 BC', '-178000000 years', null, null, null, '<(100,200),300>', '(1,1)', '((100,123),(5,10),(7,2),(4,5))', null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', null),
+(null, null, '000000000011100', null, null, -2147483648, 2147483647, null, 'aaaa', 'bbccddeeff', '', '2014-03-02', null, '2942-12-31 AD', '-178000000 years', POINT(1,2), '[(1,1),(2,2)]', null, null, null, '((1,1),(3,2),(4,5))', null, '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', null, null),
+('false', null, '000000000011100', 'hello world', -32768, 2147483647, 9223372036854775807, 6.54, '123456789a', 'bbccddeeff', null, null, null, '4713-01-01 BC', '-178000000 years', null, null, null, null, '(1,1),(2,3),(4,5)', '((1,1),(3,2),(4,5))', null, '192.168.1.255/24', null, '<aa>bb</aa>'),
+(null, null, null, null, null, -128, 0, null, '123456789a', 'bbccddeeff', 'z', '4277-12-31 AD', null, '4713-01-01 BC', '-178000000 years', POINT(1000,2000), null, '((0,1),(2,3))', '<(1,2),3>', '(1,1),(2,3),(4,5)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', null, null),
+(null, '1', '1111', 'aaaaaaaaaaaaaaaaaaa', -128, 128, 128, 0.0001, 'bbccddeeff', '123456789a', '', '4277-12-31 AD', null, '2004-10-19 10:23:54', '-178000000 years', POINT(1000,2000), '[(1,1),(2,2)]', null, null, '(1,1)', null, 'FF:89:71:45:AE:01', '192.168.1.255/24', '2001:db8:85a3:8d3:1319:8a2e:370:7344/128', '<aa>bb</aa>'),
+(null, null, '1111', 'aaaaaaaaaaaaaaaaaaa', 32767, -128, 2147483647, 0.0001, '123456789a', null, 'hello world', null, '00:00:00', '2942-12-31 AD', '-178000000 years', POINT(1000,2000), null, '((0,1),(2,3))', null, '(1,1)', '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '172.20.143.0', null, null),
+('false', '1', '000000000011100', null, -32768, 0, 0, null, 'bbccddeeff', '123456789a', 'hello world', '4713-01-01 BC', '00:00:00', null, '178000000 years', POINT(1,2), '[(0,0),(6,6)]', null, '<(1,2),3>', null, '((100,123),(5,10),(7,2),(4,5))', 'FF:89:71:45:AE:01', '2001:db8:85a3:8d3:1319:8a2e:370:7344/64', '192.168.1.255/32', '<name>wj</name>');
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/8b26974c/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_parquet_alltypes/test_parquet_alltypes.yaml
----------------------------------------------------------------------
diff --git a/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_parquet_alltypes/test_parquet_alltypes.yaml b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_parquet_alltypes/test_parquet_alltypes.yaml
new file mode 100644
index 0000000..e76f1da
--- /dev/null
+++ b/contrib/hawq-hadoop/hawq-mapreduce-tool/test-data/test_parquet_alltypes/test_parquet_alltypes.yaml
@@ -0,0 +1,20 @@
+DBVersion: PostgreSQL 8.2.15 (Greenplum Database 4.2.0 build 1) (HAWQ 1.2.1.0 build
+  dev) on i386-apple-darwin11.4.2, compiled by GCC gcc (GCC) 4.4.2 compiled on Mar
+  28 2014 13:16:47 (with assert checking)
+DFS_URL: hdfs://127.0.0.1:9000
+Encoding: UTF8
+FileFormat: Parquet
+Parquet_FileLocations:
+  Checksum: false
+  CompressionLevel: 0
+  CompressionType: none
+  EnableDictionary: false
+  Files:
+  - path: test-data/hawq-data/gpseg0/16385/24576/40966.1
+    size: 33762
+  - path: test-data/hawq-data/gpseg1/16385/24576/40966.1
+    size: 24097
+  PageSize: 1048576
+  RowGroupSize: 8388608
+TableName: public.test_parquet_alltypes
+Version: 1.0.0



Mime
View raw message