Replies: 1 comment
-
similar usecase: |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
steps:
create table r01 (id int, val row(x bigint,y double));
create table r02 (name varchar, val row(x bigint,y double));
insert into r01 values (10,row(987654,0.99999)),(20,row(321234,1.88888)),(30,row(567890,2.77777));
insert into r02 values ('one',row(987654,0.99999)),('two',row(123456,3.66666)),('three',row(567890,2.77777));
select * from r01 where r01.val in (select val from r02);
result:

as code shows , r01.val is a rowType column , so it can't enter the if statement,that why this query failed.

Beta Was this translation helpful? Give feedback.
All reactions