Consider the problem $$ \begin{split} \min_{x\in \mathbb{R}^2}\ & x_1^4 -2x_2^2-x_2 \\ \text{subject to }\ & x_1^2+x_2^2+x_2\leq 0 \end{split} $$
I have found that the point $x$ with $x_1 = 0, x_2 = -0.25$ is a KKT point with corresponding Lagrange multiplier $\lambda = 0$. According lecture notes, a sufficient condition for $x$ to be a local minimizer is that $<s,\nabla^2 L(x,\lambda) s>$ is positive definite for all $s$ such that $<s,c_i(x)> = 0$ and $\lambda >0$ where $c_i(x)$ is the ith active inequality constraint (here $L$ is the Lagrangian function). In our case, there is no such $s$, since for e.g. $\lambda = 0$.
Does this mean that $x$ is a local minimizer?

Your sufficient KKT condition is not complete. It should be $$ \langle s,c_i(x)\rangle\ \#\ 0, \quad\forall c_i\text{ active} $$ where $\#$ is equality if $\lambda>0$ or inequaity if $\lambda=0$ (the inequality is used to be $\ge$ in the literature that uses constraints $c_i(x)\ge 0$).
Now in your case (if I am not miscalculating as I am doing it a bit quickly) we have $$ \nabla^2L=\begin{bmatrix}0 & 0\\0 & -4\end{bmatrix}\qquad\text{subject to } s_2\le 0. $$ Here $\langle s,\nabla^2L s\rangle\not>0$, hence, no, it cannot be confirmed to be a local minimum from this test.
P.S. I assume that the point and $\lambda=0$ are correct.
P.P.S. The second order sufficient KKT condition is vacuously true, that is if there is no such $s$ then the point is a (strict) local minimizer.