T-SQL Analyzer

using System.IO; using Microsoft.VisualStudio.TestTools.UnitTesting; using TestHelpers; namespace SqlServer.Rules.Tests.SmokeTests; [TestClass] public class TestAW : TestModel { public TestAW() : base(TestConstants.SqlServerRules) { } [TestMethod] public void TestAdventureworks() { foreach (var fileName in Directory.GetFiles("../../../../../sqlprojects/AW/Tables", "*.sql")) { TestFiles.Add(fileName); } ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(4, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(3, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(4, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(3, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(3, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(4, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(4, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(4, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(3, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(4, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRD0047")); ExpectedProblems.Add(new TestProblem(26, 16, "SqlServer.Rules.SRD0020")); ExpectedProblems.Add(new TestProblem(22, 45, "SqlServer.Rules.SRP0009")); ExpectedProblems.Add(new TestProblem(24, 16, "SqlServer.Rules.SRD0020")); ExpectedProblems.Add(new TestProblem(23, 1, "SqlServer.Rules.SRP0018")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(32, 16, "SqlServer.Rules.SRD0020")); ExpectedProblems.Add(new TestProblem(30, 13, "SqlServer.Rules.SRD0020")); ExpectedProblems.Add(new TestProblem(27, 1, "SqlServer.Rules.SRP0018")); ExpectedProblems.Add(new TestProblem(4, 1, "SqlServer.Rules.SRD0028")); ExpectedProblems.Add(new TestProblem(14, 16, "SqlServer.Rules.SRD0020")); ExpectedProblems.Add(new TestProblem(17, 16, "SqlServer.Rules.SRD0020")); ExpectedProblems.Add(new TestProblem(14, 16, "SqlServer.Rules.SRD0020")); ExpectedProblems.Add(new TestProblem(17, 16, "SqlServer.Rules.SRD0020")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(17, 5, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(4, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(4, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(4, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(12, 5, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(18, 5, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(20, 5, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(15, 9, "SqlServer.Rules.SRD0066")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(15, 9, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(17, 5, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(12, 13, "SqlServer.Rules.SRP0016")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(28, 17, "SqlServer.Rules.SRD0020")); ExpectedProblems.Add(new TestProblem(34, 17, "SqlServer.Rules.SRD0020")); ExpectedProblems.Add(new TestProblem(43, 17, "SqlServer.Rules.SRD0020")); ExpectedProblems.Add(new TestProblem(49, 17, "SqlServer.Rules.SRD0020")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(12, 5, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(20, 31, "SqlServer.Rules.SRP0009")); ExpectedProblems.Add(new TestProblem(29, 31, "SqlServer.Rules.SRP0009")); ExpectedProblems.Add(new TestProblem(9, 5, "SqlServer.Rules.SRD0028")); ExpectedProblems.Add(new TestProblem(27, 10, "SqlServer.Rules.SRD0038")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(9, 5, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(9, 5, "SqlServer.Rules.SRD0028")); ExpectedProblems.Add(new TestProblem(27, 10, "SqlServer.Rules.SRD0038")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(9, 5, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(10, 5, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(18, 31, "SqlServer.Rules.SRP0009")); ExpectedProblems.Add(new TestProblem(27, 31, "SqlServer.Rules.SRP0009")); ExpectedProblems.Add(new TestProblem(54, 27, "SqlServer.Rules.SRD0056")); ExpectedProblems.Add(new TestProblem(20, 13, "SqlServer.Rules.SRD0066")); ExpectedProblems.Add(new TestProblem(17, 5, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(6, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(6, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(6, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(6, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(27, 71, "SqlServer.Rules.SRD0063")); ExpectedProblems.Add(new TestProblem(35, 71, "SqlServer.Rules.SRD0063")); ExpectedProblems.Add(new TestProblem(43, 71, "SqlServer.Rules.SRD0063")); ExpectedProblems.Add(new TestProblem(51, 70, "SqlServer.Rules.SRD0063")); ExpectedProblems.Add(new TestProblem(4, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(4, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(16, 7, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(20, 13, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(27, 19, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(34, 19, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(35, 19, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(42, 19, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(43, 19, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(50, 19, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(51, 19, "SqlServer.Rules.SRD0068")); ExpectedProblems.Add(new TestProblem(2, 1, "SqlServer.Rules.SRD0069")); ExpectedProblems.Add(new TestProblem(92, 1, "SqlServer.Rules.SRD0065")); ExpectedProblems.Add(new TestProblem(110, 1, "SqlServer.Rules.SRD0065")); ExpectedProblems.Add(new TestProblem(98, 1, "SqlServer.Rules.SRD0065")); ExpectedProblems.Add(new TestProblem(35, 1, "SqlServer.Rules.SRD0065")); ExpectedProblems.Add(new TestProblem(49, 9, "SqlServer.Rules.SRP0004")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0065")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0065")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0065")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRP0020")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(3, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0067")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRP0020")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(3, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(3, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0065")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(1, 1, "SqlServer.Rules.SRD0001")); ExpectedProblems.Add(new TestProblem(2, 5, "SqlServer.Rules.SRD0010")); ExpectedProblems.Add(new TestProblem(23, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(34, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(17, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(28, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(29, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(16, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(21, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(21, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(16, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(16, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(19, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(16, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(16, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(22, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(23, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(45, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(17, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(41, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(52, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(47, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(58, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(69, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(20, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(29, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(52, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(63, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(74, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(17, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(28, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(17, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(19, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(30, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(19, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(30, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(29, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(53, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(86, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(29, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(20, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(22, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(33, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(28, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(39, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(22, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(16, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(18, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(29, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(21, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(32, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(28, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(19, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(23, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(34, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(45, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(21, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(16, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(23, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(27, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(24, 1, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(11, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(11, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(9, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(9, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(10, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(16, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(18, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(11, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(15, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(27, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(9, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(10, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(13, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(13, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(15, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(13, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(28, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(11, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(9, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(12, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(13, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(10, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(11, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(11, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(5, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(10, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(12, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(14, 5, "SqlServer.Rules.SRN0007")); ExpectedProblems.Add(new TestProblem(16, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(10, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(11, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(10, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(12, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(18, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(38, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(39, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(40, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(41, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(12, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(6, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(8, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(22, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(18, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(35, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(36, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(37, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(38, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(41, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(42, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(7, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(18, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(17, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(11, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(10, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(11, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(12, 5, "SqlServer.Rules.SRD0004")); ExpectedProblems.Add(new TestProblem(20, 5, "SqlServer.Rules.SRD0004")); RunTest(); } }