Forum: Other

Post: it seems the '@Statistics TABLE' doesn't show the right result

it seems the '@Statistics TABLE' doesn't show the right result
guotong1988
Jul 24, 2015
I read it from http://docs.voltdb.com/UsingVoltDB/sysprocstatistics.php

I create a table before start the cluster

CREATE TABLE testtable0 (id integer not null primary key,name0 varchar(100));
partition table testtable0 on column id;


then I start the cluster


public static void main(String args[]){
VoltServerConfig config = null;
final MultiConfigSuiteBuilder builder = new MultiConfigSuiteBuilder(
TestByTestSuite.class);
final VoltProjectBuilder project = new VoltProjectBuilder();
try {
project.addLiteralSchema(generateSchema());
} catch (IOException error) {
fail(error.getMessage());
}
boolean success;
config = new LocalCluster("iisf-hsql.jar", 2, 2, 0,
BackendTarget.HSQLDB_BACKEND);
success = config.compile(project);
assert (success);
builder.addServerConfig(config);
config.startUp(true);
}




then I insert 10 rows in sqlcmd

insert into testtable0 values(1,'aaaa');
insert into testtable0 values(2,'aaaa');
insert into testtable0 values(3,'aaaa');
insert into testtable0 values(4,'aaaa');
insert into testtable0 values(5,'aaaa');
insert into testtable0 values(6,'aaaa');
insert into testtable0 values(7,'aaaa');
insert into testtable0 values(8,'aaaa');
insert into testtable0 values(9,'aaaa');
insert into testtable0 values(10,'aaaa');



then i execute

exec @Statistics TABLE 1;

the TUPLE_COUNT seems wrong