Apache and MIT are not copyleft, since you do not need to share your code modifications.

weak copyleft would be things like MPL, that limit the modifications you have to share to only parts of the program.

CockroachDBs new license isn't even Open Source following the common OSI definition of the term.