[GitHub] [incubator-doris] bd7ce edited a comment on issue #1428: 使用Power BI连接到doris时提示：MySQL: No matching function with signature:utc_timestamp().

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

bd7ce edited a comment on issue #1428: 使用Power BI连接到doris时提示：MySQL: No matching function with signature:utc_timestamp().
URL: https://github.com/apache/incubator-doris/issues/1428#issuecomment-510524852
 
 
   更新后验证，utc_timestamp()函数已经正常了，但连接时继续报错:
   “从提供程序读取数据时出错：输入字符串的格式不正确”。
   
   检查fe.audit.log，最后一句是：
   select timediff(now(),utc_timestamp());
   
   在mysql命令行执行该命令，发现结果中有秒与毫秒之间有乱码。
   而直接执行
   select now();
   select utc_timestamp();
   均没有毫秒。
   貌似为timediff()的实现有问题？
   
   在MySQL上测试，该语句返回正确的8小时时差，但doris上是随机的几个月。

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@doris.apache.org
For additional commands, e-mail: dev-help@doris.apache.org