Hi Eranda, I tried to capture ij> execute s1 using 'values(1)';, and as expected (I guess), it executed as two sql queries. Earlier I've attached only for the first query, now I created the plan for the second query (i.e. values(1);) as well, and attached it as a screenshot to the JIRA<https://issues.apache.org/jira/browse/DERBY-3892> .
Thanks. -- Best Regards, Nirmal C.S.Nirmal J. Fernando Department of Computer Science & Engineering, Faculty of Engineering, University of Moratuwa, Sri Lanka.
