Re: Error Parameter value unbound. Parameter at index 1 is unbound on Subquery

2020-05-29 Thread Josh Elser
Gentle reminder to always do a general search for similar issues https://issues.apache.org/jira/browse/PHOENIX-5192 There have been some issues which have been similarly reported in the past, but no one has been able to provide a reproduction. Perhaps you can be the one to do that. As of now,

Error Parameter value unbound. Parameter at index 1 is unbound on Subquery

2020-05-29 Thread Ganda Manurung
Hello, I have a query like this on my program SELECT COUNT(*) AS COUNTER from ( SELECT FULLNAME FROM TABLE_A WHERE ID = '1' AND STATUS = 'N' UNION ALL SELECT FULLNAME FROM TABLE_B WHERE ID = '1' AND STATUS = 'Y' UNION ALL SELECT FULLNAME FROM TABLE_C WHERE ID = '1' AND STATUS = 'N' ) AS TEMP