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

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Version
   
   both 2.0.2 and 2.0.3
   
   ### What's Wrong?
   
   It is deadly wierd that I can not insert data after Setting up partial 
column updates both on version 2.0.2 and 2.0.3,.And of cause I get the error 
message :**Insert has filtered data in strict mode, tracking_url=null** when 
inserting data whch was  not existed in table.If insert an existing data it 
would be very smoothly.And when setting up the session variables 
**enable_unique_key_partial_update** to false it can be proceeded without any 
error.
   ----------------------
   table stucture:
   CREATE TABLE `test_table` (
     `sdv_id` int(11) NOT NULL,
     `im_id` varchar(36) NULL,
     `series_type` varchar(50) NULL,
     `thing_category` varchar(50) NULL,
     `create_time` datetime NULL
   ) ENGINE=OLAP
   UNIQUE KEY(`sdv_id`)
   COMMENT 'OLAP'
   DISTRIBUTED BY HASH(`sdv_id`) BUCKETS 2
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 1",
   "is_being_synced" = "false",
   "storage_format" = "V2",
   "enable_unique_key_merge_on_write" = "true",
   "light_schema_change" = "true",
   "store_row_column" = "true",
   "disable_auto_compaction" = "false",
   "enable_single_replica_compaction" = "false"
   );
   ----------------------
   sql:
   set enable_unique_key_partial_update=true;
   insert into iotdata.test_true 
(`sdv_id`,`im_id`,`series_type`,`thing_category`,`create_time`)
    values (6,'im001','60','AGC','2023-11-22 00:00:00'),
   (7,'im001','60','AGC','2023-11-22');
   
![image](https://github.com/apache/doris/assets/150641822/019d6cb5-a2fc-416a-b0a0-be65ee44a9b6)
   ----------------------
   I can not find any useful info both in fe's and be's log but:**Insert has 
filtered data in strict mode, tracking_url=null**.
   The columns and values arre match i suppose.I ran into the same error 
before,but they were all stirred up by type,length of colum or sth like 
this,but this time war different.
   Is thre any thing differently? 
   If any one can help me ,it would be very considerate.
   thanks a lot.
   
   ### What You Expected?
   
   1.insert data without any error.
   2.If there were errors could it would be very kindly to offer more 
information but not only the **Insert has filtered data in strict mode, 
tracking_url=null** witch linked to a null url that was not helpful sometines.☺
   Thank.
   
   ### 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-unsubscr...@doris.apache.org.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