I've found the answer, floats don't split . Actually, I needed to reference the table and not put it in a float. As I had to add the caption and label manually using ERT, I had to reference it by manually entering the reference.
I'm trying to split a long table that is within a float over several pages without much success. The displayed result includes only the rows that fit that one page while the other rows are hidden. Is it possible?