-- Recreate Round() Issue

INSTALL SONAME "ha_spider";

CREATE DATABASE spidertesta;

CREATE TABLE `spidertesta`.`testtable` (
  `TestNum` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `ReadValue` BIGINT(20) DEFAULT 0,
  PRIMARY KEY (`TestNum`)
) ENGINE=MYISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

CREATE SERVER localspider FOREIGN DATA WRAPPER mysql OPTIONS( HOST '127.0.0.1', DATABASE 'spidertesta',USER 'root', PASSWORD '',PORT 3306 );

CREATE DATABASE spidertestb;


CREATE TABLE `spidertestb`.`testtable` ENGINE=SPIDER COMMENT='srv "localspider"';

SELECT ROUND(SUM(ReadValue),2) FROM spidertestb.testtable;
