Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space ML1 and version 9.2

ClustrixDB provides partial, view-only support for some objects in INFORMATION_SCHEMA.

Table of Contents

Supported Views

Read-only support is available for these INFORMATION_SCHEMA views. Column definitions and results may vary from MySQL. 

  • character_sets                 
  • collations                     
  • columns                        
  • events                         
  • files                          
  • key_column_usage               
  • partitions                     
  • processlist                    
  • referential_constraints        
  • routines                       
  • schemata                       
  • schema_privileges              
  • statistics                     
  • tables                         
  • table_constraints              
  • table_privileges               
  • triggers                       
  • user_privileges                
  • views                 

Anchor
unsupported
unsupported
Unsupported Views

ClustrixDB does not support these objects:

  • collation_character_set_applicability
  • column_privileges
  • engines
  • global_status                
  • global_variables        
  • nbd_transid_mysql_connection_map
  • optimizer_trace
  • parameters
  • plugins
  • profiling
  • session_status     
  • session_variables
  • tablespaces

ClustrixDB-Specific Views

The follow are views specific to ClustrixDB:

View NameDescription
clx_function_privilegesFunction privileges granted to users
clx_procedure_privilegesProcedure privileges granted to users
global_variables_with_defaultsCurrent Global variables settings along with their default values