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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/5c64099b-9996-40ef-abbd-3926f948aaf0n%40googlegroups.com.
