Warnings:
Warning	1105	No file name. Table will use t1.xml
#
# Testing zipped XML tables
#
CREATE TABLE t1 (
ISBN CHAR(13) NOT NULL XPATH='@',
LANG CHAR(2) NOT NULL XPATH='@',
SUBJECT CHAR(12) NOT NULL XPATH='@',
AUTHOR_FIRSTNAME CHAR(15) NOT NULL XPATH='AUTHOR/FIRSTNAME',
AUTHOR_LASTNAME CHAR(8) NOT NULL XPATH='AUTHOR/LASTNAME',
TRANSLATOR_PREFIX CHAR(24) DEFAULT NULL XPATH='TRANSLATOR/@PREFIX',
TRANSLATOR_FIRSTNAME CHAR(6) DEFAULT NULL XPATH='TRANSLATOR/FIRSTNAME',
TRANSLATOR_LASTNAME CHAR(6) DEFAULT NULL XPATH='TRANSLATOR/LASTNAME',
TITLE CHAR(30) NOT NULL,
PUBLISHER_NAME CHAR(15) NOT NULL XPATH='PUBLISHER/NAME',
PUBLISHER_PLACE CHAR(5) NOT NULL XPATH='PUBLISHER/PLACE',
DATEPUB CHAR(4) NOT NULL
) ENGINE=CONNECT TABLE_TYPE=XML FILE_NAME='xsample2.zip' ZIPPED=YES
OPTION_LIST='depth=0,entry=xsample2.xml,load=xsample2.xml,rownode=BOOK,xmlsup=libxml2,expand=1,mulnode=AUTHOR';
SELECT * FROM t1;
ISBN	9782212090819
LANG	fr
SUBJECT	applications
AUTHOR_FIRSTNAME	Jean-Christophe
AUTHOR_LASTNAME	Bernadac
TRANSLATOR_PREFIX	NULL
TRANSLATOR_FIRSTNAME	NULL
TRANSLATOR_LASTNAME	NULL
TITLE	Construire une application XML
PUBLISHER_NAME	Eyrolles
PUBLISHER_PLACE	Paris
DATEPUB	1999
ISBN	9782212090819
LANG	fr
SUBJECT	applications
AUTHOR_FIRSTNAME	François
AUTHOR_LASTNAME	Knab
TRANSLATOR_PREFIX	NULL
TRANSLATOR_FIRSTNAME	NULL
TRANSLATOR_LASTNAME	NULL
TITLE	Construire une application XML
PUBLISHER_NAME	Eyrolles
PUBLISHER_PLACE	Paris
DATEPUB	1999
ISBN	9782840825685
LANG	fr
SUBJECT	applications
AUTHOR_FIRSTNAME	William J.
AUTHOR_LASTNAME	Pardi
TRANSLATOR_PREFIX	adapté de l'anglais par
TRANSLATOR_FIRSTNAME	James
TRANSLATOR_LASTNAME	Guerin
TITLE	XML en Action
PUBLISHER_NAME	Microsoft Press
PUBLISHER_PLACE	Paris
DATEPUB	1999
ISBN	9782212090529
LANG	fr
SUBJECT	général
AUTHOR_FIRSTNAME	Alain
AUTHOR_LASTNAME	Michard
TRANSLATOR_PREFIX	NULL
TRANSLATOR_FIRSTNAME	NULL
TRANSLATOR_LASTNAME	NULL
TITLE	XML, Langage et Applications
PUBLISHER_NAME	Eyrolles
PUBLISHER_PLACE	Paris
DATEPUB	2003
CREATE TABLE t2
ENGINE=CONNECT TABLE_TYPE=XML FILE_NAME='xsample2.zip' ZIPPED=YES
OPTION_LIST='depth=0,xmlsup=libxml2';
SELECT * FROM t2;
ISBN	9782212090819
LANG	fr
SUBJECT	applications
AUTHOR	Jean-Christophe Bernadac
TRANSLATOR	NULL
TITLE	Construire une application XML
PUBLISHER	Eyrolles Paris
DATEPUB	1999
ISBN	9782840825685
LANG	fr
SUBJECT	applications
AUTHOR	William J. Pardi
TRANSLATOR	James Guerin
TITLE	XML en Action
PUBLISHER	Microsoft Press Paris
DATEPUB	1999
ISBN	9782212090529
LANG	fr
SUBJECT	général
AUTHOR	Alain Michard
TRANSLATOR	NULL
TITLE	XML, Langage et Applications
PUBLISHER	Eyrolles Paris
DATEPUB	2003
DROP TABLE t1,t2;