Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
11.4.5
-
None
-
RedHat 9 VM
Description
When running a select query against a spider table and using a constant the constant value is inserted into the result set instead of the selected value.
For example:
In a table with this dataset
ID | Value
1 | One
2 | Two
3 | Three
4 | Four
select "sample", value from spider.table; produces
sample,One
sample,sample
sample,sample
sample,sample
If you run the query against an InnoDB table you get these results.
select "sample", value from InnoDB.table;
sample,One
sample,Two
sample,Three
sample,Four
Attachments
Issue Links
- duplicates
-
MDEV-35874 Unexpected error 1264 'Out of Range Value for Column' when inserting into ... select ... from a spider table
-
- Closed
-