diff options
| author | unknown <ingo@mysql.com> | 2004-09-14 13:49:08 +0200 |
|---|---|---|
| committer | unknown <ingo@mysql.com> | 2004-09-14 13:49:08 +0200 |
| commit | b4e557fdd6e3918e417b16000bfa22d5b943cf25 (patch) | |
| tree | 86a33cde82dfc9f51099cdf06db8f3121e81da25 /mysql-test/r/sql_mode.result | |
| parent | 3ffc483275d6b8e733ddd98d534263f6f533cc9d (diff) | |
| download | mariadb-git-b4e557fdd6e3918e417b16000bfa22d5b943cf25.tar.gz | |
BUG#5318 - failure: 'IGNORE_SPACE' affects numeric values after DEFAULT.
Added a check to recover from IGNORE_SPACE in this situation:
<ident-character(s)><space><dot><ident-character(s)>
The ignored space led to the false identification of the dot
as an ident separator (like "db.table").
mysql-test/r/sql_mode.result:
BUG#5318 - failure: 'IGNORE_SPACE' affects numeric values after DEFAULT.
Added the test results.
mysql-test/t/sql_mode.test:
BUG#5318 - failure: 'IGNORE_SPACE' affects numeric values after DEFAULT.
Added new tests for the bug.
sql/sql_lex.cc:
BUG#5318 - failure: 'IGNORE_SPACE' affects numeric values after DEFAULT.
Added code to recover from skipped spaces in mode IGNORE_SPACES,
when testing for an ident separator (which happens to be a dot).
Diffstat (limited to 'mysql-test/r/sql_mode.result')
| -rw-r--r-- | mysql-test/r/sql_mode.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/sql_mode.result b/mysql-test/r/sql_mode.result index 77fe5d06bb0..e54dd217f8c 100644 --- a/mysql-test/r/sql_mode.result +++ b/mysql-test/r/sql_mode.result @@ -85,3 +85,26 @@ t1 CREATE TABLE "t1" ( UNIQUE KEY "email" ("email") ) drop table t1; +set session sql_mode = ''; +create table t1 ( min_num dec(6,6) default .000001); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `min_num` decimal(7,6) default '0.000001' +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop table t1 ; +set session sql_mode = 'IGNORE_SPACE'; +create table t1 ( min_num dec(6,6) default 0.000001); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `min_num` decimal(7,6) default '0.000001' +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop table t1 ; +create table t1 ( min_num dec(6,6) default .000001); +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `min_num` decimal(7,6) default '0.000001' +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +drop table t1 ; |