zhangstar333 opened a new pull request, #28194:
URL: https://github.com/apache/doris/pull/28194

   ## Proposed changes
   ```
   CREATE TABLE IF NOT EXISTS str_tb (k1 VARCHAR(10) NULL, v1 STRING NULL) 
   UNIQUE KEY(k1) DISTRIBUTED BY HASH(k1) BUCKETS 5 
properties("replication_num" = "1")
           
   mysql [test_query_qa]>set enable_fold_constant_by_be = true;
   Query OK, 0 rows affected (0.00 sec)
   
   mysql [test_query_qa]>INSERT INTO str_tb VALUES (2, repeat("test1111", 
10000));
   Query OK, 1 row affected (0.26 sec)
   {'label':'label_687238ef637b4929_9675dd5b4f31d5bf', 'status':'VISIBLE', 
'txnId':'16017'}
   
   mysql [test_query_qa]>select length(v1) from str_tb;
   +------------+
   | length(v1) |
   +------------+
   |      65533 | // the repeat("test1111", 10000) length should be 80000, but 
varchar have max length 65533
   +------------+
   1 row in set (0.07 sec)
   ```
   
   
   Issue Number: close #xxx
   
   <!--Describe your changes.-->
   
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at 
[d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you 
chose the solution you did and what alternatives you considered, etc...
   
   


-- 
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-unsubscr...@doris.apache.org

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


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

Reply via email to