// Pending resolution of https://github.com/partiql/partiql-spec/issues/51#issuecomment-1498352752.
// The following tests use SQL aggregation functions in contexts where a `COLL_` aggregation function is expected
// (e.g. as a top-level query)

spec_51::[
    {
        name:"top level AVG disallowed",
        statement:"AVG([1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level AVG ALL disallowed",
        statement:"AVG(ALL [1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level AVG DISTINCT disallowed",
        statement:"AVG(DISTINCT [1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level COUNT disallowed",
        statement:"COUNT([1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level COUNT ALL disallowed",
        statement:"COUNT(ALL [1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level COUNT DISTINCT disallowed",
        statement:"COUNT(DISTINCT [1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level MAX disallowed",
        statement:"MAX([1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level MAX ALL disallowed",
        statement:"MAX(ALL [1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level MAX DISTINCT disallowed",
        statement:"MAX(DISTINCT [1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level MIN disallowed",
        statement:"MIN([1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level MIN ALL disallowed",
        statement:"MIN(ALL [1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level MIN DISTINCT disallowed",
        statement:"MIN(DISTINCT [1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level SUM disallowed",
        statement:"SUM([1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level SUM ALL disallowed",
        statement:"SUM(ALL [1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level SUM DISTINCT disallowed",
        statement:"SUM(DISTINCT [1, 2, 3, 3])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level ANY disallowed",
        statement:"ANY([true, true, false, false])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level ANY ALL disallowed",
        statement:"ANY(ALL [true, true, false, false])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level ANY DISTINCT disallowed",
        statement:"ANY(DISTINCT [true, true, false, false])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level SOME disallowed",
        statement:"SOME([true, true, false, false])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level SOME ALL disallowed",
        statement:"SOME(ALL [true, true, false, false])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level SOME DISTINCT disallowed",
        statement:"SOME(DISTINCT [true, true, false, false])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level EVERY disallowed",
        statement:"EVERY([true, true, false, false])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level EVERY ALL disallowed",
        statement:"EVERY(ALL [true, true, false, false])",
        assert: {
            result: StaticAnalysisFail
        },
    },
    {
        name:"top level EVERY DISTINCT disallowed",
        statement:"EVERY(DISTINCT [true, true, false, false])",
        assert: {
            result: StaticAnalysisFail
        },
    },
]