A global study has found a paradox: our water supplies are shrinking at the same time as climate change is generating more intense rain.