blob: 21c0639054618ddfd5fe05d069bf7975a598cdf6 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
--echo #
--echo # MDEV-18323: Convert MySQL JSON type to MariaDB TEXT in mysql_upgrade
--echo # Test integers
--echo #
let $datadir=`select @@datadir`;
drop table if exists mysql_json;
--echo #
--echo # String value
--echo #
--copy_file std_data/json.frm $datadir/test/mysql_json.frm
--copy_file std_data/json.MYI $datadir/test/mysql_json.MYI
--copy_file std_data/json.MYD $datadir/test/mysql_json.MYD
# Now can read
select * from test.mysql_json;
drop table mysql_json;
--echo #
--echo # Negative value
--echo #
--copy_file std_data/negative_value_json.frm $datadir/test/mysql_json.frm
--copy_file std_data/negative_value_json.MYI $datadir/test/mysql_json.MYI
--copy_file std_data/negative_value_json.MYD $datadir/test/mysql_json.MYD
select * from test.mysql_json;
drop table mysql_json;
--echo #
--echo # Mix of INT32 and UINT64
--echo #
# Make sure you have placed `json.[frm/myd/myi]` files in `source/mysql-test/std_data/`
--copy_file std_data/simple_ints_table_json_object.frm $datadir/test/mysql_json.frm
--copy_file std_data/simple_ints_table_json_object.MYI $datadir/test/mysql_json.MYI
--copy_file std_data/simple_ints_table_json_object.MYD $datadir/test/mysql_json.MYD
# Now can read
select * from test.mysql_json;
drop table mysql_json;
|
