You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/10/10 06:45:00 UTC

[GitHub] [doris] nextdreamblue opened a new issue, #13242: [Bug] create view need check table by table name regex

nextdreamblue opened a new issue, #13242:
URL: https://github.com/apache/doris/issues/13242

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   master-63903136c492733449030ba222ce36ade152f2e8
   
   ### What's Wrong?
   
   When create view, it can create name like '111mv1', but return error when create table or MATERIALIZED VIEW.
   MySQL [test]> CREATE VIEW 111mv1 AS SELECT aaa,sum(abc) as abc FROM testmv;
   Query OK, 0 rows affected (4.25 sec)
   
   MySQL [test]> show tables;
   +--------------------+
   | Tables_in_test     |
   +--------------------+
   | 111mv1             |
   | testmv             |
   +--------------------+
   
   MySQL [test]> CREATE MATERIALIZED VIEW 11111mv1 AS SELECT aaa,sum(abc) as abc FROM testmv;
   ERROR 1103 (42000): errCode = 2, detailMessage = Incorrect table name '11111mv1'. Table name regex is '^[a-zA-Z][a-zA-Z0-9_]*$'
   
   ### What You Expected?
   
   check view name when create
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] yiguolei closed issue #13242: [Bug] create view need check table by table name regex

Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #13242: [Bug] create view need check table by table name regex
URL: https://github.com/apache/doris/issues/13242


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org