Hello,
I am facing strange behavior of QUERY_STATISTICS in RUNSCRIPT. It is
ignored or I do not know how to set it properly.
See my test case in H2 1.4.196 InMemory:
--this is the file c:\temp\temp\test.sql:
set QUERY_STATISTICS false;
set QUERY_STATISTICS true;
set QUERY_STATISTICS_MAX_ENTRIES 1000;
select current_timestamp;
select 'test';
drop table if exists LOG;
create table LOG as select * from "INFORMATION_SCHEMA"."QUERY_STATISTICS";
insert into LOG (SQL_STATEMENT) values('manual test entry');
select * from LOG;
then c:\temp\temp\test.sql is called as:
runscript from 'c:\temp\temp\test.sql';
select * from LOG;
--no QUERY_STATISTICS is displayed, only "manual test entry" record
Can I ask You, how to get QUERY_STATISTICS from SQL called from RUNSCRIPT?
I have quite complex of parametrised SQL commands and I can not have all of
these command in one big command.
When I run set of SQL commands from 'c:\temp\temp\test.sql', it works OK.
Regards, Stepan
--
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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
