Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Description
The SPIDER engine doesn't recognize GENERATED VIRTUAL columns, and is still trying to push down the column to the remote backend server. The SPIDER engine, much like other engines, should ignore the GENERATED VIRTUAL column from the storage backend itself.
CREATE TABLE `tbl` (
|
`id` int,
|
`testing` int as (1),
|
) ENGINE=SPIDER COMMENT='wrapper "mysql", srv "srv1"';
|
|
|
select * from tbl;
|
|
|
ERROR 1054 (42S22): Unknown column 't0.testing' in 'field list'
|