github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/function/func_multi_field.test (about)

     1  #str
     2  SELECT FIELD('Bb', 'Aa', 'Bb', 'Cc', 'Dd', 'Ff');
     3  SELECT FIELD('Bb', 'Bb', 'Aa', 'Cc', 'Dd', 'Ff');
     4  SELECT FIELD('Bb', 'Aa', 'Cc', 'Bb', 'Dd', 'Ff');
     5  SELECT FIELD('Bb', 'Aa', 'Cc', 'Dd', 'Bb', 'Ff');
     6  SELECT FIELD('Bb', 'Aa', 'Cc', 'Dd', 'Ff', 'Bb');
     7  SELECT FIELD('Gg', 'Aa', 'Bb', 'Cc', 'Dd', 'Ff');
     8  
     9  #null
    10  SELECT FIELD(null, 'Aa', 'Bb', 'Cc', 'Dd', 'Ff');
    11  SELECT FIELD('Bb', null, 'Bb', 'Cc', 'Dd', 'Ff');
    12  SELECT FIELD('Bb', 'Aa', null, 'Cc', 'Dd', 'Ff');
    13  SELECT FIELD('Bb', null, null, null, 'Bb', null, 'Dd', 'Ff');
    14  
    15  create table test(a varchar(20));
    16  insert into test values('Aa');
    17  insert into test values('Bb');
    18  insert into test values('Cc');
    19  insert into test values('Dd');
    20  insert into test values('Ee');
    21  insert into test values('Ff');
    22  SELECT FIELD(null, a, 'Aa', 'Bb', 'Cc', 'Dd', 'Ff') from test;
    23  SELECT FIELD(a, 'Aa', 'Bb', 'Cc', 'Dd', 'Ff') from test;
    24  SELECT FIELD('Aa', a, 'Bb', 'Cc', 'Dd', 'Ff') from test;
    25  SELECT FIELD('Aa', 'Bb', a, 'Cc', 'Dd', 'Ff') from test;
    26  SELECT FIELD('Aa', 'Bb', 'Cc', a, 'Dd', 'Ff') from test;
    27  SELECT FIELD('Aa', 'Aa', 'Cc', a, 'Dd', 'Ff') from test;
    28  SELECT FIELD(a, null, null, null, null) from test;
    29  drop table test;
    30  
    31  
    32  
    33  #int
    34  SELECT FIELD(1, 1, 2, 3, 4, 5);
    35  SELECT FIELD(2, 1, 2, 3, 4, 5);
    36  SELECT FIELD(3, 1, 2, 3, 4, 5);
    37  SELECT FIELD(4, 1, 2, 3, 4, 5);
    38  SELECT FIELD(5, 1, 2, 3, 4, 5);
    39  SELECT FIELD(6, 1, 2, 3, 4, 5);
    40  
    41  #null
    42  SELECT FIELD(null, 1, 1, 2, 3, 4, 5);
    43  SELECT FIELD(1, null, 2, 3, 4, 5);
    44  SELECT FIELD(1, 1, null, 3, 4, 5);
    45  SELECT FIELD(1, null, null, null, 1, null);
    46  
    47  create table test(a int);
    48  insert into test values(1);
    49  insert into test values(2);
    50  insert into test values(3);
    51  insert into test values(4);
    52  insert into test values(5);
    53  insert into test values(6);
    54  SELECT FIELD(null, a, 1, 2, 3, 4, 5) from test;
    55  SELECT FIELD(a, 1, 2, 3, 4, 5) from test;
    56  SELECT FIELD(1, a, 2, 3, 4, 5) from test;
    57  SELECT FIELD(1, 2, a, 3, 4, 5) from test;
    58  SELECT FIELD(1, 2, 3, a, 4, 5) from test;
    59  SELECT FIELD(1, 2, 3, 4, a, 5) from test;
    60  SELECT FIELD(a, null, null, null) from test;
    61  drop table test;
    62  
    63  #mixed
    64  SELECT FIELD(1, '1', '2', 3, 4, 5);
    65  SELECT FIELD(2, 1, '2', 3, 4, 5);
    66  SELECT FIELD(3, 1, '2', 3, 4, 5);
    67  SELECT FIELD(4, '1', '2', 3, 4, 5);
    68  SELECT FIELD('5', 1, 2, 3, 4, 5);
    69  SELECT FIELD('6', 1, 2, 3, 4, 5);
    70  
    71  #null
    72  SELECT FIELD(null, 1, '1', 2, '3', 4, 5);
    73  SELECT FIELD(1, null, 2, '3', 4, 5);
    74  SELECT FIELD(1, 1, null, 3, '4', 5);
    75  SELECT FIELD(1, null, null, null, '1', null);
    76  
    77  create table test(a int);
    78  insert into test values(1);
    79  insert into test values(2);
    80  insert into test values(3);
    81  insert into test values(4);
    82  insert into test values(5);
    83  insert into test values(6);
    84  SELECT FIELD(null, a, '1', 2, 3, 4, 5) from test;
    85  SELECT FIELD(a, '1', 2, 3, 4, 5) from test;
    86  SELECT FIELD('1', a, 2, 3, 4, 5) from test;
    87  SELECT FIELD(1, '2', a, 3, 4, 5) from test;
    88  SELECT FIELD(1, 2, '3', a, 4, 5) from test;
    89  SELECT FIELD('1', 2, 3, 4, a, 5) from test;
    90  SELECT FIELD(a, null, null, null) from test;
    91  drop table test;
    92  
    93  #float
    94  SELECT FIELD(1.39479374937490, 1.39479374937490, 1.39479374937491, 1.39479374937492, 1.39479374937493, 1.39479374937494);
    95  SELECT FIELD(1.39479374937491, 1.39479374937490, 1.39479374937491, 1.39479374937492, 1.39479374937493, 1.39479374937494);
    96  SELECT FIELD(1.39479374937492, 1.39479374937490, 1.39479374937491, 1.39479374937492, 1.39479374937493, 1.39479374937494);
    97  SELECT FIELD(1.39479374937493, 1.39479374937490, 1.39479374937491, 1.39479374937492, 1.39479374937493, 1.39479374937494);
    98  SELECT FIELD(1.39479374937494, 1.39479374937490, 1.39479374937491, 1.39479374937492, 1.39479374937493, 1.39479374937494);
    99  SELECT FIELD(1.39479374937495, 1.39479374937490, 1.39479374937491, 1.39479374937492, 1.39479374937493, 1.39479374937494);
   100  SELECT FIELD(1.39479374937496, 1.39479374937490, 1.39479374937491, 1.39479374937492, 1.39479374937493, 1.39479374937494);