peilinqian commented on issue #21230:
URL:
https://github.com/apache/shardingsphere/issues/21230#issuecomment-1275690755
we find java version: java8, full_version=1.8.0_282,
full_path=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.282.b08-1.el7_9.x86_64/bin/java
ShardingSphere-5.2.1-SNAPSHOT
Commit ID: dirty-bcde6f374c4a3a025173fbc9f6d0e66ed686a042
Commit Message: Fix fetch forward all error in openGauss(#21421) (#21471)
Branch: bcde6f374c4a3a025173fbc9f6d0e66ed686a042
Build time: 2022-10-11T19:13:56+0800
```
test_db=> --create table
test_db=> create table t_broadcast(id int,c_id int,a int,b char(10));
CREATE TABLE
test_db=> insert into t_broadcast values
(1,1,10,'test11'),(1,2,10,'Test12'),(1,2,null,'test12'),
test_db-> (2,1,20,'test21'),(2,2,20,'test22'),(2,3,null,'Test22'),
test_db-> (3,3,null,'test3'),(3,3,null,'test3'),(4,4,40,'test4'),(5,5,50,'');
INSERT 0 10
test_db=> --create view
test_db=> show sharding broadcast table rules;
sharding_broadcast_tables
---------------------------
t_broadcast
t_broadcast_view
t_broadcast_view_new
(3 rows)
test_db=> create view t_broadcast_view as select * from t_broadcast;
CREATE VIEW
test_db=> select * from t_broadcast_view where id=4;
id | c_id | a | b
----+------+----+------------
4 | 4 | 40 | test4
(1 row)
test_db=> --alter view
test_db=> alter view t_broadcast_view rename to t_broadcast_view_new;
--error
ALTER VIEW
test_db=> select pg_sleep(2);
pg_sleep
----------
(1 row)
test_db=> --teardown
test_db=> drop view if exists t_broadcast_view;
DROP VIEW
test_db=> drop view if exists t_broadcast_view_new;
DROP VIEW
test_db=> drop table if exists t_broadcast;
DROP TABLE
test_db=> drop sharding broadcast table rules;
SUCCESS
```
--
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]
