Adapter is failing in case there is specific comment

Add this table to the tests project and all the tests will disappear and the searcher will throw the error. It is not supposed to be temporal table, so all the temporal syntax can be excluded.

CREATE TABLE [dbo].[commercial_credit]
(
[lease_application] CHAR(8) NOT NULL PRIMARY KEY
, [lessee_name] CHAR(30) NULL
, [lessee_dba_name] CHAR(30) NULL
, [lessee_address_1] CHAR(30) NULL
, [lessee_address_2] CHAR(30) NULL
, [lessee_city] CHAR(17) NULL
, [lessee_state] CHAR(2) NULL
, [lessee_zip_code] CHAR(9) NULL
, [cellular_number] CHAR(10) NULL
, [bill_to_name] CHAR(30) NULL
, [bill_to_address_line_1] CHAR(30) NULL
, [bill_to_address_line_2] CHAR(30) NULL
, [bill_to_address_city] CHAR(17) NULL
, [bill_to_address_state] CHAR(2) NULL
, [bill_to_address_zip_code] CHAR(9) NULL
, [bill_to_contact] CHAR(30) NULL
, [bill_to_contact_phone] CHAR(18) NULL
, [tax_rate] DECIMAL(10, 4) NULL
, [tax_state] CHAR(2) NULL
, [primary_bank_name] CHAR(30) NULL
, [primary_bank_officer] CHAR(30) NULL
, [primary_bank_phone_number] CHAR(18) NULL
, [trade_1_name] CHAR(30) NULL
, [trade_1_phone_number] CHAR(18) NULL
, [trade_2_name] CHAR(30) NULL
, [trade_2_phone_number] CHAR(18) NULL
, [years_in_business] DECIMAL(5, 1) NULL
, [business_size] SMALLINT NULL
, [business_organization] CHAR(1) NULL
, [tax_exempt_indicator] CHAR(1) NULL
, [standard_industry_code] CHAR(5) NULL
, [bank_account_number] CHAR(17) NULL
, [bank_transit_number] CHAR(9) NULL
, [lessee_fed_id_number] CHAR(9) NULL
, [duns_number] CHAR(9) NULL
, [dba_duns_number] CHAR(9) NULL
, [debit_account_type] CHAR(1) NULL
, [debit_account_class] CHAR(1) NULL
, [lessee_contact] CHAR(30) NULL
, [lessee_email] CHAR(100) NULL
, [SysStart] DATETIME2(7) GENERATED ALWAYS AS ROW START NOT NULL
, [SysEnd] DATETIME2(7) GENERATED ALWAYS AS ROW END NOT NULL
, PERIOD FOR SYSTEM_TIME([SysStart], [SysEnd])
)
WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = [dbo].[commercial_credit_history], DATA_CONSISTENCY_CHECK = ON));
GO

CREATE UNIQUE NONCLUSTERED INDEX [nu_commercial_credit__lease_application]
ON [dbo].[commercial_credit] ([lease_application] ASC);
GO
/*
CREATE NONCLUSTERED INDEX [_dta_index_commercial_credit_10_533576939__k1_3_4_6_7_8_17_40]
ON [dbo].[commercial_credit] ([lease_application] ASC)
INCLUDE
([lessee_dba_name]
,[lessee_address_1]
,[lessee_city]
,[lessee_state]
,[lessee_zip_code]
,[bill_to_contact_phone]
,[lessee_email]
) ;
GO

CREATE NONCLUSTERED INDEX [_dta_index_commercial_credit_10_533576939__k1_2_3_4_6_7_8_17]
ON [dbo].[commercial_credit] ([lease_application] ASC)
INCLUDE
([lessee_name]
,[lessee_dba_name]
,[lessee_address_1]
,[lessee_city]
,[lessee_state]
,[lessee_zip_code]
,[bill_to_contact_phone]
) ;
*/

Füge die bereitgestellte Definition der Tabelle commercial_credit zum tests-Projekt hinzu und reproduziere den Fehler, bei dem Tests verschwinden und der Searcher einen Fehler auslöst. Beginne damit, die Verarbeitung der Tabellendefinition durch den Searcher nachzuverfolgen, insbesondere die temporale Syntax; fertig ist die Aufgabe, wenn das Schema keinen Fehler mehr verursacht und die Tests auffindbar bleiben.

Vom Indexierungsmodell aus dem Issue-Text verfasst.