Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
-
None
-
10.2.11
Description
DELIMITER $$
|
BEGIN NOT ATOMIC |
DECLARE d0 DATETIME DEFAULT NULL; |
DECLARE d1 DATETIME DEFAULT '2001-01-01 00:00:00'; |
DECLARE i0 INT DEFAULT NULL; |
DECLARE i1 INT DEFAULT 10; |
PREPARE stmt FROM 'CREATE OR REPLACE TABLE t1 AS SELECT ? AS c1,? AS c2,? AS c3,? AS c4'; |
EXECUTE stmt USING d0,d1,i0,i1; |
DEALLOCATE PREPARE stmt; |
SHOW CREATE TABLE t1; |
END; |
$$
|
DELIMITER ;
|
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`c1` binary(0) DEFAULT NULL,
|
`c2` datetime DEFAULT NULL,
|
`c3` binary(0) DEFAULT NULL,
|
`c4` bigint(21) NOT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
The expected data type for c0 should be DATETIME (like for c1).
The expected data type for c3 should be BIGINT (like for c3).
Attachments
Issue Links
- is blocked by
-
MDEV-14467 Item_param: replace {INT|DECIMAL|REAL|STRING|TIME}_VALUE with Type_handler
- Closed
- relates to
-
MDEV-10709 Expressions as parameters to Dynamic SQL
- Closed
-
MDEV-14271 Dynamic SQL: TIMESTAMP parameter value is not preserved on timezone change
- Open