Esempio n. 1
0
        public void Extract_Cast_String_Test()
        {
            var sql          = "SELECT CAST('Jamal' AS VARCHAR(50)) AS FirstName FROM [dbo].[Employee];";
            var minifier     = new SqlMinifier();
            var sqlWords     = minifier.LoadWordArray(sql);
            var castPosition = 1;

            Assert.IsTrue(sqlWords[castPosition] == "CAST");
            var cast1 = minifier.GetCast(sqlWords, ref castPosition, sql_function: "CAST");

            Assert.AreEqual(cast1.Length, 9);
            Assert.AreEqual(castPosition, 9);
            var results = minifier.HandleCast(cast1);

            Assert.AreEqual(results, "CAST('Jamal' AS VARCHAR(50))");
        }