You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by hu...@apache.org on 2016/07/04 02:35:55 UTC
[2/3] incubator-hawq git commit: HAWQ-805. Add feature test for
exttab1 with new framework
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;