diff options
Diffstat (limited to 'mysql-test/r/variables.result')
| -rw-r--r-- | mysql-test/r/variables.result | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result index 29f477fcfd2..becd74093da 100644 --- a/mysql-test/r/variables.result +++ b/mysql-test/r/variables.result @@ -1542,6 +1542,7 @@ INSERT INTO t1 VALUES (0.2),(0.1); SELECT 1 FROM t1 GROUP BY @a:= (SELECT ROUND(f1) FROM t1 WHERE @a=f1); 1 1 +1 DROP TABLE t1; CREATE TABLE t1 AS SELECT @a:= CAST(1 AS UNSIGNED) AS a; SHOW CREATE TABLE t1; |