summaryrefslogtreecommitdiff
path: root/mysql-test/main/anel_array.test
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;