Giving a negative offset with LIMIT

Question

What would happen if we give a negative offset in using the LIMIT command? Would it return an error as with arrays in Java? Also, what happens if we do not have a row of the given index? (E.g. Table with 3 row, type LIMIT 5,2)

Answer 1

For MySQL
Negative limit: error 1064
Don't have row: empty result