1
SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
2
3
drop table if exists tb2 ;
4
f59 numeric (0) unsigned,
5
f60 numeric (64) unsigned,
6
f61 numeric (0) zerofill,
7
f62 numeric (64) zerofill,
8
f63 numeric (0) unsigned zerofill,
9
f64 numeric (64) unsigned zerofill,
12
f67 numeric (0,0) unsigned,
13
f68 numeric (63,30) unsigned,
14
f69 numeric (0,0) zerofill,
15
f70 numeric (63,30) zerofill,
16
f71 numeric (0,0) unsigned zerofill,
17
f72 numeric (63,30) unsigned zerofill,
21
f76 real unsigned zerofill,
22
f77 double default 7.7,
23
f78 double unsigned default 7.7,
24
f79 double zerofill default 7.7,
25
f80 double unsigned zerofill default 8.8,
26
f81 float not null default 8.8,
27
f82 float unsigned not null default 8.8,
28
f83 float zerofill not null default 8.8,
29
f84 float unsigned zerofill not null default 8.8,
30
f85 float(0) not null default 8.8,
31
f86 float(23) not null default 8.8,
32
f87 float(0) unsigned not null default 8.8,
33
f88 float(23) unsigned not null default 8.8,
34
f89 float(0) zerofill not null default 8.8,
35
f90 float(23) zerofill not null default 8.8,
36
f91 float(0) unsigned zerofill not null default 8.8,
37
f92 float(23) unsigned zerofill not null default 8.8,
38
f93 float(24) not null default 8.8,
39
f94 float(53) not null default 8.8,
40
f95 float(24) unsigned not null default 8.8,
41
f96 float(53) unsigned not null default 8.8,
42
f97 float(24) zerofill not null default 8.8,
43
f98 float(53) zerofill not null default 8.8,
44
f99 float(24) unsigned zerofill not null default 8.8,
45
f100 float(53) unsigned zerofill not null default 8.8,
46
f101 date not null default '2000-01-01',
47
f102 time not null default 20,
48
f103 datetime not null default '2/2/2',
49
f104 timestamp not null default 20001231235959,
50
f105 year not null default 2000,
51
f106 year(3) not null default 2000,
52
f107 year(4) not null default 2000,
53
f108 enum("1enum","2enum") not null default "1enum",
5
f59 numeric (0) unsigned,
6
f60 numeric (64) unsigned,
7
f61 numeric (0) zerofill,
8
f62 numeric (64) zerofill,
9
f63 numeric (0) unsigned zerofill,
10
f64 numeric (64) unsigned zerofill,
13
f67 numeric (0,0) unsigned,
14
f68 numeric (63,30) unsigned,
15
f69 numeric (0,0) zerofill,
16
f70 numeric (63,30) zerofill,
17
f71 numeric (0,0) unsigned zerofill,
18
f72 numeric (63,30) unsigned zerofill,
22
f76 real unsigned zerofill,
23
f77 double default 7.7,
24
f78 double unsigned default 7.7,
25
f79 double zerofill default 7.7,
26
f80 double unsigned zerofill default 8.8,
27
f81 float not null default 8.8,
28
f82 float unsigned not null default 8.8,
29
f83 float zerofill not null default 8.8,
30
f84 float unsigned zerofill not null default 8.8,
31
f85 float(0) not null default 8.8,
32
f86 float(23) not null default 8.8,
33
f87 float(0) unsigned not null default 8.8,
34
f88 float(23) unsigned not null default 8.8,
35
f89 float(0) zerofill not null default 8.8,
36
f90 float(23) zerofill not null default 8.8,
37
f91 float(0) unsigned zerofill not null default 8.8,
38
f92 float(23) unsigned zerofill not null default 8.8,
39
f93 float(24) not null default 8.8,
40
f94 float(53) not null default 8.8,
41
f95 float(24) unsigned not null default 8.8,
42
f96 float(53) unsigned not null default 8.8,
43
f97 float(24) zerofill not null default 8.8,
44
f98 float(53) zerofill not null default 8.8,
45
f99 float(24) unsigned zerofill not null default 8.8,
46
f100 float(53) unsigned zerofill not null default 8.8,
47
f101 date not null default '2000-01-01',
48
f102 time not null default 20,
49
f103 datetime not null default '2/2/2',
50
f104 timestamp not null default 20001231235959,
51
f105 year not null default 2000,
52
f106 year(3) not null default 2000,
53
f107 year(4) not null default 2000,
54
f108 enum("1enum","2enum") not null default "1enum",
54
55
f109 set("1set","2set") not null default "1set"
56
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/memory_tb2.txt' into table tb2 ;
57
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/memory_tb2.txt'
57
59
DROP DATABASE IF EXISTS test1;
58
60
CREATE DATABASE test1;
60
62
drop table if exists tb2 ;
62
f59 numeric (0) unsigned,
63
f60 numeric (64) unsigned,
64
f61 numeric (0) zerofill,
65
f62 numeric (64) zerofill,
66
f63 numeric (0) unsigned zerofill,
67
f64 numeric (64) unsigned zerofill,
70
f67 numeric (0,0) unsigned,
71
f68 numeric (63,30) unsigned,
72
f69 numeric (0,0) zerofill,
73
f70 numeric (63,30) zerofill,
74
f71 numeric (0,0) unsigned zerofill,
75
f72 numeric (63,30) unsigned zerofill,
79
f76 real unsigned zerofill,
80
f77 double default 7.7,
81
f78 double unsigned default 7.7,
82
f79 double zerofill default 7.7,
83
f80 double unsigned zerofill default 8.8,
84
f81 float not null default 8.8,
85
f82 float unsigned not null default 8.8,
86
f83 float zerofill not null default 8.8,
87
f84 float unsigned zerofill not null default 8.8,
88
f85 float(0) not null default 8.8,
89
f86 float(23) not null default 8.8,
90
f87 float(0) unsigned not null default 8.8,
91
f88 float(23) unsigned not null default 8.8,
92
f89 float(0) zerofill not null default 8.8,
93
f90 float(23) zerofill not null default 8.8,
94
f91 float(0) unsigned zerofill not null default 8.8,
95
f92 float(23) unsigned zerofill not null default 8.8,
96
f93 float(24) not null default 8.8,
97
f94 float(53) not null default 8.8,
98
f95 float(24) unsigned not null default 8.8,
99
f96 float(53) unsigned not null default 8.8,
100
f97 float(24) zerofill not null default 8.8,
101
f98 float(53) zerofill not null default 8.8,
102
f99 float(24) unsigned zerofill not null default 8.8,
103
f100 float(53) unsigned zerofill not null default 8.8,
104
f101 date not null default '2000-01-01',
105
f102 time not null default 20,
106
f103 datetime not null default '2/2/2',
107
f104 timestamp not null default 20001231235959,
108
f105 year not null default 2000,
109
f106 year(3) not null default 2000,
110
f107 year(4) not null default 2000,
111
f108 enum("1enum","2enum") not null default "1enum",
64
f59 numeric (0) unsigned,
65
f60 numeric (64) unsigned,
66
f61 numeric (0) zerofill,
67
f62 numeric (64) zerofill,
68
f63 numeric (0) unsigned zerofill,
69
f64 numeric (64) unsigned zerofill,
72
f67 numeric (0,0) unsigned,
73
f68 numeric (63,30) unsigned,
74
f69 numeric (0,0) zerofill,
75
f70 numeric (63,30) zerofill,
76
f71 numeric (0,0) unsigned zerofill,
77
f72 numeric (63,30) unsigned zerofill,
81
f76 real unsigned zerofill,
82
f77 double default 7.7,
83
f78 double unsigned default 7.7,
84
f79 double zerofill default 7.7,
85
f80 double unsigned zerofill default 8.8,
86
f81 float not null default 8.8,
87
f82 float unsigned not null default 8.8,
88
f83 float zerofill not null default 8.8,
89
f84 float unsigned zerofill not null default 8.8,
90
f85 float(0) not null default 8.8,
91
f86 float(23) not null default 8.8,
92
f87 float(0) unsigned not null default 8.8,
93
f88 float(23) unsigned not null default 8.8,
94
f89 float(0) zerofill not null default 8.8,
95
f90 float(23) zerofill not null default 8.8,
96
f91 float(0) unsigned zerofill not null default 8.8,
97
f92 float(23) unsigned zerofill not null default 8.8,
98
f93 float(24) not null default 8.8,
99
f94 float(53) not null default 8.8,
100
f95 float(24) unsigned not null default 8.8,
101
f96 float(53) unsigned not null default 8.8,
102
f97 float(24) zerofill not null default 8.8,
103
f98 float(53) zerofill not null default 8.8,
104
f99 float(24) unsigned zerofill not null default 8.8,
105
f100 float(53) unsigned zerofill not null default 8.8,
106
f101 date not null default '2000-01-01',
107
f102 time not null default 20,
108
f103 datetime not null default '2/2/2',
109
f104 timestamp not null default 20001231235959,
110
f105 year not null default 2000,
111
f106 year(3) not null default 2000,
112
f107 year(4) not null default 2000,
113
f108 enum("1enum","2enum") not null default "1enum",
112
114
f109 set("1set","2set") not null default "1set"
113
115
) engine = memory;
114
load data infile 'MYSQL_TEST_DIR/suite/funcs_1/data/memory_tb2.txt' into table tb2 ;
116
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/memory_tb2.txt'
117
120
! Attention: The file with the expected results is not