github.com/pingcap/br@v5.3.0-alpha.0.20220125034240-ec59c7b6ce30+incompatible/tests/lightning_view/data/db0.v2-schema-view.sql (about)

     1  /*!40101 SET NAMES binary*/;
     2  DROP TABLE IF EXISTS `v2`;
     3  DROP VIEW IF EXISTS `v2`;
     4  SET @PREV_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
     5  SET @PREV_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
     6  SET @PREV_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
     7  SET character_set_client = utf8;
     8  SET character_set_results = utf8;
     9  SET collation_connection = utf8_general_ci;
    10  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`192.168.198.178` SQL SECURITY DEFINER VIEW `v2` (`s`) AS SELECT `s` FROM `db1`.`v1` WHERE `i`<2;
    11  SET character_set_client = @PREV_CHARACTER_SET_CLIENT;
    12  SET character_set_results = @PREV_CHARACTER_SET_RESULTS;
    13  SET collation_connection = @PREV_COLLATION_CONNECTION;