SQL compliance explained

SQL compliance means adhering to rules laid for SQL. Some standards and protocols related to SQL are mentioned in this.

Function Description NexusDB
E011 Numeric data types
E011-01 INTEGER and SMALLINT data types (including all spellings)
E011-02 REAL, DOUBLE PRECISION, and FLOAT data types
E011-03 DECIMAL and NUMERIC data types
E011-04 Arithmetic operators
E011-05 Numeric comparison
E011-06 Implicit casting among the numeric data types
E021 Character string types
E021-01 CHARACTER data type (including all its spellings)
E021-02 CHARACTER VARYING data type (including all its spellings)
E021-03 Character literals
E021-04 CHARACTER_LENGTH function [1]
E021-05 OCTET_LENGTH function [2]
E021-06 SUBSTRING function
E021-07 Character concatenation
E021-08 UPPER and LOWER functions
E021-09 TRIM function [3] [4]
E021-10 Implicit casting among the fixed-length and variable-length character string types
E021-11 POSITION function [5] [6] [7] [8]
E021-12 Character comparison
E031 Identifiers
E031-01 Delimited identifiers
E031-02 Lower case identifiers
E031-03 Trailing underscore
E051 Basic query specification
E051-01 SELECT DISTINCT
E051-02 GROUP BY clause
E051-04 GROUP BY can contain columns not in <select-list> || || || || || || || || || || || |-| E051-05 || Select list items can be renamed || || || || || || || || || || || |-| E051-06 || HAVING clause || || || || || || || || || || || |-| E051-07 || Qualified * in select list || || || || || || || || || || || |-| E051-08 || Correlation names in the FROM clause || || || || || || || || || || || |-| E051-09 || Rename columns in the FROM clause || || || || || || || || || || || |-! E061 || Basic predicates and search conditions || || || || || || || || || || || |-| E061-01 || Comparison predicate || || || || || || || || || || || |-| E061-02 || BETWEEN predicate || || || || || || || || || || || |-| E061-03 || IN predicate with list of values || || || || || || || || || || || |-| E061-04 || LIKE predicate || || || || || || || || || || || |-| E061-05 || LIKE predicate: ESCAPE clause || || || || || || || || || || || |-| E061-06 || NULL predicate || || || || || || || || || || || |-| E061-07 || Quantified comparison predicate || || || || || || || || || || || |-| E061-08 || EXISTS predicate || || || || || || || || || || || |-| E061-09 || Subqueries in comparison predicate || || || || || || || || || || || |-| E061-11 || Subqueries in IN predicate || || || || || || || || || || || |-| E061-12 || Subqueries in quantified comparison predicate || || || || || || || || || || || |-| E061-13 || Correlated subqueries || || || || || || || || || || || |-| E061-14 || Search condition || || [9] || || || || || || || || || |-! E071 || Basic query expressions || || || || || || || || || || || |-| E071-01 || UNION DISTINCT table operator || || [10] || || || || || || || || || |-| E071-02 || UNION ALL table operator || || || || || || || || || || || |-| E071-03 || EXCEPT DISTINCT table operator || || || [11] || || || || || || || || |-| E071-05 || Columns combined via table operators need not have exactly the same data type || || || || || || || || || || || |-| E071-06 || Table operators in subqueries || || || || || || || || || || || |-! E081 || Basic Privileges || || || || || || || || || || || |-| E081-01 || SELECT privilege at the table level || || || || || || || || || || || |-| E081-02 || DELETE privilege || || || || || || || || || || || |-| E081-03 || INSERT privilege at the table level || || || || || || || || || || || |-| E081-04 || UPDATE privilege at the table level || || || || || || || || || || || |-| E081-05 || UPDATE privilege at the column level || || || || || || || || || || || |-| E081-06 || REFERENCES privilege at the table level || || || || || || || || || || || |-| E081-07 || REFERENCES privilege at the column level || || || || || || || || || || || |-| E081-08 || WITH GRANT OPTION || || || || || || || || || || || |-| E081-09 || USAGE privilege || || || || || || || || || || || |-| E081-10 || EXECUTE privilege || || || || || || || || || || || |-! E091 || Set functions || || || || || || || || || || || |-| E091-01 || AVG || || || || || || || || || || || |-| E091-02 || COUNT || || || || || || || || || || || |-| E091-03 || MAX || || || || || || || || || || || |-| E091-04 || MIN || || || || || || || || || || || |-| E091-05 || SUM || || || || || || || || || || || |-| E091-06 || ALL quantifier || || || || || || || || || || || |-| E091-07 || DISTINCT quantifier || || || || || || || || || || || |-! E101 || Basic data manipulation || || || || || || || || || || || |-| E101-01 || INSERT statement || || || || || || || || || || || |-| E101-03 || Searched UPDATE statement || || || || || || || || || || || |-| E101-04 || Searched DELETE statement || || || || || || || || || || || |-! E111 || Single row SELECT statement || || || || || || || || || || || |-! E121 || Basic cursor support || || || || || || || || || || || |-| E121-01 || DECLARE CURSOR || || || || || || || || || || || |-| E121-02 || ORDER BY columns need not be in select list || || || || || || || || [12] || || || |-| E121-03 || Value expressions in ORDER BY clause || || || || || || || || || || || |-| E121-04 || OPEN statement || || || || || || || || || || || |-| E121-06 || Positioned UPDATE statement || || || || || || || || || || || |-| E121-07 || Positioned DELETE statement || || || || || || || || || || || |-| E121-08 || CLOSE statement || || || || || || || || || || || |-| E121-10 || FETCH statement: implicit NEXT || || || || || || || || || || || |-| E121-17 || WITH HOLD cursors || || || || || || || || || || || |-! E131 || Null value support (nulls in lieu of values) || || || || || || || || || || || |-! E141 || Basic integrity constraints || || || || || || || || || || || |-| E141-01 || NOT NULL constraints || || || || || || || || || || || |-| E141-02 || UNIQUE constraints of NOT NULL columns || || || || || || || || || || || |-| E141-03 || PRIMARY KEY constraints || || || || || || || || [13] || || || |-| E141-04 || Basic FOREIGN KEY constraint with the NO ACTION default for both referential delete action and referential update action || || || || || || || || || || || |-| E141-06 || CHECK constraints || || || || || || || || || || || |-| E141-07 || Column defaults || || || || || || || || || || || |-| E141-08 || NOT NULL inferred on PRIMARY KEY || || || || || || || || [14] || || || |-| E141-10 || Names in a foreign key can be specified in any order || || || || || || || || || || || |-! E151 || Transaction support || || || || || || || || || || || |-| E151-01 || COMMIT statement || || || || || || || || || || || |-| E151-02 || ROLLBACK statement || || || || || || || || || || || |-| E152 || Basic SET TRANSACTION statement || || || || || || || || || || || |-| E152-01 || SET TRANSACTION statement: ISOLATION LEVEL SERIALIZABLE clause || || [15] || || || || || || || || || |-| E152-02 || SET TRANSACTION statement: READ ONLY and READ WRITE clauses || || || || || || || || || || || |-! E* || Other || || || || || || || || || || || |-| E153 || Updatable queries with subqueries || || || || || || || || || || || |-| E161 || SQL comments using leading double minus || || || || || || || || || || || |-| E171 || SQLSTATE support || || || || || || || || || || || |-| E182 || Host language binding (previously "Module Language") || || [16] || || || || || || || || |-! F021 || Basic information schema || || || || || || [17] || || || || |-| F021-01 || COLUMNS view || || [18] || || || || [19] || || || || |-| F021-02 || TABLES view || || || || || || || || [20] || || |-| F021-03 || VIEWS view || || || || || || || || || || |-| F021-04 || TABLE_CONSTRAINTS view || || || || || || || || || || |-| F021-05 || REFERENTIAL_CONSTRAINTS view || || || || || || || || || || |-| F021-06 || CHECK_CONSTRAINTS view || || || || || || || || || || |-! F031 || Basic schema manipulation || || || || || || || || || || |-| F031-01 || CREATE TABLE statement to create persistent base tables || || || || || || || || || || |-| F031-02 || CREATE VIEW statement || || || || || || || || || || |-| F031-03 || GRANT statement || || || || || || || || || || |-| F031-04 || ALTER TABLE statement: ADD COLUMN clause || || || || || || || || || || |-| F031-13 || DROP TABLE statement: RESTRICT clause || || || || || || || || || || |-| F031-16 || DROP VIEW statement: RESTRICT clause || || || || || || || || || || |-| F031-19 || REVOKE statement: RESTRICT clause || || || || || || || || || || |-! F041 || Basic joined table || || || || || || || || || || |-| F041-01 || Inner join (but not necessarily the INNER keyword) || || || || || || || || || || |-| F041-02 || INNER keyword || || || || || || || || || || |-| F041-03 || LEFT OUTER JOIN || || || || || || || || || || |-| F041-04 || RIGHT OUTER JOIN || || || || || || || || || || |-| F041-05 || Outer joins can be nested || || || || || || || || || || |-| F041-07 || The inner table in a left or right outer join can also be used in an inner join || || || || || || || || || || |-| F041-08 || All comparison operators are supported (rather than just =) || || || || || || || || || || |-! F051 || Basic date and time || || || || || || || || || || |-| F051-01 || DATE data type (including support of DATE literal) || || || || || || || || || || |-| F051-02 || TIME data type (including support of TIME literal) with fractional seconds precision of at least 0 || || || || || || || || || || |-| F051-03 || TIMESTAMP data type (including support of TIMESTAMP literal) with fractional seconds precision of at least 0 and 6 || || || || || || || || || || |-| F051-04 || Comparison predicate on DATE, TIME, and TIMESTAMP data types || || || || || || || || || || |-| F051-05 || Explicit CAST between datetime types and character string types || || || || || || || || || || |-| F051-06 || CURRENT_DATE || || || || || || || || || || |-| F051-07 || LOCALTIME || || || || || || || || || || |-| F051-08 || LOCALTIMESTAMP || || || || || || || || || || |-| F081 || UNION and EXCEPT in views || || || || || || || || || || |-! F131 || Grouped operations || || || || || || || || || || |-| F131-01 || WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views || || || || || || || || || || |-| F131-02 || Multiple tables supported in queries with grouped views || || || || || || || || || || |-| F131-03 || Set functions supported in queries with grouped views || || || || || || || || || || |-| F131-04 || Subqueries with GROUP BY and HAVING clauses and grouped views || || || || || || || || || || |-| F131-05 || Single row SELECT with GROUP BY and HAVING clauses and grouped views || || || || || || || || || || |-! F* || Other || || || || || || || || || || |-| F181 || Multiple module support || || || || || || || || || || |-| F201 || function || || || || || || || || || || |-| F221 || Explicit defaults || || || || || || || || || || |-! F261 || expression || || || || || || || || || || |-| F261-01 || Simple CASE || || || || || || || || || || |-| F261-02 || Searched CASE || || || || || || || || || || |-| F261-03 || NULLIF || || || || || || || || || || |-| F261-04 || COALESCE || || || || || || || || || || |-! F311 || Schema definition statement || || || || || || || || || || |-| F311-01 || CREATE SCHEMA || || || || || || || || || || |-| F311-02 || CREATE TABLE for persistent base tables || || || || || || || || || || |-| F311-03 || CREATE VIEW || || || || || || || || || || |-| F311-04 || CREATE VIEW: WITH CHECK OPTION || || || || || || || || || || |-| F311-05 || GRANT statement || || || || || || || || || || |-| F471 || Scalar subquery values || || || || || || || || || || |-| F481 || Expanded NULL predicate || || || || || || || || || || |-! F501 || Features and conformance views || || || || || || || || || || |-| F501-01 || SQL_FEATURES view || || || || || || || || || || |-| F501-02 || SQL_SIZING view || || || || || || || || || || |-| F501-03 || SQL_LANGUAGES view || || || || || || || || || || |-| F812 || Basic flagging || || || || || || || || || || |-| S011 || Distinct data types || || || || || || || || || || |-| S011-01 || USER_DEFINED_TYPES view || || || || || || || || || || |-! T321 || Basic SQL-invoked routines || || || || || || || || || || |-| T321-01 || User-defined functions with no overloading || || || || || || || || || || |-| T321-02 || User-defined stored procedures with no overloading || || || || || || || || || || |-| T321-03 || Function invocation || || || || || || || || || || |-| T321-04 || CALL statement || || || || || || || || || || |-| T321-05 || RETURN statement || || || [21] || || || || || || || |-| T321-06 || ROUTINES view || || || [22] || || || || || || || |-| T321-07 || PARAMETERS view || || || [23] || || || || || || || |-| T631 || predicate with one list element || || || || || || || || || || |}

See also

References

Notes and References

  1. Trims trailing spaces from CHARACTER values before counting
  2. There is no built-in function by this name, although the number of octets in a string can be determined by using LENGTH(CAST(X AS BLOB)).
  3. There are LTRIM and RTRIM functions for equivalent functionality.
  4. Web site: [MS-TSQLISO02]

    E021-09, TRIM function ]

    . docs.microsoft.com . 22 April 2020 . en-us.
  5. There is INSTR.
  6. There is the CHARINDEX function for equivalent functionality.
  7. Web site: [MS-TSQLISO02]

    E021-11, POSITION function ]

    . docs.microsoft.com . 22 April 2020 . en-us.
  8. There is the charindex function for equivalent functionality.
  9. Lacks support for [IS [NOT] TRUE|FALSE|UNKNOWN]
  10. Without DISTINCT keyword
  11. Use MINUS instead of EXCEPT DISTINCT
  12. Except compound queries.
  13. Only WITHOUT ROWID tables have real primary keys other than the rowid (INTEGER PRIMARY KEY)
  14. Only for WITHOUT ROWID tables.
  15. SET [CURRENT] ISOLATION used instead of SET TRANSACTION
  16. Supports embedded language features but not the specific MODULE syntax
  17. Web site: MySQL :: MySQL 5.7 Reference Manual :: 24 INFORMATION_SCHEMA Tables.
  18. Included in SYSIBM schema
  19. Also includes MySQL-specific extension columns
  20. You can use PRAGMA for obtaining this information, and can create an information schema based on this, but it is not build in.
  21. Oracle supports the following subfeature in PL/SQL but not in Oracle SQL.
  22. Use the ALL PROCEDURES metadata view.
  23. Use the ALL_ARGUMENTS and ALL_METHOD_PARAMS metadata views.

This article is licensed under the GNU Free Documentation License. It uses material from the Wikipedia article "SQL compliance".

Except where otherwise indicated, Everything.Explained.Today is © Copyright 2009-2026, A B Cryer, All Rights Reserved. Cookie policy.