set password for 'root'@localhost='';

install soname "ha_spider";

create database spidertesta;

create table spidertesta.testtable ( testnum bigint(20) not null, readvalue bigint(20) default 0, primary key (testnum)) engine=myisam;

create server localspider foreign data wrapper mysql options( host '127.0.0.1', database 'spidertesta',user 'root', password '',port 16000 );

create database spidertestb;

set @@spider_same_server_link=1;

create table spidertestb.testtable ( testnum bigint(20) not null, readvalue bigint(20) default 0, primary key (testnum)) engine=spider comment='srv "localspider"';

select round(sum(readvalue)+0,2) from spidertestb.testtable;

select round(sum(readvalue),2) from spidertestb.testtable;

MariaDB [test]> insert into spidertesta.testtable select seq,seq from seq_1_to_10;

Query OK, 10 rows affected (0.001 sec)

Records: 10  Duplicates: 0  Warnings: 0

MariaDB [test]> select round(sum(readvalue)+0,2) from spidertestb.testtable;

+---------------------------+

| round(sum(readvalue)+0,2) |

+---------------------------+

|                     55.00 |

+---------------------------+

1 row in set (0.003 sec)

MariaDB [test]> select round(sum(readvalue),2) from spidertestb.testtable;

ERROR 1054 (42S22): Unknown column 'sum(readvalue)' in 'field list'

MariaDB [test]> select sum(readvalue) over () from spidertestb.testtable;

ERROR 1054 (42S22): Unknown column 'spidertestb.testtable.readvalue' in 'field list'

MariaDB [test]> select rank() over (order by readvalue) from spidertestb.testtable;

ERROR 1054 (42S22): Unknown column 'spidertestb.testtable.readvalue' in 'order clause'

MariaDB [test]> select rank() over (order by 1) from spidertestb.testtable;

+--------------------------+

| rank() over (order by 1) |

+--------------------------+

|                     NULL |

|                     NULL |

|                     NULL |

|                     NULL |

|                     NULL |

|                     NULL |

|                     NULL |

|                     NULL |

|                     NULL |

|                     NULL |

+--------------------------+

10 rows in set (0.003 sec)