예제 #1
0
        public void ClassicCount()
        {
            //ANSI-SQL92 definition
            //COUNT < leftparen> <asterisk> < right paren>
            IList args = new ArrayList();

            ClassicCountFunction ccf = new ClassicCountFunction();

            args.Add("va1");
            Assert.AreEqual("count(va1)", ccf.Render(args, factoryImpl).ToString());

            args.Clear();
            args.Add("*");
            Assert.AreEqual("count(*)", ccf.Render(args, factoryImpl).ToString());

            args.Clear();
            args.Add("va1");
            args.Add("va2");
            try
            {
                SqlString t = ccf.Render(args, factoryImpl);
                Assert.Fail("No exception 2 argument without <setquantifier>:" + t);
            }
            catch (QueryException)
            {
                //correct
            }
        }
예제 #2
0
        public void ClassicCount()
        {
            //ANSI-SQL92 definition
            //COUNT < leftparen> <asterisk> < right paren>
            IList args = new ArrayList();

            ClassicCountFunction ccf = new ClassicCountFunction();

            args.Add("va1");
            Assert.AreEqual("count(va1)", ccf.Render(args, factoryImpl).ToString());

            args.Clear();
            args.Add("*");
            Assert.AreEqual("count(*)", ccf.Render(args, factoryImpl).ToString());

            args.Clear();
            args.Add("va1");
            args.Add("va2");
            Assert.Throws <QueryException>(() => ccf.Render(args, factoryImpl), "No exception 2 argument without <setquantifier>");
        }