diff options
author | Alexander Barkov <bar@mariadb.com> | 2022-02-09 17:59:38 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2022-03-22 14:42:54 +0400 |
commit | d25b10fede8926f63203dfd2040ec60549d10936 (patch) | |
tree | 3e9b0da676e1a3e54f562d9f7e9552fc2ebdcdb3 /mysql-test/main/type_time_hires.result | |
parent | ab1a7925714727743e5dd7bb1b83014044fc5660 (diff) | |
download | mariadb-git-d25b10fede8926f63203dfd2040ec60549d10936.tar.gz |
MDEV-27712 Reduce the size of Lex_length_and_dec_st from 16 to 8
User visible change:
Removing the length specified by user from error messages:
ER_TOO_BIG_SCALE and ER_TOO_BIG_PRECISION
as discussed with Sergei.
Diffstat (limited to 'mysql-test/main/type_time_hires.result')
-rw-r--r-- | mysql-test/main/type_time_hires.result | 23 |
1 files changed, 22 insertions, 1 deletions
diff --git a/mysql-test/main/type_time_hires.result b/mysql-test/main/type_time_hires.result index 661ca0e98f5..bd193ba1ed6 100644 --- a/mysql-test/main/type_time_hires.result +++ b/mysql-test/main/type_time_hires.result @@ -1,7 +1,7 @@ SET timestamp=UNIX_TIMESTAMP('2001-02-03 10:20:30'); drop table if exists t1, t2, t3; create table t1 (a time(7)); -ERROR 42000: Too big precision 7 specified for 'a'. Maximum is 6 +ERROR 42000: Too big precision specified for 'a'. Maximum is 6 create table t1 (a time(3), key(a)); insert t1 values ('2010-12-11 00:20:03.1234'); Warnings: @@ -907,3 +907,24 @@ a CEILING(a) CEILING_SP(a) CEILING(a)=CEILING_SP(a) DROP FUNCTION FLOOR_SP; DROP FUNCTION CEILING_SP; DROP TABLE t1; +# +# Start of 10.9 tests +# +# +# MDEV-27712 Reduce the size of Lex_length_and_dec_st from 16 to 8 +# +CREATE TABLE t1 (a TIME(4294967295)); +ERROR 42000: Too big precision specified for 'a'. Maximum is 6 +CREATE TABLE t1 (a TIME(4294967296)); +ERROR 42000: Too big precision specified for 'a'. Maximum is 6 +CREATE TABLE t1 (a TIME(999999999999999999999999999999)); +ERROR 42000: Too big precision specified for 'a'. Maximum is 6 +SELECT CAST(1 AS TIME(4294967295)); +ERROR 42000: Too big precision specified for '1'. Maximum is 6 +SELECT CAST(1 AS TIME(4294967296)); +ERROR 42000: Too big precision specified for '1'. Maximum is 6 +SELECT CAST(1 AS TIME(999999999999999999999999999999)); +ERROR 42000: Too big precision specified for '1'. Maximum is 6 +# +# Start of 10.9 tests +# |