i did a search for such function but didn't found anything useful/complete ! , like this :
Integrable function $f$ on $\mathbb R$ does not imply that limit $f(x)$ is zero
is there any function that is integrable and $\lim_{x \to \infty}f(x) \neq0 $ and $\infty$ ??
If the limit $L:=\lim_{x\to\infty} f(x)$ exists and is nonzero, then surely $\int_0^b f(x)\,dx$ grows essentially like $Lb$ as $b\to\infty$ (because for big $b$, $\int_{b}^{b+1} f(x)\,dx\approx \int_b^{b+1}L\,dx$). Note that the question you linked to talks about the $\limsup$, not the $\lim$.