Multi_insert returns more results than expected in some specific conditions about rom-sql HOT 5 OPEN

@renatolond yes you could use a custom command and implement your own #execute

from rom-sql.

I reckon this is a known problem with composite primary keys. In rom 6.0 you'll have "void commands" that don't return anything and you'll be able to use whatever method you want to retrieve inserted data.

@flash-gordon maybe we should raise an error in case of a command that return results automatically + composite PKs?

from rom-sql.

I guess yes, raising an explicit exception is better

from rom-sql.

@flash-gordon cool, it's something to do in 4.0.0 I suppose

from rom-sql.

Is there a work around in the meantime, should I do a custom command that calls sequel directly?

from rom-sql.