--- Auto fix error

-- trim tags keys
--update current_way_tags set k=trim(k) where k regexp "^ " or k regexp " $";
--update current_relation_tags set k=trim(k) where k regexp "^ " or k regexp " $";
select * from current_way_tags where k regexp "^ " or k regexp " $";
select * from current_relation_tags where k regexp "^ " or k regexp " $";

-- trim tags values
--update current_way_tags set v=trim(v) where v regexp "^ " or v regexp " $";
--update current_relation_tags set v=trim(v) where v regexp "^ " or v regexp " $";
select * from current_way_tags where v regexp "^ " or v regexp " $";
select * from current_relation_tags where v regexp "^ " or v regexp " $";

-- remove final ";"
--update current_way_tags set v=substring(v,1,char_length(v)-1) where v regexp ";$";
--update current_relation_tags set v=substring(v,1,char_length(v)-1) where v regexp ";$";
select * from current_way_tags where v regexp ";$";
select * from current_relation_tags where v regexp ";$";

-- remove empty keys or tags
--delete from current_way_tags where v="" and k="";
select * from current_way_tags where v="" and k="";
--delete from current_way_tags where v="";
select * from current_way_tags where v="";
--delete from current_relation_tags where v="" and k="";
select * from current_relation_tags where v="" and k="";
--delete from current_relation_tags where v="";
select * from current_relation_tags where v="";


--- Warning

-- key not in map feature
-- create table mapfeature ( k varchar(255) );
select count(k), k from current_way_tags where k not in (select k from mapfeature) group by k order by count(k);
select count(k), k from current_relation_tags where k not in (select k from mapfeature) group by k order by count(k);

-- highway tag seem not contain good thing
select * from current_way_tags where k="highway" and v regexp " " and not v regexp ";" and not v like "FIXME%";
select * from current_relation_tags where k="highway" and v regexp " " and not v regexp ";" and not v like "FIXME%";

-- highway tag collapsed by poltach
select * from current_way_tags where k="highway" and v regexp " " and v regexp ";";
select * from current_relation_tags where k="highway" and v regexp " " and v regexp ";";

-- may encoding error
select * from current_way_tags where v regexp "Ã";
select * from current_relation_tags where v regexp "Ã";

-- what is the question ?
select * from current_way_tags where v like "%?%" or k like "%?%";
select * from current_relation_tags where v like "%?%" or k like "%?%";

-- full uppercase
select * from current_way_tags where k="name" and not v like "RER _" and not v regexp "[A-Z][- ]?[0-9]+" and v like "% %" and v=binary upper(v);
select * from current_relation_tags where k="name" and not v like "RER _" and not v regexp "[A-Z][- ]?[0-9]+" and v like "% %" and v=binary upper(v);


capitalis tout sauf les articles