Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.4.7, 10.3.25
-
None
Description
On source server:
CREATE TABLE simple (
|
id int(10) unsigned NOT NULL AUTO_INCREMENT,
|
val int(10) unsigned DEFAULT NULL,
|
PRIMARY KEY (id), ENGINE=InnoDB;
|
|
insert into simple(val) values(1);
|
On spider server:
create server s31689 foreign data wrapper mysql options (
|
host '10.0.0.241' ,
|
database 'd31689' ,
|
user 'spider' ,
|
password 'spider' ,
|
port 3306 );
|
|
CREATE TABLE simple (
|
id int(10) unsigned NOT NULL AUTO_INCREMENT,
|
val int(10) unsigned DEFAULT NULL,
|
PRIMARY KEY (id), ENGINE=SPIDER
|
DEFAULT CHARSET=utf8
|
COMMENT='srv "s31689", table "simple"'
|
|
Query OK, 0 rows affected (0.026 sec)
|
|
MariaDB [d31689]> select * from simple;
|
+----+------+
|
| id | val |
|
+----+------+
|
| 1 | 1 |
|
+----+------+
|
1 row in set (0.015 sec)
|
|
MariaDB [d31689]> select id, 0 as const, val from simple;
|
+----+-------+------+
|
| id | const | val |
|
+----+-------+------+
|
| 1 | 0 | 0 |
|
+----+-------+------+
|
1 row in set (0.002 sec)
|
Attachments
Issue Links
- causes
-
MDEV-26345 SELECT MIN on Spider table returns more rows than expected
- Closed
- relates to
-
MDEV-29502 ASAN: heap-buffer-overflow & stack-buffer-overflow in spider_db_mbase_row::append_to_str | SIGSEGV's in __memmove_avx_unaligned_erms from memcpy in Binary_string::q_append, in Static_binary_string::q_append and my_strntoull10rnd_8bit | Unknown error 12801
- Closed