2013-02-12 09:24:02 : DEBUG: /*DIAGNOSE_XQUERY*/
2013-02-12 09:24:02 : DEBUG: 1.0-build.170
2013-02-12 09:24:02 : DEBUG: 2.0.0-build.170
2013-02-12 09:24:02 : DEBUG: Query #2
2013-02-12 09:24:02 : DEBUG: <PARSEINFO language="datahubsql" version="32" parser="5.198" flags="0x07800000" source_encoding="8-bit">
<CHUNK status="ok" type="Select" line="1" col="21" size="416" offset="20">
<SELECT>
<EXPR cat="query">
<TOKEN value="SELECT" line="1" col="21" size="6" offset="20" cat="keyword" />
<SELECT_LIST>
<SELECT_ITEM>
<QNAME value="ADDRESS.ADDRESS_ID_1">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="1" col="29" size="7" offset="28" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="1" col="36" size="1" offset="35" cat="punctuation" />
<IDENTIFIER value="ADDRESS_ID_1">
<TOKEN value="ADDRESS_ID_1" line="1" col="37" size="12" offset="36" cat="identifier" />
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="2" col="2" size="1" offset="51" cat="punctuation" />
<SELECT_ITEM>
<QNAME value="ADDRESS.ADDRESS">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="2" col="4" size="7" offset="53" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="2" col="11" size="1" offset="60" cat="punctuation" />
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="2" col="12" size="7" offset="61" cat="identifier" />
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="3" col="2" size="1" offset="71" cat="punctuation" />
<SELECT_ITEM>
<QNAME value="ADDRESS.ADDRESS_LINE_2">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="3" col="4" size="7" offset="73" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="3" col="11" size="1" offset="80" cat="punctuation" />
<IDENTIFIER value="ADDRESS_LINE_2">
<TOKEN value="ADDRESS_LINE_2" line="3" col="12" size="14" offset="81" cat="identifier" />
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="4" col="2" size="1" offset="98" cat="punctuation" />
<SELECT_ITEM>
<QNAME value="ADDRESS.CITY">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="4" col="4" size="7" offset="100" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="4" col="11" size="1" offset="107" cat="punctuation" />
<IDENTIFIER value="CITY">
<TOKEN value="CITY" line="4" col="12" size="4" offset="108" cat="identifier" />
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="5" col="2" size="1" offset="115" cat="punctuation" />
<SELECT_ITEM>
<QNAME value="ADDRESS.STATE">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="5" col="4" size="7" offset="117" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="5" col="11" size="1" offset="124" cat="punctuation" />
<IDENTIFIER value="STATE">
<TOKEN value="STATE" line="5" col="12" size="5" offset="125" cat="identifier" />
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="6" col="2" size="1" offset="133" cat="punctuation" />
<SELECT_ITEM>
<QNAME value="ADDRESS.COUNTRY">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="6" col="4" size="7" offset="135" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="6" col="11" size="1" offset="142" cat="punctuation" />
<IDENTIFIER value="COUNTRY">
<TOKEN value="COUNTRY" line="6" col="12" size="7" offset="143" cat="identifier" />
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="7" col="2" size="1" offset="153" cat="punctuation" />
<SELECT_ITEM>
<QNAME value="ADDRESS.POSTAL_CODE">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="7" col="4" size="7" offset="155" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="7" col="11" size="1" offset="162" cat="punctuation" />
<IDENTIFIER value="POSTAL_CODE">
<TOKEN value="POSTAL_CODE" line="7" col="12" size="11" offset="163" cat="identifier" />
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="8" col="2" size="1" offset="177" cat="punctuation" />
<SELECT_ITEM>
<QNAME value="ADDRESS.REGION_ID">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="8" col="4" size="7" offset="179" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="8" col="11" size="1" offset="186" cat="punctuation" />
<IDENTIFIER value="REGION_ID">
<TOKEN value="REGION_ID" line="8" col="12" size="9" offset="187" cat="identifier" />
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="9" col="2" size="1" offset="199" cat="punctuation" />
<SELECT_ITEM>
<QNAME value="REGION.REGION_NAME">
<IDENTIFIER value="REGION">
<TOKEN value="REGION" line="9" col="4" size="6" offset="201" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="9" col="10" size="1" offset="207" cat="punctuation" />
<IDENTIFIER value="REGION_NAME">
<TOKEN value="REGION_NAME" line="9" col="11" size="11" offset="208" cat="identifier" />
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
</SELECT_LIST>
<TOKEN value="FROM" line="10" col="1" size="4" offset="221" cat="keyword" />
<TABLE_REF_LIST>
<TABLE_REF>
<JOIN type="inner">
<TABLE_REF>
<QNAME value="_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn.554s73bnoe2bv8h3bm27q03if9do9m0o">
<IDENTIFIER value="_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn">
<TOKEN value="_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn" line="11" col="2" size="33" offset="229" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="11" col="35" size="1" offset="262" cat="punctuation" />
<IDENTIFIER value="554s73bnoe2bv8h3bm27q03if9do9m0o">
<TOKEN value="554s73bnoe2bv8h3bm27q03if9do9m0o" line="11" col="36" size="32" offset="263" cat="identifier" />
</IDENTIFIER>
</QNAME>
<ALIAS>
<QNAME value="REGION">
<IDENTIFIER value="REGION">
<TOKEN value="REGION" line="11" col="69" size="6" offset="296" cat="identifier" />
</IDENTIFIER>
</QNAME>
</ALIAS>
</TABLE_REF>
<TOKEN value="INNER" line="12" col="2" size="5" offset="305" cat="keyword" />
<TOKEN value="JOIN" line="12" col="8" size="4" offset="311" cat="keyword" />
<TABLE_REF>
<QNAME value="_u7bi00qmvip4mv0mlke4njsv4l6n5u8s.3tdklhb18jjej254fb5gklasmporiono">
<IDENTIFIER value="_u7bi00qmvip4mv0mlke4njsv4l6n5u8s">
<TOKEN value="_u7bi00qmvip4mv0mlke4njsv4l6n5u8s" line="13" col="2" size="33" offset="318" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="13" col="35" size="1" offset="351" cat="punctuation" />
<IDENTIFIER value="3tdklhb18jjej254fb5gklasmporiono">
<TOKEN value="3tdklhb18jjej254fb5gklasmporiono" line="13" col="36" size="32" offset="352" cat="identifier" />
</IDENTIFIER>
</QNAME>
<ALIAS>
<QNAME value="ADDRESS">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="13" col="69" size="7" offset="385" cat="identifier" />
</IDENTIFIER>
</QNAME>
</ALIAS>
</TABLE_REF>
<JOIN_ON>
<TOKEN value="ON" line="14" col="2" size="2" offset="395" cat="keyword" />
<TOKEN value="(" line="14" col="5" size="1" offset="398" cat="punctuation" />
<EXPR cat="eq">
<QNAME value="REGION.REGION_ID">
<IDENTIFIER value="REGION">
<TOKEN value="REGION" line="14" col="6" size="6" offset="399" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="14" col="12" size="1" offset="405" cat="punctuation" />
<IDENTIFIER value="REGION_ID">
<TOKEN value="REGION_ID" line="14" col="13" size="9" offset="406" cat="identifier" />
</IDENTIFIER>
</QNAME>
<TOKEN value="=" line="14" col="23" size="1" offset="416" cat="punctuation" />
<QNAME value="ADDRESS.REGION_ID">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="14" col="25" size="7" offset="418" cat="identifier" />
</IDENTIFIER>
<TOKEN value="." line="14" col="32" size="1" offset="425" cat="punctuation" />
<IDENTIFIER value="REGION_ID">
<TOKEN value="REGION_ID" line="14" col="33" size="9" offset="426" cat="identifier" />
</IDENTIFIER>
</QNAME>
</EXPR>
<TOKEN value=")" line="14" col="42" size="1" offset="435" cat="punctuation" />
</JOIN_ON>
</JOIN>
</TABLE_REF>
</TABLE_REF_LIST>
</EXPR>
</SELECT>
</CHUNK>
</PARSEINFO>

2013-02-12 09:24:02 : DEBUG: Query Type: Select
2013-02-12 09:24:02 : DEBUG: Operation: 2
2013-02-12 09:24:02 : DEBUG: Query: SELECT ADDRESS.ADDRESS_ID_1,
       ADDRESS.ADDRESS,
       ADDRESS.ADDRESS_LINE_2,
       ADDRESS.CITY,
       ADDRESS.STATE,
       ADDRESS.COUNTRY,
       ADDRESS.POSTAL_CODE,
       ADDRESS.REGION_ID,
       REGION.REGION_NAME
  FROM    _rpcuo3lehnopqnkc8gr9pjjip4b4s3vn.554s73bnoe2bv8h3bm27q03if9do9m0o REGION
       INNER JOIN
          _u7bi00qmvip4mv0mlke4njsv4l6n5u8s.3tdklhb18jjej254fb5gklasmporiono ADDRESS
       ON (REGION.REGION_ID = ADDRESS.REGION_ID)

2013-02-12 09:24:02 : DEBUG: <EXPR cat="query">
<TOKEN value="SELECT" line="1" col="21" size="6" offset="20" cat="keyword"/>
<SELECT_LIST>
<SELECT_ITEM>
<QNAME value="ADDRESS.ADDRESS_ID_1">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="1" col="29" size="7" offset="28" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="1" col="36" size="1" offset="35" cat="punctuation"/>
<IDENTIFIER value="ADDRESS_ID_1">
<TOKEN value="ADDRESS_ID_1" line="1" col="37" size="12" offset="36" cat="identifier"/>
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="2" col="2" size="1" offset="51" cat="punctuation"/>
<SELECT_ITEM>
<QNAME value="ADDRESS.ADDRESS">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="2" col="4" size="7" offset="53" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="2" col="11" size="1" offset="60" cat="punctuation"/>
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="2" col="12" size="7" offset="61" cat="identifier"/>
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="3" col="2" size="1" offset="71" cat="punctuation"/>
<SELECT_ITEM>
<QNAME value="ADDRESS.ADDRESS_LINE_2">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="3" col="4" size="7" offset="73" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="3" col="11" size="1" offset="80" cat="punctuation"/>
<IDENTIFIER value="ADDRESS_LINE_2">
<TOKEN value="ADDRESS_LINE_2" line="3" col="12" size="14" offset="81" cat="identifier"/>
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="4" col="2" size="1" offset="98" cat="punctuation"/>
<SELECT_ITEM>
<QNAME value="ADDRESS.CITY">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="4" col="4" size="7" offset="100" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="4" col="11" size="1" offset="107" cat="punctuation"/>
<IDENTIFIER value="CITY">
<TOKEN value="CITY" line="4" col="12" size="4" offset="108" cat="identifier"/>
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="5" col="2" size="1" offset="115" cat="punctuation"/>
<SELECT_ITEM>
<QNAME value="ADDRESS.STATE">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="5" col="4" size="7" offset="117" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="5" col="11" size="1" offset="124" cat="punctuation"/>
<IDENTIFIER value="STATE">
<TOKEN value="STATE" line="5" col="12" size="5" offset="125" cat="identifier"/>
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="6" col="2" size="1" offset="133" cat="punctuation"/>
<SELECT_ITEM>
<QNAME value="ADDRESS.COUNTRY">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="6" col="4" size="7" offset="135" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="6" col="11" size="1" offset="142" cat="punctuation"/>
<IDENTIFIER value="COUNTRY">
<TOKEN value="COUNTRY" line="6" col="12" size="7" offset="143" cat="identifier"/>
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="7" col="2" size="1" offset="153" cat="punctuation"/>
<SELECT_ITEM>
<QNAME value="ADDRESS.POSTAL_CODE">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="7" col="4" size="7" offset="155" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="7" col="11" size="1" offset="162" cat="punctuation"/>
<IDENTIFIER value="POSTAL_CODE">
<TOKEN value="POSTAL_CODE" line="7" col="12" size="11" offset="163" cat="identifier"/>
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="8" col="2" size="1" offset="177" cat="punctuation"/>
<SELECT_ITEM>
<QNAME value="ADDRESS.REGION_ID">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="8" col="4" size="7" offset="179" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="8" col="11" size="1" offset="186" cat="punctuation"/>
<IDENTIFIER value="REGION_ID">
<TOKEN value="REGION_ID" line="8" col="12" size="9" offset="187" cat="identifier"/>
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
<TOKEN value="," line="9" col="2" size="1" offset="199" cat="punctuation"/>
<SELECT_ITEM>
<QNAME value="REGION.REGION_NAME">
<IDENTIFIER value="REGION">
<TOKEN value="REGION" line="9" col="4" size="6" offset="201" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="9" col="10" size="1" offset="207" cat="punctuation"/>
<IDENTIFIER value="REGION_NAME">
<TOKEN value="REGION_NAME" line="9" col="11" size="11" offset="208" cat="identifier"/>
</IDENTIFIER>
</QNAME>
</SELECT_ITEM>
</SELECT_LIST>
<TOKEN value="FROM" line="10" col="1" size="4" offset="221" cat="keyword"/>
<TABLE_REF_LIST>
<TABLE_REF>
<JOIN type="inner">
<TABLE_REF>
<QNAME value="_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn.554s73bnoe2bv8h3bm27q03if9do9m0o">
<IDENTIFIER value="_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn">
<TOKEN value="_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn" line="11" col="2" size="33" offset="229" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="11" col="35" size="1" offset="262" cat="punctuation"/>
<IDENTIFIER value="554s73bnoe2bv8h3bm27q03if9do9m0o">
<TOKEN value="554s73bnoe2bv8h3bm27q03if9do9m0o" line="11" col="36" size="32" offset="263" cat="identifier"/>
</IDENTIFIER>
</QNAME>
<ALIAS>
<QNAME value="REGION">
<IDENTIFIER value="REGION">
<TOKEN value="REGION" line="11" col="69" size="6" offset="296" cat="identifier"/>
</IDENTIFIER>
</QNAME>
</ALIAS>
</TABLE_REF>
<TOKEN value="INNER" line="12" col="2" size="5" offset="305" cat="keyword"/>
<TOKEN value="JOIN" line="12" col="8" size="4" offset="311" cat="keyword"/>
<TABLE_REF>
<QNAME value="_u7bi00qmvip4mv0mlke4njsv4l6n5u8s.3tdklhb18jjej254fb5gklasmporiono">
<IDENTIFIER value="_u7bi00qmvip4mv0mlke4njsv4l6n5u8s">
<TOKEN value="_u7bi00qmvip4mv0mlke4njsv4l6n5u8s" line="13" col="2" size="33" offset="318" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="13" col="35" size="1" offset="351" cat="punctuation"/>
<IDENTIFIER value="3tdklhb18jjej254fb5gklasmporiono">
<TOKEN value="3tdklhb18jjej254fb5gklasmporiono" line="13" col="36" size="32" offset="352" cat="identifier"/>
</IDENTIFIER>
</QNAME>
<ALIAS>
<QNAME value="ADDRESS">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="13" col="69" size="7" offset="385" cat="identifier"/>
</IDENTIFIER>
</QNAME>
</ALIAS>
</TABLE_REF>
<JOIN_ON>
<TOKEN value="ON" line="14" col="2" size="2" offset="395" cat="keyword"/>
<TOKEN value="(" line="14" col="5" size="1" offset="398" cat="punctuation"/>
<EXPR cat="eq">
<QNAME value="REGION.REGION_ID">
<IDENTIFIER value="REGION">
<TOKEN value="REGION" line="14" col="6" size="6" offset="399" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="14" col="12" size="1" offset="405" cat="punctuation"/>
<IDENTIFIER value="REGION_ID">
<TOKEN value="REGION_ID" line="14" col="13" size="9" offset="406" cat="identifier"/>
</IDENTIFIER>
</QNAME>
<TOKEN value="=" line="14" col="23" size="1" offset="416" cat="punctuation"/>
<QNAME value="ADDRESS.REGION_ID">
<IDENTIFIER value="ADDRESS">
<TOKEN value="ADDRESS" line="14" col="25" size="7" offset="418" cat="identifier"/>
</IDENTIFIER>
<TOKEN value="." line="14" col="32" size="1" offset="425" cat="punctuation"/>
<IDENTIFIER value="REGION_ID">
<TOKEN value="REGION_ID" line="14" col="33" size="9" offset="426" cat="identifier"/>
</IDENTIFIER>
</QNAME>
</EXPR>
<TOKEN value=")" line="14" col="42" size="1" offset="435" cat="punctuation"/>
</JOIN_ON>
</JOIN>
</TABLE_REF>
</TABLE_REF_LIST>
</EXPR>
2013-02-12 09:24:02 : DEBUG: append query 1:     SELECT
        d.`database_name`,
        d.`provider_name`,
        d.`hub_configuration` as database_configuration,
        o.`subtable_name`,
        o.`table_name`,
        o.`remote_data_object` as remote_name,
        o.`hub_configuration` as table_configuration,
        o.`query_text`,
        o.`object_type`
    FROM `hub_information_schema`.`hub_get_databases` d
    JOIN
    (
        SELECT
            t.`database_name` as database_name,
            t.`subtable_name` as subtable_name,
            t.`table_name` as table_name,
            t.`remote_data_object`,
            t.`hub_configuration`,
            null as query_text,
            'TABLE' as object_type
        FROM `hub_information_schema`.`hub_get_tables` t
       
        UNION
       
        SELECT
            v.`database_name` as database_name,
            v.`view_name` as subtable_name,
            v.`view_name` as table_name,
            null,
            null,
            v.`query_text`,
            'VIEW'
        FROM `hub_information_schema`.`hub_get_views` v
        
        UNION
       
        SELECT
            s.`database_name` as database_name,
            s.`snapshot_name` as subtable_name,
            s.`snapshot_name` as table_name,
            null,
            null,
            null,
            'SNAPSHOT'
        FROM `hub_information_schema`.`hub_get_snapshots` s
    ) o
    ON (d.`database_name` = o.`database_name`)
    WHERE (o.`database_name`, o.`subtable_name`) IN (('_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn', '554s73bnoe2bv8h3bm27q03if9do9m0o'), ('_u7bi00qmvip4mv0mlke4njsv4l6n5u8s', '3tdklhb18jjej254fb5gklasmporiono'))

2013-02-12 09:24:02 : read_resultset (1, 0): SELECT
        d.`database_name`,
        d.`provider_name`,
        d.`hub_configuration` as database_configuration,
        o.`subtable_name`,
        o.`table_name`,
        o.`remote_data_object` as remote_name,
        o.`hub_configuration` as table_configuration,
        o.`query_text`,
        o.`object_type`
    FROM `hub_information_schema`.`hub_get_databases` d
    JOIN
    (
        SELECT
            t.`database_name` as database_name,
            t.`subtable_name` as subtable_name,
            t.`table_name` as table_name,
            t.`remote_data_object`,
            t.`hub_configuration`,
            null as query_text,
            'TABLE' as object_type
        FROM `hub_information_schema`.`hub_get_tables` t
       
        UNION
       
        SELECT
            v.`database_name` as database_name,
            v.`view_name` as subtable_name,
            v.`view_name` as table_name,
            null,
            null,
            v.`query_text`,
            'VIEW'
        FROM `hub_information_schema`.`hub_get_views` v
        
        UNION
       
        SELECT
            s.`database_name` as database_name,
            s.`snapshot_name` as subtable_name,
            s.`snapshot_name` as table_name,
            null,
            null,
            null,
            'SNAPSHOT'
        FROM `hub_information_schema`.`hub_get_snapshots` s
    ) o
    ON (d.`database_name` = o.`database_name`)
    WHERE (o.`database_name`, o.`subtable_name`) IN (('_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn', '554s73bnoe2bv8h3bm27q03if9do9m0o'), ('_u7bi00qmvip4mv0mlke4njsv4l6n5u8s', '3tdklhb18jjej254fb5gklasmporiono'))
	query queue length: 0
	insert_id: 0
	affected_rows: 0
	warning_count: 0
	column_count: 9
	row_count: 2
2013-02-12 09:24:02 : database_name: '_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn'
2013-02-12 09:24:02 : provider_name: 'ODBC'
2013-02-12 09:24:02 : table_name: '554s73bnoe2bv8h3bm27q03if9do9m0o'
2013-02-12 09:24:02 : subtable_name: '554s73bnoe2bv8h3bm27q03if9do9m0o'
2013-02-12 09:24:02 : remote_name: 'REGION'
2013-02-12 09:24:02 : query_text: ''
2013-02-12 09:24:02 : database_name: '_u7bi00qmvip4mv0mlke4njsv4l6n5u8s'
2013-02-12 09:24:02 : provider_name: 'ODBC'
2013-02-12 09:24:02 : table_name: '3tdklhb18jjej254fb5gklasmporiono'
2013-02-12 09:24:02 : subtable_name: '3tdklhb18jjej254fb5gklasmporiono'
2013-02-12 09:24:02 : remote_name: 'dbo.ADDRESS'
2013-02-12 09:24:02 : query_text: ''
2013-02-12 09:24:02 : table: 0x02b81050 = {
	['_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn'] = {
		['provider_name'] = "ODBC",
		['tables'] = {
			['554s73bnoe2bv8h3bm27q03if9do9m0o'] = {
				['remote_name'] = "REGION",
				['table_refs'] = {
					[1] = {
						['node'] = {
							[1] = "
",
							[2] = {
								[1] = "
",
								[2] = {
									[1] = "
",
									[2] = {
										['attr'] = {
											[1] = "value",
											[2] = "line",
											[3] = "col",
											[4] = "size",
											[5] = "offset",
											[6] = "cat",
											['line'] = "11",
											['offset'] = "229",
											['size'] = "33",
											['value'] = "_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn",
											['cat'] = "identifier",
											['col'] = "2"
										},
										['tag'] = "TOKEN"
									},
									[3] = "
",
									['attr'] = {
										[1] = "value",
										['value'] = "_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn"
									},
									['tag'] = "IDENTIFIER"
								},
								[3] = "
",
								[4] = {
									['attr'] = {
										[1] = "value",
										[2] = "line",
										[3] = "col",
										[4] = "size",
										[5] = "offset",
										[6] = "cat",
										['line'] = "11",
										['offset'] = "262",
										['size'] = "1",
										['value'] = ".",
										['cat'] = "punctuation",
										['col'] = "35"
									},
									['tag'] = "TOKEN"
								},
								[5] = "
",
								[6] = {
									[1] = "
",
									[2] = {
										['attr'] = {
											[1] = "value",
											[2] = "line",
											[3] = "col",
											[4] = "size",
											[5] = "offset",
											[6] = "cat",
											['line'] = "11",
											['offset'] = "263",
											['size'] = "32",
											['value'] = "554s73bnoe2bv8h3bm27q03if9do9m0o",
											['cat'] = "identifier",
											['col'] = "36"
										},
										['tag'] = "TOKEN"
									},
									[3] = "
",
									['attr'] = {
										[1] = "value",
										['value'] = "554s73bnoe2bv8h3bm27q03if9do9m0o"
									},
									['tag'] = "IDENTIFIER"
								},
								[7] = "
",
								['attr'] = {
									[1] = "value",
									['value'] = "_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn.554s73bnoe2bv8h3bm27q03if9do9m0o"
								},
								['tag'] = "QNAME"
							},
							[3] = "
",
							[4] = {
								[1] = "
",
								[2] = {
									[1] = "
",
									[2] = {
										[1] = "
",
										[2] = {
											['attr'] = {
												[1] = "value",
												[2] = "line",
												[3] = "col",
												[4] = "size",
												[5] = "offset",
												[6] = "cat",
												['line'] = "11",
												['offset'] = "296",
												['size'] = "6",
												['value'] = "REGION",
												['cat'] = "identifier",
												['col'] = "69"
											},
											['tag'] = "TOKEN"
										},
										[3] = "
",
										['attr'] = {
											[1] = "value",
											['value'] = "REGION"
										},
										['tag'] = "IDENTIFIER"
									},
									[3] = "
",
									['attr'] = {
										[1] = "value",
										['value'] = "REGION"
									},
									['tag'] = "QNAME"
								},
								[3] = "
",
								['attr'] = {

								},
								['tag'] = "ALIAS"
							},
							[5] = "
",
							['attr'] = {

							},
							['tag'] = "TABLE_REF"
						},
						['alias'] = "REGION"
					}
				},
				['fields'] = {
					[1] = {
						['size'] = "10",
						['type'] = "integer",
						['required'] = "true",
						['name'] = "REGION_ID",
						['field'] = "REGION_ID"
					},
					[2] = {
						['size'] = "25",
						['type'] = "varchar",
						['required'] = "false",
						['name'] = "REGION_NAME",
						['field'] = "REGION_NAME"
					}
				},
				['alias'] = "REGION",
				['type'] = 1,
				['db_name'] = "_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn",
				['xml_config'] = [[<table dataObject="REGION" name="554s73bnoe2bv8h3bm27q03if9do9m0o" xmlns="http://wiki.toadforcloud.com/index.php/Xmlns/table" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://wiki.toadforcloud.com/index.php/Xmlns/table table.xsd"><columns><column field="REGION_ID" name="REGION_ID" required="true" size="10" type="integer"/><column field="REGION_NAME" name="REGION_NAME" required="false" size="25" type="varchar"/></columns></table>]],
				['table_name'] = "554s73bnoe2bv8h3bm27q03if9do9m0o"
			}
		},
		['xml_config'] = [[<datasource xmlns="http://wiki.toadforcloud.com/index.php/Xmlns/datasource" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://wiki.toadforcloud.com/index.php/Xmlns/datasource datasource.xsd"><provider type="ODBC"><connection  uri="odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};extendedansisql=1;dbq=C:\Program Files (x86)\Quest Software\Toad Data Point 3.2\Plugins\Odbc\Sample Database\Quest_Stage.mdb;uid=Admin"/></provider></datasource>]],
		['db_name'] = "_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn"
	},
	['_u7bi00qmvip4mv0mlke4njsv4l6n5u8s'] = {
		['provider_name'] = "ODBC",
		['tables'] = {
			['3tdklhb18jjej254fb5gklasmporiono'] = {
				['remote_name'] = "dbo.ADDRESS",
				['table_refs'] = {
					[1] = {
						['node'] = {
							[1] = "
",
							[2] = {
								[1] = "
",
								[2] = {
									[1] = "
",
									[2] = {
										['attr'] = {
											[1] = "value",
											[2] = "line",
											[3] = "col",
											[4] = "size",
											[5] = "offset",
											[6] = "cat",
											['line'] = "13",
											['offset'] = "318",
											['size'] = "33",
											['value'] = "_u7bi00qmvip4mv0mlke4njsv4l6n5u8s",
											['cat'] = "identifier",
											['col'] = "2"
										},
										['tag'] = "TOKEN"
									},
									[3] = "
",
									['attr'] = {
										[1] = "value",
										['value'] = "_u7bi00qmvip4mv0mlke4njsv4l6n5u8s"
									},
									['tag'] = "IDENTIFIER"
								},
								[3] = "
",
								[4] = {
									['attr'] = {
										[1] = "value",
										[2] = "line",
										[3] = "col",
										[4] = "size",
										[5] = "offset",
										[6] = "cat",
										['line'] = "13",
										['offset'] = "351",
										['size'] = "1",
										['value'] = ".",
										['cat'] = "punctuation",
										['col'] = "35"
									},
									['tag'] = "TOKEN"
								},
								[5] = "
",
								[6] = {
									[1] = "
",
									[2] = {
										['attr'] = {
											[1] = "value",
											[2] = "line",
											[3] = "col",
											[4] = "size",
											[5] = "offset",
											[6] = "cat",
											['line'] = "13",
											['offset'] = "352",
											['size'] = "32",
											['value'] = "3tdklhb18jjej254fb5gklasmporiono",
											['cat'] = "identifier",
											['col'] = "36"
										},
										['tag'] = "TOKEN"
									},
									[3] = "
",
									['attr'] = {
										[1] = "value",
										['value'] = "3tdklhb18jjej254fb5gklasmporiono"
									},
									['tag'] = "IDENTIFIER"
								},
								[7] = "
",
								['attr'] = {
									[1] = "value",
									['value'] = "_u7bi00qmvip4mv0mlke4njsv4l6n5u8s.3tdklhb18jjej254fb5gklasmporiono"
								},
								['tag'] = "QNAME"
							},
							[3] = "
",
							[4] = {
								[1] = "
",
								[2] = {
									[1] = "
",
									[2] = {
										[1] = "
",
										[2] = {
											['attr'] = {
												[1] = "value",
												[2] = "line",
												[3] = "col",
												[4] = "size",
												[5] = "offset",
												[6] = "cat",
												['line'] = "13",
												['offset'] = "385",
												['size'] = "7",
												['value'] = "ADDRESS",
												['cat'] = "identifier",
												['col'] = "69"
											},
											['tag'] = "TOKEN"
										},
										[3] = "
",
										['attr'] = {
											[1] = "value",
											['value'] = "ADDRESS"
										},
										['tag'] = "IDENTIFIER"
									},
									[3] = "
",
									['attr'] = {
										[1] = "value",
										['value'] = "ADDRESS"
									},
									['tag'] = "QNAME"
								},
								[3] = "
",
								['attr'] = {

								},
								['tag'] = "ALIAS"
							},
							[5] = "
",
							['attr'] = {

							},
							['tag'] = "TABLE_REF"
						},
						['alias'] = "ADDRESS"
					}
				},
				['fields'] = {
					[1] = {
						['size'] = "10",
						['type'] = "integer",
						['required'] = "false",
						['name'] = "ADDRESS_ID_1",
						['field'] = "ADDRESS_ID_1"
					},
					[2] = {
						['size'] = "59",
						['type'] = "varchar",
						['required'] = "false",
						['name'] = "ADDRESS",
						['field'] = "ADDRESS"
					},
					[3] = {
						['size'] = "50",
						['type'] = "varchar",
						['required'] = "false",
						['name'] = "ADDRESS_LINE_2",
						['field'] = "ADDRESS_LINE_2"
					},
					[4] = {
						['size'] = "55",
						['type'] = "varchar",
						['required'] = "false",
						['name'] = "CITY",
						['field'] = "CITY"
					},
					[5] = {
						['size'] = "50",
						['type'] = "varchar",
						['required'] = "false",
						['name'] = "STATE",
						['field'] = "STATE"
					},
					[6] = {
						['size'] = "53",
						['type'] = "varchar",
						['required'] = "false",
						['name'] = "COUNTRY",
						['field'] = "COUNTRY"
					},
					[7] = {
						['size'] = "10",
						['type'] = "integer",
						['required'] = "false",
						['name'] = "POSTAL_CODE",
						['field'] = "POSTAL_CODE"
					},
					[8] = {
						['size'] = "10",
						['type'] = "integer",
						['required'] = "false",
						['name'] = "REGION_ID",
						['field'] = "REGION_ID"
					}
				},
				['alias'] = "ADDRESS",
				['type'] = 1,
				['db_name'] = "_u7bi00qmvip4mv0mlke4njsv4l6n5u8s",
				['xml_config'] = [[<table dataObject="dbo.ADDRESS" name="3tdklhb18jjej254fb5gklasmporiono" xmlns="http://wiki.toadforcloud.com/index.php/Xmlns/table" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://wiki.toadforcloud.com/index.php/Xmlns/table table.xsd"><columns><column field="ADDRESS_ID_1" name="ADDRESS_ID_1" required="false" size="10" type="integer"/><column field="ADDRESS" name="ADDRESS" required="false" size="59" type="varchar"/><column field="ADDRESS_LINE_2" name="ADDRESS_LINE_2" required="false" size="50" type="varchar"/><column field="CITY" name="CITY" required="false" size="55" type="varchar"/><column field="STATE" name="STATE" required="false" size="50" type="varchar"/><column field="COUNTRY" name="COUNTRY" required="false" size="53" type="varchar"/><column field="POSTAL_CODE" name="POSTAL_CODE" required="false" size="10" type="integer"/><column field="REGION_ID" name="REGION_ID" required="false" size="10" type="integer"/></columns></table>]],
				['table_name'] = "3tdklhb18jjej254fb5gklasmporiono"
			}
		},
		['xml_config'] = [[<datasource xmlns="http://wiki.toadforcloud.com/index.php/Xmlns/datasource" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://wiki.toadforcloud.com/index.php/Xmlns/datasource datasource.xsd"><provider type="ODBC"><connection   uri="odbc:DRIVER={SQL Server};SERVER=alvqcs014.dev.quest.corp;UID=sa;APP=Toad Data Point;WSID=ALVDPEABODY1;DATABASE=beta;"/></provider></datasource>]],
		['db_name'] = "_u7bi00qmvip4mv0mlke4njsv4l6n5u8s"
	}
}
2013-02-12 09:24:02 : DEBUG: original query #1:	SELECT ADDRESS.ADDRESS_ID_1,
       ADDRESS.ADDRESS,
       ADDRESS.ADDRESS_LINE_2,
       ADDRESS.CITY,
       ADDRESS.STATE,
       ADDRESS.COUNTRY,
       ADDRESS.POSTAL_CODE,
       ADDRESS.REGION_ID,
       REGION.REGION_NAME
  FROM    _rpcuo3lehnopqnkc8gr9pjjip4b4s3vn.554s73bnoe2bv8h3bm27q03if9do9m0o REGION
       INNER JOIN
          _u7bi00qmvip4mv0mlke4njsv4l6n5u8s.3tdklhb18jjej254fb5gklasmporiono ADDRESS
       ON (REGION.REGION_ID = ADDRESS.REGION_ID)
2013-02-12 09:24:02 : DEBUG: LOCAL
2013-02-12 09:24:02 : DEBUG: table count: 2
2013-02-12 09:24:02 : DEBUG: is_top_query: true
2013-02-12 09:24:02 : DEBUG: primary table: `_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn`.`554s73bnoe2bv8h3bm27q03if9do9m0o`
2013-02-12 09:24:02 : DEBUG: `_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn`.`554s73bnoe2bv8h3bm27q03if9do9m0o`
2013-02-12 09:24:02 : DEBUG: `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`3tdklhb18jjej254fb5gklasmporiono`
2013-02-12 09:24:02 : DEBUG: MATERIALIZE `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`3tdklhb18jjej254fb5gklasmporiono`
2013-02-12 09:24:02 : DEBUG: new query #1 (2):	SELECT ADDRESS.ADDRESS_ID_1,
       ADDRESS.ADDRESS,
       ADDRESS.ADDRESS_LINE_2,
       ADDRESS.CITY,
       ADDRESS.STATE,
       ADDRESS.COUNTRY,
       ADDRESS.POSTAL_CODE,
       ADDRESS.REGION_ID,
       REGION.REGION_NAME
  FROM    `_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn`.`554s73bnoe2bv8h3bm27q03if9do9m0o` REGION
       INNER JOIN
          `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m` ADDRESS
       ON (REGION.REGION_ID = ADDRESS.REGION_ID)
2013-02-12 09:24:02 : processed query #1 (2):	SELECT ADDRESS.ADDRESS_ID_1,
       ADDRESS.ADDRESS,
       ADDRESS.ADDRESS_LINE_2,
       ADDRESS.CITY,
       ADDRESS.STATE,
       ADDRESS.COUNTRY,
       ADDRESS.POSTAL_CODE,
       ADDRESS.REGION_ID,
       REGION.REGION_NAME
  FROM    `_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn`.`554s73bnoe2bv8h3bm27q03if9do9m0o` REGION
       INNER JOIN
          `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m` ADDRESS
       ON (REGION.REGION_ID = ADDRESS.REGION_ID)
2013-02-12 09:24:02 : processed query #2 (4):	SELECT ADDRESS_ID_1, ADDRESS, ADDRESS_LINE_2, CITY, STATE, COUNTRY, POSTAL_CODE, REGION_ID FROM `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`3tdklhb18jjej254fb5gklasmporiono` ADDRESS
2013-02-12 09:24:02 : DEBUG: batch query #1:	    DROP TABLE IF EXISTS `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m`

2013-02-12 09:24:02 : DEBUG: batch query #2:	    CALL hub_information_schema.hub_materialize_init('_u7bi00qmvip4mv0mlke4njsv4l6n5u8s', '_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m')

2013-02-12 09:24:02 : DEBUG: batch query #3:	    CREATE TABLE IF NOT EXISTS `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m` (INDEX(`REGION_ID`)) ENGINE = MyISAM AS  SELECT ADDRESS_ID_1, ADDRESS, ADDRESS_LINE_2, CITY, STATE, COUNTRY, POSTAL_CODE, REGION_ID FROM `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`3tdklhb18jjej254fb5gklasmporiono` ADDRESS  

2013-02-12 09:24:02 : DEBUG: batch query #4:	SELECT ADDRESS.ADDRESS_ID_1,
       ADDRESS.ADDRESS,
       ADDRESS.ADDRESS_LINE_2,
       ADDRESS.CITY,
       ADDRESS.STATE,
       ADDRESS.COUNTRY,
       ADDRESS.POSTAL_CODE,
       ADDRESS.REGION_ID,
       REGION.REGION_NAME
  FROM    `_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn`.`554s73bnoe2bv8h3bm27q03if9do9m0o` REGION
       INNER JOIN
          `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m` ADDRESS
       ON (REGION.REGION_ID = ADDRESS.REGION_ID)
2013-02-12 09:24:02 : DEBUG: batch query #5:	    DROP TABLE IF EXISTS `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m`

2013-02-12 09:24:02 : DEBUG: batch query #6:	    CALL hub_information_schema.hub_materialize_fini('_u7bi00qmvip4mv0mlke4njsv4l6n5u8s', '_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m')

2013-02-12 09:24:02 : read_resultset (1, 0): DROP TABLE IF EXISTS `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m`
	query queue length: 5
	insert_id: 0
	affected_rows: 0
	warning_count: 1
	column_count: 0
	row_count: 0
2013-02-12 09:24:02 : query (1) database access took 0 min 0 sec
2013-02-12 09:24:02 : read_resultset (2, 0): CALL hub_information_schema.hub_materialize_init('_u7bi00qmvip4mv0mlke4njsv4l6n5u8s', '_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m')
	query queue length: 4
	insert_id: 0
	affected_rows: 0
	warning_count: 0
	column_count: 0
	row_count: 0
2013-02-12 09:24:02 : query (2) database access took 0 min 0 sec
2013-02-12 09:24:02 : read_resultset (3, 0): CREATE TABLE IF NOT EXISTS `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m` (INDEX(`REGION_ID`)) ENGINE = MyISAM AS  SELECT ADDRESS_ID_1, ADDRESS, ADDRESS_LINE_2, CITY, STATE, COUNTRY, POSTAL_CODE, REGION_ID FROM `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`3tdklhb18jjej254fb5gklasmporiono` ADDRESS
	query queue length: 3
	insert_id: 0
	affected_rows: 1228
	warning_count: 0
	column_count: 0
	row_count: 0
2013-02-12 09:24:02 : query (3) database access took 0 min 0 sec
2013-02-12 09:24:02 : read_resultset (4, 0): SELECT ADDRESS.ADDRESS_ID_1,
       ADDRESS.ADDRESS,
       ADDRESS.ADDRESS_LINE_2,
       ADDRESS.CITY,
       ADDRESS.STATE,
       ADDRESS.COUNTRY,
       ADDRESS.POSTAL_CODE,
       ADDRESS.REGION_ID,
       REGION.REGION_NAME
  FROM    `_rpcuo3lehnopqnkc8gr9pjjip4b4s3vn`.`554s73bnoe2bv8h3bm27q03if9do9m0o` REGION
       INNER JOIN
          `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m` ADDRESS
       ON (REGION.REGION_ID = ADDRESS.REGION_ID)
	query queue length: 2
	insert_id: 0
	affected_rows: 0
	warning_count: 0
	column_count: 9
	row_count: 1228
2013-02-12 09:24:02 : query (4) database access took 0 min 0 sec
2013-02-12 09:24:02 : read_resultset (5, 0): DROP TABLE IF EXISTS `_u7bi00qmvip4mv0mlke4njsv4l6n5u8s`.`_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m`
	query queue length: 1
	insert_id: 0
	affected_rows: 0
	warning_count: 0
	column_count: 0
	row_count: 0
2013-02-12 09:24:02 : query (5) database access took 0 min 0 sec
2013-02-12 09:24:02 : read_resultset (6, 0): CALL hub_information_schema.hub_materialize_fini('_u7bi00qmvip4mv0mlke4njsv4l6n5u8s', '_20130212092402_3tdklhb18jjej254fb5gklasmporiono_8_m')
	query queue length: 0
	insert_id: 0
	affected_rows: 0
	warning_count: 1
	column_count: 0
	row_count: 0
2013-02-12 09:24:02 : query (6) database access took 0 min 0 sec