For tables with no primary keys, we (will soon) create an extra column named "rowid". It is not hidden or special in any way. This causes both INSERTs with no named columns and SELECT *s to fail since the column orders are different than what the user specified.
See line 3091 of https://github.com/cockroachdb/sqllogictest/blob/master/test/select4.test