Cooking with SQL

I deleted all the TinyStat data gathered for the past two weeks.  I hated doing that, but I am still in Alpha development afterall.

I inadvertantly introduced a serious error in the portion of the codebase that inserts new UserAgent records.  I translate spaces in the UserAgent to "_space_" prior to sending to the TinyStats collection script.  I then use the replace function to change the data back.  The bug was that I forgot to include the replace command in the correlated subquery.  The example below shows the correct method.  

insert into UserAgent (UserAgent)
select distinct replace(UserAgent,'_space_',' ')
  from WebLogQueue wlq
 where not exists(select 1
                    from UserAgent ua where ua.UserAgent = replace(wlq.UserAgent,'_space_',' '))

 To make a long story short, I am too time pressed to spend the hour it would take to resolve the data inconsistencies.  Hitting the reset switch is the easiest solution at this point. 

For those participating in the testing, I apologize.  It hopefully will not happen again.    

Comments (0)

Subscribe to this comment's feed

Name

Website

Title

Comment

smaller | bigger

I have read and agree to the Terms of Usage.

Add Comment