strongduanmu commented on issue #24619:
URL:
https://github.com/apache/shardingsphere/issues/24619#issuecomment-1491228751
Hi @peilinqian, I have test it with master branch, this sql can execute
successfully.
```sql
sharding_db=> sharding_db=>
sharding_db=> drop view if exists t_view ;
DROP VIEW
sharding_db=> drop table if exists t_table;
DROP TABLE
sharding_db=> create table t_table(id int,c_id int,a int,b char(10));
CREATE TABLE
sharding_db=>
sharding_db=> insert into t_table values
(1,1,10,'test11'),(1,2,10,'Test12'),(1,2,null,'test12'),
sharding_db->
sharding_db-> (2,1,20,'test21'),(2,2,20,'test22'),(2,3,null,'Test22'),
sharding_db->
(3,3,null,'test3'),(3,3,null,'test3'),(3,1,null,'test31'),(4,4,40,'test4'),(5,5,50,'Test5');
INSERT 0 11
sharding_db=> create or replace view t_view as select id,c_id,a,b from
t_ssdb_tb;
ERROR: relation "t_ssdb_tb" does not exist on gaussdb
LINE 1: ...or replace view t_view as select id,c_id,a,b from t_ssdb_tb;
^
sharding_db=> create or replace view t_view as select id,c_id,a,b from
t_ssdb_tb;
ERROR: relation "t_ssdb_tb" does not exist on gaussdb
LINE 1: ...or replace view t_view as select id,c_id,a,b from t_ssdb_tb;
^
sharding_db=> create or replace view t_view as select id,c_id,a,b from
t_ssdb_tb;
ERROR: relation "t_ssdb_tb" does not exist on gaussdb
LINE 1: ...or replace view t_view as select id,c_id,a,b from t_ssdb_tb;
^
sharding_db=> create or replace view t_view as select id,c_id,a,b from
t_table;
CREATE VIEW
sharding_db=> select * from t_view where b='test11';
id | c_id | a | b
----+------+----+------------
1 | 1 | 10 | test11
(1 row)
sharding_db=> select * from t_table where b='test11';
id | c_id | a | b
----+------+----+------------
1 | 1 | 10 | test11
(1 row)
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
