blob: 236d5dbf8abc9be9843d8370788688cad8c694c3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
--echo #
--echo # MDEV-18323: Convert MySQL JSON type to MariaDB TEXT in mysql_upgrade
--echo # Test 2 (field treated as a blob):
--echo # Can read .frm file from mysql table containg the json data,
--echo # but is not well structured
--echo #
let $datadir=`select @@datadir`;
drop table if exists mysql_json;
# Make sure you have placed `json.[frm/myd/myi]` files in `source/mysql-test/std_data/`
--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;
|
