release/src/router/mysql/mysql-test/suite/funcs_1/r/is_statistics_is.result

   1 DROP DATABASE IF EXISTS db_datadict;
   2 CREATE DATABASE db_datadict;
   3 DROP   USER testuser1@localhost;
   4 CREATE USER testuser1@localhost;
   5 GRANT SELECT ON db_datadict.* TO testuser1@localhost;
   6 SELECT * FROM information_schema.statistics
   7 WHERE table_schema = 'information_schema'
   8 ORDER BY table_schema, table_name, index_name, seq_in_index, column_name;
   9 TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      NON_UNIQUE      INDEX_SCHEMA    INDEX_NAME      SEQ_IN_INDEX    COLUMN_NAME     COLLATION       CARDINALITY     SUB_PART        PACKED  NULLABLE        INDEX_TYPE      COMMENT
  10 # Establish connection testuser1 (user=testuser1)
  11 SELECT * FROM information_schema.statistics
  12 WHERE table_schema = 'information_schema'
  13 ORDER BY table_schema, table_name, index_name, seq_in_index, column_name;
  14 TABLE_CATALOG   TABLE_SCHEMA    TABLE_NAME      NON_UNIQUE      INDEX_SCHEMA    INDEX_NAME      SEQ_IN_INDEX    COLUMN_NAME     COLLATION       CARDINALITY     SUB_PART        PACKED  NULLABLE        INDEX_TYPE      COMMENT
  15 # Switch to connection default and close connection testuser1
  16 DROP USER testuser1@localhost;
  17 DROP DATABASE db_datadict;