[h2] Re: getPlanSQL response

[Evgenij Ryazanov]

Hello.

org.h2.command.Prepared is not a part of API and it should never be used 
directly by application.

If you need to get execution plan of some query or DML command, you should 
use the EXPLAIN command:
https://h2database.com/html/commands.html#explain

-- 
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/41ceb8a2-f2a5-4048-a740-787065c69fa3n%40googlegroups.com.

[h2] getPlanSQL response

[Ronit]

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_SPENTFROM INSTITUTE.COURCES*












*/*  INSTITUTE  . COURCES  .tableScan */) _0/* SELECT
C_TIMESPENT AS TIME_SPENTFROM  INSTITUTE  . COURCES/++  
INSTITUTE  . COURCES  .tableScan ++/ *//* WHERE TIME_SPENT IN(  
  SELECTC_TIMESPENTFROM  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.