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 2021/07/08 08:11:24 UTC

[GitHub] [incubator-doris] xy720 opened a new issue #6183: [Bug] Show view report "Unresolved table reference" error

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


   **Describe the bug**
   Show view report "Unresolved table reference" error
   
   **To Reproduce**
   
   ```
   CREATE DATABASE test_sys_view_test_show_view_db
   ```
   
   ```
   CREATE TABLE test_sys_view_test_show_view_db.test_sys_view_test_show_view_tb ( k1 TINYINT NOT NULL, v1 TINYINT NOT NULL, v2 TINYINT NOT NULL, v3 TINYINT NOT NULL, v4 TINYINT NOT NULL ) UNIQUE KEY(k1) DISTRIBUTED BY HASH(k1) BUCKETS 5
   ```
   
   ```
   insert into test_sys_view_test_show_view_tb values(1, 2, 3, 4, 5)
   ```
   
   ```
   create view test_view as select * from test_sys_view_test_show_view_tb
   ```
   
   ```
   show view from test_sys_view_test_show_view_db.test_sys_view_test_show_view_tb
   ```
   
   
   **Expected behavior**
   
   Successful execute
   
   
   **Actual behavior**
   
   ERROR 5011 (HY000): errCode = 2, detailMessage = Unresolved table reference '`default_cluster:test_sys_view_test_show_view_db`.`test_sys_view_test_show_view_tb`'
   
   
   


-- 
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] [incubator-doris] yangzhg closed issue #6183: [Bug] Show view report "Unresolved table reference" error

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


   


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