<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 12pt; color: #000000'>Mike,<br><br>The defect you've uncovered isn't the same as TEIID-93, it's much simpler and obvious. I'm checking in a change for 6.2 today. Are you working with 6.2 or 6.1?<br><br>~jd<br>----- "Mike Mascari" <mascarim@yahoo.com> wrote:
<br>> <style><!-- DIV {margin:0px;} --></style><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">> <div>I've attached both the xml and the xsd used and re-tested the importation and query against them with the same result. Thanks for looking into it! Could it be the same issue as this:</div><div><br>> </div><div><a href="https://jira.jboss.org/jira/browse/TEIID-93" target="_blank">https://jira.jboss.org/jira/browse/TEIID-93</a></div><div><br>> </div><div>??</div><div><br>> </div><div>My issue is a much simpler case, however. The query needn't be pushed down as apart of the planner over a federated view to cause the irregularity -- one need only query the XML source directly. </div><div><br>> </div><div>Thanks again!</div><div><br>> </div><div>And just for giggles:</div><div><br>> </div><div><div># xmllint --schema clients.xsd clients.xml </div><div><?xml version="1.0"
encoding="UTF-8"?></div><div><clients></div><div> <client></div><div> <name>acme</name></div><div> <rate>15</rate></div><div> </client></div><div> <client></div><div> <name>toolwerks</name></div><div> <rate>20</rate></div><div> </client></div><div></clients></div><div>clients.xml validates</div><div><br>> </div><div>:-)</div><div><br>> </div><div>- Mike</div></div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;">> <br>> <div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">> <font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> John Doyle <jdoyle@redhat.com><br>> <b><span style="font-weight: bold;">To:</span></b> Mike Mascari <mascarim@yahoo.com><br>> <b><span style="font-weight: bold;">Cc:</span></b> teiid-users@lists.jboss.org<br>> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, September 1, 2009 11:48:24 AM<br>> <b><span style="font-weight: bold;">Subject:</span></b> Re: [teiid-users] unexpected query results against XML data source<br>> </font><br>>
<style>p {margin:0;}</style><div style="font-family: Times New Roman; font-size: 12pt; color: rgb(0, 0, 0);">> Hi Mike,<br>> <br>> I've tried to reproduce this but get no root elements to select from during the import process. Is it possible that the XSD pasted here is different from what you're using?<br>> <br>> ~jd<br>> ----- "Mike Mascari" <mascarim@yahoo.com> wrote:
<br>> > <div style="font-family: arial,helvetica,sans-serif; font-size: 10pt; color: black;">> > <div>Hello. I've downloaded and installed the snapshot as of today (8/31/2009) and, using the designer:</div><div><br>> > </div><div>1. Used Import->XML Schema as Relational Source Model</div><div><br>> > </div><div>2. Selected Document over HTTP with no request parameters</div><div><br>> > </div><div>3. Selected No Catalog</div><div><br>> > </div><div>4. Chose "File System" as source of XML Schema (inlined below)</div><div><br>> > </div><div>5. Chose "client" (I've tried w/"clients" as well) as the root element and "Finish"</div><div><br>> > </div><div>6. Create a "purchasing" View Model and, with "purchasing" selected, created an "example" BaseTable. I then drag-and-drop "client" from clients.xmi Source Model into SOURCES pane. (This View abstraction turns out not to be the problem -- I query the Source via the
Execute'd VDB with the same outcome.)</div><div><br>> > </div><div>7. Created a "billing" vdb, cleaned, built, and synchronized.</div><div><br>> > </div><div>8. Then, with this data served up by apache:</div><div><br>> > </div><div><div><?xml version="1.0" encoding="UTF-8"?></div><div><clients></div><div> <client></div><div> <name>acme</name></div><div> <rate>15</rate></div><div> </client></div><div> <client></div><div> <name>toolwerks</name></div><div> <rate>20</rate></div><div> </client></div><div></clients></div><div><br>> > </div><div>I issued the following query:</div><div><br>> > </div><div><div>select * from clients.client</div><div><br>> > </div><div>and received the expected
result:</div><div><br>> > </div><div><div><div>null;acme;15</div><div>null;toolwerks;20</div><div><br>> > </div><div>9. Then I did this:</div><div><br>> > </div><div>select * from clients.client where name = 'acme'</div><div><br>> > </div><div>and received *two rows*:</div><div><br>> > </div><div><div>null;acme;15</div><div>null;toolwerks;20</div><div><br>> > </div><div>10. So I did this:</div><div><br>> > </div><div>select * from clients.client where name != 'acme' </div><div><br>> > </div><div>and received the expected one row:</div><div><br>> > </div><div><div>null;toolwerks;20</div><div><br>> > </div><div>???</div><div><br>> > </div><div>Is there something goofy with the equality operator against XML data? Is there flag that needs flipped on these attributes? I went with the "string" mapping on the 'XML Schema as Relational Source Model' dialog wizard (pane 4 IIRC). Oughtn't I have? I also changed XML node names that might
have been SQL keywords ('name' -> 'fullname') but no
dice...</div><div><br>> > </div><div>Thoughts? </div><div><br>> > </div><div>- Mike</div><div><br>> > </div><div>Schema:</div><div><br>> > </div></div></div></div></div></div><div><div><?xml version="1.0"?></div><div><span></span></div><div><br>> > </div><div> <!-- our client database --></div><div><br>> > </div><div> <xs:element name="clients"></div><div> </div><div> <xs:complexType></div><div> <xs:sequence></div><div><br>> > </div><div> <!-- the client --></div><div> </div><div> <xs:element name="client" minOccurs="1" maxOccurs="unbounded"></div><div>
<xs:complexType></div><div> <xs:sequence></div><div><br>> > </div><div> <!-- client name --></div><div><br>> > </div><div> <xs:element name="name" type="xs:string" minOccurs="1" maxOccurs="1"/></div><div><br>> > </div><div> <!-- bill rate --></div><div><br>> > </div><div> <xs:element name="rate" minOccurs="0"></div><div> <xs:simpleType></div><div> <xs:restriction base="xs:decimal"></div><div> <xs:minInclusive
value="50"/></div><div>
<xs:maxInclusive value="250"/></div><div> </xs:restriction></div><div> </xs:simpleType></div><div> </xs:element></div><div><br>> > </div><div> </xs:sequence></div><div><br>> > </div><div> </xs:complexType></div><div><br>> > </div><div> </xs:element></div><div><br>> > </div><div> </xs:sequence></div><div> </xs:complexType></div><div><br>> > </div><div> </xs:element></div><div></xs:schema></div></div><div><br>> > </div></div><div style="">> > </div></div><br>> >
<br>> <span>> _______________________________________________
teiid-users mailing list
teiid-users@lists.jboss.org
<a target="_blank" href="https://lists.jboss.org/mailman/listinfo/teiid-users">https://lists.jboss.org/mailman/listinfo/teiid-users</a>
</span></div></div></div><div style="position: fixed;">> </div></div><br>>
<br>> _______________________________________________
teiid-users mailing list
teiid-users@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/teiid-users
</div></body></html>