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_PK
FROM (
    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

[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