Incorrect deployment plan order generated when a table valued function with schema binding is dependent on Temporal table

[sejagada]

• DacFx Version: 162.3.564
• Tested in SSMS latest version

• You can reproduce the issue in the one of the 2 ways:

1. Steps to Reproduce using WideWorldImporters Database:

   i. Install SQL Server 2022 & import WideWorldImporters database. ii. Right click on 'Application.Cities' -> Encrypt columns -> Select City Name -> New Encryption key -> Go to Summary & finish. Encryption fails with the below error.

   

2. Steps to Reproduce by creating tables i. Install SQL Server 2022 & connect to it using SSMS. ii. Create a new database & create a temporal table as below:

      CREATE TABLE Department
       (
           DeptID INT NOT NULL PRIMARY KEY CLUSTERED,
           DeptName VARCHAR(50) NOT NULL,
           ManagerID INT NULL,
           ParentDeptID INT NULL,
           ValidFrom DATETIME2 GENERATED ALWAYS AS ROW START NOT NULL,
           ValidTo DATETIME2 GENERATED ALWAYS AS ROW END NOT NULL,
           PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo)
       )
       WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = dbo.DepartmentHistory));

   iii. Create a table-valued function with schema binding as below:

   CREATE FUNCTION Test(@ManagerID int)  
       RETURNS TABLE  
       WITH SCHEMABINDING
       AS  
       RETURN  
           SELECT ParentDeptID  
           FROM dbo.Department  
           WHERE ManagerID > @ManagerID

   iv. Right click on the table -> Encrypt columns -> Select DeptName -> New Encryption key -> Go to Summary & finish. Encryption fails with the same error as above.

DetermineCustomerAccess is a table value function with schema binding which depends on the temporal table Application.Cities. During the deployment, drop system-versioning step is being executed before schema unbinding step due to which the exception is thrown.