http://git-wip-us.apache.org/repos/asf/incubator-trafodion-site/blob/c9ae8c27/docs/2.1.0/sql_reference/index.html ---------------------------------------------------------------------- diff --git a/docs/2.1.0/sql_reference/index.html b/docs/2.1.0/sql_reference/index.html index e5b1b15..1e6a519 100644 --- a/docs/2.1.0/sql_reference/index.html +++ b/docs/2.1.0/sql_reference/index.html @@ -607,398 +607,377 @@ table.CodeRay td.code>pre{padding:0} <li><a href="#show_get_and_explain_statements">3.1.9. SHOW, GET, and EXPLAIN Statements</a></li> </ul> </li> -<li><a href="#alter_sequence_statement">3.2. ALTER SEQUENCE Statement</a> +<li><a href="#alter_table_statement">3.2. ALTER TABLE Statement</a> <ul class="sectlevel3"> -<li><a href="#alter_sequence_syntax">3.2.1. Syntax Description of ALTER SEQUENCE</a></li> -<li><a href="#alter_sequence_considerations">3.2.2. Considerations for ALTER SEQUENCE</a></li> -<li><a href="#alter_sequence_examples">3.2.3. Examples of ALTER SEQUENCE</a></li> +<li><a href="#alter_table_syntax">3.2.1. Syntax Description of ALTER TABLE</a></li> +<li><a href="#alter_table_considerations">3.2.2. Considerations for ALTER TABLE</a></li> +<li><a href="#alter_table_examples">3.2.3. Example of ALTER TABLE</a></li> </ul> </li> -<li><a href="#alter_table_statement">3.3. ALTER TABLE Statement</a> +<li><a href="#alter_user_statement">3.3. ALTER USER Statement</a> <ul class="sectlevel3"> -<li><a href="#alter_table_syntax">3.3.1. Syntax Description of ALTER TABLE</a></li> -<li><a href="#alter_table_considerations">3.3.2. Considerations for ALTER TABLE</a></li> -<li><a href="#alter_table_examples">3.3.3. Example of ALTER TABLE</a></li> +<li><a href="#alter_user_syntax">3.3.1. Syntax Description of ALTER USER</a></li> +<li><a href="#alter_user_considerations">3.3.2. Considerations for ALTER USER</a></li> +<li><a href="#alter_user_examples">3.3.3. Examples of ALTER USER</a></li> </ul> </li> -<li><a href="#alter_user_statement">3.4. ALTER USER Statement</a> +<li><a href="#begin_work_statement">3.4. BEGIN WORK Statement</a> <ul class="sectlevel3"> -<li><a href="#alter_user_syntax">3.4.1. Syntax Description of ALTER USER</a></li> -<li><a href="#alter_user_considerations">3.4.2. Considerations for ALTER USER</a></li> -<li><a href="#alter_user_examples">3.4.3. Examples of ALTER USER</a></li> +<li><a href="#begin_work_considerations">3.4.1. Considerations for BEGIN WORK</a></li> +<li><a href="#begin_work_examples">3.4.2. Example of BEGIN WORK</a></li> </ul> </li> -<li><a href="#begin_work_statement">3.5. BEGIN WORK Statement</a> +<li><a href="#call_statement">3.5. CALL Statement</a> <ul class="sectlevel3"> -<li><a href="#begin_work_considerations">3.5.1. Considerations for BEGIN WORK</a></li> -<li><a href="#begin_work_examples">3.5.2. Example of BEGIN WORK</a></li> +<li><a href="#call_syntax">3.5.1. Syntax Description of CALL</a></li> +<li><a href="#call_considerations">3.5.2. Considerations for CALL</a></li> +<li><a href="#call_examples">3.5.3. Examples of CALL</a></li> </ul> </li> -<li><a href="#call_statement">3.6. CALL Statement</a> +<li><a href="#commit_work_statement">3.6. COMMIT WORK Statement</a> <ul class="sectlevel3"> -<li><a href="#call_syntax">3.6.1. Syntax Description of CALL</a></li> -<li><a href="#call_considerations">3.6.2. Considerations for CALL</a></li> -<li><a href="#call_examples">3.6.3. Examples of CALL</a></li> +<li><a href="#commit_work_considerations">3.6.1. Considerations for COMMIT WORK</a></li> +<li><a href="#commit_work_examples">3.6.2. Example of COMMIT WORK</a></li> </ul> </li> -<li><a href="#commit_work_statement">3.7. COMMIT WORK Statement</a> +<li><a href="#control_query_cancel_statement">3.7. CONTROL QUERY CANCEL Statement</a> <ul class="sectlevel3"> -<li><a href="#commit_work_considerations">3.7.1. Considerations for COMMIT WORK</a></li> -<li><a href="#commit_work_examples">3.7.2. Example of COMMIT WORK</a></li> +<li><a href="#control_query_cancel_syntax">3.7.1. Syntax Description of CONTROL QUERY CANCEL</a></li> +<li><a href="#control_query_cancel_considerations">3.7.2. Considerations for CONTROL QUERY CANCEL</a></li> +<li><a href="#control_query_cancel_examples">3.7.3. Example of CONTROL QUERY CANCEL</a></li> </ul> </li> -<li><a href="#control_query_cancel_statement">3.8. CONTROL QUERY CANCEL Statement</a> +<li><a href="#control_query_default_statement">3.8. CONTROL QUERY DEFAULT Statement</a> <ul class="sectlevel3"> -<li><a href="#control_query_cancel_syntax">3.8.1. Syntax Description of CONTROL QUERY CANCEL</a></li> -<li><a href="#control_query_cancel_considerations">3.8.2. Considerations for CONTROL QUERY CANCEL</a></li> -<li><a href="#control_query_cancel_examples">3.8.3. Example of CONTROL QUERY CANCEL</a></li> +<li><a href="#control_query_default_syntax">3.8.1. Syntax Description of CONTROL QUERY DEFAULT</a></li> +<li><a href="#control_query_default_considerations">3.8.2. Considerations for CONTROL QUERY DEFAULT</a></li> +<li><a href="#control_query_default_examples">3.8.3. Examples of CONTROL QUERY DEFAULT</a></li> </ul> </li> -<li><a href="#control_query_default_statement">3.9. CONTROL QUERY DEFAULT Statement</a> +<li><a href="#create_function_statement">3.9. CREATE FUNCTION Statement</a> <ul class="sectlevel3"> -<li><a href="#control_query_default_syntax">3.9.1. Syntax Description of CONTROL QUERY DEFAULT</a></li> -<li><a href="#control_query_default_considerations">3.9.2. Considerations for CONTROL QUERY DEFAULT</a></li> -<li><a href="#control_query_default_examples">3.9.3. Examples of CONTROL QUERY DEFAULT</a></li> +<li><a href="#create_function_syntax">3.9.1. Syntax Description of CREATE FUNCTION</a></li> +<li><a href="#create_function_considerations">3.9.2. Considerations for CREATE FUNCTION</a></li> +<li><a href="#create_function_examples">3.9.3. Examples of CREATE FUNCTION</a></li> </ul> </li> -<li><a href="#create_function_statement">3.10. CREATE FUNCTION Statement</a> +<li><a href="#create_index_statement">3.10. CREATE INDEX Statement</a> <ul class="sectlevel3"> -<li><a href="#create_function_syntax">3.10.1. Syntax Description of CREATE FUNCTION</a></li> -<li><a href="#create_function_considerations">3.10.2. Considerations for CREATE FUNCTION</a></li> -<li><a href="#create_function_examples">3.10.3. Examples of CREATE FUNCTION</a></li> +<li><a href="#create_index_syntax">3.10.1. Syntax Description of CREATE INDEX</a></li> +<li><a href="#create_index_considerations">3.10.2. Considerations for CREATE INDEX</a></li> +<li><a href="#create_index_examples">3.10.3. Examples of CREATE INDEX</a></li> </ul> </li> -<li><a href="#create_index_statement">3.11. CREATE INDEX Statement</a> +<li><a href="#create_library_statement">3.11. CREATE LIBRARY Statement</a> <ul class="sectlevel3"> -<li><a href="#create_index_syntax">3.11.1. Syntax Description of CREATE INDEX</a></li> -<li><a href="#create_index_considerations">3.11.2. Considerations for CREATE INDEX</a></li> -<li><a href="#create_index_examples">3.11.3. Examples of CREATE INDEX</a></li> +<li><a href="#create_library_syntax">3.11.1. Syntax Description of CREATE LIBRARY</a></li> +<li><a href="#create_library_considerations">3.11.2. Considerations for CREATE LIBRARY</a></li> +<li><a href="#create_library_examples">3.11.3. Examples of CREATE LIBRARY</a></li> </ul> </li> -<li><a href="#create_library_statement">3.12. CREATE LIBRARY Statement</a> +<li><a href="#create_procedure_statement">3.12. CREATE PROCEDURE Statement</a> <ul class="sectlevel3"> -<li><a href="#create_library_syntax">3.12.1. Syntax Description of CREATE LIBRARY</a></li> -<li><a href="#create_library_considerations">3.12.2. Considerations for CREATE LIBRARY</a></li> -<li><a href="#create_library_examples">3.12.3. Examples of CREATE LIBRARY</a></li> +<li><a href="#create_procedure_syntax">3.12.1. Syntax Description of CREATE PROCEDURE</a></li> +<li><a href="#create_procedure_considerations">3.12.2. Considerations for CREATE PROCEDURE</a></li> +<li><a href="#create_procedure_examples">3.12.3. Examples of CREATE PROCEDURE</a></li> </ul> </li> -<li><a href="#create_procedure_statement">3.13. CREATE PROCEDURE Statement</a> +<li><a href="#create_role_statement">3.13. CREATE ROLE Statement</a> <ul class="sectlevel3"> -<li><a href="#create_procedure_syntax">3.13.1. Syntax Description of CREATE PROCEDURE</a></li> -<li><a href="#create_procedure_considerations">3.13.2. Considerations for CREATE PROCEDURE</a></li> -<li><a href="#create_procedure_examples">3.13.3. Examples of CREATE PROCEDURE</a></li> +<li><a href="#create_role_syntax">3.13.1. Syntax Description of CREATE ROLE</a></li> +<li><a href="#create_role_considerations">3.13.2. Considerations for CREATE ROLE</a></li> +<li><a href="#create_role_examples">3.13.3. Examples of CREATE ROLE</a></li> </ul> </li> -<li><a href="#create_role_statement">3.14. CREATE ROLE Statement</a> +<li><a href="#create_schema_statement">3.14. CREATE SCHEMA Statement</a> <ul class="sectlevel3"> -<li><a href="#create_role_syntax">3.14.1. Syntax Description of CREATE ROLE</a></li> -<li><a href="#create_role_considerations">3.14.2. Considerations for CREATE ROLE</a></li> -<li><a href="#create_role_examples">3.14.3. Examples of CREATE ROLE</a></li> +<li><a href="#create_schema_syntax">3.14.1. Syntax Description of CREATE SCHEMA</a></li> +<li><a href="#create_schema_considerations">3.14.2. Considerations for CREATE SCHEMA</a></li> +<li><a href="#create_schema_examples">3.14.3. Examples of CREATE SCHEMA</a></li> </ul> </li> -<li><a href="#create_schema_statement">3.15. CREATE SCHEMA Statement</a> +<li><a href="#create_table_statement">3.15. CREATE TABLE Statement</a> <ul class="sectlevel3"> -<li><a href="#create_schema_syntax">3.15.1. Syntax Description of CREATE SCHEMA</a></li> -<li><a href="#create_schema_considerations">3.15.2. Considerations for CREATE SCHEMA</a></li> -<li><a href="#create_schema_examples">3.15.3. Examples of CREATE SCHEMA</a></li> +<li><a href="#create_table_syntax">3.15.1. Syntax Description of CREATE TABLE</a></li> +<li><a href="#create_table_considerations">3.15.2. Considerations for CREATE TABLE</a></li> +<li><a href="#create_table_trafodion_sql_extensions_to_create_table">3.15.3. Trafodion SQL Extensions to CREATE TABLE</a></li> +<li><a href="#create_table_examples">3.15.4. Examples of CREATE TABLE</a></li> </ul> </li> -<li><a href="#create_sequence_statement">3.16. CREATE SEQUENCE Statement</a> +<li><a href="#create_view_statement">3.16. CREATE VIEW Statement</a> <ul class="sectlevel3"> -<li><a href="#create_sequence_syntax">3.16.1. Syntax Description of CREATE SEQUENCE</a></li> -<li><a href="#create_sequence_considerations">3.16.2. Considerations for CREATE SEQUENCE</a></li> -<li><a href="#create_sequence_examples">3.16.3. Examples of CREATE SEQUENCE</a></li> +<li><a href="#create_view_syntax">3.16.1. Syntax Description of CREATE VIEW</a></li> +<li><a href="#create_view_considerations">3.16.2. Considerations for CREATE VIEW</a></li> +<li><a href="#create_view_examples">3.16.3. Examples of CREATE VIEW</a></li> </ul> </li> -<li><a href="#create_table_statement">3.17. CREATE TABLE Statement</a> +<li><a href="#delete_statement">3.17. DELETE Statement</a> <ul class="sectlevel3"> -<li><a href="#create_table_syntax">3.17.1. Syntax Description of CREATE TABLE</a></li> -<li><a href="#create_table_considerations">3.17.2. Considerations for CREATE TABLE</a></li> -<li><a href="#create_table_trafodion_sql_extensions_to_create_table">3.17.3. Trafodion SQL Extensions to CREATE TABLE</a></li> -<li><a href="#create_table_examples">3.17.4. Examples of CREATE TABLE</a></li> +<li><a href="#delete_syntax">3.17.1. Syntax Description of DELETE</a></li> +<li><a href="#delete_considerations">3.17.2. Considerations for DELETE</a></li> +<li><a href="#delete_examples">3.17.3. Examples of DELETE</a></li> </ul> </li> -<li><a href="#create_view_statement">3.18. CREATE VIEW Statement</a> +<li><a href="#drop_function_statement">3.18. DROP FUNCTION Statement</a> <ul class="sectlevel3"> -<li><a href="#create_view_syntax">3.18.1. Syntax Description of CREATE VIEW</a></li> -<li><a href="#create_view_considerations">3.18.2. Considerations for CREATE VIEW</a></li> -<li><a href="#create_view_examples">3.18.3. Examples of CREATE VIEW</a></li> +<li><a href="#drop_function_syntax">3.18.1. Syntax Description of DROP FUNCTION</a></li> +<li><a href="#drop_function_considerations">3.18.2. Considerations for DROP FUNCTION</a></li> +<li><a href="#drop_function_examples">3.18.3. Examples of DROP FUNCTION</a></li> </ul> </li> -<li><a href="#delete_statement">3.19. DELETE Statement</a> +<li><a href="#drop_index_statement">3.19. DROP INDEX Statement</a> <ul class="sectlevel3"> -<li><a href="#delete_syntax">3.19.1. Syntax Description of DELETE</a></li> -<li><a href="#delete_considerations">3.19.2. Considerations for DELETE</a></li> -<li><a href="#delete_examples">3.19.3. Examples of DELETE</a></li> +<li><a href="#drop_index_syntax">3.19.1. Syntax Description of DROP INDEX</a></li> +<li><a href="#drop_index_considerations">3.19.2. Considerations for DROP INDEX</a></li> +<li><a href="#drop_index_examples">3.19.3. Examples of DROP INDEX</a></li> </ul> </li> -<li><a href="#drop_function_statement">3.20. DROP FUNCTION Statement</a> +<li><a href="#drop_library_statement">3.20. DROP LIBRARY Statement</a> <ul class="sectlevel3"> -<li><a href="#drop_function_syntax">3.20.1. Syntax Description of DROP FUNCTION</a></li> -<li><a href="#drop_function_considerations">3.20.2. Considerations for DROP FUNCTION</a></li> -<li><a href="#drop_function_examples">3.20.3. Examples of DROP FUNCTION</a></li> +<li><a href="#drop_library_syntax">3.20.1. Syntax Description of DROP LIBRARY</a></li> +<li><a href="#drop_library_considerations">3.20.2. Considerations for DROP LIBRARY</a></li> +<li><a href="#drop_library_examples">3.20.3. Examples of DROP LIBRARY</a></li> </ul> </li> -<li><a href="#drop_index_statement">3.21. DROP INDEX Statement</a> +<li><a href="#drop_procedure_statement">3.21. DROP PROCEDURE Statement</a> <ul class="sectlevel3"> -<li><a href="#drop_index_syntax">3.21.1. Syntax Description of DROP INDEX</a></li> -<li><a href="#drop_index_considerations">3.21.2. Considerations for DROP INDEX</a></li> -<li><a href="#drop_index_examples">3.21.3. Examples of DROP INDEX</a></li> +<li><a href="#drop_procedure_syntax">3.21.1. Syntax Description of DROP PROCEDURE</a></li> +<li><a href="#drop_procedure_considerations">3.21.2. Considerations for DROP PROCEDURE</a></li> +<li><a href="#drop_procedure_examples">3.21.3. Examples of DROP PROCEDURE</a></li> </ul> </li> -<li><a href="#drop_library_statement">3.22. DROP LIBRARY Statement</a> +<li><a href="#drop_role_statement">3.22. DROP ROLE Statement</a> <ul class="sectlevel3"> -<li><a href="#drop_library_syntax">3.22.1. Syntax Description of DROP LIBRARY</a></li> -<li><a href="#drop_library_considerations">3.22.2. Considerations for DROP LIBRARY</a></li> -<li><a href="#drop_library_examples">3.22.3. Examples of DROP LIBRARY</a></li> +<li><a href="#drop_role_syntax">3.22.1. Syntax Description of DROP ROLE</a></li> +<li><a href="#drop_role_considerations">3.22.2. Considerations for DROP ROLE</a></li> +<li><a href="#drop_role_examples">3.22.3. Examples of DROP ROLE</a></li> </ul> </li> -<li><a href="#drop_procedure_statement">3.23. DROP PROCEDURE Statement</a> +<li><a href="#drop_schema_statement">3.23. DROP SCHEMA Statement</a> <ul class="sectlevel3"> -<li><a href="#drop_procedure_syntax">3.23.1. Syntax Description of DROP PROCEDURE</a></li> -<li><a href="#drop_procedure_considerations">3.23.2. Considerations for DROP PROCEDURE</a></li> -<li><a href="#drop_procedure_examples">3.23.3. Examples of DROP PROCEDURE</a></li> +<li><a href="#drop_schema_syntax">3.23.1. Syntax Description of DROP SCHEMA</a></li> +<li><a href="#drop_schema_considerations">3.23.2. Considerations for DROP SCHEMA</a></li> +<li><a href="#drop_schema_examples">3.23.3. Example of DROP SCHEMA</a></li> </ul> </li> -<li><a href="#drop_role_statement">3.24. DROP ROLE Statement</a> +<li><a href="#drop_table_statement">3.24. DROP TABLE Statement</a> <ul class="sectlevel3"> -<li><a href="#drop_role_syntax">3.24.1. Syntax Description of DROP ROLE</a></li> -<li><a href="#drop_role_considerations">3.24.2. Considerations for DROP ROLE</a></li> -<li><a href="#drop_role_examples">3.24.3. Examples of DROP ROLE</a></li> +<li><a href="#drop_table_syntax">3.24.1. Syntax Description of DROP TABLE</a></li> +<li><a href="#drop_table_considerations">3.24.2. Considerations for DROP TABLE</a></li> +<li><a href="#drop_table_examples">3.24.3. Examples of DROP TABLE</a></li> </ul> </li> -<li><a href="#drop_schema_statement">3.25. DROP SCHEMA Statement</a> +<li><a href="#drop_view_statement">3.25. DROP VIEW Statement</a> <ul class="sectlevel3"> -<li><a href="#drop_schema_syntax">3.25.1. Syntax Description of DROP SCHEMA</a></li> -<li><a href="#drop_schema_considerations">3.25.2. Considerations for DROP SCHEMA</a></li> -<li><a href="#drop_schema_examples">3.25.3. Example of DROP SCHEMA</a></li> +<li><a href="#drop_view_syntax">3.25.1. Syntax Description of DROP VIEW</a></li> +<li><a href="#drop_view_considerations">3.25.2. Considerations for DROP VIEW</a></li> +<li><a href="#drop_view_examples">3.25.3. Example of DROP VIEW</a></li> </ul> </li> -<li><a href="#drop_sequence_statement">3.26. DROP SEQUENCE Statement</a> +<li><a href="#execute_statement">3.26. Execute Statement</a> <ul class="sectlevel3"> -<li><a href="#drop_sequence_syntax">3.26.1. Syntax Description of DROP SEQUENCE</a></li> -<li><a href="#drop_sequence_considerations">3.26.2. Considerations for DROP SEQUENCE</a></li> -<li><a href="#drop_sequence_examples">3.26.3. Examples of DROP SEQUENCE</a></li> +<li><a href="#execute_syntax">3.26.1. Syntax Description of EXECUTE</a></li> +<li><a href="#execute_considerations">3.26.2. Considerations for EXECUTE</a></li> +<li><a href="#execute_examples">3.26.3. Examples of EXECUTE</a></li> </ul> </li> -<li><a href="#drop_table_statement">3.27. DROP TABLE Statement</a> +<li><a href="#explain_statement">3.27. EXPLAIN Statement</a> <ul class="sectlevel3"> -<li><a href="#drop_table_syntax">3.27.1. Syntax Description of DROP TABLE</a></li> -<li><a href="#drop_table_considerations">3.27.2. Considerations for DROP TABLE</a></li> -<li><a href="#drop_table_examples">3.27.3. Examples of DROP TABLE</a></li> +<li><a href="#explain_syntax">3.27.1. Syntax Description of EXPLAIN</a></li> +<li><a href="#explain_considerations">3.27.2. Considerations for EXPLAIN</a></li> </ul> </li> -<li><a href="#drop_view_statement">3.28. DROP VIEW Statement</a> +<li><a href="#get_statement">3.28. GET Statement</a> <ul class="sectlevel3"> -<li><a href="#drop_view_syntax">3.28.1. Syntax Description of DROP VIEW</a></li> -<li><a href="#drop_view_considerations">3.28.2. Considerations for DROP VIEW</a></li> -<li><a href="#drop_view_examples">3.28.3. Example of DROP VIEW</a></li> +<li><a href="#get_syntax">3.28.1. Syntax Description of GET</a></li> +<li><a href="#get_considerations">3.28.2. Considerations for GET</a></li> +<li><a href="#get_examples">3.28.3. Examples of GET</a></li> </ul> </li> -<li><a href="#execute_statement">3.29. Execute Statement</a> +<li><a href="#get_hbase_objects_statement">3.29. GET HBASE OBJECTS Statement</a> <ul class="sectlevel3"> -<li><a href="#execute_syntax">3.29.1. Syntax Description of EXECUTE</a></li> -<li><a href="#execute_considerations">3.29.2. Considerations for EXECUTE</a></li> -<li><a href="#execute_examples">3.29.3. Examples of EXECUTE</a></li> +<li><a href="#get_hbase_objects_syntax">3.29.1. Syntax Description of GET HBASE OBJECTS</a></li> +<li><a href="#get_hbase_objects_examples">3.29.2. Examples of GET HBASE OBJECTS</a></li> </ul> </li> -<li><a href="#explain_statement">3.30. EXPLAIN Statement</a> +<li><a href="#get_version_of_metadata_statement">3.30. GET VERSION OF METADATA Statement</a> <ul class="sectlevel3"> -<li><a href="#explain_syntax">3.30.1. Syntax Description of EXPLAIN</a></li> -<li><a href="#explain_considerations">3.30.2. Considerations for EXPLAIN</a></li> +<li><a href="#get_version_of_metadata_considerations">3.30.1. Considerations for GET VERSION OF METADATA</a></li> +<li><a href="#get_version_of_metadata_examples">3.30.2. Examples of GET VERSION OF METADATA</a></li> </ul> </li> -<li><a href="#get_statement">3.31. GET Statement</a> +<li><a href="#get_version_of_software_statement">3.31. GET VERSION OF SOFTWARE Statement</a> <ul class="sectlevel3"> -<li><a href="#get_syntax">3.31.1. Syntax Description of GET</a></li> -<li><a href="#get_considerations">3.31.2. Considerations for GET</a></li> -<li><a href="#get_examples">3.31.3. Examples of GET</a></li> +<li><a href="#get_version_of_software_considerations">3.31.1. Considerations for GET VERSION OF SOFTWARE</a></li> +<li><a href="#get_version_of_software_examples">3.31.2. Examples of GET VERSION OF SOFTWARE</a></li> </ul> </li> -<li><a href="#get_hbase_objects_statement">3.32. GET HBASE OBJECTS Statement</a> +<li><a href="#grant_statement">3.32. GRANT Statement</a> <ul class="sectlevel3"> -<li><a href="#get_hbase_objects_syntax">3.32.1. Syntax Description of GET HBASE OBJECTS</a></li> -<li><a href="#get_hbase_objects_examples">3.32.2. Examples of GET HBASE OBJECTS</a></li> +<li><a href="#_syntax_description_of_grant">3.32.1. syntax description of grant</a></li> +<li><a href="#grant_considerations">3.32.2. Considerations for GRANT</a></li> +<li><a href="#grant_examples">3.32.3. Examples of GRANT</a></li> </ul> </li> -<li><a href="#get_version_of_metadata_statement">3.33. GET VERSION OF METADATA Statement</a> +<li><a href="#grant_component_privilege_statement">3.33. GRANT COMPONENT PRIVILEGE Statement</a> <ul class="sectlevel3"> -<li><a href="#get_version_of_metadata_considerations">3.33.1. Considerations for GET VERSION OF METADATA</a></li> -<li><a href="#get_version_of_metadata_examples">3.33.2. Examples of GET VERSION OF METADATA</a></li> +<li><a href="#grant_component_privilege_syntax">3.33.1. Syntax Description of GRANT COMPONENT PRIVILEGE</a></li> +<li><a href="#grant_component_privilege_considerations">3.33.2. Considerations for GRANT COMPONENT PRIVILEGE</a></li> +<li><a href="#grant_component_privilege_considerations">3.33.3. Examples of GRANT COMPONENT PRIVILEGE</a></li> </ul> </li> -<li><a href="#get_version_of_software_statement">3.34. GET VERSION OF SOFTWARE Statement</a> +<li><a href="#grant_role_statement">3.34. GRANT ROLE Statement</a> <ul class="sectlevel3"> -<li><a href="#get_version_of_software_considerations">3.34.1. Considerations for GET VERSION OF SOFTWARE</a></li> -<li><a href="#get_version_of_software_examples">3.34.2. Examples of GET VERSION OF SOFTWARE</a></li> +<li><a href="#grant_role_syntax">3.34.1. Syntax Description of GRANT ROLE</a></li> +<li><a href="#grant_role_considerations">3.34.2. Considerations for GRANT ROLE</a></li> +<li><a href="#grant_role_examples">3.34.3. Examples of GRANT ROLE</a></li> </ul> </li> -<li><a href="#grant_statement">3.35. GRANT Statement</a> +<li><a href="#insert_statement">3.35. INSERT Statement</a> <ul class="sectlevel3"> -<li><a href="#_syntax_description_of_grant">3.35.1. syntax description of grant</a></li> -<li><a href="#grant_considerations">3.35.2. Considerations for GRANT</a></li> -<li><a href="#grant_examples">3.35.3. Examples of GRANT</a></li> +<li><a href="#insert_syntax">3.35.1. Syntax Description of INSERT</a></li> +<li><a href="#insert_considerations">3.35.2. Considerations for INSERT</a></li> +<li><a href="#insert_examples">3.35.3. Examples of INSERT</a></li> </ul> </li> -<li><a href="#grant_component_privilege_statement">3.36. GRANT COMPONENT PRIVILEGE Statement</a> +<li><a href="#invoke_statement">3.36. INVOKE Statement</a> <ul class="sectlevel3"> -<li><a href="#grant_component_privilege_syntax">3.36.1. Syntax Description of GRANT COMPONENT PRIVILEGE</a></li> -<li><a href="#grant_component_privilege_considerations">3.36.2. Considerations for GRANT COMPONENT PRIVILEGE</a></li> -<li><a href="#grant_component_privilege_considerations">3.36.3. Examples of GRANT COMPONENT PRIVILEGE</a></li> +<li><a href="#invoke_syntax">3.36.1. Syntax Description of INVOKE</a></li> +<li><a href="#invoke_considerations">3.36.2. Considerations for INVOKE</a></li> +<li><a href="#invoke_required_privileges">3.36.3. Required Privileges</a></li> +<li><a href="#invoke_examples">3.36.4. Examples of INVOKE</a></li> </ul> </li> -<li><a href="#grant_role_statement">3.37. GRANT ROLE Statement</a> +<li><a href="#merge_statement">3.37. MERGE Statement</a> <ul class="sectlevel3"> -<li><a href="#grant_role_syntax">3.37.1. Syntax Description of GRANT ROLE</a></li> -<li><a href="#grant_role_considerations">3.37.2. Considerations for GRANT ROLE</a></li> -<li><a href="#grant_role_examples">3.37.3. Examples of GRANT ROLE</a></li> +<li><a href="#merge_syntax">3.37.1. Syntax Description of MERGE</a></li> +<li><a href="#merge_considerations">3.37.2. Considerations for MERGE</a></li> +<li><a href="#merge_upsert_using_single_row">3.37.3. Upsert Using Single Row</a></li> +<li><a href="#merge_examples">3.37.4. Examples of MERGE</a></li> </ul> </li> -<li><a href="#insert_statement">3.38. INSERT Statement</a> +<li><a href="#prepare_statement">3.38. PREPARE Statement</a> <ul class="sectlevel3"> -<li><a href="#insert_syntax">3.38.1. Syntax Description of INSERT</a></li> -<li><a href="#insert_considerations">3.38.2. Considerations for INSERT</a></li> -<li><a href="#insert_examples">3.38.3. Examples of INSERT</a></li> +<li><a href="#prepare_syntax">3.38.1. Syntax Description of PREPARE</a></li> +<li><a href="#prepare_considerations">3.38.2. Considerations for PREPARE</a></li> +<li><a href="#prepare_examples">3.38.3. Examples of PREPARE</a></li> </ul> </li> -<li><a href="#invoke_statement">3.39. INVOKE Statement</a> +<li><a href="#register_user_statement">3.39. REGISTER USER Statement</a> <ul class="sectlevel3"> -<li><a href="#invoke_syntax">3.39.1. Syntax Description of INVOKE</a></li> -<li><a href="#invoke_considerations">3.39.2. Considerations for INVOKE</a></li> -<li><a href="#invoke_required_privileges">3.39.3. Required Privileges</a></li> -<li><a href="#invoke_examples">3.39.4. Examples of INVOKE</a></li> +<li><a href="#register_user_syntax">3.39.1. Syntax Description of REGISTER USER</a></li> +<li><a href="#register_user_register_user_considerations">3.39.2. Considerations for REGISTER USER</a></li> +<li><a href="#register_user_examples">3.39.3. Examples of REGISTER USER</a></li> </ul> </li> -<li><a href="#merge_statement">3.40. MERGE Statement</a> +<li><a href="#_revoke_statement">3.40. REVOKE Statement</a> <ul class="sectlevel3"> -<li><a href="#merge_syntax">3.40.1. Syntax Description of MERGE</a></li> -<li><a href="#merge_considerations">3.40.2. Considerations for MERGE</a></li> -<li><a href="#merge_upsert_using_single_row">3.40.3. Upsert Using Single Row</a></li> -<li><a href="#merge_examples">3.40.4. Examples of MERGE</a></li> +<li><a href="#_syntax_description_of_revoke">3.40.1. Syntax Description of REVOKE</a></li> +<li><a href="#revoke_considerations">3.40.2. Considerations for REVOKE</a></li> +<li><a href="#revoke_examples">3.40.3. Examples of REVOKE</a></li> </ul> </li> -<li><a href="#prepare_statement">3.41. PREPARE Statement</a> +<li><a href="#revoke_component_privilege_statement">3.41. REVOKE COMPONENT PRIVILEGE Statement</a> <ul class="sectlevel3"> -<li><a href="#prepare_syntax">3.41.1. Syntax Description of PREPARE</a></li> -<li><a href="#prepare_considerations">3.41.2. Considerations for PREPARE</a></li> -<li><a href="#prepare_examples">3.41.3. Examples of PREPARE</a></li> +<li><a href="#_syntax_description_of_revoke_component_privilege">3.41.1. Syntax Description of REVOKE COMPONENT PRIVILEGE</a></li> +<li><a href="#revoke_component_privilege_considerations">3.41.2. Considerations for REVOKE COMPONENT PRIVILEGE</a></li> +<li><a href="#revoke_component_examples">3.41.3. Examples of REVOKE COMPONENT PRIVILEGE</a></li> </ul> </li> -<li><a href="#register_user_statement">3.42. REGISTER USER Statement</a> +<li><a href="#revoke_role_statement">3.42. REVOKE ROLE Statement</a> <ul class="sectlevel3"> -<li><a href="#register_user_syntax">3.42.1. Syntax Description of REGISTER USER</a></li> -<li><a href="#register_user_register_user_considerations">3.42.2. Considerations for REGISTER USER</a></li> -<li><a href="#register_user_examples">3.42.3. Examples of REGISTER USER</a></li> +<li><a href="#revoke_role_syntax">3.42.1. Syntax Description of REVOKE ROLE</a></li> +<li><a href="#revoke_role_considerations">3.42.2. Considerations for REVOKE ROLE</a></li> +<li><a href="#revoke_role_examples">3.42.3. Examples of REVOKE ROLE</a></li> </ul> </li> -<li><a href="#_revoke_statement">3.43. REVOKE Statement</a> +<li><a href="#rollback_work_statement">3.43. ROLLBACK WORK Statement</a> <ul class="sectlevel3"> -<li><a href="#_syntax_description_of_revoke">3.43.1. Syntax Description of REVOKE</a></li> -<li><a href="#revoke_considerations">3.43.2. Considerations for REVOKE</a></li> -<li><a href="#revoke_examples">3.43.3. Examples of REVOKE</a></li> +<li><a href="#rollback_work_syntax">3.43.1. Syntax Description of ROLLBACK WORK</a></li> +<li><a href="#rollback_work_considerations">3.43.2. Considerations for ROLLBACK WORK</a></li> +<li><a href="#rollback_work_examples">3.43.3. Example of ROLLBACK WORK</a></li> </ul> </li> -<li><a href="#revoke_component_privilege_statement">3.44. REVOKE COMPONENT PRIVILEGE Statement</a> +<li><a href="#select_statement">3.44. SELECT Statement</a> <ul class="sectlevel3"> -<li><a href="#_syntax_description_of_revoke_component_privilege">3.44.1. Syntax Description of REVOKE COMPONENT PRIVILEGE</a></li> -<li><a href="#revoke_component_privilege_considerations">3.44.2. Considerations for REVOKE COMPONENT PRIVILEGE</a></li> -<li><a href="#revoke_component_examples">3.44.3. Examples of REVOKE COMPONENT PRIVILEGE</a></li> +<li><a href="#select_syntax">3.44.1. Syntax Description of SELECT</a></li> +<li><a href="#select_considerations">3.44.2. Considerations for SELECT</a></li> +<li><a href="#select_examples">3.44.3. Examples of SELECT</a></li> </ul> </li> -<li><a href="#revoke_role_statement">3.45. REVOKE ROLE Statement</a> +<li><a href="#set_schema_statement">3.45. SET SCHEMA Statement</a> <ul class="sectlevel3"> -<li><a href="#revoke_role_syntax">3.45.1. Syntax Description of REVOKE ROLE</a></li> -<li><a href="#revoke_role_considerations">3.45.2. Considerations for REVOKE ROLE</a></li> -<li><a href="#revoke_role_examples">3.45.3. Examples of REVOKE ROLE</a></li> +<li><a href="#set_schema_syntax">3.45.1. Syntax Description of SET SCHEMA</a></li> +<li><a href="#set_schema_considerations">3.45.2. Considerations for SET SCHEMA</a></li> +<li><a href="#set_schema_examples">3.45.3. Examples of SET SCHEMA</a></li> </ul> </li> -<li><a href="#rollback_work_statement">3.46. ROLLBACK WORK Statement</a> +<li><a href="#set_transaction_statement">3.46. SET TRANSACTION Statement</a> <ul class="sectlevel3"> -<li><a href="#rollback_work_syntax">3.46.1. Syntax Description of ROLLBACK WORK</a></li> -<li><a href="#rollback_work_considerations">3.46.2. Considerations for ROLLBACK WORK</a></li> -<li><a href="#rollback_work_examples">3.46.3. Example of ROLLBACK WORK</a></li> +<li><a href="#set_transaction_syntax">3.46.1. Syntax Description of SET TRANSACTION</a></li> +<li><a href="#set_transaction_consideration">3.46.2. Considerations for SET TRANSACTION</a></li> +<li><a href="#set_transaction_examples">3.46.3. Examples of SET TRANSACTION</a></li> </ul> </li> -<li><a href="#select_statement">3.47. SELECT Statement</a> +<li><a href="#showcontrol_statement">3.47. SHOWCONTROL Statement</a> <ul class="sectlevel3"> -<li><a href="#select_syntax">3.47.1. Syntax Description of SELECT</a></li> -<li><a href="#select_considerations">3.47.2. Considerations for SELECT</a></li> -<li><a href="#select_examples">3.47.3. Examples of SELECT</a></li> +<li><a href="#showcontrol_syntax">3.47.1. Syntax Description of SHOWCONTROL</a></li> +<li><a href="#showcontrol_examples">3.47.2. Examples of SHOWCONTROL</a></li> </ul> </li> -<li><a href="#set_schema_statement">3.48. SET SCHEMA Statement</a> +<li><a href="#showddl_statement">3.48. SHOWDDL Statement</a> <ul class="sectlevel3"> -<li><a href="#set_schema_syntax">3.48.1. Syntax Description of SET SCHEMA</a></li> -<li><a href="#set_schema_considerations">3.48.2. Considerations for SET SCHEMA</a></li> -<li><a href="#set_schema_examples">3.48.3. Examples of SET SCHEMA</a></li> +<li><a href="#showddl_syntax">3.48.1. Syntax Description of SHOWDDL</a></li> +<li><a href="#showddl_considerations">3.48.2. Considerations for SHOWDDL</a></li> +<li><a href="#showddl_examples">3.48.3. Examples of SHOWDDL</a></li> </ul> </li> -<li><a href="#set_transaction_statement">3.49. SET TRANSACTION Statement</a> +<li><a href="#showddl_schema_statement">3.49. SHOWDDL SCHEMA Statement</a> <ul class="sectlevel3"> -<li><a href="#set_transaction_syntax">3.49.1. Syntax Description of SET TRANSACTION</a></li> -<li><a href="#set_transaction_consideration">3.49.2. Considerations for SET TRANSACTION</a></li> -<li><a href="#set_transaction_examples">3.49.3. Examples of SET TRANSACTION</a></li> +<li><a href="#showddl_schema_syntax">3.49.1. Syntax Description for SHOWDDL SCHEMA</a></li> +<li><a href="#showddl_schema_considerations">3.49.2. Considerations for SHOWDDL SCHEMA</a></li> +<li><a href="#showddl_schema_examples">3.49.3. Examples of SHOWDDL SCHEMA</a></li> </ul> </li> -<li><a href="#showcontrol_statement">3.50. SHOWCONTROL Statement</a> +<li><a href="#_showstats_statement">3.50. SHOWSTATS Statement</a> <ul class="sectlevel3"> -<li><a href="#showcontrol_syntax">3.50.1. Syntax Description of SHOWCONTROL</a></li> -<li><a href="#showcontrol_examples">3.50.2. Examples of SHOWCONTROL</a></li> +<li><a href="#showstats_syntax">3.50.1. Syntax Description of SHOWSTATS</a></li> +<li><a href="#showstats_considerations">3.50.2. Considerations for SHOWSTATS</a></li> +<li><a href="#showstats_examples">3.50.3. Examples of SHOWSTATS</a></li> </ul> </li> -<li><a href="#showddl_statement">3.51. SHOWDDL Statement</a> +<li><a href="#table_statement">3.51. TABLE Statement</a> <ul class="sectlevel3"> -<li><a href="#showddl_syntax">3.51.1. Syntax Description of SHOWDDL</a></li> -<li><a href="#showddl_considerations">3.51.2. Considerations for SHOWDDL</a></li> -<li><a href="#showddl_examples">3.51.3. Examples of SHOWDDL</a></li> +<li><a href="#table_syntax">3.51.1. Syntax Description of Table Statement</a></li> +<li><a href="#_considerations_for_table">3.51.2. Considerations for TABLE</a></li> +<li><a href="#_examples_of_table_statement">3.51.3. Examples of TABLE Statement</a></li> </ul> </li> -<li><a href="#showddl_schema_statement">3.52. SHOWDDL SCHEMA Statement</a> +<li><a href="#unregister_user_statement">3.52. UNREGISTER USER Statement</a> <ul class="sectlevel3"> -<li><a href="#showddl_schema_syntax">3.52.1. Syntax Description for SHOWDDL SCHEMA</a></li> -<li><a href="#showddl_schema_considerations">3.52.2. Considerations for SHOWDDL SCHEMA</a></li> -<li><a href="#showddl_schema_examples">3.52.3. Examples of SHOWDDL SCHEMA</a></li> +<li><a href="#unregister_user_syntax">3.52.1. Syntax Description of UNREGISTER USER</a></li> +<li><a href="#unregister_user_considerations">3.52.2. Considerations for UNREGISTER USER</a></li> +<li><a href="#unregister_user_examples">3.52.3. Examples of UNREGISTER USER</a></li> </ul> </li> -<li><a href="#_showstats_statement">3.53. SHOWSTATS Statement</a> +<li><a href="#update_statement">3.53. UPDATE Statement</a> <ul class="sectlevel3"> -<li><a href="#showstats_syntax">3.53.1. Syntax Description of SHOWSTATS</a></li> -<li><a href="#showstats_considerations">3.53.2. Considerations for SHOWSTATS</a></li> -<li><a href="#showstats_examples">3.53.3. Examples of SHOWSTATS</a></li> +<li><a href="#update_syntax">3.53.1. Syntax Description of UPDATE</a></li> +<li><a href="#update_considerations">3.53.2. Considerations for UPDATE</a></li> +<li><a href="#update_examples">3.53.3. Examples of UPDATE</a></li> </ul> </li> -<li><a href="#table_statement">3.54. TABLE Statement</a> +<li><a href="#upsert_statement">3.54. UPSERT Statement</a> <ul class="sectlevel3"> -<li><a href="#table_syntax">3.54.1. Syntax Description of Table Statement</a></li> -<li><a href="#_considerations_for_table">3.54.2. Considerations for TABLE</a></li> -<li><a href="#_examples_of_table_statement">3.54.3. Examples of TABLE Statement</a></li> +<li><a href="#upsert_syntax">3.54.1. Syntax Description of UPSERT</a></li> +<li><a href="#upsert_examples">3.54.2. Examples of UPSERT</a></li> </ul> </li> -<li><a href="#unregister_user_statement">3.55. UNREGISTER USER Statement</a> +<li><a href="#values_statement">3.55. VALUES Statement</a> <ul class="sectlevel3"> -<li><a href="#unregister_user_syntax">3.55.1. Syntax Description of UNREGISTER USER</a></li> -<li><a href="#unregister_user_considerations">3.55.2. Considerations for UNREGISTER USER</a></li> -<li><a href="#unregister_user_examples">3.55.3. Examples of UNREGISTER USER</a></li> -</ul> -</li> -<li><a href="#update_statement">3.56. UPDATE Statement</a> -<ul class="sectlevel3"> -<li><a href="#update_syntax">3.56.1. Syntax Description of UPDATE</a></li> -<li><a href="#update_considerations">3.56.2. Considerations for UPDATE</a></li> -<li><a href="#update_examples">3.56.3. Examples of UPDATE</a></li> -</ul> -</li> -<li><a href="#upsert_statement">3.57. UPSERT Statement</a> -<ul class="sectlevel3"> -<li><a href="#upsert_syntax">3.57.1. Syntax Description of UPSERT</a></li> -<li><a href="#upsert_examples">3.57.2. Examples of UPSERT</a></li> -</ul> -</li> -<li><a href="#values_statement">3.58. VALUES Statement</a> -<ul class="sectlevel3"> -<li><a href="#values_syntax">3.58.1. Syntax Description of VALUES</a></li> -<li><a href="#values_considerations">3.58.2. Considerations for VALUES</a></li> -<li><a href="#values_examples">3.58.3. Examples of VALUES</a></li> +<li><a href="#values_syntax">3.55.1. Syntax Description of VALUES</a></li> +<li><a href="#values_considerations">3.55.2. Considerations for VALUES</a></li> +<li><a href="#values_examples">3.55.3. Examples of VALUES</a></li> </ul> </li> </ul> @@ -1102,82 +1081,76 @@ table.CodeRay td.code>pre{padding:0} <li><a href="#examples_of_identifiers">5.10.4. Examples of Identifiers</a></li> </ul> </li> -<li><a href="#identity_column">5.11. Identity Column</a> +<li><a href="#indexes">5.11. Indexes</a> <ul class="sectlevel3"> -<li><a href="#syntax_description_of_identity_column">5.11.1. Syntax Description of Identity Column</a></li> -<li><a href="#examples_of_identity_column">5.11.2. Examples of Identity Column</a></li> +<li><a href="#sql_indexes">5.11.1. SQL Indexes</a></li> </ul> </li> -<li><a href="#indexes">5.12. Indexes</a> +<li><a href="#keys">5.12. Keys</a> <ul class="sectlevel3"> -<li><a href="#sql_indexes">5.12.1. SQL Indexes</a></li> +<li><a href="#clustering_keys">5.12.1. Clustering Keys</a></li> +<li><a href="#syskey">5.12.2. SYSKEY</a></li> +<li><a href="#index_keys">5.12.3. Index Keys</a></li> +<li><a href="#primary_keys">5.12.4. Primary Keys</a></li> </ul> </li> -<li><a href="#keys">5.13. Keys</a> +<li><a href="#literals">5.13. Literals</a> <ul class="sectlevel3"> -<li><a href="#clustering_keys">5.13.1. Clustering Keys</a></li> -<li><a href="#syskey">5.13.2. SYSKEY</a></li> -<li><a href="#index_keys">5.13.3. Index Keys</a></li> -<li><a href="#primary_keys">5.13.4. Primary Keys</a></li> +<li><a href="#character_string_literals">5.13.1. Character String Literals</a></li> +<li><a href="#datetime_literals">5.13.2. Datetime Literals</a></li> +<li><a href="#interval_literals">5.13.3. Interval Literals</a></li> +<li><a href="#numeric_literals">5.13.4. Numeric Literals</a></li> </ul> </li> -<li><a href="#literals">5.14. Literals</a> +<li><a href="#null">5.14. Null</a> <ul class="sectlevel3"> -<li><a href="#character_string_literals">5.14.1. Character String Literals</a></li> -<li><a href="#datetime_literals">5.14.2. Datetime Literals</a></li> -<li><a href="#interval_literals">5.14.3. Interval Literals</a></li> -<li><a href="#numeric_literals">5.14.4. Numeric Literals</a></li> +<li><a href="#using_null_versus_default_values">5.14.1. Using Null Versus Default Values</a></li> +<li><a href="#defining_columns_that_allow_or_prohibit_null">5.14.2. Defining Columns That Allow or Prohibit Null</a></li> </ul> </li> -<li><a href="#null">5.15. Null</a> +<li><a href="#predicates">5.15. Predicates</a> <ul class="sectlevel3"> -<li><a href="#using_null_versus_default_values">5.15.1. Using Null Versus Default Values</a></li> -<li><a href="#defining_columns_that_allow_or_prohibit_null">5.15.2. Defining Columns That Allow or Prohibit Null</a></li> -</ul> -</li> -<li><a href="#predicates">5.16. Predicates</a> +<li><a href="#between_predicate">5.15.1. BETWEEN Predicate</a></li> +<li><a href="#comparison_predicates">5.15.2. Comparison Predicates</a></li> +<li><a href="#exists_predicate">5.15.3. EXISTS Predicate</a></li> +<li><a href="#in_predicate">5.15.4. IN Predicate</a></li> +<li><a href="#like_predicate">5.15.5. LIKE Predicate</a></li> +<li><a href="#regexp_predicate">5.15.6. REGEXP Predicate</a></li> +<li><a href="#null_predicate">5.15.7. NULL Predicate</a></li> +<li><a href="#quantified_comparison_predicates">5.15.8. Quantified Comparison Predicates</a></li> +</ul> +</li> +<li><a href="#privileges">5.16. Privileges</a></li> +<li><a href="#roles">5.17. Roles</a></li> +<li><a href="#schemas">5.18. Schemas</a> <ul class="sectlevel3"> -<li><a href="#between_predicate">5.16.1. BETWEEN Predicate</a></li> -<li><a href="#comparison_predicates">5.16.2. Comparison Predicates</a></li> -<li><a href="#exists_predicate">5.16.3. EXISTS Predicate</a></li> -<li><a href="#in_predicate">5.16.4. IN Predicate</a></li> -<li><a href="#like_predicate">5.16.5. LIKE Predicate</a></li> -<li><a href="#regexp_predicate">5.16.6. REGEXP Predicate</a></li> -<li><a href="#null_predicate">5.16.7. NULL Predicate</a></li> -<li><a href="#quantified_comparison_predicates">5.16.8. Quantified Comparison Predicates</a></li> -</ul> -</li> -<li><a href="#privileges">5.17. Privileges</a></li> -<li><a href="#roles">5.18. Roles</a></li> -<li><a href="#schemas">5.19. Schemas</a> -<ul class="sectlevel3"> -<li><a href="#creating_and_dropping_schemas">5.19.1. Creating and Dropping Schemas</a></li> +<li><a href="#creating_and_dropping_schemas">5.18.1. Creating and Dropping Schemas</a></li> </ul> </li> -<li><a href="#search_condition">5.20. Search Condition</a> +<li><a href="#search_condition">5.19. Search Condition</a> <ul class="sectlevel3"> -<li><a href="#considerations_for_search_condition">5.20.1. Considerations for Search Condition</a></li> -<li><a href="#examples_of_search_condition">5.20.2. Examples of Search Condition</a></li> +<li><a href="#considerations_for_search_condition">5.19.1. Considerations for Search Condition</a></li> +<li><a href="#examples_of_search_condition">5.19.2. Examples of Search Condition</a></li> </ul> </li> -<li><a href="#subquery">5.21. Subquery</a> +<li><a href="#subquery">5.20. Subquery</a> <ul class="sectlevel3"> -<li><a href="#select_form_of_a_subquery">5.21.1. SELECT Form of a Subquery</a></li> -<li><a href="#using_subqueries_to_provide_comparison_values">5.21.2. Using Subqueries to Provide Comparison Values</a></li> -<li><a href="#nested_subqueries_when_providing_comparison_values">5.21.3. Nested Subqueries When Providing Comparison Values</a></li> -<li><a href="#correlated_subqueries_when_providing_comparison_values">5.21.4. Correlated Subqueries When Providing Comparison Values</a></li> +<li><a href="#select_form_of_a_subquery">5.20.1. SELECT Form of a Subquery</a></li> +<li><a href="#using_subqueries_to_provide_comparison_values">5.20.2. Using Subqueries to Provide Comparison Values</a></li> +<li><a href="#nested_subqueries_when_providing_comparison_values">5.20.3. Nested Subqueries When Providing Comparison Values</a></li> +<li><a href="#correlated_subqueries_when_providing_comparison_values">5.20.4. Correlated Subqueries When Providing Comparison Values</a></li> </ul> </li> -<li><a href="#tables">5.22. Tables</a> +<li><a href="#tables">5.21. Tables</a> <ul class="sectlevel3"> -<li><a href="#base_tables_and_views">5.22.1. Base Tables and Views</a></li> -<li><a href="#example_of_a_base_table">5.22.2. Example of a Base Table</a></li> +<li><a href="#base_tables_and_views">5.21.1. Base Tables and Views</a></li> +<li><a href="#example_of_a_base_table">5.21.2. Example of a Base Table</a></li> </ul> </li> -<li><a href="#views">5.23. Views</a> +<li><a href="#views">5.22. Views</a> <ul class="sectlevel3"> -<li><a href="#sql_views">5.23.1. SQL Views</a></li> -<li><a href="#example_of_a_view">5.23.2. Example of a View</a></li> +<li><a href="#sql_views">5.22.1. SQL Views</a></li> +<li><a href="#example_of_a_view">5.22.2. Example of a View</a></li> </ul> </li> </ul> @@ -1927,51 +1900,32 @@ table.CodeRay td.code>pre{padding:0} <li><a href="#dense_rank_window_function">8.6. DENSE_RANK Window Function</a> <ul class="sectlevel3"> <li><a href="#examples_of_dense_rank_window_function">8.6.1. Examples of DENSE_RANK Window Function</a></li> +<li><a href="#max_window_function">8.6.2. MAX Window Function</a></li> +<li><a href="#examples_of_max_window_function">8.6.3. Examples of MAX Window Function</a></li> </ul> </li> -<li><a href="#first_value_window_function">8.7. FIRST_VALUE Window Function</a> -<ul class="sectlevel3"> -<li><a href="#examples_of_first_value_window_function">8.7.1. Examples of FIRST_VALUE Window Function</a></li> -</ul> -</li> -<li><a href="#lag_window_function">8.8. LAG Window Function</a> -<ul class="sectlevel3"> -<li><a href="#examples_of_lag_window_function">8.8.1. Examples of LAG Window Function</a></li> -</ul> -</li> -<li><a href="#last_value_window_function">8.9. LAST_VALUE Window Function</a></li> -<li><a href="#lead_window_function">8.10. LEAD Window Function</a> -<ul class="sectlevel3"> -<li><a href="#examples_of_lead_window_function">8.10.1. Examples of LEAD Window Function</a></li> -</ul> -</li> -<li><a href="#max_window_function">8.11. MAX Window Function</a> +<li><a href="#min_window_function">8.7. MIN Window Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_max_window_function">8.11.1. Examples of MAX Window Function</a></li> +<li><a href="#examples_of_min_window_function">8.7.1. Examples of MIN Window Function</a></li> </ul> </li> -<li><a href="#min_window_function">8.12. MIN Window Function</a> +<li><a href="#rank_window_function">8.8. RANK Window Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_min_window_function">8.12.1. Examples of MIN Window Function</a></li> +<li><a href="#examples_of_rank_window_function">8.8.1. Examples of RANK Window Function</a></li> +<li><a href="#row_number_window_function">8.8.2. ROW_NUMBER Window Function</a></li> +<li><a href="#examples_of_row_number_window_function">8.8.3. Examples of ROW_NUMBER Window Function</a></li> +<li><a href="#stddev_window_function">8.8.4. STDDEV Window Function</a></li> +<li><a href="#examples_of_stddev">8.8.5. Examples of STDDEV</a></li> </ul> </li> -<li><a href="#rank_window_function">8.13. RANK Window Function</a> +<li><a href="#sum_window_function">8.9. SUM Window Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_rank_window_function">8.13.1. Examples of RANK Window Function</a></li> -<li><a href="#row_number_window_function">8.13.2. ROW_NUMBER Window Function</a></li> -<li><a href="#examples_of_row_number_window_function">8.13.3. Examples of ROW_NUMBER Window Function</a></li> -<li><a href="#stddev_window_function">8.13.4. STDDEV Window Function</a></li> -<li><a href="#examples_of_stddev">8.13.5. Examples of STDDEV</a></li> +<li><a href="#examples_of_sum_window_function">8.9.1. Examples of SUM Window Function</a></li> </ul> </li> -<li><a href="#sum_window_function">8.14. SUM Window Function</a> +<li><a href="#variance_window_function">8.10. VARIANCE Window Function</a> <ul class="sectlevel3"> -<li><a href="#examples_of_sum_window_function">8.14.1. Examples of SUM Window Function</a></li> -</ul> -</li> -<li><a href="#variance_window_function">8.15. VARIANCE Window Function</a> -<ul class="sectlevel3"> -<li><a href="#examples_of_variance_window_function">8.15.1. Examples of VARIANCE Window Function</a></li> +<li><a href="#examples_of_variance_window_function">8.10.1. Examples of VARIANCE Window Function</a></li> </ul> </li> </ul> @@ -2133,7 +2087,7 @@ with the furnishing, performance, or use of this material.</p> <tbody> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">2.1.0</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">May 1, 2017</p></td> +<td class="tableblock halign-left valign-top"><p class="tableblock">TBD</p></td> </tr> <tr> <td class="tableblock halign-left valign-top"><p class="tableblock">2.0.1</p></td> @@ -3902,87 +3856,7 @@ within a table. These statistics are used to devise optimized access plans.</p>< </div> </div> <div class="sect2"> -<h3 id="alter_sequence_statement">3.2. ALTER SEQUENCE Statement</h3> -<div class="paragraph"> -<p>The ALTER SEQUENCE Statement changes the future behavior of exiting sequence, including INCREMENT, MAXVALUE, CACHE and CYCLE.</p> -</div> -<div class="paragraph"> -<p>Multiple options can be concurrently specified and separated by a space. Any options not altered will -retain their previous settings.</p> -</div> -<div class="paragraph"> -<p>ALTER SEQUENCE is a Trafodion SQL extension.</p> -</div> -<div class="paragraph"> -<p>For more inforamation, see <a href="#create_sequence_statement">CREATE SEQUENCE Statement</a> or <a href="#drop_sequence_statement">DROP SEQUENCE Statement</a>.</p> -</div> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">ALTER SEQUENCE [[catalog-name.]schema-name.]sequence -[INCREMENT BY integer] -[MAXVALUE integer | NO MAXVALUE] -[CACHE integer] -[CYCLE | NO CYCLE]</code></pre> -</div> -</div> -<div style="page-break-after: always;"></div> -<div class="sect3"> -<h4 id="alter_sequence_syntax">3.2.1. Syntax Description of ALTER SEQUENCE</h4> -<div class="paragraph"> -<p>The options above serve the same purposes as they serve when you create a sequence. For more information, see <a href="#create_sequence_statement">CREATE SEQUENCE Statement</a>.</p> -</div> -<div class="paragraph"> -<p>NOTE:</p> -</div> -<div class="ulist"> -<ul> -<li> -<p>START WITH, MINVALUE, NO CACHE and DATA TYPE cannot be changed. Instead, drop and recreate the sequence specifying the desired options.</p> -</li> -<li> -<p>The unused preallocated values will be lost if a sequence is altered.</p> -</li> -<li> -<p>Some sequence values will be skipped if you change the INCREMENT BY before the first reference to <code>seqnum(SEQUENCE, next)</code>.</p> -</li> -</ul> -</div> -<div style="page-break-after: always;"></div> -</div> -<div class="sect3"> -<h4 id="alter_sequence_considerations">3.2.2. Considerations for ALTER SEQUENCE</h4> -<div class="paragraph"> -<p>To issue an ALTER SEQUENCE statement, one of the following must be true:</p> -</div> -<div class="ulist"> -<ul> -<li> -<p>You are DB ROOT.</p> -</li> -<li> -<p>You have the ALTER or ALTER_SEQUENCE component privilege for the SQL_OPERATIONS component.</p> -</li> -</ul> -</div> -<div style="page-break-after: always;"></div> -</div> -<div class="sect3"> -<h4 id="alter_sequence_examples">3.2.3. Examples of ALTER SEQUENCE</h4> -<div class="paragraph"> -<p>The following statement changes the MAXVALUE and CACHE for the sequence named <code>employee_seq</code>, which is created in <a href="#create_sequence_examples">Examples of CRAETE SEQUENCE</a>.</p> -</div> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">ALTER SEQUENCE employee_seq -MAXVALUE 20000 -CACHE 30</code></pre> -</div> -</div> -<div style="page-break-after: always;"></div> -</div> -</div> -<div class="sect2"> -<h3 id="alter_table_statement">3.3. ALTER TABLE Statement</h3> +<h3 id="alter_table_statement">3.2. ALTER TABLE Statement</h3> <div class="paragraph"> <p>The ALTER TABLE statement changes a Trafodion SQL table. See <a href="#tables">Tables</a>.</p> </div> @@ -4077,7 +3951,7 @@ column-list is: </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="alter_table_syntax">3.3.1. Syntax Description of ALTER TABLE</h4> +<h4 id="alter_table_syntax">3.2.1. Syntax Description of ALTER TABLE</h4> <div class="ulist"> <ul> <li> @@ -4361,7 +4235,7 @@ a.b.c might be assigned a name such as a.b.c_123…_01….</p> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="alter_table_considerations">3.3.2. Considerations for ALTER TABLE</h4> +<h4 id="alter_table_considerations">3.2.2. Considerations for ALTER TABLE</h4> <div class="sect4"> <h5 id="effect_of_adding_a_column_on_view_definitions">Effect of Adding a Column on View Definitions</h5> <div class="paragraph"> @@ -4429,7 +4303,7 @@ following must be true:</p> </div> </div> <div class="sect3"> -<h4 id="alter_table_examples">3.3.3. Example of ALTER TABLE</h4> +<h4 id="alter_table_examples">3.2.3. Example of ALTER TABLE</h4> <div class="paragraph"> <p>This example adds a column:</p> </div> @@ -4444,7 +4318,7 @@ following must be true:</p> </div> </div> <div class="sect2"> -<h3 id="alter_user_statement">3.4. ALTER USER Statement</h3> +<h3 id="alter_user_statement">3.3. ALTER USER Statement</h3> <div class="paragraph"> <p>The ALTER USER statement changes attributes associated with a user who is registered in the database.</p> </div> @@ -4461,7 +4335,7 @@ alter-action is: </div> </div> <div class="sect3"> -<h4 id="alter_user_syntax">3.4.1. Syntax Description of ALTER USER</h4> +<h4 id="alter_user_syntax">3.3.1. Syntax Description of ALTER USER</h4> <div class="ulist"> <ul> <li> @@ -4518,7 +4392,7 @@ identifier. See <a href="#Case_Insensitive_Delimited_Identifiers">Case-Insensiti <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="alter_user_considerations">3.4.2. Considerations for ALTER USER</h4> +<h4 id="alter_user_considerations">3.3.2. Considerations for ALTER USER</h4> <div class="paragraph"> <p>Only a user with user administrative privileges (that is, a user who has been granted the MANAGE_USERS component privilege) can do the following:</p> @@ -4538,7 +4412,7 @@ can do the following:</p> </div> </div> <div class="sect3"> -<h4 id="alter_user_examples">3.4.3. Examples of ALTER USER</h4> +<h4 id="alter_user_examples">3.3.3. Examples of ALTER USER</h4> <div class="ulist"> <ul> <li> @@ -4563,7 +4437,7 @@ can do the following:</p> </div> </div> <div class="sect2"> -<h3 id="begin_work_statement">3.5. BEGIN WORK Statement</h3> +<h3 id="begin_work_statement">3.4. BEGIN WORK Statement</h3> <div class="paragraph"> <p>The BEGIN WORK statement enables you to start a transaction explicitlyâwhere the transaction consists of the set of operations defined by the sequence of SQL statements that begins immediately after BEGIN WORK and ends with the next COMMIT or ROLLBACK @@ -4578,13 +4452,13 @@ statement. See <a href="#Transaction_Management">Transaction Management</a>. BEG </div> </div> <div class="sect3"> -<h4 id="begin_work_considerations">3.5.1. Considerations for BEGIN WORK</h4> +<h4 id="begin_work_considerations">3.4.1. Considerations for BEGIN WORK</h4> <div class="paragraph"> <p>BEGIN WORK starts a transaction. COMMIT WORK or ROLLBACK WORK ends a transaction.</p> </div> </div> <div class="sect3"> -<h4 id="begin_work_examples">3.5.2. Example of BEGIN WORK</h4> +<h4 id="begin_work_examples">3.4.2. Example of BEGIN WORK</h4> <div class="paragraph"> <p>Group three separate statementsâtwo INSERT statements and an UPDATE statementâthat update the database within a single transaction:</p> </div> @@ -4618,7 +4492,7 @@ COMMIT WORK; </div> </div> <div class="sect2"> -<h3 id="call_statement">3.6. CALL Statement</h3> +<h3 id="call_statement">3.5. CALL Statement</h3> <div class="paragraph"> <p>The CALL statement invokes a stored procedure in Java (SPJ) in a Trafodion SQL database.</p> </div> @@ -4634,7 +4508,7 @@ argument-list is: </div> </div> <div class="sect3"> -<h4 id="call_syntax">3.6.1. Syntax Description of CALL</h4> +<h4 id="call_syntax">3.5.1. Syntax Description of CALL</h4> <div class="ulist"> <ul> <li> @@ -4692,7 +4566,7 @@ separated by commas:</p> </div> </div> <div class="sect3"> -<h4 id="call_considerations">3.6.2. Considerations for CALL</h4> +<h4 id="call_considerations">3.5.2. Considerations for CALL</h4> <div class="sect4"> <h5 id="call_usage_restrictions">Usage Restrictions</h5> <div class="paragraph"> @@ -4793,7 +4667,7 @@ a CALL statement does not always automatically abort the transaction.</p> </div> </div> <div class="sect3"> -<h4 id="call_examples">3.6.3. Examples of CALL</h4> +<h4 id="call_examples">3.5.3. Examples of CALL</h4> <div class="ulist"> <ul> <li> @@ -4859,7 +4733,7 @@ ORDERNUM PARTNUM UNIT_PRICE QTY_ORDERED PARTDESC </div> </div> <div class="sect2"> -<h3 id="commit_work_statement">3.7. COMMIT WORK Statement</h3> +<h3 id="commit_work_statement">3.6. COMMIT WORK Statement</h3> <div class="paragraph"> <p>The COMMIT WORK statement commits any changes to objects made during the current transaction and ends the transaction. See <a href="#Transaction_Management">Transaction Management</a>.</p> @@ -4876,14 +4750,14 @@ the transaction. See <a href="#Transaction_Management">Transaction Management</a </div> </div> <div class="sect3"> -<h4 id="commit_work_considerations">3.7.1. Considerations for COMMIT WORK</h4> +<h4 id="commit_work_considerations">3.6.1. Considerations for COMMIT WORK</h4> <div class="paragraph"> <p>BEGIN WORK starts a transaction. COMMIT WORK or ROLLBACK WORK ends a transaction.</p> </div> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="commit_work_examples">3.7.2. Example of COMMIT WORK</h4> +<h4 id="commit_work_examples">3.6.2. Example of COMMIT WORK</h4> <div class="paragraph"> <p>Suppose that your application adds information to the inventory. You have received 24 terminals from a new supplier and want to add the supplier and update the quantity on hand. The part number for the @@ -4931,7 +4805,7 @@ COMMIT WORK; </div> </div> <div class="sect2"> -<h3 id="control_query_cancel_statement">3.8. CONTROL QUERY CANCEL Statement</h3> +<h3 id="control_query_cancel_statement">3.7. CONTROL QUERY CANCEL Statement</h3> <div class="paragraph"> <p>The CONTROL QUERY CANCEL statement cancels an executing query that you identify with a query ID. You can execute the CONTROL QUERY CANCEL statement in a client-based tool like TrafCI or through any ODBC or JDBC @@ -4946,7 +4820,7 @@ application.</p> </div> </div> <div class="sect3"> -<h4 id="control_query_cancel_syntax">3.8.1. Syntax Description of CONTROL QUERY CANCEL</h4> +<h4 id="control_query_cancel_syntax">3.7.1. Syntax Description of CONTROL QUERY CANCEL</h4> <div class="ulist"> <ul> <li> @@ -4965,7 +4839,7 @@ application.</p> </div> </div> <div class="sect3"> -<h4 id="control_query_cancel_considerations">3.8.2. Considerations for CONTROL QUERY CANCEL</h4> +<h4 id="control_query_cancel_considerations">3.7.2. Considerations for CONTROL QUERY CANCEL</h4> <div class="sect4"> <h5 id="control_query_cancel_benefitsl">Benefits of CONTROL QUERY CANCEL</h5> <div class="paragraph"> @@ -5052,7 +4926,7 @@ and rarely with other statements.</p> </div> </div> <div class="sect3"> -<h4 id="control_query_cancel_examples">3.8.3. Example of CONTROL QUERY CANCEL</h4> +<h4 id="control_query_cancel_examples">3.7.3. Example of CONTROL QUERY CANCEL</h4> <div class="paragraph"> <p>This CONTROL QUERY CANCEL statement cancels a specified query and provides a comment concerning the cancel operation:</p> @@ -5079,7 +4953,7 @@ error message indicating that the query has been canceled:</p> </div> </div> <div class="sect2"> -<h3 id="control_query_default_statement">3.9. CONTROL QUERY DEFAULT Statement</h3> +<h3 id="control_query_default_statement">3.8. CONTROL QUERY DEFAULT Statement</h3> <div class="paragraph"> <p>The CONTROL QUERY DEFAULT statement changes the default settings for the current process. You can execute the CONTROL QUERY DEFAULT statement in a client-based tool like TrafCI or through any ODBC or JDBC application.</p> @@ -5096,7 +4970,7 @@ control-default-option is: </div> </div> <div class="sect3"> -<h4 id="control_query_default_syntax">3.9.1. Syntax Description of CONTROL QUERY DEFAULT</h4> +<h4 id="control_query_default_syntax">3.8.1. Syntax Description of CONTROL QUERY DEFAULT</h4> <div class="ulist"> <ul> <li> @@ -5125,7 +4999,7 @@ to be reset to the value or values in effect at the start of the current session <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="control_query_default_considerations">3.9.2. Considerations for CONTROL QUERY DEFAULT</h4> +<h4 id="control_query_default_considerations">3.8.2. Considerations for CONTROL QUERY DEFAULT</h4> <div class="sect4"> <h5 id="control_query_default_scope">Scope of CONTROL QUERY DEFAULT</h5> <div class="paragraph"> @@ -5149,7 +5023,7 @@ EXECUTE y; -- uses MYSCHEMA;</code></pre> </div> </div> <div class="sect3"> -<h4 id="control_query_default_examples">3.9.3. Examples of CONTROL QUERY DEFAULT</h4> +<h4 id="control_query_default_examples">3.8.3. Examples of CONTROL QUERY DEFAULT</h4> <div class="ulist"> <ul> <li> @@ -5174,7 +5048,7 @@ EXECUTE y; -- uses MYSCHEMA;</code></pre> </div> </div> <div class="sect2"> -<h3 id="create_function_statement">3.10. CREATE FUNCTION Statement</h3> +<h3 id="create_function_statement">3.9. CREATE FUNCTION Statement</h3> <div class="paragraph"> <p>The CREATE FUNCTION statement registers a user-defined function (UDF) written in C as a function within a Trafodion database. Currently, Trafodion supports the creation of <em>scalar UDFs</em>, which return a single @@ -5222,7 +5096,7 @@ return-parameter-declaration is: </div> <div style="page-break-after: always;"></div> <div class="sect3"> -<h4 id="create_function_syntax">3.10.1. Syntax Description of CREATE FUNCTION</h4> +<h4 id="create_function_syntax">3.9.1. Syntax Description of CREATE FUNCTION</h4> <div class="ulist"> <ul> <li> @@ -5404,7 +5278,7 @@ bytes. acceptable values range from 0 to 16000. the default is no state area.</p <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="create_function_considerations">3.10.2. Considerations for CREATE FUNCTION</h4> +<h4 id="create_function_considerations">3.9.2. Considerations for CREATE FUNCTION</h4> <div class="sect4"> <h5 id="create_function_required_privileges">Required Privileges</h5> <div class="paragraph"> @@ -5447,7 +5321,7 @@ In this case, if you create a function in a private schema, it will be owned by </div> </div> <div class="sect3"> -<h4 id="create_function_examples">3.10.3. Examples of CREATE FUNCTION</h4> +<h4 id="create_function_examples">3.9.3. Examples of CREATE FUNCTION</h4> <div class="ulist"> <ul> <li> @@ -5490,9 +5364,11 @@ five input integers:</p> </div> </div> <div class="sect2"> -<h3 id="create_index_statement">3.11. CREATE INDEX Statement</h3> +<h3 id="create_index_statement">3.10. CREATE INDEX Statement</h3> <div class="paragraph"> -<p>The CREATE INDEX statement creates an SQL index based on one or more columns of a table or table-like object.</p> +<p>The CREATE INDEX statement creates an SQL index based on one or more columns of a table or table-like object. +The CREATE VOLATILE INDEX statement creates an SQL index with a lifespan that is limited to the SQL session that +the index is created. Volatile indexes are dropped automatically when the session ends. See <a href="#indexes">Indexes</a>.</p> </div> <div class="paragraph"> <p>CREATE INDEX is a Trafodion SQL extension.</p> @@ -5513,7 +5389,7 @@ AUTOCOMMIT must be turned ON (the default) for the session. </div> <div class="listingblock"> <div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">CREATE [VOLATILE | UNIQUE] INDEX index ON table +<pre class="CodeRay highlight"><code data-lang="text">CREATE [VOLATILE] INDEX index ON table (column-name [ASC[ENDING] | DESC[ENDING]] [,column-name [ASC[ENDING] | DESC[ENDING]]]...) [HBASE_OPTIONS (hbase-options-list)] @@ -5524,37 +5400,10 @@ hbase-options-list is: </div> </div> <div class="sect3"> -<h4 id="create_index_syntax">3.11.1. Syntax Description of CREATE INDEX</h4> +<h4 id="create_index_syntax">3.10.1. Syntax Description of CREATE INDEX</h4> <div class="ulist"> <ul> <li> -<p><code>VOLATILE</code></p> -<div class="paragraph"> -<p>The CREATE VOLATILE INDEX statement creates an SQL index with a lifespan that is limited to the SQL session that the index is created. Volatile indexes are dropped automatically when the session ends. See <a href="#indexes">Indexes</a>.</p> -</div> -</li> -<li> -<p><code>UNIQUE</code></p> -<div class="paragraph"> -<p>The CREATE UNIQUE INDEX statement creates a unique index on a table and enforces uniqueness for the indexed field, that is, it imposes the restriction that any duplicate column values are disallowed and must be eliminated before creating a unique index on a column.</p> -</div> -<div class="paragraph"> -<p>Unique index not only improves the query performance, but also provides data integrity checking. The constraint is checked when rows of the table are inserted or updated.</p> -</div> -<div class="admonitionblock note"> -<table> -<tr> -<td class="icon"> -<i class="fa icon-note" title="Note"></i> -</td> -<td class="content"> -Multiple NULL values are treated as duplicate values for a column which can contain only one NULL value. -</td> -</tr> -</table> -</div> -</li> -<li> <p><code><em>index</em></code></p> <div class="paragraph"> <p>is an SQL identifier that specifies the simple name for the new index. You cannot qualify <em>index</em> with its schema @@ -5728,7 +5577,7 @@ KeyPrefixRegionSplitPolicy'</p></td> <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="create_index_considerations">3.11.2. Considerations for CREATE INDEX</h4> +<h4 id="create_index_considerations">3.10.2. Considerations for CREATE INDEX</h4> <div class="paragraph"> <p>Indexes are created under a single transaction. When an index is created, the following steps occur:</p> </div> @@ -5837,7 +5686,7 @@ the clustering key of the underlying table cannot exceed 2048 bytes.</p> </div> </div> <div class="sect3"> -<h4 id="create_index_examples">3.11.3. Examples of CREATE INDEX</h4> +<h4 id="create_index_examples">3.10.3. Examples of CREATE INDEX</h4> <div class="ulist"> <ul> <li> @@ -5849,87 +5698,13 @@ ON persnl.employee (last_name, first_name);</code></pre> </div> </div> </li> -<li> -<p>This example shows that a volatile index can be created only on a volatile table.</p> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">SQL>create volatile table test2(c1 int); ---- SQL operation complete. - -SQL>create volatile index idx_test2 on test2(c1); ---- SQL operation complete. - -SQL>create table test1(c1 int); ---- SQL operation complete. - -SQL>create volatile index idx_test1 on test1 (c1); - -*** ERROR[4082] Object TEST1 does not exist or is inaccessible. [2017-01-13 11:35:26]</code></pre> -</div> -</div> -</li> -<li> -<p>This example shows a unique index can be created on a table which has only one NULL value.</p> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">SQL>select * from t25; - -A B ------------ ---------- - 1 NULL - 2 aaa - ---- 2 row(s) selected. - -SQL>create unique index idx_t25 on t25(b); ---- SQL operation complete. - -SQL>showddl t25; - -CREATE TABLE TRAFODION.SEABASE.T25 - ( - A INT DEFAULT NULL NOT SERIALIZED, - B CHAR(10) CHARACTER SET ISO88591 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED - ) - ATTRIBUTES ALIGNED FORMAT; - -CREATE UNIQUE INDEX IDX_T25 ON TRAFODION.SEABASE.T25 - ( - B ASC - ) - ATTRIBUTES ALIGNED FORMAT; - ---- SQL operation complete.</code></pre> -</div> -</div> -</li> -<li> -<p>This example shows a unique index cannot be created on a table which has multiple NULL values.</p> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">SQL>select * from t25; - -A B ------------ ---------- - 1 NULL - 2 aaa - ---- 2 row(s) selected. - -SQL>create unique index idx_t25 on t25(b); - -*** ERROR[8110] Duplicate rows detected. [2017-01-12 17:17:51] -*** ERROR[1053] Unique index TRAFODION.SEABASE.IDX_T25 could not be created because the specified column(s) contain duplicate data. [2017-01-12 17:17:51]</code></pre> -</div> -</div> -</li> </ul> </div> <div style="page-break-after: always;"></div> </div> </div> <div class="sect2"> -<h3 id="create_library_statement">3.12. CREATE LIBRARY Statement</h3> +<h3 id="create_library_statement">3.11. CREATE LIBRARY Statement</h3> <div class="paragraph"> <p>The CREATE LIBRARY statement registers a library object in a Trafodion database. A library object can be an SPJ’s JAR file or a UDF’s library file.</p> @@ -5960,7 +5735,7 @@ is OFF. To run this statement, AUTOCOMMIT must be turned ON (the default) for th </div> </div> <div class="sect3"> -<h4 id="create_library_syntax">3.12.1. Syntax Description of CREATE LIBRARY</h4> +<h4 id="create_library_syntax">3.11.1. Syntax Description of CREATE LIBRARY</h4> <div class="ulist"> <ul> <li> @@ -6005,7 +5780,7 @@ will see an error message indicating that the jar or dll file was not found.</p> </div> </div> <div class="sect3"> -<h4 id="create_library_considerations">3.12.2. Considerations for CREATE LIBRARY</h4> +<h4 id="create_library_considerations">3.11.2. Considerations for CREATE LIBRARY</h4> <div class="ulist"> <ul> <li> @@ -6061,7 +5836,7 @@ In this case, if you create a library in a private schema, it will be owned by t </div> </div> <div class="sect3"> -<h4 id="create_library_examples">3.12.3. Examples of CREATE LIBRARY</h4> +<h4 id="create_library_examples">3.11.3. Examples of CREATE LIBRARY</h4> <div class="ulist"> <ul> <li> @@ -6086,7 +5861,7 @@ In this case, if you create a library in a private schema, it will be owned by t </div> </div> <div class="sect2"> -<h3 id="create_procedure_statement">3.13. CREATE PROCEDURE Statement</h3> +<h3 id="create_procedure_statement">3.12. CREATE PROCEDURE Statement</h3> <div class="paragraph"> <p>The CREATE PROCEDURE statement registers a Java method as a stored procedure in Java (SPJ) within a Trafodion database.</p> </div> @@ -6161,7 +5936,7 @@ the remaining syntax is not case-sensitive. </table> </div> <div class="sect3"> -<h4 id="create_procedure_syntax">3.13.1. Syntax Description of CREATE PROCEDURE</h4> +<h4 id="create_procedure_syntax">3.12.1. Syntax Description of CREATE PROCEDURE</h4> <div class="ulist"> <ul> <li> @@ -6516,7 +6291,7 @@ reuses them during subsequent calls, thus optimizing the CALL statement.</p> </div> </div> <div class="sect3"> -<h4 id="create_procedure_considerations">3.13.2. Considerations for CREATE PROCEDURE</h4> +<h4 id="create_procedure_considerations">3.12.2. Considerations for CREATE PROCEDURE</h4> <div class="sect4"> <h5 id="create_procedure_required_privileges">Required Privileges</h5> <div class="paragraph"> @@ -6630,7 +6405,7 @@ JDBC transaction methods, <code>Connection.commit()</code> and <code>Connection. </div> </div> <div class="sect3"> -<h4 id="create_procedure_examples">3.13.3. Examples of CREATE PROCEDURE</h4> +<h4 id="create_procedure_examples">3.12.3. Examples of CREATE PROCEDURE</h4> <div class="ulist"> <ul> <li> @@ -6794,7 +6569,7 @@ ORDERNUM PARTNUM UNIT_PRICE QTY_ORDERED PARTDESC </div> </div> <div class="sect2"> -<h3 id="create_role_statement">3.14. CREATE ROLE Statement</h3> +<h3 id="create_role_statement">3.13. CREATE ROLE Statement</h3> <div class="paragraph"> <p>The CREATE ROLE statement creates an SQL role. See <a href="#roles">Roles</a>.</p> </div> @@ -6807,7 +6582,7 @@ grantor is: </div> </div> <div class="sect3"> -<h4 id="create_role_syntax">3.14.1. Syntax Description of CREATE ROLE</h4> +<h4 id="create_role_syntax">3.13.1. Syntax Description of CREATE ROLE</h4> <div class="ulist"> <ul> <li> @@ -6837,7 +6612,7 @@ See <a href="#Case_Insensitive_Delimited_Identifiers">Case-Insensitive Delimited <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="create_role_considerations">3.14.2. Considerations for CREATE ROLE</h4> +<h4 id="create_role_considerations">3.13.2. Considerations for CREATE ROLE</h4> <div class="ulist"> <ul> <li> @@ -6872,7 +6647,7 @@ See <a href="#Case_Insensitive_Delimited_Identifiers">Case-Insensitive Delimited </div> </div> <div class="sect3"> -<h4 id="create_role_examples">3.14.3. Examples of CREATE ROLE</h4> +<h4 id="create_role_examples">3.13.3. Examples of CREATE ROLE</h4> <div class="ulist"> <ul> <li> @@ -6897,7 +6672,7 @@ See <a href="#Case_Insensitive_Delimited_Identifiers">Case-Insensitive Delimited </div> </div> <div class="sect2"> -<h3 id="create_schema_statement">3.15. CREATE SCHEMA Statement</h3> +<h3 id="create_schema_statement">3.14. CREATE SCHEMA Statement</h3> <div class="paragraph"> <p>The CREATE SCHEMA statement creates a schema in the database. See <a href="#schemas">Schemas</a>.</p> </div> @@ -6927,7 +6702,7 @@ schema-clause is: </div> </div> <div class="sect3"> -<h4 id="create_schema_syntax">3.15.1. Syntax Description of CREATE SCHEMA</h4> +<h4 id="create_schema_syntax">3.14.1. Syntax Description of CREATE SCHEMA</h4> <div class="ulist"> <ul> <li> @@ -6976,7 +6751,7 @@ user becomes the schema owner.</p> </div> </div> <div class="sect3"> -<h4 id="create_schema_considerations">3.15.2. Considerations for CREATE SCHEMA</h4> +<h4 id="create_schema_considerations">3.14.2. Considerations for CREATE SCHEMA</h4> <div class="sect4"> <h5 id="create_schema_reserved_schema_names">Reserved Schema Names</h5> <div class="paragraph"> @@ -7050,7 +6825,7 @@ By default, this privilege is granted to PUBLIC, but it can be revoked by DB ROO </div> </div> <div class="sect3"> -<h4 id="create_schema_examples">3.15.3. Examples of CREATE SCHEMA</h4> +<h4 id="create_schema_examples">3.14.3. Examples of CREATE SCHEMA</h4> <div class="ulist"> <ul> <li> @@ -7094,329 +6869,7 @@ By default, this privilege is granted to PUBLIC, but it can be revoked by DB ROO </div> </div> <div class="sect2"> -<h3 id="create_sequence_statement">3.16. CREATE SEQUENCE Statement</h3> -<div class="paragraph"> -<p>The CREATE SEQUENCE Statement produces an automatic ascending sequence of numeric values, which can be used by multiple users as primary key values. For example, to generate only odd numbers in a sequence, you can create a sequence defined with START WITH=1, INCREMENT BY=2.</p> -</div> -<div class="paragraph"> -<p>Multiple options can be concurrently specified and separated by a space.</p> -</div> -<div class="paragraph"> -<p>There are two expressions can be used with sequence:</p> -</div> -<div class="ulist"> -<ul> -<li> -<p><code>seqnum(SEQUENCE, current)</code>: get the current value which is returned from the sequence on the current session rather than the current value of the sequence.</p> -<div class="paragraph"> -<p>For example, a sequence object called <code>employee_seq</code> which starts with 1 and caches up to 25 with only three users.</p> -</div> -<div class="paragraph"> -<p>If User A calls <code>seqnum(SEQUENCE, current)</code>, it will return 1 and reserve from 1 to 25, and User B immediately calls <code>seqnum(SEQUENCE, current)</code> and it will return 26 and reserve from 26 to 51, then User C immediately calls <code>seqnum(SEQUENCE, current)</code> and it will return 51 and reserve from 51 to 75.</p> -</div> -<div class="paragraph"> -<p>Now, if User A immediately calls <code>seqnum(SEQUENCE, next)</code>, it will return 2 rather than 76. 76 will be returned if User A immediately calls <code>seqnum(SEQUENCE, next)</code> after achieving 25 where the cache for User A is exhausted.</p> -</div> -</li> -<li> -<p><code>seqnum(SEQUENCE, next)</code>: advance the sequence and retrieve the next value. For an ascending sequence, this value is increasing.</p> -<div class="paragraph"> -<p>NOTE:</p> -</div> -<div class="ulist"> -<ul> -<li> -<p>It always returns the initial value of the sequence by calling <code>seqnum(SEQUENCE, current)</code> or <code>seqnum(SEQUENCE, next)</code> for the first time.</p> -</li> -<li> -<p>It returns a new incremented value of the sequence with each subsequent reference to <code>seqnum(SEQUENCE, next)</code>.</p> -</li> -</ul> -</div> -</li> -</ul> -</div> -<div class="paragraph"> -<p>CREATE SEQUENCE is a Trafodion SQL extension.</p> -</div> -<div class="paragraph"> -<p>For more inforamation, see <a href="#drop_sequence_statement">DROP SEQUENCE Statement</a> or <a href="#alter_sequence_statement">ALTER SEQUENCE Statement</a>.</p> -</div> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">CREATE SEQUENCE [[catalog-name.]schema-name.]sequence -[START WITH integer] -[INCREMENT BY integer] -[MAXVALUE integer | NOMAXVALUE] -[MINVALUE integer] -[CACHE integer | NO CACHE] -[CYCLE | NO CYCLE] -[DATA TYPE]</code></pre> -</div> -</div> -<div class="paragraph"> -<p>By default, it is an ascending sequence that starts with 1, increments by 1, has cache value of 25 and the -maximum value of 2<sup>63</sup>-2, does not cycle and belongs to LARGEINT data type.</p> -</div> -<div class="sect3"> -<h4 id="create_sequence_syntax">3.16.1. Syntax Description of CREATE SEQUENCE</h4> -<div class="ulist"> -<ul> -<li> -<p><code>[[catalog-name.]schema-name.]sequence</code></p> -<div class="paragraph"> -<p>Specifies the name of the sequence to be created, with optional catalog and schema name, where each part of the name is a valid sql identifier with a maximum of 128 characters.</p> -</div> -<div class="paragraph"> -<p>The name should be unique and does not exist for any session in the same schema. Trafodion does not support the overloading of session names. That is, you cannot register the same session name more than once.</p> -</div> -<div class="paragraph"> -<p>If you do not fully qualify the session name, Trafodion qualifies it according to the schema of the current session. For more information, see <a href="#identifiers">Identifiers</a> and <a href="#database_object_names">Database Object Names</a>.</p> -</div> -</li> -<li> -<p><code>START WITH</code></p> -<div class="paragraph"> -<p>Specifies the initial value. This value can only be positive, and must be greater than or equal to MINVALUE (if NO CACHE is specified) and less than MAXVALUE.</p> -</div> -<div class="admonitionblock note"> -<table> -<tr> -<td class="icon"> -<i class="fa icon-note" title="Note"></i> -</td> -<td class="content"> -If the initial value is beyond the range specified by MINVALUE or MAXVALUE, an error will be raised. -</td> -</tr> -</table> -</div> -<div class="paragraph"> -<p>If not specified, the START WITH defaults to 1. For an ascending sequence, this value is MINVALUE.</p> -</div> -</li> -<li> -<p><code>INCREMENT BY</code></p> -<div class="paragraph"> -<p>Specifies the increment value between consecutive sequence values.</p> -</div> -<div class="admonitionblock note"> -<table> -<tr> -<td class="icon"> -<i class="fa icon-note" title="Note"></i> -</td> -<td class="content"> -This value can only be positive, so that Trafodion only supports ascending sequence. The value must be smaller than or equal to the difference between MAXVALUE and MINVALUE. -</td> -</tr> -</table> -</div> -<div class="paragraph"> -<p>If not specified, the INCREMENT BY defaults to 1.</p> -</div> -</li> -<li> -<p><code>MAXVALUE</code></p> -<div class="paragraph"> -<p>Specifies the maximum value where an ascending sequence stops generating values or cycles. The default is 2<sup>^63</sup>-2.</p> -</div> -<div class="paragraph"> -<p>The MAXVALUE of a sequence depends on the maximum value supported by the data type, and you can also specify a MAXVALUE within the range.</p> -</div> -<div class="paragraph"> -<p>NOTE:</p> -</div> -<div class="ulist"> -<ul> -<li> -<p>An error is returned if MAXVALUE is beyond supported range, or if subsequent value is generated for an ascending sequence when the MAXVALUE is exceeded with NO CYCLE specified.</p> -</li> -<li> -<p>MAXVALUE might not be same as the actual maximum value that the sequence generated if the INCREAMENT BY is a value other than 1. For example, when a sequence is specified with START WITH 3, INCREMENT 4 and MAXVALUE 12 will return a maximum value of 11.</p> -</li> -</ul> -</div> -</li> -<li> -<p><code>NONMAXVALUE</code></p> -<div class="paragraph"> -<p>If NOMAXVALUE is specified, for an ascending sequence, the MAXVALUE is the value you specified or the maximum value supported by the data type.</p> -</div> -</li> -<li> -<p><code>MINVALUE</code></p> -<div class="paragraph"> -<p>Specifies the minimum value where an ascending sequence cycles after hitting the maximum limit. The default is 1.</p> -</div> -<div class="paragraph"> -<p>The MINVALUE of a sequence depends on the minimum value supported by the data type, and you can also specify a MINVALUE within the range.</p> -</div> -<div class="paragraph"> -<p>If MINVALUE and START WITH are not specified, for an ascending sequence, the MINVALUE defaults to 1.</p> -</div> -</li> -<li> -<p><code>CYCLE</code></p> -<div class="paragraph"> -<p>Specifies that the sequence exhausts its range and wraps around after reaching its MAXVALUE.</p> -</div> -<div class="paragraph"> -<p>If specified, for an ascending sequence, it restarts from MINVALUE after reaching MAXVALUE.</p> -</div> -</li> -<li> -<p><code>NOCYCLE</code></p> -<div class="paragraph"> -<p>Specifies that the sequence cannot cycle once the MAXVALUE is reached, and throws an exception when generating subsequent value if the limit is exceeded.</p> -</div> -<div class="paragraph"> -<p>NOCYCLE is the default.</p> -</div> -</li> -<li> -<p><code>CACHE</code></p> -<div class="paragraph"> -<p>Specifies the range of upcoming successive values preallocated and stored in memory for speeding up future request.</p> -</div> -<div class="paragraph"> -<p>The default CACHE value is 25.</p> -</div> -<div class="paragraph"> -<p>The minimum CACHE value is 2.</p> -</div> -<div class="paragraph"> -<p>The CACHE value must be less than or equal to the value determined by following formula:</p> -</div> -<div class="paragraph"> -<p><code>(MAXVALUE â START WITH + 1) / INCREMENT BY</code></p> -</div> -<div class="paragraph"> -<p>The sequence cache will be repopulated when the cache is exhausted.</p> -</div> -<div class="admonitionblock note"> -<table> -<tr> -<td class="icon"> -<i class="fa icon-note" title="Note"></i> -</td> -<td class="content"> -The unused preallocated values will be lost and leave unintended gaps if unexpected shutdown occurs or the sequence object is manually restarted, Trafodion will continue to cache new values from where it left off, so that the same value will never appear twice unless CYCLE is specified. -</td> -</tr> -</table> -</div> -</li> -<li> -<p><code>NOCACHE</code></p> -<div class="paragraph"> -<p>Specifies the values of the sequence are not preallocated, which lowers the risk of losing values even if it might cause performance degradation. In this case, every request for a new value will be synchronously updated in the system table.</p> -</div> -<div class="paragraph"> -<p>If both CACHE and NOCACHE are not specified, it will cache 25 values by default.</p> -</div> -</li> -<li> -<p><code>DATA TYPE</code></p> -<div class="paragraph"> -<p>A sequence can be specified as following data types:</p> -</div> -<table class="tableblock frame-all grid-all spread"> -<colgroup> -<col style="width: 33.3333%;"> -<col style="width: 33.3333%;"> -<col style="width: 33.3334%;"> -</colgroup> -<tbody> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock">Type</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Minimum value</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">Maximum value</p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock">UNSIGNED SMALLINT</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">1</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">2<sup>16</sup>-1</p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock">UNSIGHED INTEGER</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">1</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">2<sup>32</sup>-1</p></td> -</tr> -<tr> -<td class="tableblock halign-left valign-top"><p class="tableblock">LARGEINT</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">1</p></td> -<td class="tableblock halign-left valign-top"><p class="tableblock">2<sup>63</sup>-2</p></td> -</tr> -</tbody> -</table> -<div class="paragraph"> -<p>If not specified, the default data type is LARGEINT.</p> -</div> -</li> -</ul> -</div> -<div style="page-break-after: always;"></div> -</div> -<div class="sect3"> -<h4 id="create_sequence_considerations">3.16.2. Considerations for CREATE SEQUENCE</h4> -<div class="paragraph"> -<p>To issue a CREATE SEQUENCE statement, one of the following must be true:</p> -</div> -<div class="ulist"> -<ul> -<li> -<p>You are DB ROOT.</p> -</li> -<li> -<p>You are creating the sequence in a shared schema.</p> -</li> -<li> -<p>You are the private schema owner.</p> -</li> -<li> -<p>You have the CREATE or CREATE_SEQUENCE component privilege for the SQL_OPERATIONS component.</p> -<div class="admonitionblock note"> -<table> -<tr> -<td class="icon"> -<i class="fa icon-note" title="Note"></i> -</td> -<td class="content"> -In this case, if you create a sequence in a private schema, it will be owned by the schema owner. -</td> -</tr> -</table> -</div> -</li> -</ul> -</div> -<div style="page-break-after: always;"></div> -</div> -<div class="sect3"> -<h4 id="create_sequence_examples">3.16.3. Examples of CREATE SEQUENCE</h4> -<div class="paragraph"> -<p>The following statement creates a sequence named <code>employee_seq</code>, that starts with 1, increments by 1, has maximum value of 10000, does not cycle, caches 20 at a time and belongs to UNSIGNED SAMLLINT.</p> -</div> -<div class="listingblock"> -<div class="content"> -<pre class="CodeRay highlight"><code data-lang="text">CREATE SEQUENCE employee_seq -START WITH 1 -INCREMENT BY 1 -MAXVALUE 10000 -NOCYCLE -CACHE 20 -UNSIGNED SMALLINT</code></pre> -</div> -</div> -<div class="paragraph"> -<p>The first reference to <code>seqnum(empolyee_seq, next)</code> will return 10000, and the second reference will return 10001. Each subsequent reference will return a value 1 greater than the previous value.</p> -</div> -<div style="page-break-after: always;"></div> -</div> -</div> -<div class="sect2"> -<h3 id="create_table_statement">3.17. CREATE TABLE Statement</h3> +<h3 id="create_table_statement">3.15. CREATE TABLE Statement</h3> <div class="paragraph"> <p>The CREATE TABLE statement creates a Trafodion SQL table, which is a mapping of a relational SQL table to an HBase table. The CREATE VOLATILE TABLE statement creates a temporary Trafodion SQL table that exists only during an SQL session. The @@ -7537,7 +6990,7 @@ hbase-options-list is: </div> </div> <div class="sect3"> -<h4 id="create_table_syntax">3.17.1. Syntax Description of CREATE TABLE</h4> +<h4 id="create_table_syntax">3.15.1. Syntax Description of CREATE TABLE</h4> <div class="ulist"> <ul> <li> @@ -8000,7 +7453,7 @@ the <em>table</em> will have the same divisioning as the <em>source-table</em>.< <div style="page-break-after: always;"></div> </div> <div class="sect3"> -<h4 id="create_table_considerations">3.17.2. Considerations for CREATE TABLE</h4> +<h4 id="create_table_considerations">3.15.2. Considerations for CREATE TABLE</h4> <div class="paragraph"> <p>The following subsections provide considerations for various CREATE TABLE options:</p> </div> @@ -8086,7 +7539,7 @@ sessions, and therefore allow multiple sessions to use the same volatile tempora any conflicts.</p> </li> <li> -<p>Volatile tables support creation of indexes. Volatile index can be created only on volatile table.</p> +<p>Volatile tables support creation of indexes.</p> </li> <li> <p>Volatile tables are partitioned by the system. The number
<TRUNCATED>
