magento2-37550: JoinProcessor join definitions are only applied the first time per request

Searching for order #001 ...  Not Found
Searching for order #002 ... 
In Mysql.php line 110:
                                                                                                                                                                            
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'store.group_id' in 'where clause', query was: SELECT `main_table`.* FROM `sales_order` AS `main_table` WHERE ((`  
  increment_id` = '002')) AND ((`store`.`group_id` = 1))                                                                                                                    
                                                                                                                                                                            

In Mysql.php line 91:
                                                                                             
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'store.group_id' in 'where clause'  
                                                                                             

order:update

    <?php

    use Magento\Framework\Component\ComponentRegistrar;

    ComponentRegistrar::register(ComponentRegistrar::MODULE, 'SomeVendor_SomeModule', __DIR__);
    

    <?xml version="1.0"?>
    <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Module/etc/module.xsd">
        <module name="SomeVendor_SomeModule" />
    </config>
    

    <?xml version="1.0"?>
    <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
        <type name="Magento\Framework\Console\CommandListInterface">
            <arguments>
                <argument name="commands" xsi:type="array">
                    <item name="order:update" xsi:type="object">SomeVendor\SomeModule\Console\Command\OrderUpdate</item>
                </argument>
            </arguments>
        </type>
        <type name="SomeVendor\SomeModule\Console\Command\OrderUpdate">
            <arguments>
                <argument name="orderRepository" xsi:type="object">SomeVendor\SomeModule\Model\OrderRepository</argument>
            </arguments>
        </type>
        <virtualType name="SomeVendor\SomeModule\Model\OrderRepository" type="Magento\Sales\Model\OrderRepository">
            <arguments>
                <argument name="collectionProcessor" xsi:type="object">SomeVendor\SomeModule\Model\OrderRepository\CollectionProcessor</argument>
            </arguments>
        </virtualType>
        <virtualType name="SomeVendor\SomeModule\Model\OrderRepository\CollectionProcessor" type="Magento\Framework\Api\SearchCriteria\CollectionProcessor">
            <arguments>
                <argument name="processors" xsi:type="array">
                    <item name="joins" xsi:type="object">SomeVendor\SomeModule\Model\Api\SearchCriteria\CollectionProcessor\StoreViewJoinProcessor</item>
                </argument>
            </arguments>
        </virtualType>
        <virtualType name="SomeVendor\SomeModule\Model\Api\SearchCriteria\CollectionProcessor\StoreViewJoinProcessor" type="Magento\Framework\Api\SearchCriteria\CollectionProcessor\JoinProcessor">
            <arguments>
                <argument name="customJoins" xsi:type="array">
                    <item name="store.group_id" xsi:type="object">SomeVendor\SomeModule\Model\Api\SearchCriteria\JoinProcessor\Store</item>
                </argument>
            </arguments>
        </virtualType>
    </config>
    

    <?php
    /**
     * Store Join Processor
     */
    declare(strict_types = 1);

    namespace SomeVendor\SomeModule\Model\Api\SearchCriteria\JoinProcessor;

    use Magento\Framework\Api\SearchCriteria\CollectionProcessor\JoinProcessor\CustomJoinInterface;
    use Magento\Framework\Data\Collection\AbstractDb;

    /**
     * Store Join Processor
     */
    class Store implements CustomJoinInterface
    {
        /**
         * @inheritDoc
         */
        public function apply(AbstractDb $collection)
        {
            $collection->join(
                ['store' => $collection->getResource()->getTable('store')],
                'store.store_id = main_table.store_id',
                []
            );

            return true;
        }
    }
    

    <?php
    /**
     * Order Update CLI
     */

    declare(strict_types = 1);

    namespace SomeVendor\SomeModule\Console\Command;

    use Magento\Framework\Api\SearchCriteriaBuilder;
    use Magento\Sales\Api\Data\OrderInterface;
    use Magento\Sales\Api\OrderRepositoryInterface;
    use Symfony\Component\Console\Command\Command;
    use Symfony\Component\Console\Input\InputInterface;
    use Symfony\Component\Console\Output\OutputInterface;

    /**
     * Order Update CLI
     */
    class OrderUpdate extends Command
    {
        /** @var OrderRepositoryInterface */
        protected $orderRepository;

        /** @var SearchCriteriaBuilder */
        protected $searchCriteriaBuilder;

        /**
         * OrderUpdate constructor.
         *
         * @param OrderRepositoryInterface $orderRepository
         * @param SearchCriteriaBuilder $searchCriteriaBuilder
         */
        public function __construct(
            OrderRepositoryInterface $orderRepository,
            SearchCriteriaBuilder $searchCriteriaBuilder
        ) {
            $this->orderRepository = $orderRepository;
            $this->searchCriteriaBuilder = $searchCriteriaBuilder;
            parent::__construct();
        }

        /**
         * @inheritDoc
         */
        protected function configure()
        {
            $this->setName('order:update');
            $this->setDescription('Order Update');

            parent::configure();
        }

        /**
         * @inheritDoc
         */
        protected function execute(InputInterface $input, OutputInterface $output)
        {
            foreach (['001', '002'] as $orderId) {
                echo 'Searching for order #' . $orderId . ' ... ';
                $order = $this->searchOrder($orderId, 1);
                echo $order ? ' Found' : ' Not Found';
                echo PHP_EOL;
            }
        }

        /**
         * Search Order
         *
         * @param string $incrementId
         * @param int $storeId
         *
         * @return OrderInterface|null
         */
        protected function searchOrder(string $incrementId, int $storeId): ?OrderInterface
        {
            $searchCriteria = $this->searchCriteriaBuilder
                ->addFilter('increment_id', $incrementId)
                ->addFilter('store.group_id', $storeId)
                ->create();
            $orders = $this->orderRepository->getList($searchCriteria)->getItems();

            return current($orders) ?: null;
        }
    }
    

    php bin/magento module:enable SomeVendor_SomeModule
    php bin/magento setup:upgrade
    php bin/magento cache:clean
    php bin/magento order:update
    

Searching for order #001 ... Not Found
Searching for order #002 ... Not Found

Searching for order #001 ...  Not Found
Searching for order #002 ... 
In Mysql.php line 110:
                                                                                                                                                                            
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'store.group_id' in 'where clause', query was: SELECT `main_table`.* FROM `sales_order` AS `main_table` WHERE ((`  
  increment_id` = '002')) AND ((`store`.`group_id` = 1))                                                                                                                    
                                                                                                                                                                            

In Mysql.php line 91:
                                                                                             
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'store.group_id' in 'where clause'  
                                                                                             

order:update

echo 'Collection ID: ' . spl_object_id($collection) . PHP_EOL;