Let $S$ be space consisting of collection of square integrable continuous functions $f:[0,1]\rightarrow\mathbb{R}$ with the constraint $f(0)=f(1)$. So $S$ is an inner product space with the inner product $$\langle f,g \rangle =\int_0^1f(x)g(x)dx.$$
Now the question is whether $S$ is a Hilbert space or not??
Now, $S$ to be a Hilbert space it is necessary to show that $S$ is complete metric space with respect to its natural metric $$\|f-g\|=\sqrt{\langle f-g,f-g\rangle}.$$ To show completeness I need to show that every Cauchy sequence in that space is convergent.
Here I stuck. Specifically I have no idea how to show the sequence of $f$ has limit $f_0$ which has the property that $f_0(0)=f_0(1)$.
Is there any counter example to show that $S$ is not a Hilbert space? Thanks for any suggestion.
Added later: Thanks to @Aweygan for pointing out the role of the (previous) restriction of positivity to the function. Though primarily I was interested about positive valued function, with out loss of generality I am now considering the mean shift version of the functions which enable the new functions to take values in real line. I modified this point in the edited question.
Regarding convergence and completeness: For $n\in N$ let $f_n(x)=0$ for $x\leq 1/2-1/(n+2)$ and $f_n(x)=1$ for $x\geq 1/2.$ Let $f_n(x)$ be linear for $x\in [1/2-1/(n+2),1/2].$
Then $(f_n)_{n\in N}$ is a Cauchy sequence with respect to the norm $\|f-g\|=[\int_0^1|f(x)-g(x)|^2\;dx]^{1/2}.$
Let $h(x)=0$ for $x\leq 1/2$ and $h(x)=1$ for $x>1/2.$ The function $h$ is not continuous. And it has the property that for any continuous $g:[0,1]\to R$ there exists $r>0$ and here exist $a,b$ with either $0<a<b<1/2$ or $1/2<a<b<1$, such that $x\in [a,b]\implies |g(x)-h(x)|\geq r.$
But for all sufficiently large $n$ we have $x\in [a,b]\implies f_n(x)=h(x).$ So $\lim \sup \|g-f_n\|^2\geq \int_a^b |g(x)-h(x)|^2\;dx\geq (b-a)r^2>0.$ So $(f_n)_{n\in N}$ cannot converge in norm to any continuous $g.$