[GitHub] [doris] yuxuan-luo commented on issue #15986: [Bug] if 函数后计算结果发生错误

[GitBox <gi...@apache.org>]

yuxuan-luo commented on issue #15986:
URL: https://github.com/apache/doris/issues/15986#issuecomment-1385017752

   复现方法：
   建表语句及数据导入：
   CREATE TABLE `doris_test_sink` (
     `id` int(11) NULL,
     `s_count` int(11) NULL,
     `fee` DECIMALV3(15,4) NULL,
     `skuname` varchar(40) NULL,
     `skudesc` varchar(200) NULL
   ) ENGINE=OLAP
   DUPLICATE KEY(`id`)
   COMMENT 'OLAP'
   DISTRIBUTED BY HASH(`id`) BUCKETS 1
   PROPERTIES (
   "replication_allocation" = "tag.location.default: 3",
   "in_memory" = "false",
   "storage_format" = "V2",
   "disable_auto_compaction" = "false"
   );
   
   curl -u admin -H "label:load_local_file_test" -H "column_separator:," -T /root/test.csv http://10.0.0.xx:8040/api/xiaomi/doris_test_sink/_stream_load
   
   csv:
   10001,12,13.3, test1,this is atest
   10002,100,15.3,test2,this is atest
   10003,102,16.3,test3,this is atest
   10004,120,17.3,test4,this is atest
   10005,23,10.3, test5,this is atest
   10006,24,112.3,test6,this is atest
   10007,26,13.3, test7,this is atest
   10008,29,145.3,test8,this is atest
   10009,30,16.3, test9,this is atest
   100010,32,18.3,test10,this is atest
   100011,52,18.3,test11,this is atest
   100012,62,10.3,test12,this is atest
   
   -- 查询 sql
   select *,if(1 = 2, 
   	1.0*s_count - fee,
   	fee) as bug ,round(fee - s_count,6) as fe from doris_test_sink;


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