0

yahoo.identity false negatives

Queries to the yahoo.identity table are inconsistent. Often resulting in false negative results. 

For example, the first time I query using the test id:

select * from yahoo.identity where yid='spullara'

results in 

<?xml version="1.0" encoding="UTF-8"?>
<query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng"
    yahoo:count="0" yahoo:created="2011-10-27T13:38:46Z" yahoo:lang="en-US">
    <diagnostics>
        <publiclyCallable>false</publiclyCallable>
        <url execution-start-time="2" execution-stop-time="51"
            execution-time="49" http-status-code="404" http-status-message="Not Found"><![CDATA[http://profiles.yahoo.com/v2/identities.handle(spullara~yid)]]></url>
        <user-time>52</user-time>
        <service-time>49</service-time>
        <build-version>22940</build-version>
    </diagnostics> 
    <results/>
</query>

Then two call later I get a found message

<?xml version="1.0" encoding="UTF-8"?>
<query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng"
    yahoo:count="1" yahoo:created="2011-10-27T13:39:08Z" yahoo:lang="en-US">
    <diagnostics>
        <publiclyCallable>false</publiclyCallable>
        <url execution-start-time="1" execution-stop-time="161" execution-time="160"><![CDATA[http://profiles.yahoo.com/v2/identities.handle(spullara~yid)]]></url>
        <user-time>162</user-time>
        <service-time>160</service-time>
        <build-version>22940</build-version>
    </diagnostics> 
    <results>
        <identity>
            <guid>7C7SIF3MMHEOH3MJ5HYPYQQVQI</guid>
        </identity>
    </results>
</query>

by
2 Replies
  • Sorry the xml did not cut and past. Will try the JSON.<br><br><div>1st couple of tries result in not found<br><div>cbfunc({<div>&nbsp;&quot;query&quot;: {<div>&nbsp; &quot;count&quot;: 0,<div>&nbsp; &quot;created&quot;: &quot;2011-10-27T13:48:42Z&quot;,<div>&nbsp; &quot;lang&quot;: &quot;en-US&quot;,<div>&nbsp; &quot;diagnostics&quot;: {<div>&nbsp; &nbsp;&quot;publiclyCallable&quot;: &quot;false&quot;,<div>&nbsp; &nbsp;&quot;url&quot;: {<div>&nbsp; &nbsp; &quot;execution-start-time&quot;: &quot;1&quot;,<div>&nbsp; &nbsp; &quot;execution-stop-time&quot;: &quot;51&quot;,<div>&nbsp; &nbsp; &quot;execution-time&quot;: &quot;50&quot;,<div>&nbsp; &nbsp; <font style="background-color:#ffff00;">&quot;http-status-code&quot;: &quot;404&quot;,</font><div>&nbsp; &nbsp; &quot;http-status-message&quot;: &quot;Not Found&quot;,<div>&nbsp; &nbsp; &quot;content&quot;: &quot;http://profiles.yahoo.com/v2/identities.handle(spullara~yid)&quot;<div>&nbsp; &nbsp;},<div>&nbsp; &nbsp;&quot;user-time&quot;: &quot;52&quot;,<div>&nbsp; &nbsp;&quot;service-time&quot;: &quot;50&quot;,<div>&nbsp; &nbsp;&quot;build-version&quot;: &quot;22940&quot;<div>&nbsp; },<div>&nbsp; &quot;results&quot;: null<div>&nbsp;}<div>});<br><div>While another try results in found<br><div>cbfunc({<div>&nbsp;&quot;query&quot;: {<div>&nbsp; &quot;count&quot;: 1,<div>&nbsp; &quot;created&quot;: &quot;2011-10-27T13:49:00Z&quot;,<div>&nbsp; &quot;lang&quot;: &quot;en-US&quot;,<div>&nbsp; &quot;diagnostics&quot;: {<div>&nbsp; &nbsp;&quot;publiclyCallable&quot;: &quot;false&quot;,<div>&nbsp; &nbsp;&quot;url&quot;: {<div>&nbsp; &nbsp; &quot;execution-start-time&quot;: &quot;1&quot;,<div>&nbsp; &nbsp; &quot;execution-stop-time&quot;: &quot;178&quot;,<div>&nbsp; &nbsp; &quot;execution-time&quot;: &quot;177&quot;,<div>&nbsp; &nbsp; &quot;content&quot;: &quot;http://profiles.yahoo.com/v2/identities.handle(spullara~yid)&quot;<div>&nbsp; &nbsp;},<div>&nbsp; &nbsp;&quot;user-time&quot;: &quot;178&quot;,<div>&nbsp; &nbsp;&quot;service-time&quot;: &quot;177&quot;,<div>&nbsp; &nbsp;&quot;build-version&quot;: &quot;22940&quot;<div>&nbsp; },<div>&nbsp; &quot;results&quot;: {<div>&nbsp; &nbsp;&quot;identity&quot;: {<div>&nbsp; &nbsp; &quot;guid&quot;: &quot;7C7SIF3MMHEOH3MJ5HYPYQQVQI&quot;<div>&nbsp; &nbsp;}<div>&nbsp; }<div>&nbsp;}<div>});<br><br><div class="quote "><div class="quotetop ">QUOTE<cite>(Meschach @ 27 Oct 2011 6:47 AM)</cite><blockquote class="quotemain">Queries to the&nbsp;yahoo.identity table are inconsistent. Often resulting in false negative results.&nbsp;<br><br>For example, the first time I query using the test id:<br><br>select * from yahoo.identity where yid=&#39;spullara&#39;<br><br>results in&nbsp;<br><br><div><!--?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?--><div> &nbsp; &nbsp; yahoo:count=&quot;0&quot; yahoo:created=&quot;2011-10-27T13:38:46Z&quot; yahoo:lang=&quot;en-US&quot;&gt;<div>&nbsp; &nbsp; <div>&nbsp; &nbsp; &nbsp; &nbsp; false<div>&nbsp; &nbsp; &nbsp; &nbsp; <span style="text-decoration:underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; execution-time=&quot;49&quot; http-status-code=&quot;404&quot; <font style="background-color:#ffff00;">http-status-message=&quot;Not Found&quot;&gt;</font><!--[CDATA[http://profiles.yahoo.com/v2/identities.handle(spullara~yid)]]--><div>&nbsp; &nbsp; &nbsp; &nbsp; <span style="text-decoration:underline;">52<div>&nbsp; &nbsp; &nbsp; &nbsp; 49<div>&nbsp; &nbsp; &nbsp; &nbsp; 22940<div>&nbsp; &nbsp; &nbsp;<div>&nbsp; &nbsp; <div><br><br>Then two call later I get a found message<br><br><div><!--?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?--><div> &nbsp; &nbsp; yahoo:count=&quot;1&quot; yahoo:created=&quot;2011-10-27T13:39:08Z&quot; yahoo:lang=&quot;en-US&quot;&gt;<div>&nbsp; &nbsp; <div>&nbsp; &nbsp; &nbsp; &nbsp; false<div>&nbsp; &nbsp; &nbsp; &nbsp; <span style="text-decoration:underline;"><!--[CDATA[http://profiles.yahoo.com/v2/identities.handle(spullara~yid)]]--><div>&nbsp; &nbsp; &nbsp; &nbsp; <span style="text-decoration:underline;">162<div>&nbsp; &nbsp; &nbsp; &nbsp; 160<div>&nbsp; &nbsp; &nbsp; &nbsp; 22940<div>&nbsp; &nbsp; &nbsp;<div>&nbsp; &nbsp; <div>&nbsp; &nbsp; &nbsp; &nbsp; <div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7C7SIF3MMHEOH3MJ5HYPYQQVQI<div>&nbsp; &nbsp; &nbsp; &nbsp; <div>&nbsp; &nbsp; <div><br><br></div></div></div></div></div></div></div></div></div></span></div></span></div></div></div></div></div></div></div></div></div></div></span></div></span></div></div></div></div></div></blockquote></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
    0
  • Ticket created (4942478)<span style="font-weight:bold;"></span><span style="font-size:136%;font-weight:bold;"></span><br><br><div class="quote"><div class="quotetop">QUOTE<cite>(Meschach @ 27 Oct 2011 6:50 AM)</cite></div><blockquote class="quotemain">Sorry the xml did not cut and past. Will try the JSON.<br><br><div>1st couple of tries result in not found<br><div>cbfunc({<div>&nbsp;&quot;query&quot;: {<div>&nbsp; &quot;count&quot;: 0,<div>&nbsp; &quot;created&quot;: &quot;2011-10-27T13:48:42Z&quot;,<div>&nbsp; &quot;lang&quot;: &quot;en-US&quot;,<div>&nbsp; &quot;diagnostics&quot;: {<div>&nbsp; &nbsp;&quot;publiclyCallable&quot;: &quot;false&quot;,<div>&nbsp; &nbsp;&quot;url&quot;: {<div>&nbsp; &nbsp; &quot;execution-start-time&quot;: &quot;1&quot;,<div>&nbsp; &nbsp; &quot;execution-stop-time&quot;: &quot;51&quot;,<div>&nbsp; &nbsp; &quot;execution-time&quot;: &quot;50&quot;,<div>&nbsp; &nbsp; <font style="background-color:#ffff00;">&quot;http-status-code&quot;: &quot;404&quot;,</font><div>&nbsp; &nbsp; &quot;http-status-message&quot;: &quot;Not Found&quot;,<div>&nbsp; &nbsp; &quot;content&quot;: &quot;http://profiles.yahoo.com/v2/identities.handle(spullara~yid)&quot;<div>&nbsp; &nbsp;},<div>&nbsp; &nbsp;&quot;user-time&quot;: &quot;52&quot;,<div>&nbsp; &nbsp;&quot;service-time&quot;: &quot;50&quot;,<div>&nbsp; &nbsp;&quot;build-version&quot;: &quot;22940&quot;<div>&nbsp; },<div>&nbsp; &quot;results&quot;: null<div>&nbsp;}<div>});<br><div>While another try results in found<br><div>cbfunc({<div>&nbsp;&quot;query&quot;: {<div>&nbsp; &quot;count&quot;: 1,<div>&nbsp; &quot;created&quot;: &quot;2011-10-27T13:49:00Z&quot;,<div>&nbsp; &quot;lang&quot;: &quot;en-US&quot;,<div>&nbsp; &quot;diagnostics&quot;: {<div>&nbsp; &nbsp;&quot;publiclyCallable&quot;: &quot;false&quot;,<div>&nbsp; &nbsp;&quot;url&quot;: {<div>&nbsp; &nbsp; &quot;execution-start-time&quot;: &quot;1&quot;,<div>&nbsp; &nbsp; &quot;execution-stop-time&quot;: &quot;178&quot;,<div>&nbsp; &nbsp; &quot;execution-time&quot;: &quot;177&quot;,<div>&nbsp; &nbsp; &quot;content&quot;: &quot;http://profiles.yahoo.com/v2/identities.handle(spullara~yid)&quot;<div>&nbsp; &nbsp;},<div>&nbsp; &nbsp;&quot;user-time&quot;: &quot;178&quot;,<div>&nbsp; &nbsp;&quot;service-time&quot;: &quot;177&quot;,<div>&nbsp; &nbsp;&quot;build-version&quot;: &quot;22940&quot;<div>&nbsp; },<div>&nbsp; &quot;results&quot;: {<div>&nbsp; &nbsp;&quot;identity&quot;: {<div>&nbsp; &nbsp; &quot;guid&quot;: &quot;7C7SIF3MMHEOH3MJ5HYPYQQVQI&quot;<div>&nbsp; &nbsp;}<div>&nbsp; }<div>&nbsp;}<div>});<br><br><div class="quote "><div class="quotetop ">QUOTE<cite>(Meschach @ 27 Oct 2011 6:47 AM)</cite><blockquote class="quotemain">Queries to the&nbsp;yahoo.identity table are inconsistent. Often resulting in false negative results.&nbsp;<br><br>For example, the first time I query using the test id:<br><br>select * from yahoo.identity where yid=&#39;spullara&#39;<br><br>results in&nbsp;<br><br><div><!--?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?--><div> &nbsp; &nbsp; yahoo:count=&quot;0&quot; yahoo:created=&quot;2011-10-27T13:38:46Z&quot; yahoo:lang=&quot;en-US&quot;&gt;<div>&nbsp; &nbsp; <div>&nbsp; &nbsp; &nbsp; &nbsp; false<div>&nbsp; &nbsp; &nbsp; &nbsp; <span style="text-decoration:underline;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; execution-time=&quot;49&quot; http-status-code=&quot;404&quot; <font style="background-color:#ffff00;">http-status-message=&quot;Not Found&quot;&gt;</font><!--[CDATA[http://profiles.yahoo.com/v2/identities.handle(spullara~yid)]]--><div>&nbsp; &nbsp; &nbsp; &nbsp; <span style="text-decoration:underline;">52<div>&nbsp; &nbsp; &nbsp; &nbsp; 49<div>&nbsp; &nbsp; &nbsp; &nbsp; 22940<div>&nbsp; &nbsp; &nbsp;<div>&nbsp; &nbsp; <div><br><br>Then two call later I get a found message<br><br><div><!--?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?--><div> &nbsp; &nbsp; yahoo:count=&quot;1&quot; yahoo:created=&quot;2011-10-27T13:39:08Z&quot; yahoo:lang=&quot;en-US&quot;&gt;<div>&nbsp; &nbsp; <div>&nbsp; &nbsp; &nbsp; &nbsp; false<div>&nbsp; &nbsp; &nbsp; &nbsp; <span style="text-decoration:underline;"><!--[CDATA[http://profiles.yahoo.com/v2/identities.handle(spullara~yid)]]--><div>&nbsp; &nbsp; &nbsp; &nbsp; <span style="text-decoration:underline;">162<div>&nbsp; &nbsp; &nbsp; &nbsp; 160<div>&nbsp; &nbsp; &nbsp; &nbsp; 22940<div>&nbsp; &nbsp; &nbsp;<div>&nbsp; &nbsp; <div>&nbsp; &nbsp; &nbsp; &nbsp; <div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7C7SIF3MMHEOH3MJ5HYPYQQVQI<div>&nbsp; &nbsp; &nbsp; &nbsp; <div>&nbsp; &nbsp; <div><br><br></div></div></div></div></div></div></div></div></div></span></div></span></div></div></div></div></div></div></div></div></div></div></span></div></span></div></div></div></div></div></blockquote></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></blockquote></div>
    0

Recent Posts

in YQL