hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From h...@apache.org
Subject [2/3] incubator-hawq git commit: HAWQ-805. Add feature test for exttab1 with new framework
Date Mon, 04 Jul 2016 02:35:55 GMT
http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a2fa04ff/src/test/feature/ExternalSource/data/whois.csv
----------------------------------------------------------------------
diff --git a/src/test/feature/ExternalSource/data/whois.csv b/src/test/feature/ExternalSource/data/whois.csv
new file mode 100755
index 0000000..a54ee19
--- /dev/null
+++ b/src/test/feature/ExternalSource/data/whois.csv
@@ -0,0 +1,1303 @@
+source_line_number,domain,subdomain,tld,ip_address,ip_address_int,reverse_ip_address,reverse_ip_address_int,registrar,registrar_url,whois_server,harvest_date,creation_date,updated_date,expiration_date,rank,status,update_status,nameserver1,nameserver1_domain,nameserver1_subdomain,nameserver1_tld,nameserver2,nameserver2_domain,nameserver2_subdomain,nameserver2_tld,nameserver3,nameserver3_domain,nameserver3_subdomain,nameserver3_tld,nameserver4,nameserver4_domain,nameserver4_subdomain,nameserver4_tld,nameserver5,nameserver5_domain,nameserver5_subdomain,nameserver5_tld,registrant_name,registrant_org,registrant_email,registrant_email_domain,registrant_email_subdomain,registrant_email_tld,registrant_phone,registrant_fax,registrant_street_address,registrant_address1,registrant_address2,registrant_address3,registrant_city,registrant_region,registrant_postal_code,registrant_country,tech_name,tech_org,tech_email,tech_email_domain,tech_email_subdomain,tech_email_tld,tech_phone,tech_fax,tech_st
 reet_address,tech_address1,tech_address2,tech_address3,tech_city,tech_region,tech_postal_code,tech_country,admin_name,admin_org,admin_email,admin_email_domain,admin_email_subdomain,admin_email_tld,admin_phone,admin_fax,admin_street_address,admin_street1,admin_street2,admin_street3,admin_city,admin_region,admin_postal_code,admin_country,path,raw_record
+2,00111.net,net,net,,,,,,,,2006-06-16 19:33:12.11421,2006-02-17,2006-02-18 01:19:53,2007-02-17,3,,,ns1.cnolnic.net,cnolnic.net,net,net,ns2.cnolnic.net,cnolnic.net,net,net,,,,,,,,,,,,,wu guishan,wu guishan,wuabcd@163.com,163.com,com,com,+86.05962196589,,"xianchen|zhangzhou, Fujian, cn 363000",xianchen,,,zhangzhou,Fujian,363000,cn,wu guishan,wu guishan,wuabcd@163.com,163.com,com,com,+86.05962196589,"jian, cn 363000|+86.05962196589","xianchen|zhangzhou, Fujian, cn 363000",xianchen,,,zhangzhou,Fujian,363000,cn,wu guishan,wu guishan,wuabcd@163.com,163.com,com,com,+86.05962196589,"jian, cn 363000|+86.05962196589","xianchen|zhangzhou, Fujian, cn 363000",xianchen,,,zhangzhou,Fujian,363000,cn,,"<rec>The Data in Web Commerce Communications Limited (""WEBCC"")'s WHOIS database 
+is provided by WEBCC for information purposes, and to assist in obtaining 
+information about or related to a domain name registration record. WEBCC 
+does not guarantee its accuracy. By submitting a WHOIS query, you agree 
+that you will use this Data only for lawful purposes and that, under no 
+circumstances will you use this Data to:
+
+(1) allow, enable, or otherwise support the transmission of mass unsolicited, 
+    commercial advertising or solicitations via e-mail (spam).
+(2) enable high volume, automated, electronic processes that apply to WEBCC 
+    (or its systems).
+
+The compilation, repackaging, dissemination or other use of this Data is 
+expressly prohibited without the prior written consent of WEBCC. WEBCC 
+reserves the right to terminate your access to the WEBCC WHOIS database in 
+its sole discretion, including without limitation, for excessive querying 
+of the WHOIS database or for failure to otherwise abide by this policy. 
+WEBCC reserves the right to modify these terms at any time.
+
+
+Domain: 00111.NET
+Status: Protected
+
+DNS:
+	ns1.cnolnic.net
+	ns2.cnolnic.net
+
+Created: 2006-02-17
+Expires: 2007-02-17
+Last Modified: 2006-02-18 01:19:53
+
+Registrant Contact:
+	wu guishan
+	wu guishan (wuabcd@163.com)
+	xianchen 
+	zhangzhou, Fujian, cn 363000
+	P: +86.05962196589	 F: +86.05962196589
+
+Administrative Contact:
+	wu guishan
+	wu guishan (wuabcd@163.com)
+	xianchen 
+	zhangzhou, Fujian, cn 363000
+	P: +86.05962196589	 F: +86.05962196589
+	
+Technical Contact:
+	wu guishan
+	wu guishan (wuabcd@163.com)
+	xianchen 
+	zhangzhou, Fujian, cn 363000
+	P: +86.05962196589	 F: +86.05962196589
+
+Billing Contact:
+	wu guishan
+	wu guishan (wuabcd@163.com)
+	xianchen 
+	zhangzhou, Fujian, cn 363000
+	P: +86.05962196589	 F: +86.05962196589</rec>"
+62,007china.net,net,net,,,,,,,,2006-06-16 19:33:12.22845,2005-09-05,,2006-09-05,3,,,ns1.4everdns.com,4everdns.com,com,com,ns2.4everdns.com,4everdns.com,com,com,,,,,,,,,,,,,YIN JIANPING,,shiguangzh@163.com,163.com,com,com,,,Xige street No 87 Zhongshan north road|Xuzhou Jiangsu 221000|cn,Xige street No 87 Zhongshan north road,,,Xuzhou Jiangsu,,221000,cn,jianping yin,,shiguangzh@163.com,163.com,com,com,86-0516-7821111,86-0516-7825555,xige street No 87 zhongshan north road|xuzhou jiangsu 221000|cn,xige street No 87 zhongshan north road,,,xuzhou jiangsu,,221000,cn,JIANPING YIN,,sjiguangzh@163.com,163.com,com,com,86-0516-7821111,86-0516-7825555,xige street No87 zhongshan north road|xuzhou jiangsu 221000|cn,xige street No87 zhongshan north road,,,xuzhou jiangsu,,221000,cn,,"<rec>The data in this whois database is provided to you for information
+purposes only, that is, to assist you in obtaining information about or
+related to a domain name registration record. We make this information
+available ""as is,"" and do not guarantee its accuracy. By submitting a
+whois query, you agree that you will use this data only for lawful
+purposes and that, under no circumstances will you use this data to: (1)
+enable high volume, automated, electronic processes that stress or load
+this whois database system providing you this information; or (2) allow,
+enable, or otherwise support the transmission of mass unsolicited,
+commercial advertising or solicitations via direct mail, electronic
+mail, or by telephone.  The compilation, repackaging, dissemination or
+other use of this data is expressly prohibited without prior written
+consent from us.  We reserve the right to modify these terms at any time.
+By submitting this query, you agree to abide by these terms.
+
+Domain name: 007china.net
+
+Registrant Contact:
+   YIN JIANPING
+   JIANPING YIN shiguangzh@163.com
+   86-0516-7821111 fax: 86-0516-7825555
+   Xige street No 87 Zhongshan north road
+   Xuzhou Jiangsu 221000
+   cn
+
+Administrative Contact:
+   JIANPING YIN sjiguangzh@163.com
+   86-0516-7821111 fax: 86-0516-7825555
+   xige street No87 zhongshan north road
+   xuzhou jiangsu 221000
+   cn
+
+Technical Contact:
+   jianping yin shiguangzh@163.com
+   86-0516-7821111 fax: 86-0516-7825555
+   xige street No 87 zhongshan north road
+   xuzhou jiangsu 221000
+   cn
+
+Billing Contact:
+   jianping yin shiguangzh@163.com
+   86-0516-7821111 fax: 86-0516-7825555
+   xige street No 87 zhongshan north road
+   xuzhou jiangsu 221000
+   cn
+
+DNS:
+ns1.4everdns.com
+ns2.4everdns.com
+
+Created: 2005-09-05
+Expires: 2006-09-05</rec>"
+116,001web.net,net,net,,,,,,,,2006-06-16 19:33:13.195138,2003-12-15,,2006-12-15,3,,,dns.bizcn.com,bizcn.com,com,com,dns.cnmsn.net,cnmsn.net,net,net,,,,,,,,,,,,,Yuanxijun,,webmaster@001web.net,001web.net,net,net,,,"2403#,022F,6# beimengqiao road|Nanjing jiangsu 210018|cn","2403#,022F,6# beimengqiao road",,,Nanjing jiangsu,,210018,cn,tinghai zhang,,webmaster@yz114.com,yz114.com,com,com,+86.5147239297,+86.5147229089,"105#,38F,shaibei three village|yangzhou jiangsu 225000|cn","105#,38F,shaibei three village",,,yangzhou jiangsu,,225000,cn,tinghai zhang,,webmaster@yz114.com,yz114.com,com,com,+86.5147239297,+86.5147229089,"105#,38F,shaibei three village|yangzhou jiangsu 225000|cn","105#,38F,shaibei three village",,,yangzhou jiangsu,,225000,cn,,"<rec>The data in this whois database is provided to you for information
+purposes only, that is, to assist you in obtaining information about or
+related to a domain name registration record. We make this information
+available ""as is,"" and do not guarantee its accuracy. By submitting a
+whois query, you agree that you will use this data only for lawful
+purposes and that, under no circumstances will you use this data to: (1)
+enable high volume, automated, electronic processes that stress or load
+this whois database system providing you this information; or (2) allow,
+enable, or otherwise support the transmission of mass unsolicited,
+commercial advertising or solicitations via direct mail, electronic
+mail, or by telephone.  The compilation, repackaging, dissemination or
+other use of this data is expressly prohibited without prior written
+consent from us.  We reserve the right to modify these terms at any time.
+By submitting this query, you agree to abide by these terms.
+
+Domain name: 001web.net
+
+Registrant Contact:
+   Yuanxijun
+   xijun yuan webmaster@001web.net
+   +86.2584714502 fax: +86.2584714502
+   2403#,022F,6# beimengqiao road
+   Nanjing jiangsu 210018
+   cn
+
+Administrative Contact:
+   tinghai zhang webmaster@yz114.com
+   +86.5147239297 fax: +86.5147229089
+   105#,38F,shaibei three village
+   yangzhou jiangsu 225000
+   cn
+
+Technical Contact:
+   tinghai zhang webmaster@yz114.com
+   +86.5147239297 fax: +86.5147229089
+   105#,38F,shaibei three village
+   yangzhou jiangsu 225000
+   cn
+
+Billing Contact:
+   tinghai zhang webmaster@yz114.com
+   +86.5147239297 fax: +86.5147229089
+   105#,38F,shaibei three village
+   yangzhou jiangsu 225000
+   cn
+
+DNS:
+dns.bizcn.com
+dns.cnmsn.net
+
+Created: 2003-12-15
+Expires: 2006-12-15</rec>"
+170,007toys.net,net,net,,,,,,,,2006-06-16 19:33:13.935131,14-Jun-2006,15-Jun-2006,2007-06-14,3,,,dns.dns-parking-service.com,dns-parking-service.com,com,com,dns1.dns-parking-service.com,dns-parking-service.com,com,com,dns2.dns-parking-service.com,dns-parking-service.com,com,com,,,,,,,,,Wang Lee (007TOYS-NET-DOM),,contact@wangleedomains.com,wangleedomains.com,com,com,+852.3014916,,"255 King's Road|North Point,|Hong Kong",255 King's Road,,,"North Point,",,,Hong Kong,Wang Lee,,contact@wangleedomains.com,wangleedomains.com,com,com,+852.3014916,85230149162,"255 King's Road|North Point,|Hong Kong|Record last updated on 15-Jun-2006.|Record expires on 14-Jun-2007.",255 King's Road,"North Point,",Hong Kong,Record expires on,,14-Jun-2007.,,Wang Lee,,contact@wangleedomains.com,wangleedomains.com,com,com,+852.3014916,85230149162,"255 King's Road|North Point,|Hong Kong",255 King's Road,,,"North Point,",,,Hong Kong,,"<rec>This whois service shows the information for .COM, .NET and .ORG domains 
+The fact that your query returns ""NOT FOUND"" does not necessarily mean that
+the domain may be available for registration. To search all domains, please
+go to the shared registry whois located at:
+http://www.internic.net/whois.html
+
+
+Registrant:
+   Wang Lee (007TOYS-NET-DOM)
+   Olympia Plaza
+   255 King's Road
+   North Point,  
+   Hong Kong
+   +852.30149162
+   +852.30149162
+   contact@wangleedomains.com
+
+   Domain Name: 007TOYS.NET
+   Status: PROTECTED
+
+   Administrative Contact:
+      Wang Lee contact@wangleedomains.com
+      Olympia Plaza
+      255 King's Road
+      North Point,  
+      Hong Kong
+      +852.30149162
+      Fax- +852.30149162
+
+   Technical Contact, Zone Contact:
+      Wang Lee contact@wangleedomains.com
+      Olympia Plaza
+      255 King's Road
+      North Point,  
+      Hong Kong
+      +852.30149162
+      Fax- +852.30149162
+
+   Record last updated on 15-Jun-2006.
+   Record expires on 14-Jun-2007.
+   Record created on 14-Jun-2006.
+
+   Domain servers in listed order:
+      Name Server: DNS2.DNS-PARKING-SERVICE.COM
+      Name Server: DNS1.DNS-PARKING-SERVICE.COM
+      Name Server: DNS.DNS-PARKING-SERVICE.COM</rec>"
+218,007cybermall.net,net,net,,,,,,,,2006-06-16 19:33:14.012383,2001-03-17 09:28:20 EST,2005-03-19 22:03:20 EST,2007-03-17,3,,,ns.sbbank.net,sbbank.net,net,net,ns2.sbbank.net,sbbank.net,net,net,,,,,,,,,,,,,"Hyoung Geun, Kim",,khg882@hanmail.net,hanmail.net,net,net,02-508-7321,02-508-7844,"1803-2, HallaClassic-Offistel, 824-11, Yuksam-dong, Gangnam-gu,Seoul,Korea|135-080|KR","1803-2, HallaClassic-Offistel, 824-11, Yuksam-dong, Gangnam-gu,Seoul,Korea",,,,,135-080,KR,"Jonghyun, Lee",,webmaster@domain7.co.kr,domain7.co.kr,co.kr,kr,02-585-2011,02-525-1116,"#B07,Hyochun B/D,1425-10,Seocho-dong,Seocho-Gu, Seoul, Korea|137-070|KR","#B07,Hyochun B/D,1425-10,Seocho-dong,Seocho-Gu, Seoul, Korea",,,,,137-070,KR,"Hyoung Geun, Kim",,zit001@kornet.net,kornet.net,net,net,053-261-9469,053-621-3001,"102-610 Chilkok Woobang APT Umnae-dong, Puk-gu, Taegu|702848|KR","102-610 Chilkok Woobang APT Umnae-dong, Puk-gu, Taegu",,,,,702848,KR,,"<rec>-----------------------------------------------
+Queried Domain Information as follows
+-----------------------------------------------
+
+Domain Name : 007cybermall.net
+
+::Registrant::
+	Name      : Hyoung Geun, Kim
+	Email     : khg882@hanmail.net
+	Address   : 1803-2, HallaClassic-Offistel, 824-11, Yuksam-dong, Gangnam-gu,Seoul,Korea
+	Zipcode   : 135-080
+	Nation    : KR
+	Tel       : 02-508-7321
+	Fax       : 02-508-7844
+
+::Administrative Contact::
+	Name      : Hyoung Geun, Kim
+	Email     : zit001@kornet.net
+	Address   : 102-610 Chilkok Woobang APT  Umnae-dong, Puk-gu, Taegu
+	Zipcode   : 702848
+	Nation    : KR
+	Tel       : 053-261-9469
+	Fax       : 053-621-3001
+
+::Technical Contact::
+	Name      : Jonghyun, Lee
+	Email     : webmaster@domain7.co.kr
+	Address   : #B07,Hyochun B/D,1425-10,Seocho-dong,Seocho-Gu, Seoul, Korea
+	Zipcode   : 137-070
+	Nation    : KR
+	Tel       : 02-585-2011
+	Fax       : 02-525-1116
+
+::Name Servers::
+	NS2.SBBANK.NET
+	NS.SBBANK.NET
+
+::Dates & Status::
+	Created Date   2001-03-17 09:28:20 EST
+	Updated Date   2005-03-19 22:03:20 EST
+	Valid Date     2007-03-17 09:28:20 EST
+	Status         ACTIVE</rec>"
+261,007hk.net,net,net,,,,,,,,2006-06-16 19:33:14.086281,2004-11-01,,2006-11-01,3,,,ns1.4everdns.com,4everdns.com,com,com,ns2.4everdns.com,4everdns.com,com,com,,,,,,,,,,,,,007,,yangxinan@163.com,163.com,com,com,,,hongkong88hao|hongkong Henan 000007|cn,hongkong88hao,,,hongkong Henan,,000007,cn,sheng song,,yangxinan@163.com,163.com,com,com,13907555645,07755745078,hongkong88hao|hongkong Henan 000007|cn,hongkong88hao,,,hongkong Henan,,000007,cn,sheng song,,yangxinan@163.com,163.com,com,com,13907555645,07755745078,hongkong88hao|hongkong Henan 000007|cn,hongkong88hao,,,hongkong Henan,,000007,cn,,"<rec>The data in this whois database is provided to you for information
+purposes only, that is, to assist you in obtaining information about or
+related to a domain name registration record. We make this information
+available ""as is,"" and do not guarantee its accuracy. By submitting a
+whois query, you agree that you will use this data only for lawful
+purposes and that, under no circumstances will you use this data to: (1)
+enable high volume, automated, electronic processes that stress or load
+this whois database system providing you this information; or (2) allow,
+enable, or otherwise support the transmission of mass unsolicited,
+commercial advertising or solicitations via direct mail, electronic
+mail, or by telephone.  The compilation, repackaging, dissemination or
+other use of this data is expressly prohibited without prior written
+consent from us.  We reserve the right to modify these terms at any time.
+By submitting this query, you agree to abide by these terms.
+
+Domain name: 007hk.net
+
+Registrant Contact:
+   007
+   sheng song yangxinan@163.com
+   13907555645 fax: 07755745078
+   hongkong88hao
+   hongkong Henan 000007
+   cn
+
+Administrative Contact:
+   sheng song yangxinan@163.com
+   13907555645 fax: 07755745078
+   hongkong88hao
+   hongkong Henan 000007
+   cn
+
+Technical Contact:
+   sheng song yangxinan@163.com
+   13907555645 fax: 07755745078
+   hongkong88hao
+   hongkong Henan 000007
+   cn
+
+Billing Contact:
+   sheng song yangxinan@163.com
+   13907555645 fax: 07755745078
+   hongkong88hao
+   hongkong Henan 000007
+   cn
+
+DNS:
+ns1.4everdns.com
+ns2.4everdns.com
+
+Created: 2004-11-01
+Expires: 2006-11-01</rec>"
+315,007adulthosting.net,net,net,,,,,"TUCOWS, INC.",,,2006-06-16 19:33:14.917354,15-Nov-2000,26-Apr-2006,2006-11-15,3,,,ns1.california.net,california.net,net,net,ns1.oakweb.com,oakweb.com,com,com,,,,,,,,,,,,,"Reliablehosting.com / Black Oak Computers, Inc.",,,,,,,,"11110 W. Oakland Park Blvd.|#379|Sunrise, FL 33351|US",11110 W. Oakland Park Blvd.,#379,,Sunrise,FL,33351,US,"Reliablehosting.com, Mr.",,getrenewed@reliablehosting.com,reliablehosting.com,com,com,954-452-7781,415-467-7690,"11110 W. Oakland Park Blvd.|#379|Sunrise, FL 33351|US",11110 W. Oakland Park Blvd.,#379,,Sunrise,FL,33351,US,"Reliablehosting.com, Mr.",,getrenewed@reliablehosting.com,reliablehosting.com,com,com,954-452-7781,415-467-7690,"11110 W. Oakland Park Blvd.|#379|Sunrise, FL 33351|US",11110 W. Oakland Park Blvd.,#379,,Sunrise,FL,33351,US,,"<rec>Registrant:
+ Reliablehosting.com / Black Oak Computers, Inc.
+ 11110 W. Oakland Park Blvd.
+ #379
+ Sunrise, FL 33351
+ US
+
+ Domain name: 007ADULTHOSTING.NET
+
+ Administrative Contact:
+    Reliablehosting.com, Mr.  getrenewed@reliablehosting.com
+    11110 W. Oakland Park Blvd.
+    #379
+    Sunrise, FL 33351
+    US
+    954-452-7781    Fax: 415-467-7690
+
+ Technical Contact:
+    Reliablehosting.com, Mr.  getrenewed@reliablehosting.com
+    11110 W. Oakland Park Blvd.
+    #379
+    Sunrise, FL 33351
+    US
+    954-452-7781    Fax: 415-467-7690
+
+
+
+ Registration Service Provider:
+    California.net / Reliablehosting, webmaster@reliablehosting.com
+    877-402-9532
+    http://www.reliablehosting.com
+    This company may be contacted for domain login/passwords,
+    DNS/Nameserver changes, and general domain support questions.
+
+
+ Registrar of Record: TUCOWS, INC.
+ Record last updated on 26-Apr-2006.
+ Record expires on 15-Nov-2006.
+ Record created on 15-Nov-2000.
+
+ Domain servers in listed order:
+    NS1.CALIFORNIA.NET   216.131.95.20
+    NS1.OAKWEB.COM   216.131.94.5
+
+
+ Domain status: ACTIVE
+
+The Data in the Tucows Registrar WHOIS database is provided to you by Tucows
+for information purposes only, and may be used to assist you in obtaining
+information about or related to a domain name's registration record.
+
+Tucows makes this information available ""as is,"" and does not guarantee its
+accuracy.
+
+By submitting a WHOIS query, you agree that you will use this data only for
+lawful purposes and that, under no circumstances will you use this data to:
+a) allow, enable, or otherwise support the transmission by e-mail,
+telephone, or facsimile of mass, unsolicited, commercial advertising or
+solicitations to entities other than the data recipient's own existing
+customers; or (b) enable high volume, automated, electronic processes that
+send queries or data to the systems of any Registry Operator or
+ICANN-Accredited registrar, except as reasonably necessary to register
+domain names or modify existing registrations.
+
+The compilation, repackaging, dissemination or other use of this Data is
+expressly prohibited without the prior written consent of Tucows.
+
+Tucows reserves the right to terminate your access to the Tucows WHOIS
+database in its sole discretion, including without limitation, for excessive
+querying of the WHOIS database or for failure to otherwise abide by this
+policy.
+
+Tucows reserves the right to modify these terms at any time.
+
+By submitting this query, you agree to abide by these terms.
+
+NOTE: THE WHOIS DATABASE IS A CONTACT DATABASE ONLY.  LACK OF A DOMAIN
+RECORD DOES NOT SIGNIFY DOMAIN AVAILABILITY.</rec>"
+396,00-1.net,net,net,,,,,,,,2006-06-16 19:33:15.145672,2005-10-17,2006-02-22,2008-10-17,3,,,ns1.dnsfamily.com,dnsfamily.com,com,com,ns2.dnsfamily.com,dnsfamily.com,com,com,,,,,,,,,,,,,ming wen,,,,,,,,guangzhou|528455,guangzhou,,,528455,,,,ming wen,ming wen,wm343400@163.com,163.com,com,com,86263960,7358469,guangzhou|guangzhou Beijing|CN,guangzhou,,,guangzhou Beijing,,,CN,ming wen,ming wen,wm343400@163.com,163.com,com,com,028 86263960,0208 7358469,guangzhou|guangzhou Guangdong|CN,guangzhou,,,guangzhou Guangdong,,,CN,,"<rec>The Data in Paycenter's WHOIS database is provided by Paycenter 
+for information purposes, and to assist persons in obtaining 
+information about or related to a domain name registration 
+record.
+Paycenter does not guarantee its accuracy.  By submitting 
+a WHOIS query, you agree that you will use this Data only 
+for lawful purposes and that, under no circumstances will 
+you use this Data to:
+(1) allow, enable, or otherwise support the transmission 
+of mass unsolicited, commercial advertising or solicitations 
+via e-mail (spam); or  
+(2) enable high volume, automated, electronic processes that 
+apply to Paycenter or its systems.  
+Paycenter reserves the right to modify these terms at any time. 
+By submitting this query, you agree to abide by this policy.	
+        
+Domain Name:00-1.net
+
+
+Registrant: 
+ming wen
+	guangzhou
+	528455
+	
+	
+
+Administrative Contact: 
+ming wen
+	ming wen
+	guangzhou
+	guangzhou Guangdong 
+	CN
+	tel:  028 86263960 
+	fax:  0208 7358469 
+	wm343400@163.com
+	
+Technical Contact: 
+ming wen
+	ming wen
+	guangzhou
+	guangzhou Beijing 
+	CN
+	tel:   86263960 
+	fax:   7358469 
+	wm343400@163.com
+	
+Billing Contact: 
+ming wen
+	ming wen
+	guangzhou
+	guangzhou Beijing 
+	CN
+	tel:   86263960 
+	fax:   7358469 
+	wm343400@163.com
+	
+ Registration Date: 2005-10-17
+       Update Date: 2006-02-22
+   Expiration Date: 2008-10-17
+	
+    Primary DNS:  ns1.DNSFAMILY.com		218.85.132.246
+  Secondary DNS:  ns2.DNSFAMILY.com		218.107.216.80</rec>"
+460,00045.net,net,net,,,,,,,,2006-06-16 19:33:16.008923,2005-04-16,2005-04-16 15:36:51,2006-04-16,3,,,ns1.cnolnic.net,cnolnic.net,net,net,ns2.cnolnic.net,cnolnic.net,net,net,,,,,,,,,,,,,wu shanlun,wu shanlun,jakemt@21cn.com,21cn.com,com,com,+86.07593339000,,"Room BD402,CuiFuYuan,No.19,Lane 6,haibin Road,ChiKan District|zhanjiang, Guangdong, cn 524000","Room BD402,CuiFuYuan,No.19,Lane 6,haibin Road,ChiKan District",,,zhanjiang,Guangdong,524000,cn,jones jones,jones,jakemt@21cn.com,21cn.com,com,com,+86.07593339000,"Yuan,No.19,Lane 6,haibin Road,ChiKan District|+86.","Room BD402,CuiFuYuan,No.19,Lane 6,haibin Road,ChiKan District|zhanjiang, Guangdong, cn 524000","Room BD402,CuiFuYuan,No.19,Lane 6,haibin Road,ChiKan District",,,zhanjiang,Guangdong,524000,cn,jones jones,jones,jakemt@21cn.com,21cn.com,com,com,+86.07593339000,"Yuan,No.19,Lane 6,haibin Road,ChiKan District|+86.","Room BD402,CuiFuYuan,No.19,Lane 6,haibin Road,ChiKan District|zhanjiang, Guangdong, cn 524000","Room BD402,CuiFuYu
 an,No.19,Lane 6,haibin Road,ChiKan District",,,zhanjiang,Guangdong,524000,cn,,"<rec>The Data in Web Commerce Communications Limited (""WEBCC"")'s WHOIS database 
+is provided by WEBCC for information purposes, and to assist in obtaining 
+information about or related to a domain name registration record. WEBCC 
+does not guarantee its accuracy. By submitting a WHOIS query, you agree 
+that you will use this Data only for lawful purposes and that, under no 
+circumstances will you use this Data to:
+
+(1) allow, enable, or otherwise support the transmission of mass unsolicited, 
+    commercial advertising or solicitations via e-mail (spam).
+(2) enable high volume, automated, electronic processes that apply to WEBCC 
+    (or its systems).
+
+The compilation, repackaging, dissemination or other use of this Data is 
+expressly prohibited without the prior written consent of WEBCC. WEBCC 
+reserves the right to terminate your access to the WEBCC WHOIS database in 
+its sole discretion, including without limitation, for excessive querying 
+of the WHOIS database or for failure to otherwise abide by this policy. 
+WEBCC reserves the right to modify these terms at any time.
+
+
+Domain: 00045.NET
+Status: 
+
+DNS:
+	ns1.cnolnic.net
+	ns2.cnolnic.net
+
+Created: 2005-04-16
+Expires: 2006-04-16
+Last Modified: 2005-04-16 15:36:51
+
+Registrant Contact:
+	wu shanlun
+	wu shanlun (jakemt@21cn.com)
+	Room BD402,CuiFuYuan,No.19,Lane 6,haibin  Road,ChiKan District
+	zhanjiang, Guangdong, cn 524000
+	P: +86.07593339000	 F: +86.07593339000
+
+Administrative Contact:
+	jones
+	jones jones (jakemt@21cn.com)
+	Room BD402,CuiFuYuan,No.19,Lane 6,haibin  Road,ChiKan District
+	zhanjiang, Guangdong, cn 524000
+	P: +86.07593339000	 F: +86.07593339000
+	
+Technical Contact:
+	jones
+	jones jones (jakemt@21cn.com)
+	Room BD402,CuiFuYuan,No.19,Lane 6,haibin  Road,ChiKan District
+	zhanjiang, Guangdong, cn 524000
+	P: +86.07593339000	 F: +86.07593339000
+
+Billing Contact:
+	jones
+	jones jones (jakemt@21cn.com)
+	Room BD402,CuiFuYuan,No.19,Lane 6,haibin  Road,ChiKan District
+	zhanjiang, Guangdong, cn 524000
+	P: +86.07593339000	 F: +86.07593339000</rec>"
+520,007-melodiasmoviles.net,net,net,,,,,Register.com,http://www.register.com,whois.register.com,2006-06-16 19:33:16.113883,"Fri, Jan 31, 2003","Thu, Feb 23, 2006",2008-01-31,3,,,dns27.register.com,register.com,com,com,dns28.register.com,register.com,com,com,,,,,,,,,,,,,Joaquin Edo,Joaquin Edo,joaquinedo@eresmas.com,eresmas.com,com,com,964539036,964532357,"C/ Sardenya, 29|Vila-real, CS 12540|ES","C/ Sardenya, 29",,,Vila-real,CS,12540,ES,Domain Registrar,Register.Com,domain-registrar@register.com,register.com,com,com,902-749-2701,902-749-5429,"575 8th Avenue|New York, NY 10018|US",575 8th Avenue,,,New York,NY,10018,US,Joaquin Edo,Joaquin Edo,chimo@nrs-group.com,nrs-group.com,com,com,964539036,964532357,"C/ Sardenya, 29|Vila-real, CS 12540|ES","C/ Sardenya, 29",,,Vila-real,CS,12540,ES,,"<rec>The data in Register.com's WHOIS database is provided to you by
+Register.com for information purposes only, that is, to assist you in
+obtaining information about or related to a domain name registration
+record.  Register.com makes this information available ""as is,"" and
+does not guarantee its accuracy.  By submitting a WHOIS query, you
+agree that you will use this data only for lawful purposes and that,
+under no circumstances will you use this data to: (1) allow, enable,
+or otherwise support the transmission of mass unsolicited, commercial
+advertising or solicitations via direct mail, electronic mail, or by
+telephone; or (2) enable high volume, automated, electronic processes
+that apply to Register.com (or its systems).  The compilation,
+repackaging, dissemination or other use of this data is expressly
+prohibited without the prior written consent of Register.com. 
+Register.com reserves the right to modify these terms at any time.
+By submitting this query, you agree to abide by these terms.
+
+
+   Organization:
+      Joaquin Edo
+      Joaquin Edo
+      C/ Sardenya, 29
+      Vila-real, CS 12540
+      ES
+      Phone: 964539036
+      Fax..: 964532357
+      Email: joaquinedo@eresmas.com
+
+   Registrar Name....: Register.com
+   Registrar Whois...: whois.register.com
+   Registrar Homepage: http://www.register.com
+
+   Domain Name: 007-MELODIASMOVILES.NET
+
+      Created on..............: Fri, Jan 31, 2003
+      Expires on..............: Thu, Jan 31, 2008
+      Record last updated on..: Thu, Feb 23, 2006
+
+   Administrative Contact:
+      Joaquin Edo
+      Joaquin Edo
+      C/ Sardenya, 29
+      Vila-real, CS 12540
+      ES
+      Phone: 964539036
+      Fax..: 964532357
+      Email: chimo@nrs-group.com
+
+   Technical Contact:
+      Register.Com
+      Domain Registrar
+      575 8th Avenue
+      New York, NY 10018
+      US
+      Phone: 902-749-2701
+      Fax..: 902-749-5429
+      Email: domain-registrar@register.com
+
+   Zone Contact:
+      Register.Com
+      Domain Registrar
+      575 8th Avenue
+      New York, NY 10018
+      US
+      Phone: 902-749-2701
+      Fax..: 902-749-5429
+      Email: domain-registrar@register.com
+
+   Domain servers in listed order:
+
+   DNS27.REGISTER.COM                                216.21.234.84     
+   DNS28.REGISTER.COM                                216.21.226.84     
+
+Register your domain name at http://www.register.com</rec>"
+596,007dy.net,net,net,,,,,,,,2006-06-16 19:33:16.186276,2005-06-21,,2007-06-21,3,,,ns5.cnmsn.net,cnmsn.net,net,net,ns6.cnmsn.net,cnmsn.net,net,net,,,,,,,,,,,,,zhangyuanzong,,aaaqqq616@sohu.com,sohu.com,com,com,,,anxi|Xiamen Fujian 362400|cn,anxi,,,Xiamen Fujian,,362400,cn,yuanzong zhang,,aaaqqq616@sohu.com,sohu.com,com,com,13959805966,0592-7220135,anxi|Xiamen Fujian 362400|cn,anxi,,,Xiamen Fujian,,362400,cn,yuanzong zhang,,aaaqqq616@sohu.com,sohu.com,com,com,13959805966,0592-7220135,anxi|Xiamen Fujian 362400|cn,anxi,,,Xiamen Fujian,,362400,cn,,"<rec>The data in this whois database is provided to you for information
+purposes only, that is, to assist you in obtaining information about or
+related to a domain name registration record. We make this information
+available ""as is,"" and do not guarantee its accuracy. By submitting a
+whois query, you agree that you will use this data only for lawful
+purposes and that, under no circumstances will you use this data to: (1)
+enable high volume, automated, electronic processes that stress or load
+this whois database system providing you this information; or (2) allow,
+enable, or otherwise support the transmission of mass unsolicited,
+commercial advertising or solicitations via direct mail, electronic
+mail, or by telephone.  The compilation, repackaging, dissemination or
+other use of this data is expressly prohibited without prior written
+consent from us.  We reserve the right to modify these terms at any time.
+By submitting this query, you agree to abide by these terms.
+
+Domain name: 007dy.net
+
+Registrant Contact:
+   zhangyuanzong
+   yuanzong zhang aaaqqq616@sohu.com
+   13959805966 fax: 0592-7220135
+   anxi
+   Xiamen Fujian 362400
+   cn
+
+Administrative Contact:
+   yuanzong zhang aaaqqq616@sohu.com
+   13959805966 fax: 0592-7220135
+   anxi
+   Xiamen Fujian 362400
+   cn
+
+Technical Contact:
+   yuanzong zhang aaaqqq616@sohu.com
+   13959805966 fax: 0592-7220135
+   anxi
+   Xiamen Fujian 362400
+   cn
+
+Billing Contact:
+   Bishuang Chen jeffcai@hotmail.com
+   0592-8611101 fax: 0592-5880619
+   Unit 501,E2 Building,Fushan Garden,No.663 South Hubin Road
+   Xiamen Fujian 361004
+   cn
+
+DNS:
+ns5.cnmsn.net
+ns6.cnmsn.net
+
+Created: 2005-06-21
+Expires: 2007-06-21</rec>"
+650,00163.net,net,net,,,,,,,,2006-06-16 19:33:16.339013,03-11-2004,,2007-03-11,3,,,ns0.directnic.com,directnic.com,com,com,ns1.directnic.com,directnic.com,com,com,,,,,,,,,,,,,"NOLDC, Inc",,,,,,504-523-0360,504-274-0360,"838 Camp Street|Apartment C|New Orleans, LA 70130|US",838 Camp Street,Apartment C,,New Orleans,LA,70130,US,"Purchase, Domain",,support@noldc.com,noldc.com,com,com,504-523-0360,504-274-0360,"838 Camp Street|Apartment C|New Orleans, LA 70130|US",838 Camp Street,Apartment C,,New Orleans,LA,70130,US,"Purchase, Domain",,support@noldc.com,noldc.com,com,com,504-523-0360,504-274-0360,"838 Camp Street|Apartment C|New Orleans, LA 70130|US",838 Camp Street,Apartment C,,New Orleans,LA,70130,US,,"<rec>Registration and WHOIS Service provided by directNIC.com
+
+Intercosmos Media Group, Inc. provides the data in the directNIC.com
+Registrar WHOIS database for informational purposes only.  The information
+may only be used to assist in obtaining information about a domain name's
+registration record.
+
+directNIC makes this information available ""as is"", and does not guarantee
+its accuracy.
+
+
+Registrant:
+ NOLDC, Inc
+ 838 Camp Street
+ Apartment C
+ New Orleans, LA 70130
+ US
+ 504-523-0360 
+Fax:504-274-0360
+
+
+Domain Name: 00163.NET
+
+Administrative Contact: 
+ Purchase, Domain support@noldc.com
+ 838 Camp Street
+ Apartment C
+ New Orleans, LA 70130
+ US
+ 504-523-0360 
+Fax:504-274-0360
+
+
+Technical Contact: 
+ Purchase, Domain support@noldc.com
+ 838 Camp Street
+ Apartment C
+ New Orleans, LA 70130
+ US
+ 504-523-0360 
+Fax:504-274-0360
+
+
+Record last updated 03-11-2004 03:24:56 PM
+Record expires on 03-11-2007
+Record created on 03-11-2004
+
+Domain servers in listed order:
+	NS0.DIRECTNIC.COM	204.251.10.100
+	NS1.DIRECTNIC.COM	206.251.177.2
+
+
+By submitting a WHOIS query, you agree you will use this data only for
+lawful purposes.  You also agree that, under no circumstances, will you use
+this data to:  (a) allow, enable, or otherwise support the transmission by
+email, telephone, or facsimile of mass, unsolicited, commercial advertising
+or solicitations to entities other than the data recipient's own existing
+customers; or to (b) enable high volume, automated, electronic processes
+that send queries or data to the systems of any Registry Operator or
+ICANN-accredited registrar.
+
+The compilation, repackaging, dissemination, or other use of this WHOIS
+data is expressly prohibited without the prior written consent of
+directNIC.com.
+
+directNIC.com reserves the right to terminate your access to its WHOIS
+database in its sole discretion, including without limitation, for
+excessive querying of the database or for failure to otherwise abide by
+this policy.
+
+directNIC reserves the right to modify these terms at any time.
+
+NOTE: THE WHOIS DATABASE IS A CONTACT DATABASE ONLY.  
+LACK OF A DOMAIN RECORD DOES NOT SIGNIFY DOMAIN AVAILABILITY.</rec>"
+725,0-sexyteens.net,net,net,,,,,,,,2006-06-16 19:47:19.247488,"March 25, 2002","May 11, 2006",2007-03-25,3,,,ns1.maturedns.com,maturedns.com,com,com,ns2.maturedns.com,maturedns.com,com,com,,,,,,,,,,,,,"SecureWhois, Inc.",QHdNKgNBRqs@securewhois.com,904 S. Roselle Road #136,904,,,+1.6306727455,,"Schaumburg, IL 60193 US","Schaumburg, IL 60193 US",,,,,,,"SecureWhois, Inc.",xFGFKPPcrWV@securewhois.com,904 S. Roselle Road #136,904,,,+1.6306727455,+1.6306727455,"Schaumburg, IL 60193 US","Schaumburg, IL 60193 US",,,,,,,"SecureWhois, Inc.",qFgflfDcXRV@securewhois.com,904 S. Roselle Road #136,904,,,+1.6306727455,+1.6306727455,"Schaumburg, IL 60193 US","Schaumburg, IL 60193 US",,,,,,,,"<rec>The Data in ItsYourDomain's WHOIS database is provided by ItsYourDomain.com 
+for information purposes, and to assist persons in obtaining information 
+about or related to a domain name registration record.  ItsYourDomain.com 
+does not guarantee its accuracy.  By submitting a WHOIS query, you agree 
+that you will use this Data only for lawful purposes and that, under no 
+circumstances will you use this Data to: (1) allow, enable, or otherwise 
+support the transmission of mass unsolicited, commercial advertising or 
+solicitations via e-mail (spam); or (2) enable high volume, automated, 
+electronic processes that apply to ItsYourDomain.com, its systems, or its 
+customers. ItsYourDomain reserves the right to modify these terms at any 
+time.By submitting this query, you agree to abide by this policy.
+
+
+ Domain: 0-sexyteens.net
+
+ Registrant 
+   SecureWhois, Inc.
+   QHdNKgNBRqs@securewhois.com
+   904 S. Roselle Road #136
+   Schaumburg, IL 60193 US 
+   +1.6306727455
+   +1.6306727455 (FAX)
+
+ Administrative 
+   SecureWhois, Inc.
+   qFgflfDcXRV@securewhois.com
+   904 S. Roselle Road #136
+   Schaumburg, IL 60193 US 
+   +1.6306727455
+   +1.6306727455 (FAX)
+
+ Billing 
+   SecureWhois, Inc.
+   xFGFKPPcrWV@securewhois.com
+   904 S. Roselle Road #136
+   Schaumburg, IL 60193 US 
+   +1.6306727455
+   +1.6306727455 (FAX)
+
+ Technical 
+   SecureWhois, Inc.
+   xFGFKPPcrWV@securewhois.com
+   904 S. Roselle Road #136
+   Schaumburg, IL 60193 US 
+   +1.6306727455
+   +1.6306727455 (FAX)
+
+ Record created on March 25, 2002
+ Record last updated on May 11, 2006
+ Record expires on March 25, 2007
+
+ Domain Name Servers:
+   NS1.MATUREDNS.COM
+   NS2.MATUREDNS.COM</rec>"
+782,0000ff.net,net,net,,,,,,,,2006-06-16 19:47:19.833943,2005-01-20 00:00:00,2005-01-20 00:00:00,2008-01-20,3,,,ns1.phpwebhosting.com,phpwebhosting.com,com,com,ns2.phpwebhosting.com,phpwebhosting.com,com,com,,,,,,,,,,,,,Jeff Berk,,jeffreyberk@gmail.com,gmail.com,com,com,+1 (978) 887-6502,,"62 Rowley Road|Boxford, MA 01921|United States",62 Rowley Road,,,Boxford,MA,01921,United States,Jeff Berk,,jeffreyberk@gmail.com,gmail.com,com,com,+1 (978) 887-6502,,"62 Rowley Road|Boxford, MA 01921|United States",62 Rowley Road,,,Boxford,MA,01921,United States,Jeff Berk,,jeffreyberk@gmail.com,gmail.com,com,com,+1 (978) 887-6502,,"62 Rowley Road|Boxford, MA 01921|United States",62 Rowley Road,,,Boxford,MA,01921,United States,,"<rec>The information below is provided by NAMES4EVER for personal use only.
+NAMES4EVER does not guarantee its accuracy. By submitting a query, you
+agree that you will use this information only for lawful purposes and
+that; under no circumstances will you use this information from
+NAMES4EVER to: (a) allow, enable, or otherwise support the
+transmission of mass commercial advertising or solicitations via e-mail;
+(b) enable high volume, automated, electronic processes that apply to
+NAMES4EVER and (c) sell the information. NAMES4EVER reserves the right
+to modify these terms at any time. By submitting this query, you agree
+to abide by this policy by NAMES4EVER. NAMES4EVER is ICANN accredited
+Registrar for .com .org and .net domain names.
+
+Domain name: 0000ff.net
+
+Registrant:
+   Jeff Berk (MHDUW) jeffreyberk@gmail.com
+   62 Rowley Road
+   Boxford,    MA    01921
+   United States
+   Phone: +1 (978) 887-6502
+
+Administrative Contact:
+   Jeff Berk (PUJBP) jeffreyberk@gmail.com
+   62 Rowley Road
+   Boxford,    MA    01921
+   United States
+   Phone: +1 (978) 887-6502
+
+Technical Contact:
+   Jeff Berk (MHDUW) jeffreyberk@gmail.com
+   62 Rowley Road
+   Boxford,    MA    01921
+   United States
+   Phone: +1 (978) 887-6502
+
+Billing Contact:
+   Jeff Berk (F2KPR) jeffreyberk@gmail.com
+   62 Rowley Road
+   Boxford,    MA    01921
+   United States
+   Phone: +1 (978) 887-6502
+
+Record last updated on 2005-01-20 00:00:00
+Record created on 2005-01-20 00:00:00
+Record expires on 2008-01-20 00:00:00
+
+Domain servers in listed order:
+   ns1.phpwebhosting.com   64.65.1.112
+   ns2.phpwebhosting.com   64.65.34.231
+
+Registration Service Provider: AplusNet(APRO)
+   apro-n4e-racc@abac.com
+   
+   http://www.aplus.net
+
+Registrar: NAMES4EVER, http://www.names4ever.com</rec>"
+839,0041.net,net,net,,,,,,,,2006-06-16 19:47:20.313468,2004-03-09,2004-03-09,2007-03-09,3,,,ns.xinnet.cn,xinnet.cn,cn,cn,ns.xinnetdns.com,xinnetdns.com,com,com,,,,,,,,,,,,,zheng minjie,,,,,,,,zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi|315700,zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi,,,315700,,,,wang wei,Ningbo Haishu E-time Electron,diso@21cn.com,21cn.com,com,com,86 574 87365478,86 574 87365450,Room 602 No.43 changshong road|Ningbo Zhejiang 315012|China,Room 602 No.43 changshong road,,,Ningbo Zhejiang,,315012,China,wang wei,zheng minjie,diso@21cn.com,21cn.com,com,com,86 574 87365478,86 574 87365450,zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi|xiangshan Zhejiang 315700|China,zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi,,,xiangshan Zhejiang,,315700,China,,"<rec>The Data in Paycenter's WHOIS database is provided by Paycenter 
+for information purposes, and to assist persons in obtaining 
+information about or related to a domain name registration 
+record.
+Paycenter does not guarantee its accuracy.  By submitting 
+a WHOIS query, you agree that you will use this Data only 
+for lawful purposes and that, under no circumstances will 
+you use this Data to:
+(1) allow, enable, or otherwise support the transmission 
+of mass unsolicited, commercial advertising or solicitations 
+via e-mail (spam); or  
+(2) enable high volume, automated, electronic processes that 
+apply to Paycenter or its systems.  
+Paycenter reserves the right to modify these terms at any time. 
+By submitting this query, you agree to abide by this policy.	
+        
+Domain Name:0041.net
+
+
+Registrant: 
+zheng minjie
+	zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi
+	315700
+	
+	
+
+Administrative Contact: 
+wang wei
+	zheng minjie
+	zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi
+	xiangshan Zhejiang 315700
+	China
+	tel: 86 574 87365478 
+	fax: 86 574 87365450 
+	diso@21cn.com
+	
+Technical Contact: 
+wang wei
+	Ningbo Haishu E-time Electron
+	Room 602 No.43 changshong road
+	Ningbo Zhejiang 315012
+	China
+	tel: 86 574 87365478 
+	fax: 86 574 87365450 
+	diso@21cn.com
+	
+Billing Contact: 
+wang wei
+	Ningbo Haishu E-time Electron
+	Room 602 No.43 changshong road
+	Ningbo Zhejiang 315012
+	China
+	tel: 86 574 87365478 
+	fax: 86 574 87365450 
+	diso@21cn.com
+	
+ Registration Date: 2004-03-09
+       Update Date: 2004-03-09
+   Expiration Date: 2007-03-09
+	
+    Primary DNS:  ns.xinnetdns.com		210.51.170.66
+  Secondary DNS:  ns.xinnet.cn		210.51.171.209</rec>"
+903,0086-595.net,net,net,,,,,,,,2006-06-16 19:52:07.9191,2004-03-08,2004-03-08,2007-03-08,3,,,ns.xinnet.cn,xinnet.cn,cn,cn,ns.xinnetdns.com,xinnetdns.com,com,com,,,,,,,,,,,,,zhegn minjie,,,,,,,,zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi|315700,zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi,,,315700,,,,wang wei,Ningbo Haishu E-time Electron,diso@21cn.com,21cn.com,com,com,86 574 87365478,86 574 87365450,Room 602 No.43 changshong road|Ningbo Zhejiang 315012|China,Room 602 No.43 changshong road,,,Ningbo Zhejiang,,315012,China,wang wei,zhegn minjie,diso@21cn.com,21cn.com,com,com,86 574 87365478,86 574 87365450,zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi|xiangshan Zhejiang 315700|China,zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi,,,xiangshan Zhejiang,,315700,China,,"<rec>The Data in Paycenter's WHOIS database is provided by Paycenter 
+for information purposes, and to assist persons in obtaining 
+information about or related to a domain name registration 
+record.
+Paycenter does not guarantee its accuracy.  By submitting 
+a WHOIS query, you agree that you will use this Data only 
+for lawful purposes and that, under no circumstances will 
+you use this Data to:
+(1) allow, enable, or otherwise support the transmission 
+of mass unsolicited, commercial advertising or solicitations 
+via e-mail (spam); or  
+(2) enable high volume, automated, electronic processes that 
+apply to Paycenter or its systems.  
+Paycenter reserves the right to modify these terms at any time. 
+By submitting this query, you agree to abide by this policy.	
+        
+Domain Name:0086-595.net
+
+
+Registrant: 
+zhegn minjie
+	zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi
+	315700
+	
+	
+
+Administrative Contact: 
+wang wei
+	zhegn minjie
+	zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi
+	xiangshan Zhejiang 315700
+	China
+	tel: 86 574 87365478 
+	fax: 86 574 87365450 
+	diso@21cn.com
+	
+Technical Contact: 
+wang wei
+	Ningbo Haishu E-time Electron
+	Room 602 No.43 changshong road
+	Ningbo Zhejiang 315012
+	China
+	tel: 86 574 87365478 
+	fax: 86 574 87365450 
+	diso@21cn.com
+	
+Billing Contact: 
+wang wei
+	Ningbo Haishu E-time Electron
+	Room 602 No.43 changshong road
+	Ningbo Zhejiang 315012
+	China
+	tel: 86 574 87365478 
+	fax: 86 574 87365450 
+	diso@21cn.com
+	
+ Registration Date: 2004-03-08
+       Update Date: 2004-03-08
+   Expiration Date: 2007-03-08
+	
+    Primary DNS:  ns.xinnetdns.com		210.51.170.66
+  Secondary DNS:  ns.xinnet.cn		210.51.171.209</rec>"
+967,000gps.net,net,net,,,,,,,,2006-06-16 19:59:55.74642,30-MAR-04,30-MAR-05,,3,N,,,,,,,,,,,,,,,,,,,,,,Reno USA,,,,,,,,"PO Box 669875|Marietta, GA 30066|US",PO Box 669875,,,Marietta,GA,30066,US,,,,,,,,,,,,,,,,,"Farah, Dawoud david@kvms.com",,,,,,1.8005867948|1.7709712639,,"Reno USA|PO Box 669875|Marietta, GA 30066|US",Reno USA,PO Box 669875,,Marietta,GA,30066,US,,"<rec>The information in this whois database is provided for the sole
+purpose of assisting you in obtaining information about domain
+name registration records. This information is available ""as is,""
+and we do not guarantee its accuracy. By submitting a whois
+query, you agree that you will use this data only for lawful
+purposes and that, under no circumstances will you use this data
+to: (1) enable high volume, automated, electronic processes that
+stress or load this whois database system providing you this
+information; or (2) allow,enable, or otherwise support the
+transmission of mass, unsolicited, commercial advertising or
+solicitations via facsimile, electronic mail, or by telephone to
+entitites other than your own existing customers.  The
+compilation, repackaging, dissemination or other use of this data
+is expressly prohibited without prior written consent from this
+company. We reserve the right to modify these terms at any
+time. By submitting an inquiry, you agree to these terms of usage
+and limitations of warranty.  Please limit your queries to 10 per
+minute and one connection.
+
+   Domain Services Provided By:
+      000domains, support@000domains.com
+      http://www.000domains.com
+
+Registrant:
+   Reno USA
+   PO Box 669875
+   Marietta, GA  30066
+   US
+
+   Registrar: 000DOM
+   Domain Name: 000GPS.NET
+      Created on: 30-MAR-04
+      Expires on: 19-SEP-06
+      Last Updated on: 30-MAR-05
+
+   Administrative, Technical Contact:
+      Farah, Dawoud  david@kvms.com
+      Reno USA
+      PO Box 669875
+      Marietta, GA  30066
+      US
+      1.8005867948
+      1.7709712639
+
+
+   Domain servers in listed order:
+      FWNS1.000DOMAINS.COM 
+      FWNS2.000DOMAINS.COM 
+
+End of Whois Information</rec>"
+1019,0086-534.net,net,net,,,,,,,,2006-06-16 20:09:15.945701,2004-03-08,2004-03-08,2007-03-08,3,,,ns.xinnet.cn,xinnet.cn,cn,cn,ns.xinnetdns.com,xinnetdns.com,com,com,,,,,,,,,,,,,zheng minjie,,,,,,,,zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi|315700,zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi,,,315700,,,,wang wei,Ningbo Haishu E-time Electron,diso@21cn.com,21cn.com,com,com,86 574 87365478,86 574 87365450,Room 602 No.43 changshong road|Ningbo Zhejiang 315012|China,Room 602 No.43 changshong road,,,Ningbo Zhejiang,,315012,China,wang wei,zheng minjie,diso@21cn.com,21cn.com,com,com,86 574 87365478,86 574 87365450,zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi|xiangshan Zhejiang 315700|China,zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi,,,xiangshan Zhejiang,,315700,China,,"<rec>The Data in Paycenter's WHOIS database is provided by Paycenter 
+for information purposes, and to assist persons in obtaining 
+information about or related to a domain name registration 
+record.
+Paycenter does not guarantee its accuracy.  By submitting 
+a WHOIS query, you agree that you will use this Data only 
+for lawful purposes and that, under no circumstances will 
+you use this Data to:
+(1) allow, enable, or otherwise support the transmission 
+of mass unsolicited, commercial advertising or solicitations 
+via e-mail (spam); or  
+(2) enable high volume, automated, electronic processes that 
+apply to Paycenter or its systems.  
+Paycenter reserves the right to modify these terms at any time. 
+By submitting this query, you agree to abide by this policy.	
+        
+Domain Name:0086-534.net
+
+
+Registrant: 
+zheng minjie
+	zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi
+	315700
+	
+	
+
+Administrative Contact: 
+wang wei
+	zheng minjie
+	zhejiangsheng xiangshanxian danchengzhen xinfengxiaoqu 3zhuang 104shi
+	xiangshan Zhejiang 315700
+	China
+	tel: 86 574 87365478 
+	fax: 86 574 87365450 
+	diso@21cn.com
+	
+Technical Contact: 
+wang wei
+	Ningbo Haishu E-time Electron
+	Room 602 No.43 changshong road
+	Ningbo Zhejiang 315012
+	China
+	tel: 86 574 87365478 
+	fax: 86 574 87365450 
+	diso@21cn.com
+	
+Billing Contact: 
+wang wei
+	Ningbo Haishu E-time Electron
+	Room 602 No.43 changshong road
+	Ningbo Zhejiang 315012
+	China
+	tel: 86 574 87365478 
+	fax: 86 574 87365450 
+	diso@21cn.com
+	
+ Registration Date: 2004-03-08
+       Update Date: 2004-03-08
+   Expiration Date: 2007-03-08
+	
+    Primary DNS:  ns.xinnetdns.com		210.51.170.66
+  Secondary DNS:  ns.xinnet.cn		210.51.171.209</rec>"
+1083,0-l.net,net,net,,,,,"GoDaddy.com, Inc.",http://www.godaddy.com,whois.godaddy.com,2006-06-16 20:17:31.778459,12-Jan-06,03-Aug-06,2007-01-12,3,,,ns1.sedoparking.com,sedoparking.com,com,com,ns2.sedoparking.com,sedoparking.com,com,com,,,,,,,,,,,,,Central Equities,,,,,,,,"Kirkegardsvegen 3|Tromso, Tromso N-9009|Norway",Kirkegardsvegen 3,,,Tromso,Tromso,N-9009,Norway,"Fosshaug, Karl-Oskar",Central Equities,central@equities.no,equities.no,no,no,90123466,,"Kirkegardsvegen 3|Tromso, Tromso N-9009|Norway",Kirkegardsvegen 3,,,Tromso,Tromso,N-9009,Norway,"Fosshaug, Karl-Oskar",Central Equities,central@equities.no,equities.no,no,no,90123466,,"Kirkegardsvegen 3|Tromso, Tromso N-9009|Norway|",Kirkegardsvegen 3,,,Tromso,Tromso,N-9009,Norway,,"<rec>The data contained in GoDaddy.com, Inc.'s WhoIs database,
+while believed by the company to be reliable, is provided ""as is""
+with no guarantee or warranties regarding its accuracy.  This
+information is provided for the sole purpose of assisting you
+in obtaining information about domain name registration records.
+Any use of this data for any other purpose is expressly forbidden without the prior written
+permission of GoDaddy.com, Inc.  By submitting an inquiry,
+you agree to these terms of usage and limitations of warranty.  In particular,
+you agree not to use this data to allow, enable, or otherwise make possible,
+dissemination or collection of this data, in part or in its entirety, for any
+purpose, such as the transmission of unsolicited advertising and
+and solicitations of any kind, including spam.  You further agree
+not to use this data to enable high volume, automated or robotic electronic
+processes designed to collect or compile this data for any purpose,
+including mining this data for your own personal or commercial purposes. 
+
+Please note: the registrant of the domain name is specified
+in the ""registrant"" field.  In most cases, GoDaddy.com, Inc. 
+is not the registrant of domain names listed in this database.
+
+
+Registrant:
+   Central Equities
+   Kirkegardsvegen 3
+   Tromso, Tromso N-9009
+   Norway
+
+   Registered through: GoDaddy.com, Inc. (http://www.godaddy.com)
+   Domain Name: 0-L.NET
+      Created on: 12-Jan-06
+      Expires on: 12-Jan-07
+      Last Updated on: 03-Aug-06
+
+   Administrative Contact:
+      Fosshaug, Karl-Oskar  central@equities.no
+      Central Equities
+      Kirkegardsvegen 3
+      Tromso, Tromso N-9009
+      Norway
+      90123466      Fax -- 
+
+   Technical Contact:
+      Fosshaug, Karl-Oskar  central@equities.no
+      Central Equities
+      Kirkegardsvegen 3
+      Tromso, Tromso N-9009
+      Norway
+      90123466      Fax -- 
+
+   Domain servers in listed order:
+      NS1.SEDOPARKING.COM
+      NS2.SEDOPARKING.COM</rec>"
+1137,0049165.net,net,net,,,,,"TUCOWS, INC.",,,2006-06-17 09:36:12.986089,18-Apr-2001,27-Jun-2006,2007-04-18,3,,,ns.komplex.net,komplex.net,net,net,ns2.komplex.net,komplex.net,net,net,ns3.komplex.net,komplex.net,net,net,,,,,,,,,FreeCity GmbH,,,,,,,,"Bismarckstr. 120|Duisburg, 47057|DE",Bismarckstr. 120,,,Duisburg,,47057,DE,"Hostmaster, KomPlex",,hostmaster@komplex.net,komplex.net,net,net,+49.2033094100,+49.2033094110,"Ruhrorter Str. 100|Duisburg, 47059|DE",Ruhrorter Str. 100,,,Duisburg,,47059,DE,"Klinkhammer, Uli",,uk@komplex.net,komplex.net,net,net,+49.20330940,+49.2033094232,"Koloniestr. 98|Duisburg, 47057|DE",Koloniestr. 98,,,Duisburg,,47057,DE,,"<rec>Registrant:
+ FreeCity GmbH
+ Bismarckstr. 120
+ Duisburg,  47057
+ DE
+
+ Domain name: 0049165.NET
+
+ Administrative Contact:
+    Klinkhammer, Uli  uk@komplex.net
+    Koloniestr. 98
+    Duisburg,  47057
+    DE
+    +49.20330940    Fax: +49.2033094232
+
+ Technical Contact:
+    Hostmaster, KomPlex  hostmaster@komplex.net
+    Ruhrorter Str. 100
+    Duisburg,  47059
+    DE
+    +49.2033094100    Fax: +49.2033094110
+
+
+
+ Registrar of Record: TUCOWS, INC.
+ Record last updated on 27-Jun-2006.
+ Record expires on 18-Apr-2007.
+ Record created on 18-Apr-2001.
+
+ Domain servers in listed order:
+    NS.KOMPLEX.NET   81.88.32.17
+    NS2.KOMPLEX.NET   81.88.36.18
+    NS3.KOMPLEX.NET   134.91.19.6
+
+
+ Domain status: REGISTRAR-LOCK
+
+The Data in the Tucows Registrar WHOIS database is provided to you by Tucows
+for information purposes only, and may be used to assist you in obtaining
+information about or related to a domain name's registration record.
+
+Tucows makes this information available ""as is,"" and does not guarantee its
+accuracy.
+
+By submitting a WHOIS query, you agree that you will use this data only for
+lawful purposes and that, under no circumstances will you use this data to:
+a) allow, enable, or otherwise support the transmission by e-mail,
+telephone, or facsimile of mass, unsolicited, commercial advertising or
+solicitations to entities other than the data recipient's own existing
+customers; or (b) enable high volume, automated, electronic processes that
+send queries or data to the systems of any Registry Operator or
+ICANN-Accredited registrar, except as reasonably necessary to register
+domain names or modify existing registrations.
+
+The compilation, repackaging, dissemination or other use of this Data is
+expressly prohibited without the prior written consent of Tucows.
+
+Tucows reserves the right to terminate your access to the Tucows WHOIS
+database in its sole discretion, including without limitation, for excessive
+querying of the WHOIS database or for failure to otherwise abide by this
+policy.
+
+Tucows reserves the right to modify these terms at any time.
+
+By submitting this query, you agree to abide by these terms.
+
+NOTE: THE WHOIS DATABASE IS A CONTACT DATABASE ONLY.  LACK OF A DOMAIN
+RECORD DOES NOT SIGNIFY DOMAIN AVAILABILITY.</rec>"
+1208,00791.net,net,net,,,,,"TUCOWS, INC.",,,2006-06-17 09:45:07.111594,28-May-2004,28-Apr-2006,2007-05-28,3,,,a.ns.ultsearch.com,ultsearch.com,com,com,b.ns.ultsearch.com,ultsearch.com,com,com,,,,,,,,,,,,,Contactprivacy.com,,,,,,,,"96 Mowat Ave|Toronto, ON M6K 3M1|CA",96 Mowat Ave,,,Toronto,ON M6K,3M1,CA,"contactprivacy.com,",,00791.net@contactprivacy.com,contactprivacy.com,com,com,+1.4165385457,,"96 Mowat Ave|Toronto, ON M6K 3M1|CA",96 Mowat Ave,,,Toronto,ON M6K,3M1,CA,"contactprivacy.com,",,00791.net@contactprivacy.com,contactprivacy.com,com,com,+1.4165385457,,"96 Mowat Ave|Toronto, ON M6K 3M1|CA",96 Mowat Ave,,,Toronto,ON M6K,3M1,CA,,"<rec>Registrant:
+ Contactprivacy.com
+ 96 Mowat Ave
+ Toronto, ON M6K 3M1
+ CA
+
+ Domain name: 00791.NET
+
+ Administrative Contact:
+    contactprivacy.com,   00791.net@contactprivacy.com
+    96 Mowat Ave
+    Toronto, ON M6K 3M1
+    CA
+    +1.4165385457
+ Technical Contact:
+    contactprivacy.com,   00791.net@contactprivacy.com
+    96 Mowat Ave
+    Toronto, ON M6K 3M1
+    CA
+    +1.4165385457
+
+
+ Registrar of Record: TUCOWS, INC.
+ Record last updated on 28-Apr-2006.
+ Record expires on 28-May-2007.
+ Record created on 28-May-2004.
+
+ Domain servers in listed order:
+    A.NS.ULTSEARCH.COM   66.116.109.47
+    B.NS.ULTSEARCH.COM   66.116.109.48
+
+
+ Domain status: REGISTRAR-LOCK
+
+
+This domain's privacy is protected by contactprivacy.com. To reach the domain contacts, please go to http://www.contactprivacy.com and follow the instructions.
+
+The Data in the Tucows Registrar WHOIS database is provided to you by Tucows
+for information purposes only, and may be used to assist you in obtaining
+information about or related to a domain name's registration record.
+
+Tucows makes this information available ""as is,"" and does not guarantee its
+accuracy.
+
+By submitting a WHOIS query, you agree that you will use this data only for
+lawful purposes and that, under no circumstances will you use this data to:
+a) allow, enable, or otherwise support the transmission by e-mail,
+telephone, or facsimile of mass, unsolicited, commercial advertising or
+solicitations to entities other than the data recipient's own existing
+customers; or (b) enable high volume, automated, electronic processes that
+send queries or data to the systems of any Registry Operator or
+ICANN-Accredited registrar, except as reasonably necessary to register
+domain names or modify existing registrations.
+
+The compilation, repackaging, dissemination or other use of this Data is
+expressly prohibited without the prior written consent of Tucows.
+
+Tucows reserves the right to terminate your access to the Tucows WHOIS
+database in its sole discretion, including without limitation, for excessive
+querying of the WHOIS database or for failure to otherwise abide by this
+policy.
+
+Tucows reserves the right to modify these terms at any time.
+
+By submitting this query, you agree to abide by these terms.
+
+NOTE: THE WHOIS DATABASE IS A CONTACT DATABASE ONLY.  LACK OF A DOMAIN
+RECORD DOES NOT SIGNIFY DOMAIN AVAILABILITY.</rec>"
+1279,000askexperts.net,net,net,,,,,,,,2006-06-17 11:01:44.848426,2000-02-21,,2007-02-21,3,,,ns1.virtualstoredirectory.com,virtualstoredirectory.com,com,com,ns2.virtualstoredirectory.com,virtualstoredirectory.com,com,com,,,,,,,,,,,,,Internet Promotion Service,,,,,,,,501 West Broadway|San Diego|92101|CA|UNITED STATES,501 West Broadway,,,San Diego,92101,CA,UNITED STATES,S.J. Paul,,webmaster@000askexperts.com,000askexperts.com,com,com,619-615-7474,,501 West Broadway|San Diego|92101|CA|UNITED STATES,501 West Broadway,,,San Diego,92101,CA,UNITED STATES,S.J. Paul,,webmaster@000askexperts.com,000askexperts.com,com,com,619-615-7474,,501 West Broadway|San Diego|92101|CA|UNITED STATES,501 West Broadway,,,San Diego,92101,CA,UNITED STATES,,"<rec>Domain Name.......... 000askexperts.net
+  Creation Date........ 2000-02-21
+  Registration Date.... 2000-02-21
+  Expiry Date.......... 2007-02-21
+  Organisation Name.... Internet Promotion Service
+  Organisation Address. 501 West Broadway
+  Organisation Address. 
+  Organisation Address. San Diego
+  Organisation Address. 92101
+  Organisation Address. CA
+  Organisation Address. UNITED STATES
+
+Admin Name........... S.J. Paul
+  Admin Address........ 501 West Broadway
+  Admin Address........ 
+  Admin Address........ San Diego
+  Admin Address........ 92101
+  Admin Address........ CA
+  Admin Address........ UNITED STATES
+  Admin Email.......... webmaster@000askexperts.com
+  Admin Phone.......... 619-615-7474
+  Admin Fax............ 
+
+Tech Name............ S.J. Paul
+  Tech Address......... 501 West Broadway
+  Tech Address......... 
+  Tech Address......... San Diego
+  Tech Address......... 92101
+  Tech Address......... CA
+  Tech Address......... UNITED STATES
+  Tech Email........... webmaster@000askexperts.com
+  Tech Phone........... 619-615-7474
+  Tech Fax............. 
+  Name Server.......... ns1.virtualstoredirectory.com
+  Name Server.......... ns2.virtualstoredirectory.com</rec>"
+1318,0029.net,net,net,,,,,,,,2006-06-17 11:01:46.143617,,,2009-02-16,3,,,ns1.neoken.co.kr,neoken.co.kr,co.kr,kr,,,,,,,,,,,,,,,,,hanil,,,,,,,,"Incheon, 407050|KR","Incheon, 407050",,,,,,KR,,,,,,,,,,,,,,,,,NEOKEN,,admin@neoken.co.kr,neoken.co.kr,co.kr,kr,822703988782262309889,82262309889,"Seoul, 121816|KR","Seoul, 121816",,,,,,KR,,"<rec>Welcome to Inames Co., Ltd. dba inames.co.kr's WHOIS Service
+
+Domain Name: 0029.NET 
+Domain Status: ACTIVE
+Registrar: Inames Co., Ltd. dba inames.co.kr
+Referral URL: http://www.inames.co.kr
+
+Domain Registration Date....: 2004-02-17 GMT.
+Domain Expiration Date......: 2009-02-17 GMT.
+
+
+Registrant:
+    hanil
+    Gyesan-dong, Gyeyang-gu, 1083-2
+    Incheon,  407050
+    KR
+
+Administrative Contact:
+    NEOKEN    admin@neoken.co.kr
+    Donggyo-dong, Mapo-gu,  113~159
+    Seoul,  121816
+    KR
+    (PHONE) +82-2-703-9887    (FAX) +82-2-6230-9889
+
+Technical, Billing Contact:
+    too top    admin@neoken.co.kr
+    Gangbyeon Hanshin Core Bldg. Mapo-dong, Mapo-gu, #414
+    Seoul,  121703
+    KR
+    (PHONE) +82-2-703-9887    (FAX) +82-2-6230-9889
+
+		
+Domain Name Servers in listed order:  
+    NS1.NEOKEN.CO.KR		220.90.213.144</rec>"
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a2fa04ff/src/test/feature/ExternalSource/sql/errortbl.source
----------------------------------------------------------------------
diff --git a/src/test/feature/ExternalSource/sql/errortbl.source b/src/test/feature/ExternalSource/sql/errortbl.source
new file mode 100644
index 0000000..aeaaff4
--- /dev/null
+++ b/src/test/feature/ExternalSource/sql/errortbl.source
@@ -0,0 +1,93 @@
+-- --------------------------------------
+-- 'gpfdist' protocol
+-- --------------------------------------
+
+CREATE EXTERNAL WEB TABLE gpfdist_status (x text)
+execute E'( python $GPHOME/bin/lib/gppinggpfdist.py @hostname@:7070 2>&1 || echo) '
+on SEGMENT 0
+FORMAT 'text' (delimiter '|');
+
+CREATE EXTERNAL WEB TABLE gpfdist_start (x text)
+execute E'((@gpwhich_gpfdist@ -p 7070 -d @abs_srcdir@/data  </dev/null >/dev/null 2>&1 &); sleep 2; echo "starting...") '
+on SEGMENT 0
+FORMAT 'text' (delimiter '|');
+
+CREATE EXTERNAL WEB TABLE gpfdist_stop (x text)
+execute E'(/bin/pkill gpfdist || killall gpfdist) > /dev/null 2>&1; echo "stopping..."'
+on SEGMENT 0
+FORMAT 'text' (delimiter '|');
+-- start_ignore
+select * from gpfdist_stop;
+select * from gpfdist_status;
+select * from gpfdist_start;
+select * from gpfdist_status;
+-- end_ignore
+
+-- readable external table with error table
+
+CREATE EXTERNAL TABLE EXT_NATION1 ( N_NATIONKEY  INTEGER ,
+                            N_NAME       CHAR(25) ,
+                            N_REGIONKEY  INTEGER ,
+                            N_COMMENT    VARCHAR(152))
+location ('gpfdist://@hostname@:7070/nation_error50.tbl')
+FORMAT 'text' (delimiter '|')
+LOG ERRORS INTO EXT_NATION_ERROR1 SEGMENT REJECT LIMIT 51;
+
+CREATE EXTERNAL TABLE EXT_NATION2 ( N_NATIONKEY  INTEGER ,
+                            N_NAME       CHAR(25) ,
+                            N_REGIONKEY  INTEGER ,
+                            N_COMMENT    VARCHAR(152))
+location ('gpfdist://@hostname@:7070/nation_error50.tbl')
+FORMAT 'text' (delimiter '|')
+LOG ERRORS INTO EXT_NATION_ERROR2 SEGMENT REJECT LIMIT 50;
+
+CREATE EXTERNAL TABLE EXT_NATION3 ( N_NATIONKEY  INTEGER ,
+                            N_NAME       CHAR(25) ,
+                            N_REGIONKEY  INTEGER ,
+                            N_COMMENT    VARCHAR(152))
+location ('gpfdist://@hostname@:7070/nation.tbl')
+FORMAT 'text' (delimiter '|')
+LOG ERRORS INTO EXT_NATION_ERROR3 SEGMENT REJECT LIMIT 50;
+
+-- use existing error table
+CREATE EXTERNAL TABLE EXT_NATION_WITH_EXIST_ERROR_TABLE ( N_NATIONKEY  INTEGER ,
+                            N_NAME       CHAR(25) ,
+                            N_REGIONKEY  INTEGER ,
+                            N_COMMENT    VARCHAR(152))
+location ('gpfdist://@hostname@:7070/nation_error50.tbl')
+FORMAT 'text' (delimiter '|')
+LOG ERRORS INTO EXT_NATION_ERROR1 SEGMENT REJECT LIMIT 51;
+
+select * from EXT_NATION1;
+select count(*) from EXT_NATION_ERROR1; -- should be 50
+select * from EXT_NATION_WITH_EXIST_ERROR_TABLE;
+select count(*) from EXT_NATION_ERROR1; -- should be 100
+select * from EXT_NATION2; -- should fail
+select count(*) from EXT_NATION_ERROR2; -- should be empty
+select * from EXT_NATION3;
+select count(*) from EXT_NATION_ERROR3; -- should be empty
+
+truncate EXT_NATION_ERROR1;
+select * from EXT_NATION1 as x, EXT_NATION3 as y where x.n_nationkey = y.n_nationkey;
+select count(*) from EXT_NATION_ERROR1; -- should be 50
+
+select * from EXT_NATION1 as x, EXT_NATION1 as y where x.n_nationkey = y.n_nationkey; --should fail on self join
+select * from EXT_NATION1 as x, EXT_NATION_WITH_EXIST_ERROR_TABLE as y where x.n_nationkey = y.n_nationkey; --should fail with the same error table
+
+-- should fail on writable external table
+CREATE WRITABLE EXTERNAL TABLE EXT_NATION_WRITABLE ( N_NATIONKEY  INTEGER ,
+                            N_NAME       CHAR(25) ,
+                            N_REGIONKEY  INTEGER ,
+                            N_COMMENT    VARCHAR(152))
+LOCATION ('gpfdist://@hostname@:7070/nation_error50.tbl') 
+FORMAT 'text' (delimiter '|')
+LOG ERRORS INTO EXT_NATION_ERROR_WRITABLE SEGMENT REJECT LIMIT 5;
+
+-- start_ignore
+select * from gpfdist_stop;
+select * from gpfdist_status;
+-- end_ignore
+
+drop external table gpfdist_status;
+drop external table gpfdist_start;
+drop external table gpfdist_stop;
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/a2fa04ff/src/test/feature/ExternalSource/sql/exttab1.sql.source
----------------------------------------------------------------------
diff --git a/src/test/feature/ExternalSource/sql/exttab1.sql.source b/src/test/feature/ExternalSource/sql/exttab1.sql.source
new file mode 100755
index 0000000..7aa1f71
--- /dev/null
+++ b/src/test/feature/ExternalSource/sql/exttab1.sql.source
@@ -0,0 +1,551 @@
+--
+-- external tables 1 - short and simple functional tests. The full set of tests
+-- exists in cdbunit.
+--
+-- start_matchsubs
+--
+-- # replace return code in error message (platform specific)
+--
+-- m/ERROR\:\s+external table .* command ended with .* not found/
+-- s/nosuchcommand\:\s*(command)? not found/nosuchcommand\: NOT FOUND/
+--
+-- m/ERROR\:\s+external table .* command ended with .*No such file.*/
+-- s/nosuchfile\.txt\:\s*No such file (or directory)?/nosuchfile\.txt\: NO SUCH FILE/
+-- m/ERROR\:\s+external table .* command ended with .*No such file.*/i
+-- s/cat\: (cannot open)? nosuchfile\.txt/cat\: nosuchfile\.txt/
+--
+-- # remove line number - redhat
+-- m/ERROR\:\s+external table .* command ended with .*NOT FOUND.*/i
+-- s/\s+line \d+\://
+-- # remove cannot open - solaris
+-- m/ERROR\:\s+external table .* command ended with .*cat\: cannot open.*/i
+-- s/cat\: cannot open (.*)$/cat\: $1\: NO SUCH FILE/
+--
+-- end_matchsubs
+SET gp_foreign_data_access = true;
+set optimizer_disable_missing_stats_collection = on;
+CREATE TABLE REG_REGION (R_REGIONKEY INT, R_NAME CHAR(25), R_COMMENT VARCHAR(152)) DISTRIBUTED BY (R_REGIONKEY);
+
+-- start_ignore
+-- --------------------------------------
+-- check platform
+-- --------------------------------------
+drop external web table if exists check_echo;
+CREATE EXTERNAL WEB TABLE check_echo (x text)
+execute E'(echo gpfdist)'
+on SEGMENT 0
+format 'text';
+select * from check_echo;
+
+
+-- end_ignore
+
+
+-- --------------------------------------
+-- 'gpfdist' protocol
+-- --------------------------------------
+
+CREATE EXTERNAL WEB TABLE gpfdist_status (x text)
+execute E'( python $GPHOME/bin/lib/gppinggpfdist.py @hostname@:7070 2>&1 || echo) '
+on SEGMENT 0
+FORMAT 'text' (delimiter '|');
+
+CREATE EXTERNAL WEB TABLE gpfdist_start (x text)
+execute E'((@gpwhich_gpfdist@ -p 7070 -d @abs_srcdir@/data  </dev/null >/dev/null 2>&1 &); sleep 2; echo "starting...") '
+on SEGMENT 0
+FORMAT 'text' (delimiter '|');
+
+CREATE EXTERNAL WEB TABLE gpfdist_stop (x text)
+execute E'(/bin/pkill gpfdist || killall gpfdist) > /dev/null 2>&1; echo "stopping..."'
+on SEGMENT 0
+FORMAT 'text' (delimiter '|');
+
+-- start_ignore
+select * from gpfdist_stop;
+select * from gpfdist_status;
+select * from gpfdist_start;
+select * from gpfdist_status;
+-- end_ignore
+
+CREATE EXTERNAL TABLE EXT_NATION  ( N_NATIONKEY  INTEGER ,
+                            N_NAME       CHAR(25) ,
+                            N_REGIONKEY  INTEGER ,
+                            N_COMMENT    VARCHAR(152))
+location ('gpfdist://@hostname@:7070/nation.tbl' )
+FORMAT 'text' (delimiter '|');
+CREATE EXTERNAL TABLE EXT_REGION  (LIKE REG_REGION)
+location ('gpfdist://@hostname@:7070/region.tbl' )
+FORMAT 'text' (delimiter '|');
+
+SELECT * FROM EXT_NATION;
+SELECT * FROM EXT_REGION;
+SELECT * FROM EXT_REGION as r, EXT_NATION as n WHERE n.N_REGIONKEY = r.R_REGIONKEY;
+
+-- start_ignore
+select * from gpfdist_status;
+select * from gpfdist_stop;
+select * from gpfdist_status;
+-- end_ignore
+
+-- drop tables
+DROP EXTERNAL TABLE EXT_NATION;
+DROP EXTERNAL TABLE EXT_REGION;
+
+--
+-- gpfdist in csv (mpp-1519, etc)
+--
+CREATE EXTERNAL WEB TABLE gpfdist_csv_start (x text)
+execute E'((@gpwhich_gpfdist@ -p 7070 -d @abs_srcdir@/data  </dev/null >/dev/null 2>&1 &); sleep 2; echo "starting...") '
+on SEGMENT 0
+FORMAT 'text' (delimiter '|');
+-- 
+-- "
+-- (end the double quote so emacs highlighting works correctly)
+--
+-- start_ignore
+select * from gpfdist_status;
+select * from gpfdist_stop;
+select * from gpfdist_status;
+select * from gpfdist_csv_start;
+select * from gpfdist_status;
+-- end_ignore
+
+create external table ext_whois (
+source_lineno			int,
+domain_name			varchar(350),
+subdomain			varchar(150),
+tld				varchar(50),
+ip_address			inet,
+ip_address_int			bigint,
+reverse_dns			varchar(512),
+reverse_domain			varchar(350),
+registrar			varchar(200),
+registrar_referral		varchar(512),
+whois_server			varchar(512),
+harvest_date			timestamp with time zone,
+created_on			timestamp with time zone,
+update_date			timestamp with time zone,
+expire_date			timestamp with time zone,
+rank				int,
+status				char(1),
+update_status			int,
+nameserver1			varchar(512),
+nameserver1_domain_name		varchar(350),
+nameserver1_subdomain		varchar(150),
+nameserver1_tld			varchar(50),
+nameserver2			varchar(512),
+nameserver2_domain_name		varchar(350),
+nameserver2_subdomain		varchar(150),
+nameserver2_tld			varchar(50),
+nameserver3			varchar(512),
+nameserver3_domain_name		varchar(350),
+nameserver3_subdomain		varchar(150),
+nameserver3_tld			varchar(50),
+nameserver4			varchar(512),
+nameserver4_domain_name		varchar(350),
+nameserver4_subdomain		varchar(150),
+nameserver4_tld			varchar(50),
+nameserver5			varchar(512),
+nameserver5_domain_name		varchar(350),
+nameserver5_subdomain		varchar(150),
+nameserver5_tld			varchar(50),
+registrant_name			varchar(200),
+registrant_organization		varchar(200),
+registrant_email		varchar(512),
+registrant_email_domain		varchar(350),
+registrant_email_subdomain	varchar(150),
+registrant_email_tld		varchar(50),
+registrant_phone		varchar(50),
+registrant_fax			varchar(50),
+registrant_addrall		varchar(1024),
+registrant_street1		varchar(200),
+registrant_street2		varchar(200),
+registrant_street3		varchar(200),
+registrant_city			varchar(200),
+registrant_state_province	varchar(100),
+registrant_postal_code		varchar(50),
+registrant_country		varchar(100),
+tech_name			varchar(200),
+tech_organization		varchar(200),
+tech_email			varchar(512),
+tech_email_domain		varchar(350),
+tech_email_subdomain		varchar(150),
+tech_email_tld			varchar(50),
+tech_phone			varchar(50),
+tech_fax			varchar(50),
+tech_addrall			varchar(1024),
+tech_street1			varchar(200),
+tech_street2			varchar(200),
+tech_street3			varchar(200),
+tech_city			varchar(200),
+tech_state_province		varchar(100),
+tech_postal_code		varchar(50),
+tech_country			varchar(100),
+admin_name			varchar(200),
+admin_organization		varchar(200),
+admin_email			varchar(512),
+admin_email_domain		varchar(350),
+admin_email_subdomain		varchar(150),
+admin_email_tld			varchar(50),
+admin_phone			varchar(50),
+admin_fax			varchar(50),
+admin_addrall			varchar(1024),
+admin_street1			varchar(200),
+admin_street2			varchar(200),
+admin_street3			varchar(200),
+admin_city			varchar(200),
+admin_state_province		varchar(100),
+admin_postal_code		varchar(50),
+admin_country			varchar(100),
+rec_path			varchar(512),
+raw_record			text
+)
+location ('gpfdist://@hostname@:7070/whois.csv' )
+format 'csv' ( quote as '"' header);
+-- "
+-- start_ignore
+select count(*) from ext_whois;
+-- end_ignore
+
+-- test FILL EMPTY FIELDS
+create external table ext_fill1(a int, b int, c int)
+location('gpfdist://@hostname@:7070/missing_fields1.data' )
+format 'text' ( delimiter '|' fill missing fields);
+
+create external table ext_fill2(a int, b int, c int)
+location('gpfdist://@hostname@:7070/missing_fields2.data' )
+format 'text' ( delimiter '|' fill missing fields);
+
+-- also test force not null in addition to fill empty fields
+create external table ext_fill3_fnn(a text, b text, c text)
+location('gpfdist://@hostname@:7070/missing_fields1.data' )
+format 'csv' ( delimiter '|' fill missing fields force not null c);
+
+create external table ext_fill4_fnn(a text, b text, c text)
+location('gpfdist://@hostname@:7070/missing_fields1.data' )
+format 'csv' ( delimiter '|' fill missing fields force not null b,c);
+
+select * from ext_fill1 order by a,b,c; -- should pad missing attrs with nulls
+-- start_ignore
+select * from ext_fill2 order by a,b,c; -- should fail due to empty data line
+-- end_ignore
+select * from ext_fill3_fnn where c is null; -- should be empty
+select * from ext_fill3_fnn where b is null; -- one row result
+select * from ext_fill4_fnn where c is null or b is null; -- should be empty
+
+drop external table ext_fill1;
+drop external table ext_fill2;
+drop external table ext_fill3_fnn;
+drop external table ext_fill4_fnn;
+
+-- test NEWLINE
+create external table ext_newline1(N_NATIONKEY INT, N_NAME text, N_REGIONKEY INT, N_COMMENT text)
+location('gpfdist://@hostname@:7070/nation.tbl' )
+format 'text' ( delimiter '|' newline 'lf');
+
+create external table ext_newline2(like ext_newline1)
+location('gpfdist://@hostname@:7070/nation.tbl' )
+format 'text' ( delimiter '|' newline 'cr');
+
+create external table ext_willfail(a int)
+location('gpfdist://@hostname@:7070/nation.tbl' )
+format 'text' ( delimiter '|' newline 'blah'); -- should fail with invalid newline.
+
+select * from ext_newline1; -- should pass. using the correct linefeed. file has 'lf'.
+-- start_ignore
+select * from ext_newline2; -- should fail. using an incorrect linefeed. file has 'lf'.
+-- end_ignore
+
+drop external table ext_newline1;
+drop external table ext_newline2;
+
+-- MPP-6698
+create external table ext_mpp6698(a text)
+location('gpfdist://@hostname@:7070/mpp6698.data' )
+format 'csv' (quote '''');
+
+select * from ext_mpp6698 order by a; -- should ignore the quotes
+drop external table ext_mpp6698;
+
+-- MPP-12839
+create external table ext_mpp12839
+(
+  userguid varchar(36),
+  action_time timestamp without time zone,
+  action_type smallint,
+  object_id integer,
+  general_param character varying(8000),
+  plu_id smallint,
+  page_name character varying(2000),
+  browser integer,
+  platform integer,
+  filtering_data character varying(8000),
+  is_new_user boolean,
+  dummy character varying(1)
+)
+location('gpfdist://@hostname@:7070/mpp12839*.data' )
+format 'text' (delimiter E'\177' null '' newline 'crlf')
+segment reject limit 100 rows;
+
+select * from ext_mpp12839; -- should not reach reject limit
+drop external table ext_mpp12839;
+
+-- --------------------------------------
+-- some negative tests
+-- --------------------------------------
+
+--
+-- test for exec child process stderr showing in error message
+--
+create external web table ext_stderr1(a text) execute 'nosuchcommand' ON 0 format 'text';
+create external web table ext_stderr2(a text) execute 'cat nosuchfile.txt' ON 0 format 'text';
+
+--
+-- bad csv (quote must be a single char)
+--
+create external table bad_whois (
+source_lineno			int,
+domain_name			varchar(350)
+)
+location ('gpfdist://@hostname@:7070/whois.csv' )
+format 'csv' ( header quote as 'ggg');
+select count(*) from bad_whois;
+drop external table bad_whois;
+
+--
+-- try a bad protocol
+--
+create external table badt2 (x text) 
+location ('bad_protocol://@hostname@@abs_srcdir@/data/no/such/place/badt2.tbl' )
+format 'text' (delimiter '|');
+
+--
+-- ALTER
+--
+--create external table ext (a int, x text) 
+--location ('gpfdist://@hostname@:7070@abs_srcdir@/data/no/such/place/badt1.tbl' )
+--format 'text';
+--alter foreign table ext drop column a; -- should fail (wrong object)
+--alter table ext drop column a; -- should pass with warning
+--alter external table ext add column a int;
+--alter external table ext drop column a;
+--alter external table ext add column extnewcol int not null; -- should fail (constraints not allowed)
+--alter external table ext add column extnewcol int;
+--alter external table ext alter column extnewcol set default 1; -- should fail (unsupported alter type)
+
+--
+-- TRUNCATE/UPDATE/DELETE/INSERT (INTO RET)
+--
+--truncate ext;
+--delete from ext;
+--update ext set x='1' where x='2';
+--insert into ext(x) values('a');
+--drop table ext; -- should fail (wrong object)
+--drop foreign table ext; -- should fail (wrong object)
+--drop external table ext;
+
+----------------------------------------------------------------------
+-- CUSTOM PROTOCOLS
+----------------------------------------------------------------------
+-- DROP EXTERNAL TABLE IF EXISTS ext_w;
+-- DROP EXTERNAL TABLE IF EXISTS ext_r;
+-- DROP ROLE IF EXISTS extprotu;
+-- CREATE OR REPLACE FUNCTION write_to_file() RETURNS integer as '$libdir/gpextprotocol.so', 'demoprot_export' LANGUAGE C STABLE;
+-- CREATE OR REPLACE FUNCTION read_from_file() RETURNS integer as '$libdir/gpextprotocol.so', 'demoprot_import' LANGUAGE C STABLE;
+
+-- DROP PROTOCOL IF EXISTS demoprot;
+-- CREATE TRUSTED PROTOCOL demoprot (readfunc = 'nosuchfunc'); -- should fail
+-- CREATE TRUSTED PROTOCOL demoprot (readfunc = 'boolin'); -- should fail
+-- CREATE TRUSTED PROTOCOL demoprot (readfunc = 'read_from_file', writefunc = 'write_to_file'); -- should succeed
+-- CREATE PROTOCOL demoprot_untrusted (readfunc = 'read_from_file', writefunc = 'write_to_file'); -- should succeed
+
+-- CREATE ROLE extprotu NOSUPERUSER;
+-- SET SESSION AUTHORIZATION extprotu;
+
+-- CREATE WRITABLE EXTERNAL TABLE ext_w(a int) location('demoprot://demoprotfile.txt') format 'text'; -- should fail
+-- CREATE READABLE EXTERNAL TABLE ext_r(a int) location('demoprot://demoprotfile.txt') format 'text'; -- should fail
+
+-- RESET SESSION AUTHORIZATION;
+-- ALTER PROTOCOL demoprot_untrusted OWNER TO extprotu; -- should fail. protocol is not trusted
+-- GRANT SELECT ON PROTOCOL demoprot_untrusted TO extprotu; -- should fail. protocol is not trusted
+-- GRANT SELECT ON PROTOCOL demoprot TO extprotu;
+-- GRANT INSERT ON PROTOCOL demoprot TO extprotu;
+-- SET SESSION AUTHORIZATION extprotu;
+
+-- CREATE WRITABLE EXTERNAL TABLE ext_w(a int) location('demoprot://demoprotfile.txt') format 'text'; -- should succeed
+-- CREATE READABLE EXTERNAL TABLE ext_r(a int) location('demoprot://demoprotfile.txt') format 'text'; -- should succeed
+-- DROP EXTERNAL TABLE IF EXISTS ext_w;
+-- DROP EXTERNAL TABLE IF EXISTS ext_r;
+
+-- RESET SESSION AUTHORIZATION;
+-- REVOKE INSERT ON PROTOCOL demoprot FROM extprotu;
+-- SET SESSION AUTHORIZATION extprotu;
+
+-- CREATE WRITABLE EXTERNAL TABLE ext_w(a int) location('demoprot://demoprotfile.txt') format 'text'; -- should fail
+-- CREATE READABLE EXTERNAL TABLE ext_r(a int) location('demoprot://demoprotfile.txt') format 'text'; -- should succeed
+-- DROP EXTERNAL TABLE ext_r;
+-- RESET SESSION AUTHORIZATION;
+-- REVOKE ALL PRIVILEGES ON PROTOCOL demoprot FROM extprotu;
+-- DROP ROLE IF EXISTS extprotu;
+
+--
+-- WET tests
+--
+
+--
+-- CREATE (including LIKE, DISTRIBUTED BY)
+--
+-- positive
+create writable external table wet_pos1(a text, b text) location('gpfdist://@hostname@:7070/wet.out') format 'text';
+create writable external table wet_pos2(a text, b text) location('gpfdist://@hostname@:7070/wet.out') format 'text' distributed by(b);
+create writable external table wet_pos3(like wet_pos2) location('gpfdist://@hostname@:7070/wet.out') format 'text' distributed by(a,b);
+create writable external table wet_region(like reg_region) location('gpfdist://@hostname@:7070/wet_region.out') format 'text';
+create readable external table ret_region(like wet_region) location('gpfdist://@hostname@:7070/wet_region.out') format 'text';
+
+-- negative
+create writable external table wet_neg1(a text, b text) location('gpfdist://@hostname@:7070@abs_srcdir@/badt1.tbl') format 'text';
+create writable external table wet_neg1(a text, b text) location('gpfdist://@hostname@:7070/wet.out', 'gpfdist://@hostname@:7070/wet.out') format 'text';
+create writable external web table wet_pos5(a text, b text) execute 'some command' on segment 0 format 'text';
+
+--
+-- SELECT from WET (negative)
+--
+select * from wet_pos1;
+
+--
+-- WET: export some data with INSERT SELECT, INSERT and COPY. 
+--
+-- COPY reg_region FROM STDIN DELIMITER '|';
+-- 0|AFRICA|lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to 
+-- 1|AMERICA|hs use ironic, even requests. s
+-- \.
+INSERT INTO wet_region SELECT * from reg_region;
+
+-- COPY wet_region FROM STDIN DELIMITER '|';
+-- 2|ASIA|ges. thinly even pinto beans ca
+-- 3|EUROPE|ly final courts cajole furiously final excuse
+-- \.
+-- INSERT INTO wet_region VALUES(4,'MIDDLE EAST','uickly special');
+
+--
+-- Now use RET to see if data was exported correctly.
+-- NOTE: since we don't bother cleaning up the exported file, it may grow bigger
+-- in between runs, so we don't check for count(*), and instead check for distinct.
+--
+-- SELECT DISTINCT(R_NAME) FROM ret_region ORDER BY R_NAME;
+
+-- start_ignore
+select * from gpfdist_status;
+select * from gpfdist_stop;
+select * from gpfdist_status;
+-- end_ignore
+
+--
+-- get an error for missing gpfdist
+--
+select count(*) from ext_whois;
+
+--
+-- test CREATE EXTERNAL TABLE privileges
+--
+-- show gp_external_grant_privileges; -- MUST BE OFF for the following tests to work.
+-- CREATE ROLE exttab1_su SUPERUSER; -- SU with no privs in pg_auth
+-- CREATE ROLE exttab1_u1 CREATEEXTTABLE(protocol='gpfdist', type='readable'); 
+-- CREATE ROLE exttab1_u2 CREATEEXTTABLE(protocol='gpfdist', type='writable'); 
+-- CREATE ROLE exttab1_u3 CREATEEXTTABLE(protocol='gpfdist') NOCREATEEXTTABLE(protocol='gpfdist', type='readable'); -- fail due to conflict 
+
+-- SET SESSION AUTHORIZATION exttab1_su;
+-- create readable external table auth_ext_test1(a int) location ('gpfdist://host:8000/file') format 'text';
+-- SET SESSION AUTHORIZATION exttab1_u1;
+-- create readable external table auth_ext_test2(a int) location ('gpfdist://host:8000/file') format 'text';
+-- create writable external table auth_ext_test3(a int) location ('gpfdist://host:8000/file') format 'text'; -- fail
+-- SET SESSION AUTHORIZATION exttab1_u2;
+-- create writable external table auth_ext_test3(a int) location ('gpfdist://host:8000/file') format 'text';
+-- RESET SESSION AUTHORIZATION;
+-- ALTER ROLE exttab1_u2 NOCREATEEXTTABLE(protocol='gpfdist', type='writable');
+-- SET SESSION AUTHORIZATION exttab1_u2;
+-- create writable external table auth_ext_test4(a int) location ('gpfdist://host:8000/file') format 'text'; -- fail
+-- RESET SESSION AUTHORIZATION;
+
+-- drop external table auth_ext_test1;
+-- drop external table auth_ext_test2;
+-- drop external table auth_ext_test3;
+
+-- DROP ROLE exttab1_su;
+-- DROP ROLE exttab1_u1;
+-- DROP ROLE exttab1_u2;
+
+drop external table ext_whois;
+drop external table gpfdist_csv_start;
+drop external table check_echo;
+drop external table wet_pos1;
+drop external table wet_pos2;
+drop external table wet_pos3;
+drop external table wet_region;
+drop external table ret_region;
+drop table reg_region;
+
+-- Tests for MPP-2513: dropping an external table must result in the deletion
+-- of the relation pg_exttable row. This was done when using drop external
+-- table but not drop schema cascade;
+
+create schema exttabletest;
+CREATE EXTERNAL TABLE exttabletest.EXT_NATION  ( N_NATIONKEY  INTEGER ,
+                            N_NAME       CHAR(25) ,
+                            N_REGIONKEY  INTEGER ,
+                            N_COMMENT    VARCHAR(152))
+location ('gpfdist://host:8000/nation.tbl' )
+FORMAT 'text' (delimiter '|');
+-- Don't just return the row, as we'll get skew from OID differences between
+-- runs.
+select count(*) from pg_catalog.pg_exttable where reloid in (select r.oid from pg_class r where r.relname in ('ext_nation', 'ext_whois', 'gpfdist_status'));
+drop schema exttabletest cascade;
+select count(*) from pg_catalog.pg_exttable where reloid in (select r.oid from pg_class r where r.relname in ('ext_nation', 'ext_whois', 'gpfdist_status'));
+SET gp_foreign_data_access = false;
+
+CREATE USER nonsuperproto;
+GRANT SELECT ON PROTOCOL pxf TO nonsuperproto;
+GRANT INSERT ON PROTOCOL pxf TO nonsuperproto;
+REVOKE SELECT ON PROTOCOL pxf FROM nonsuperproto;
+REVOKE INSERT ON PROTOCOL pxf FROM nonsuperproto;
+DROP USER nonsuperproto;
+
+-- start_ignore
+select * from gpfdist_status;
+select * from gpfdist_start;
+select * from gpfdist_status;
+-- end_ignore
+
+-- Tests for MPP17980: generating artificial CTIDs for external table scans
+-- This is necessary because the planner currently generates plans that include
+-- the CTID attribute for external tables. 
+
+CREATE EXTERNAL TABLE ext_mpp17980 ( id int , id1 int , id2 int)
+LOCATION ('gpfdist://@hostname@:7070/mpp17980.data')
+FORMAT 'CSV' ( DELIMITER ',' NULL ' ');
+
+CREATE TABLE mpp17980 (id int, date date, amt decimal(10,2))
+DISTRIBUTED randomly PARTITION BY RANGE (date)
+( START (date '2008-01-01') INCLUSIVE  END (date '2009-01-01') EXCLUSIVE 
+EVERY (INTERVAL '1 month') );
+
+INSERT INTO mpp17980 VALUES ( 1,'2008-02-20',122.11);
+
+SELECT COUNT(*) FROM ext_mpp17980 WHERE id IN ( 1 ) ;  -- This returns 18 tuples
+
+SELECT COUNT(*) FROM ext_mpp17980 WHERE id IN ( SELECT id FROM mpp17980 ) ; -- This should return 18 tuples but returns only 1
+
+SELECT ctid, * FROM ext_mpp17980;
+
+DROP EXTERNAL TABLE ext_mpp17980;
+DROP TABLE mpp17980;
+
+-- start_ignore
+select * from gpfdist_status;
+select * from gpfdist_stop;
+select * from gpfdist_status;
+-- end_ignore
+
+drop external table gpfdist_status;
+drop external table gpfdist_start;
+drop external table gpfdist_stop;


Mime
View raw message