Re: Row expression parse problem

2018-04-23 Thread Shuyi Chen
Thanks for raising the issue. I did remember seeing this problem before. I've created a JIRA to log the issue. On Mon, Apr 23, 2018 at 7:29 AM, Julian Hyde wrote: > I agree, this looks like a bug. > > Julian > > > On Apr 23, 2018, at 05:03, 陈硕

Re: Row expression parse problem

2018-04-23 Thread Julian Hyde
I agree, this looks like a bug. Julian > On Apr 23, 2018, at 05:03, 陈硕清 wrote: > > Dear all: > > Now for our production, we can parse a query successfully like this : > > -- correlated IN subquery > -- TC 01.01 > SELECT t1a, > t1b, > t1h > FROM t1 > WHERE ( t1a, t1h ) NOT IN (

Row expression parse problem

2018-04-23 Thread 陈硕清
Dear all: Now for our production, we can parse a query successfully like this : -- correlated IN subquery -- TC 01.01 SELECT t1a, t1b, t1h FROM t1 WHERE ( t1a, t1h ) NOT IN (SELECT t2a, t2h FROM t2