You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/12/11 08:43:18 UTC

[GitHub] [incubator-doris] morningman opened a new issue #5066: [Bug] Query external table with UNION get incomplete result.

morningman opened a new issue #5066:
URL: https://github.com/apache/incubator-doris/issues/5066


   **Describe the bug**
   How to reproduce:
   
   ```
   CREATE EXTERNAL TABLE db1.tbl1
   (
   k1 INT
   )
   ENGINE=mysql
   PROPERTIES
   (
   "host" = "xxxx",
   "port" = "8777",
   "user" = "root",
   "password" = "xxx",
   "database" = "cmytest",
   "table" = "tbl1"
   );
   
   CREATE EXTERNAL TABLE db1.tbl2
   (
   k1 INT
   )
   ENGINE=mysql
   PROPERTIES
   (
   "host" = "xxxx",
   "port" = "8777",
   "user" = "root",
   "password" = "xxxx",
   "database" = "cmytest",
   "table" = "tbl1"
   );
   
   CREATE EXTERNAL TABLE db1.tbl3
   (
   k1 INT
   )
   ENGINE=mysql
   PROPERTIES
   (
   "host" = "xxxx",
   "port" = "8777",
   "user" = "root",
   "password" = "xxxx",
   "database" = "cmytest",
   "table" = "tbl1"
   );
   
   create view v1 as select * from tbl1 union all select * from tbl2 union all select * from tbl3;
   ```
   And query like:
   ```
   select count(*) from v1;
   ```
   
   if there are more than 1024 rows in mysql table, the query will return less than 3000.
   
    - Version [0.13.11]
   


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



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

[GitHub] [incubator-doris] morningman closed issue #5066: [Bug] Query external table with UNION get incomplete result.

Posted by GitBox <gi...@apache.org>.
morningman closed issue #5066:
URL: https://github.com/apache/incubator-doris/issues/5066


   


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



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