| -- This file is automatically generated. You should know what you did if you want to edit this |
| -- !sql -- |
| 1 4x0fdjDNBZAJxCD7qm/EHg== |
| |
| -- !sql -- |
| 1 |
| |
| -- !sql -- |
| 1 |
| |
| -- !information_schema1 -- |
| internal regression_test_view_p0 test_varchar_view SELECT GROUP_CONCAT(cast( `internal`.`regression_test_view_p0`.`test_view_table`.`id` as varchar)) AS `id` from `internal`.`regression_test_view_p0`.`test_view_table` NONE NO root@% DEFINER utf8 \N |
| |
| -- !information_schema2 -- |
| internal regression_test_view_p0 test_view select 1,to_base64(AES_ENCRYPT('doris','doris')) NONE NO root@% DEFINER utf8 \N |
| |
| -- !sql -- |
| 1 2023-08-01 DORID_FIELD1 DORID_FIELD2 ["cat", "dog"] cat |
| 1 2023-08-01 DORID_FIELD1 DORID_FIELD2 ["cat", "dog"] dog |
| |
| -- !sql -- |
| 960 |
| |
| -- !sql2 -- |
| |
| |
| -- !select_aes -- |
| 17777208882 |
| |
| -- !show_aes -- |
| test_view_aes CREATE VIEW `test_view_aes`\n(__aes_decrypt_0)\n AS SELECT aes_decrypt(from_base64("EXp7k7M9Zv1mIwPpno28Hg=="), '17IMZrGdwWf2Piy8', 'II2HLtihr5TQpQgR', 'AES_128_CBC'); utf8mb4 utf8mb4_0900_bin |
| |
| -- !comment0 -- |
| test_view_table2_view CREATE VIEW `test_view_table2_view`\n(CREATE_DATE)\n AS SELECT \n date_format(`internal`.`regression_test_view_p0`.`test_view_table2`.`c_date`,'%Y-%m-%d') AS `CREATE_DATE`\n FROM \n `internal`.`regression_test_view_p0`.`test_view_table2`\n GROUP BY \n date_format(`internal`.`regression_test_view_p0`.`test_view_table2`.`c_date`, '%Y-%m-%d'); utf8mb4 utf8mb4_0900_bin |
| |
| -- !comment1 -- |
| test_view_table2_view CREATE VIEW `test_view_table2_view`\n(CREATE_DATE)\n COMMENT 'comment1' AS SELECT \n date_format(`internal`.`regression_test_view_p0`.`test_view_table2`.`c_date`,'%Y-%m-%d') AS `CREATE_DATE`\n FROM \n `internal`.`regression_test_view_p0`.`test_view_table2`\n GROUP BY \n date_format(`internal`.`regression_test_view_p0`.`test_view_table2`.`c_date`, '%Y-%m-%d'); utf8mb4 utf8mb4_0900_bin |
| |
| -- !comment2 -- |
| test_view_table2_view CREATE VIEW `test_view_table2_view`\n(CREATE_DATE)\n COMMENT 'comment1' AS SELECT\n date_format(`internal`.`regression_test_view_p0`.`test_view_table2`.`c_date`,'%Y-%m-%d') AS `CREATE_DATE`\n FROM\n `internal`.`regression_test_view_p0`.`test_view_table2`\n GROUP BY\n date_format(`internal`.`regression_test_view_p0`.`test_view_table2`.`c_date`, '%Y-%m-%d'); utf8mb4 utf8mb4_0900_bin |
| |
| -- !comment4 -- |
| test_view_table2_view CREATE VIEW `test_view_table2_view`\n(CREATE_DATE)\n COMMENT 'comment4' AS SELECT\n date_format(`internal`.`regression_test_view_p0`.`test_view_table2`.`c_date`,'%Y-%m-%d') AS `CREATE_DATE`\n FROM\n `internal`.`regression_test_view_p0`.`test_view_table2`\n GROUP BY\n date_format(`internal`.`regression_test_view_p0`.`test_view_table2`.`c_date`, '%Y-%m-%d'); utf8mb4 utf8mb4_0900_bin |
| |
| -- !comment_empty -- |
| test_view_table2_view CREATE VIEW `test_view_table2_view`\n(CREATE_DATE)\n AS SELECT\n date_format(`internal`.`regression_test_view_p0`.`test_view_table2`.`c_date`,'%Y-%m-%d') AS `CREATE_DATE`\n FROM\n `internal`.`regression_test_view_p0`.`test_view_table2`\n GROUP BY\n date_format(`internal`.`regression_test_view_p0`.`test_view_table2`.`c_date`, '%Y-%m-%d'); utf8mb4 utf8mb4_0900_bin |
| |
| -- !desc_view_1 -- |
| c_date varchar(50) Yes false \N |
| |
| -- !desc_view_2 -- |
| C_DatE varchar(50) Yes false \N |
| |
| -- !desc_view_3 -- |
| c_dATE varchar(65533) Yes false \N |
| |
