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/08/23 06:59:11 UTC

[GitHub] [doris] zingdle opened a new issue, #11993: [Bug] can't create table when column name with dot(.)

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

   ### 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
   
   1.1.1
   
   ### What's Wrong?
   
   ```sql
   CREATE DATABASE FOO;
   
   CREATE TABLE `FOO`.`tbl`
   (
       `ID`    BIGINT NOT NULL,
       `COL.0` BIGINT NOT NULL,
       `COL.1` BIGINT NOT NULL
   ) UNIQUE KEY(`ID`)
   DISTRIBUTED BY HASH(`ID`) BUCKETS 10
   PROPERTIES("replication_num" = "1");
   ```
   
   I got:
   ```
   ERROR 1166 (42000): errCode = 2, detailMessage = Incorrect column name 'COL.0'
   ```
   
   ### What You Expected?
   
   `FOO`.`tbl` should be ok.
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] 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] zingdle commented on issue #11993: [Bug] can't create table when column name with dot(.)

Posted by GitBox <gi...@apache.org>.
zingdle commented on issue #11993:
URL: https://github.com/apache/doris/issues/11993#issuecomment-1223941751

   @Henry2SS seems that it's ok to have dot in column name.
   
   http://sqlfiddle.com/#!9/66fccf7/1/0


-- 
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

[GitHub] [doris] Henry2SS commented on issue #11993: [Bug] can't create table when column name with dot(.)

Posted by GitBox <gi...@apache.org>.
Henry2SS commented on issue #11993:
URL: https://github.com/apache/doris/issues/11993#issuecomment-1223791677

   It is not allowed to use `.` in column name.
   The column regex is `^[_a-zA-Z@][a-zA-Z0-9_]{0,63}$`


-- 
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

[GitHub] [doris] morningman commented on issue #11993: [Bug] can't create table when column name with dot(.)

Posted by GitBox <gi...@apache.org>.
morningman commented on issue #11993:
URL: https://github.com/apache/doris/issues/11993#issuecomment-1235157132

   > [Enhancement](Error Msg) show details of COLUMN and TABLE name regex #11999
   MySQL support it.
   But IMO, it may be conflict with the nested column type which Doris will be supported in future.
   For example, a STRUCT type column `k1`, we can get it's member `k1.field1`, but it is hard to explain this: `k1.0.field1`.
   
   


-- 
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

[GitHub] [doris] yiguolei closed issue #11993: [Bug] can't create table when column name with dot(.)

Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #11993: [Bug] can't create table when column name with dot(.)
URL: https://github.com/apache/doris/issues/11993


-- 
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