GoEddie / GoEddie/tSQLt-TestAdapter

Adapter is failing in case there is specific comment

Open
#9 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
21
Forks
9
PR merge metrics
No merged PRs in 30d

Description

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]
) ;
*/

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.