Hello ,
Is there a chance for *Prepared.getPlanSQL(1)* to return empty string or
null or exception ?
For now I am getting
*SELECT*
* "_0".TIME_SPENT, "_1".SUBJECT_PKFROM ( SELECT
"C_TIMESPENT" AS "TIME_SPENT"*
* FROM "INSTITUTE"."COURCES") "_0"*
This is the result after the migration of H2 to the latest version, in
H2-1.3.176
it was
*SELECT _0.TIME_SPENT, _1.* *SUBJECT_PK*
*FROM ( SELECT*
* C_TIMESPENT AS TIME_SPENT FROM INSTITUTE.COURCES*
* /* INSTITUTE . COURCES .tableScan */) _0 /* SELECT
C_TIMESPENT AS TIME_SPENT FROM INSTITUTE . COURCES /++
INSTITUTE . COURCES .tableScan ++/ */ /* WHERE TIME_SPENT IN(
SELECT C_TIMESPENT FROM INSTITUTE . COURCES
/++ INSTITUTE . COURCES .tableScan ++/ )*
*/
Thanks and Regards
R. Joshi
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/5c64099b-9996-40ef-abbd-3926f948aaf0n%40googlegroups.com.
