Composite pk break test

Is this SQL standard? Sqlite seems that does not support this