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/05/12 06:38:34 UTC

[GitHub] [incubator-doris] BiteTheDDDDt opened a new issue, #9522: [Bug] [Vectorized] fix schema change add varchar type column default value get wrong result

BiteTheDDDDt opened a new issue, #9522:
URL: https://github.com/apache/incubator-doris/issues/9522

   ### 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
   
   ### What's Wrong?
   
   ```sql
   CREATE TABLE `test_dup` (
     `k1` int(11) NULL COMMENT "",
     `k2` int(11) NULL COMMENT ""
   ) ENGINE=OLAP
   DUPLICATE KEY(`k1`)
   COMMENT "OLAP"
   DISTRIBUTED BY HASH(`k1`) BUCKETS 5
   PROPERTIES (
   "replication_num" = "1",
   "in_memory" = "false",
   "storage_format" = "V2"
   );
   
   insert into test_dup values(1,1),(2,2),(3,3);
   
   ALTER TABLE test_dup ADD COLUMN new_col VARCHAR(100) DEFAULT "1" AFTER k2;
   
   MySQL [test]> select * from test_dup;
   +------+------+------------------+
   | k1   | k2   | new_col          |
   +------+------+------------------+
   |    2 |    2 | (��N              |
   |    1 |    1 | (��v              |
   |    3 |    3 | (��v              |
   +------+------+------------------+
   ```
   
   ### What You Expected?
   
   fix it
   
   ### 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] [incubator-doris] yiguolei closed issue #9522: [Bug] [Vectorized] fix schema change add varchar type column default value get wrong result

Posted by GitBox <gi...@apache.org>.
yiguolei closed issue #9522: [Bug] [Vectorized] fix schema change add varchar type column default value get wrong result
URL: https://github.com/apache/incubator-doris/issues/9522


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