But there's this from a recent review of the evidence:
..asymptomatic bacteriuria, by which we mean significant bacteriuria without local urinary tract symptoms or evidence of systemic infection, does not cause delirium and should not be treated with antibiotics. Stated differently, delirium is not a symptom of asymptomatic bacteriuria. The widespread belief that asymptomatic bacteriuria causes delirium is harmful. We propose strategies to mitigate this harm until better evidence is developed.
Available as free full text.