Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL)
-
None
Description
This script:
DROP TABLE IF EXISTS t1; |
EXECUTE IMMEDIATE 'CREATE TABLE t1 AS SELECT ?' USING POINT(1,1); |
SHOW CREATE TABLE t1; |
creates a column of a wrong type:
+-------+-----------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-----------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`?` varbinary(25) NOT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+-----------------------------------------------------------------------------------------+
|
The expected type should be POINT.
The same problem is repeatable in:
DROP TABLE IF EXISTS t1; |
PREPARE stmt FROM 'CREATE OR REPLACE TABLE t1 AS SELECT ?'; |
EXECUTE stmt USING POINT(1,1); |
SHOW CREATE TABLE t1; |
Attachments
Issue Links
- blocks
-
MDEV-4912 Data type plugin API version 1
- Closed
- relates to
-
MDEV-10866 Extend PREPARE and EXECUTE IMMEDIATE to understand expressions
- Closed