blob: 3234b9d2150dd91e62af949dc2384c6ea4dd9055 (
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
48
49
50
51
|
let $datadir=`select @@datadir`;
--echo #
--echo # Array test with JSONB_TYPE_LARGE_OBJECT
--echo #
call mtr.add_suppression("Table './test/mysql_json_array_long' is marked as crashed and should be repaired");
call mtr.add_suppression("Checking table: './test/mysql_json_array_long'");
call mtr.add_suppression("Table './test/mysql_json_array' is marked as crashed and should be repaired");
call mtr.add_suppression("Checking table: './test/mysql_json_array'");
call mtr.add_suppression("Table './test/mysql_json' is marked as crashed and should be repaired");
call mtr.add_suppression("Checking table: './test/mysql_json'");
# Make sure you have placed `json.[frm/myd/myi]` files in `source/mysql-test/std_data/`
--copy_file std_data/long_string_JSONB_TYPE_LARGE_OBJECT.frm $datadir/test/mysql_json_array_long.frm
--copy_file std_data/long_string_JSONB_TYPE_LARGE_OBJECT.MYI $datadir/test/mysql_json_array_long.MYI
--copy_file std_data/long_string_JSONB_TYPE_LARGE_OBJECT.MYD $datadir/test/mysql_json_array_long.MYD
# Now can read
select * from test.mysql_json_array_long;
drop table test.mysql_json_array_long;
--echo #
--echo # Array test with json array
--echo #
# Make sure you have placed `json.[frm/myd/myi]` files in `source/mysql-test/std_data/`
--copy_file std_data/simple_array1.frm $datadir/test/mysql_json_array.frm
--copy_file std_data/simple_array1.MYI $datadir/test/mysql_json_array.MYI
--copy_file std_data/simple_array1.MYD $datadir/test/mysql_json_array.MYD
# Now can read
select * from test.mysql_json_array;
drop table test.mysql_json_array;
--echo #
--echo # Array test with json object
--echo #
# Make sure you have placed `json.[frm/myd/myi]` files in `source/mysql-test/std_data/`
--copy_file std_data/simple_array_table_json_object.frm $datadir/test/mysql_json.frm
--copy_file std_data/simple_array_table_json_object.MYI $datadir/test/mysql_json.MYI
--copy_file std_data/simple_array_table_json_object.MYD $datadir/test/mysql_json.MYD
# Now can read
select * from test.mysql_json;
drop table test.mysql_json;
|