github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/all_mode/data/db3.prepare.sql (about)

     1  drop database if exists `all_mode`;
     2  create database `all_mode`;
     3  use `all_mode`;
     4  
     5  create table t_extract
     6  (
     7      id int primary key auto_increment,
     8      j  json,
     9      a  int as (j ->> '$.a'),
    10      b  char(10) as (j ->> '$.b'),
    11      j1 json as (json_search(j, 'one', '1')),
    12      j2 json as (json_array(j ->> '$.a', j ->> '$.b')),
    13      j3 json as (json_object('a', j ->> '$.a', 'b', j ->> '$.b')),
    14      j4 json as (json_merge_preserve(b, '{"k": "v"}')),
    15      j5 json as (json_merge_patch(b, '{"k": "v"}')),
    16      j7 json as (json_set(b, '$.k', 'v')),
    17      j8 json as (json_insert(b, '$.k', 'v')),
    18      j9 json as (json_replace(b, '$.k', 'v')),
    19      j10 json as (json_remove(b, '$.k')),
    20      j11 int as (json_contains(b, '{"k": "v"}')),
    21      j12 int as (json_contains_path(b, 'one', '$.k')),
    22      j13 json as (json_array_append(b, '$[0]', 'v')),
    23      j14 json as (json_array_insert(j3, '$[0]', 'v'))
    24  );
    25  
    26  insert into t_extract(j)values ('{"a":1, "b": {"a":1}}');
    27  insert into t_extract(j)values ('{"a":1, "b": [1,2,3]}');
    28  insert into t_extract(j)values ('[1,2]');
    29  insert into t_extract(j)values ('true');
    30  insert into t_extract(j)values ('false');
    31  insert into t_extract(j)values (null);
    32  insert into t_extract(j)values ('"string"');
    33  insert into t_extract(j)values ('1');
    34  insert into t_extract(j)values ('3.14');
    35  insert into t_extract(j)values ('{"a":1, "b": {"a":1}, "c": "string"}');