[MDEV-10201] Bad results for CREATE TABLE t1 (a INT DEFAULT b, b INT DEFAULT 4) Created: 2016-06-09  Updated: 2017-02-13  Resolved: 2017-02-13

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.2
Fix Version/s: 10.2.4

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: 10.2-ga

Issue Links:
Blocks
blocks MDEV-10134 Add full support for DEFAULT Closed
Sprint: 10.2.4-1, 10.2.4-2

 Description   

I'm testing the MDEV-10134 feature tree, branch bb-10.2-default.

This script:

DROP TABLE IF EXISTS t1;
 
CREATE TABLE t1 (a INT DEFAULT b, b INT DEFAULT 4);
 
INSERT INTO t1 VALUES (DEFAULT,5);
 
SELECT * FROM t1;

returns

+-------------+------+
 
| a           | b    |
 
+-------------+------+
 
| -1886417009 |    5 |
 
+-------------+------+

Looks wrong, most likely some non-initialized data gets written into the column "a".

 Comments   
Comment by Elena Stepanova [ 2016-07-09 ]

MDEV-10134 has been finished now, but this issue still exists.

Generated at Thu Feb 08 07:40:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.