wrong_num_function_args::[
  date_diff::[
    {
      name:"date_diff wrong number of arguments{sql:\"date_diff()\"}",
      statement:"date_diff()",
      assert: {
        result: StaticAnalysisFail
      },
    },
    {
      name:"date_diff wrong number of arguments{sql:\"date_diff(year)\"}",
      statement:"date_diff(year)",
      assert: {
        result: StaticAnalysisFail
      },
    },
    {
      name:"date_diff wrong number of arguments{sql:\"date_diff(year, `2017T`)\"}",
      statement:"date_diff(year, `2017T`)",
      assert: {
        result: StaticAnalysisFail
      },
    },
    {
      name:"date_diff wrong number of arguments{sql:\"date_diff(year, `2017T`, `2017T`, `2017T`)\"}",
      statement:"date_diff(year, `2017T`, `2017T`, `2017T`)",
      assert: {
        result: StaticAnalysisFail
      },
    },
    {
      name:"date_diff wrong number of arguments{sql:\"date_diff(year, `2017T`, `2017T`, 1)\"}",
      statement:"date_diff(year, `2017T`, `2017T`, 1)",
      assert: {
        result: StaticAnalysisFail
      },
    },
  ],
]

invalid_function_args::[
  date_diff::[
    {
      name:"date_diff wrong type of arguments{time_part:\"1\",left:\"`2017T`\",right:\"`2017T`\"}",
      statement:"date_diff(1, `2017T`, `2017T`)",
      assert: {
        result: StaticAnalysisFail
      },
    },
    {
      name:"date_diff wrong type of arguments{time_part:\"year\",left:\"1\",right:\"`2017T`\"}",
      statement:"date_diff(year, 1, `2017T`)",
      assert: {
        result: StaticAnalysisFail
      },
    },
    {
      name:"date_diff wrong type of arguments{time_part:\"year\",left:\"`2017T`\",right:\"1\"}",
      statement:"date_diff(year, `2017T`, 1)",
      assert: {
        result: StaticAnalysisFail
      },
    },
    {
      name:"date_diff invalid arguments{time_part:\"'foobar'\"}",
      statement:"date_diff('foobar', `2001T`, `1986T`)",
      assert: {
        result: StaticAnalysisFail
      },
    },
    {
      name:"date_diff invalid arguments{time_part:1}",
      statement:"date_diff(1, `2001T`, `1986T`)",
      assert: {
        result: StaticAnalysisFail
      },
    },
    {
      name:"date_diff invalid arguments{time_part:[]}",
      statement:"date_diff([], `2001T`, `1986T`)",
      assert: {
        result: StaticAnalysisFail
      },
    },
  ],
]