Actually, I'm betting your active column is actually 0 or 1 and not true or false because of the appallingly terrible state of Boolean types in most SQL dialect

Actually, I'm betting your active column is actually 0 or 1 and not true or false because of the appallingly terrible state of Boolean types in most SQL dialects. God dammit why do we use this? Oh right, because every attempt to "fix" it throws out the relational algebra baby with the sql bathwater.