search

praveenbankbazaar / httparchive

Automatically exported from code.google.com/p/httparchive
0 stars 0 forks source link

Unknown CDN values as '' #356

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
The column CDN is set to be nullable but data from the 2013-01-15 run contains 
values where it is an empty string. This is an "MVL" (multi-valued logic) 
problem with unknown being possibly both NULL and an empty string. I suggest 
that NULL is used where no known CDN can be assigned.

UPDATE pages
SET CDN = NULL
WHERE
CDN = ''

Original issue reported on code.google.com by charlie....@clark-consulting.eu on 26 Jan 2013 at 3:33

GoogleCodeExporter commented 9 years ago 
fixed

Original comment by stevesou...@gmail.com on 26 Jan 2013 at 5:40