与 SQLSTATE 42P20 关联的消息

本主题列出了与 SQLSTATE 42P20 关联的消息。

SQLSTATE 42P20 说明

WINDOWING_ERROR

与此 SQLState 关联的消息

ERROR 2011: string cannot use the WITHIN GROUP clause

ERROR 2041: string may only have one sort expression in the WITHIN GROUP
            clause

ERROR 2043: string must contain an ORDER BY clause within its analytic
            clause

ERROR 2044: string must NOT contain an ORDER BY clause or WINDOWING clause
            within its analytic clause

ERROR 2045: string must NOT contain WINDOWING clause within its analytic
            clause

ERROR 2047: string only supports the Integer, Float, Interval and Numeric
            data types

ERROR 2182: Analytic functions are allowed only in a SELECT list
            and/or ORDER BY clause

ERROR 2185: Analytic functions are not supported in the PARTITION BY
            of an OVER clause

ERROR 2187: Analytic functions cannot be nested

ERROR 2188: Analytic functions must have a FROM clause

ERROR 2189: Analytic functions not allowed in string

ERROR 2305: Can't cast the window bound into Int

ERROR 2306: Can't cast the window bound into the same data type of the
            ORDER BY column

ERROR 2465: Cannot override ORDER BY clause of window "string"

ERROR 2466: Cannot override PARTITION BY clause of window "string"

ERROR 2524: Cannot specify frame clause of window "string"

ERROR 3435: For range moving window, OrderBy expression must be one of
            Int, Float, Time, Timestamp, Interval, Date or Numeric

ERROR 3446: Frame clause not allowed without windowing order by

ERROR 3839: Keyword "ALL" is invalid in analytic functions

ERROR 4362: PERCENTILE_CONT/PERCENTILE_DISC must have the WITHIN GROUP
            clause

ERROR 4363: PERCENTILE_CONT/PERCENTILE_DISC must NOT contain an ORDER
            BY clause or WINDOWING clause within its analytic clause

ERROR 4811: Subqueries are not supported in the PARTITION BY of a
            timeseries OVER clause

ERROR 5006: Time Series Aggregate Functions are not supported in the
            PARTITION BY of a timeseries OVER clause

ERROR 5010: Time Series timestamp alias/Time Series Aggregate
            Functions not allowed in string

ERROR 5460: Window "string" is already defined

ERROR 5461: Window frame cannot end with PRECEDING if start is CURRENT
            ROW

ERROR 5462: Window frame cannot end with PRECEDING or CURRENT ROW if
            start is FOLLOWING

ERROR 5463: Window frame cannot end with UNBOUNDED PRECEDING

ERROR 5464: Window frame cannot start with UNBOUNDED FOLLOWING

ERROR 5466: Window frame logical offset must be a non-negative number
            to be consistent with the sort column type

ERROR 5467: Window frame logical offset must be an Interval (Day to
            Second or Year to Month) to be consistent with the sort
            column type

ERROR 5468: Window frame logical offset must be an Interval (Day to
            Second) to be consistent with the sort column type

ERROR 5469: Window frame logical offset must be an interval to be
            consistent with the sort column type

ERROR 5470: Window frame logical offset must be Int when the sort
            column type is Int

ERROR 5471: Window frame logical offset must be the same type as the
            sort column type (Interval Day to Second)

ERROR 5472: Window frame logical offset must be the same type as the
            sort column type (Interval Year to Month)

ERROR 5473: Window frame logical or physical offset must be a constant

ERROR 5474: Window frame logical or physical offset must be non-
            negative number or interval

ERROR 5475: Window frame physical offset must be non-negative number

ERROR 5477: Window ordering clause can only contain a single sort key
            if RANGE is used

ERROR 5478: Windowing not supported for User Defined Analytic
            functions

ERROR 6276: Grouping functions cannot appear within Analytic functions

ERROR 6900: Partition Prepass/Batch may only be used with Live
            Aggregate Projection

ERROR 7838: Windowing not supported for analytic usage of BOOL_XOR