You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "jgq2008303393 (via GitHub)" <gi...@apache.org> on 2023/06/05 14:22:46 UTC

[GitHub] [doris] jgq2008303393 opened a new issue, #20468: [Bug] Fixed bigint display problem in doris playground

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

   ### 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
   
   1.2.4
   
   ### What's Wrong?
   
   在Doris中通过如下命令，建表并写入样例数据
   CREATE TABLE test.tt2(
   id BIGINT COMMENT "用户ID",
   name VARCHAR(20) COMMENT "用户姓名",
   age SMALLINT COMMENT "用户年龄",
   address VARCHAR(100) COMMENT "用户所在地区",
   date DATETIME COMMENT "数据导入时间"
   )
   DUPLICATE KEY (id)
   DISTRIBUTED BY HASH (id) BUCKETS 3
   PROPERTIES("replication_num" = "1");
   
   INSERT INTO test.tt2 VALUES 
   (1022222222222222221,"kkk",18,"beijing","2022-06-28 00:00:00"),
   (1022222222222222222,"kkk",18,"beijing","2022-06-28 00:00:00"),
   (1022222222222222223,"kkk",18,"beijing","2022-06-28 00:00:00"),
   (1022222222222222224,"kkk",18,"beijing","2022-06-28 00:00:00"),
   (1022222222222222225,"kkk",18,"beijing","2022-06-28 00:00:00");
   
   通过mysql client结果正常，通过doris playground执行时，长整型字段类型显示异常：
   ![image](https://github.com/apache/doris/assets/657140/f2a7eac6-5202-4cb8-828f-87bc8f4985ed)
   
   
   ### What You Expected?
   
   应该显示完整的id字段值，即1022222222222222221~ 1022222222222222225。
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] 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] [doris] caicancai commented on issue #20468: [Bug] Fixed bigint display problem in doris playground

Posted by "caicancai (via GitHub)" <gi...@apache.org>.
caicancai commented on issue #20468:
URL: https://github.com/apache/doris/issues/20468#issuecomment-1636702504

   hello, it is normal to return the response information now, but the web UI is still truncated by default, which may be a problem with the front-end display component, and the default is a number type


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

[GitHub] [doris] caicancai commented on issue #20468: [Bug] Fixed bigint display problem in doris playground

Posted by "caicancai (via GitHub)" <gi...@apache.org>.
caicancai commented on issue #20468:
URL: https://github.com/apache/doris/issues/20468#issuecomment-1581942387

   在doris playground中确实对bigint类型进行截断，无法显示完整数值
   <img width="846" alt="屏幕截图 2023-06-08 105633" src="https://github.com/apache/doris/assets/77189278/ee2440a3-521c-4237-aa6f-92c947198831">
   但在reponse中返回的数据中是正常显示的
   <img width="379" alt="屏幕截图 2023-06-08 105906" src="https://github.com/apache/doris/assets/77189278/6ff52c48-23df-4de8-ad1a-9fbd1fc99465">
   该接口接口详细信息如下
   
   ```bash
   curl 'http://192.168.11.150:8030/api/query/default_cluster/test' \
     -H 'Accept: */*' \
     -H 'Accept-Language: zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6' \
     -H 'Connection: keep-alive' \
     -H 'Content-Type: application/json; charset=utf-8' \
     -H 'Cookie: PALO_SESSION_ID=5534cf51-38dd-4b0d-90c1-5a7f9662418e' \
     -H 'Origin: http://192.168.11.150:8030' \
     -H 'Referer: http://192.168.11.150:8030/Playground/structure/test-tt2' \
     -H 'User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1823.41' \
     --data-raw '{"stmt":"SELECT * FROM test.tt2 LIMIT 10"}' \
     --compressed \
     --insecure
   ```
   调用结果如下：
   <img width="568" alt="屏幕截图 2023-06-08 135902" src="https://github.com/apache/doris/assets/77189278/5984f36d-70da-4f55-ac3a-3727e9d35264">
   <img width="568" alt="屏幕截图 2023-06-08 135902" src="https://github.com/apache/doris/assets/77189278/ef105b21-7af6-4c63-8e0a-86dbd3116c3a">
   结果正常，故该bug可能浏览器兼容问题
   
   已测试浏览器：谷歌浏览器、IE浏览器、火狐浏览器，均有类似问题
   


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

[GitHub] [doris] jgq2008303393 commented on issue #20468: [Bug] Fixed bigint display problem in doris playground

Posted by "jgq2008303393 (via GitHub)" <gi...@apache.org>.
jgq2008303393 commented on issue #20468:
URL: https://github.com/apache/doris/issues/20468#issuecomment-1600851555

   @caicancai Looking forward to submitting PR!


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

[GitHub] [doris] caicancai commented on issue #20468: [Bug] Fixed bigint display problem in doris playground

Posted by "caicancai (via GitHub)" <gi...@apache.org>.
caicancai commented on issue #20468:
URL: https://github.com/apache/doris/issues/20468#issuecomment-1636710788

   ![Uploading 微信图片_20230715155323.png…]()
   


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

[GitHub] [doris] caicancai commented on issue #20468: [Bug] Fixed bigint display problem in doris playground

Posted by "caicancai (via GitHub)" <gi...@apache.org>.
caicancai commented on issue #20468:
URL: https://github.com/apache/doris/issues/20468#issuecomment-1581938175

   在doris playground中确实对bigint类型进行截断，无法显示完整数值
   
   ![屏幕截图 2023-06-08 105633.png](https://s3-us-west-2.amazonaws.com/secure.notion-static.com/ac1292a9-f391-49b9-98dd-7cd3abf5063a/%E5%B1%8F%E5%B9%95%E6%88%AA%E5%9B%BE_2023-06-08_105633.png)
   
   但在reponse中返回的数据中是正常显示的
   
   ![屏幕截图 2023-06-08 105906.png](https://s3-us-west-2.amazonaws.com/secure.notion-static.com/0bf3a86b-d0cd-43f2-98bc-a5c94a4f7dec/%E5%B1%8F%E5%B9%95%E6%88%AA%E5%9B%BE_2023-06-08_105906.png)
   
   该接口接口详细信息如下
   
   ```bash
   curl 'http://192.168.11.150:8030/api/query/default_cluster/test' \
     -H 'Accept: */*' \
     -H 'Accept-Language: zh-CN,zh;q=0.9,en;q=0.8,en-GB;q=0.7,en-US;q=0.6' \
     -H 'Connection: keep-alive' \
     -H 'Content-Type: application/json; charset=utf-8' \
     -H 'Cookie: PALO_SESSION_ID=5534cf51-38dd-4b0d-90c1-5a7f9662418e' \
     -H 'Origin: http://192.168.11.150:8030' \
     -H 'Referer: http://192.168.11.150:8030/Playground/structure/test-tt2' \
     -H 'User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1823.41' \
     --data-raw '{"stmt":"SELECT * FROM test.tt2 LIMIT 10"}' \
     --compressed \
     --insecure
   ```
   
   ![屏幕截图 2023-06-08 135902.png](https://s3-us-west-2.amazonaws.com/secure.notion-static.com/ee54642c-9936-4322-b775-7427f64dd807/%E5%B1%8F%E5%B9%95%E6%88%AA%E5%9B%BE_2023-06-08_135902.png)
   
   结果正常，故该bug可能浏览器兼容问题
   
   已测试浏览器：谷歌浏览器、IE浏览器、火狐浏览器


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

[GitHub] [doris] caicancai commented on issue #20468: [Bug] Fixed bigint display problem in doris playground

Posted by "caicancai (via GitHub)" <gi...@apache.org>.
caicancai commented on issue #20468:
URL: https://github.com/apache/doris/issues/20468#issuecomment-1578998789

   I‘d like to work on this!


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