When a block reward is spent together with other outputs in the wallet and that block reward is later orphaned, the wallet does not show the other funds as available anymore.  Even a `-rescan` is not enough - only `-zapwallettxes` or an explicit `abandontransaction` "recovers" the funds.  I prepared a [test case](https://github.com/domob1812/bitcoin/blob/wallet-bug-invalidated-block-rewards/test/functional/wallet_bug.py) that shows this behaviour.

Is this a known issue or the expected behaviour?  While this situation is something that will presumably not occur in practice (as it requires a long reorg), I wonder if that transaction should be automatically abandoned as it seems clear it won't be able to be confirmed anymore.
// 
    bool create_blank = (_creation_flags & WALLET_FLAG_BLANK_WALLET);
    // 
    if (!passphrempty()) {
        _creation_flags |= WALLET_FLAG_BLANK_WALLET;
    }
    // 
    if ((_creation_flags & WALLET_FLAG_EXTERNAL_SIGNER) && !(_creation_flags & WALLET_FLAG_DISABLE_PRIVATE_KEYS)) {
        error = Untranslated("Private keys must be disabled when using an external signer");
        status = DatabaseStatusFAILED_CREATE;
        return nullptr;
    }
    // 
    if ((_creation_flags & WALLET_FLAG_EXTERNAL_SIGNER) && !(_creation_flags & WALLET_FLAG_DESCRIPTORS)) {
        error = Untranslated("Descriptor support must be enabled when using an external signer");
        status = DatabaseStatusFAILED_CREATE;
        return nullptr;
    }
    // 
    if (!passphrempty() && (_creation_flags & WALLET_FLAG_DISABLE_PRIVATE_KEYS)) {
        error = Untranslated("Passphrase provided but private keys are disabled. A passphrase is only used to encrypt private keys, so cannot be used for s with private keys disabled.");
        status = DatabaseStatusFAILED_CREATE;
        return nullptr;
    }
    // 
    stdunique_ptr<WalletDatabase> database = MakeWalletDatabase(name, options, status, error);
    if (!database) {
        error = Untranslated("Wallet file verification failed.") + Untranslated(" ") + error;
        status = DatabaseStatusFAILED_VERIFY;
        return nullptr;