Details

    Description

      In mariadb 10.6 the result was good, in mariadb 10.11 give wrong result

      SET @JSON='
      {
        "SZ": [
          {
            "NAME": "S0",
            "OFFERS": [
              {
                "NAME": "S0A0"
              }
            ]
          },
          {
            "NAME": "S1",
            "OFFERS": [
              {
                "NAME": "S1A0"
              },
              {
                "NAME": "S1A1"
              }
            ]
          },
          {
            "NAME": "S2",
            "OFFERS": [
              {
                "NAME": "S2A0"
              }
            ]
          },
          {
            "NAME": "S3",
            "OFFERS": [
              {
                "NAME": "S3A0"
              }
            ]
          },
          {
            "NAME": "S4",
            "OFFERS": [
              {
                "NAME": "S4A0"
              }
            ]
          },
          {
            "NAME": "S5",
            "OFFERS": [
              {
                "NAME": "S5A0"
              }
            ]
          }
        ]
      }
       
      '
      ;
       
      #Good result S0A0 this ok in mariadb 10.11
      SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]' 
      COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
      #Good result no result, wrong result in 10.11
      SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]' 
      COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
       
      #Good result S1A1  wrong result in 10.11
      SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]' 
      COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
       
      #Good  result in mariadb 10.11
      select JSON_VALUE(@json, '$.SZ[1].OFFERS[1].NAME');
      
      

      Attachments

        Issue Links

          Activity

            bulepage bulepage created issue -
            bulepage bulepage made changes -
            Field Original Value New Value
            Summary Wron result json_table Wrong result json_table
            bulepage bulepage made changes -
            Component/s JSON [ 13908 ]
            bulepage bulepage made changes -
            Description cd ~/sql_schema2/forras_sql/
            /opt/skeema init -H 192.168.30.18 -u csenki2 -p --schema=pworkflow -d ~/sql_schema2/forras_sql/pworkflow


            /opt/skeema init -H 127.0.0.1 -u root -p --schema=pworkflow -d ~/sql_schema2/forras_sql/pworkflow
            /opt/skeema diff development
            /opt/skeema init -h 127.0.0.1 -u root -p --schema=pworkflow -d ~/sql_schema2/forras_sql/pworkflow

            /opt/skeema push development -p

            /opt/skeema diff -H 192.168.30.18 -u csenki2 -p --schema=pworkflow




            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            In mariadb 10.6 the result was good
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            In mariadb 10.6 the result was good
            bulepage bulepage made changes -
            Description SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            In mariadb 10.6 the result was good
            {code:mysql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            {code}


            In mariadb 10.6 the result was good
            bulepage bulepage made changes -
            Description {code:mysql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            {code}


            In mariadb 10.6 the result was good
            {code:sql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            {code}


            In mariadb 10.6 the result was good
            bulepage bulepage made changes -
            Description {code:sql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            {code}


            In mariadb 10.6 the result was good
            {code:sql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            {code}


            In mariadb 10.6 the result was good, in mariadb 10.11 give wrong result



            bulepage bulepage made changes -
            Description {code:sql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            {code}


            In mariadb 10.6 the result was good, in mariadb 10.11 give wrong result




            In mariadb 10.6 the result was good, in mariadb 10.11 give wrong result

            {code:sql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            {code}






            bulepage bulepage made changes -
            Description
            In mariadb 10.6 the result was good, in mariadb 10.11 give wrong result

            {code:sql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            {code}






            In mariadb 10.6 the result was good, in mariadb 10.11 give wrong result

            {code:sql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0 this ok in mariadb 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result, wrong result in 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1 wrong result in 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            {code}






            bulepage bulepage made changes -
            Description In mariadb 10.6 the result was good, in mariadb 10.11 give wrong result

            {code:sql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0 this ok in mariadb 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result, wrong result in 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1 wrong result in 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;


            {code}






            In mariadb 10.6 the result was good, in mariadb 10.11 give wrong result

            {code:sql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0 this ok in mariadb 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result, wrong result in 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1 wrong result in 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;

            #Good result in in mariadb 10.11
            select JSON_VALUE(@json, '$.SZ[1].OFFERS[1].NAME');

            {code}






            bulepage bulepage made changes -
            Description In mariadb 10.6 the result was good, in mariadb 10.11 give wrong result

            {code:sql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0 this ok in mariadb 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result, wrong result in 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1 wrong result in 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;

            #Good result in in mariadb 10.11
            select JSON_VALUE(@json, '$.SZ[1].OFFERS[1].NAME');

            {code}






            In mariadb 10.6 the result was good, in mariadb 10.11 give wrong result

            {code:sql}
            SET @JSON='
            {
              "SZ": [
                {
                  "NAME": "S0",
                  "OFFERS": [
                    {
                      "NAME": "S0A0"
                    }
                  ]
                },
                {
                  "NAME": "S1",
                  "OFFERS": [
                    {
                      "NAME": "S1A0"
                    },
                    {
                      "NAME": "S1A1"
                    }
                  ]
                },
                {
                  "NAME": "S2",
                  "OFFERS": [
                    {
                      "NAME": "S2A0"
                    }
                  ]
                },
                {
                  "NAME": "S3",
                  "OFFERS": [
                    {
                      "NAME": "S3A0"
                    }
                  ]
                },
                {
                  "NAME": "S4",
                  "OFFERS": [
                    {
                      "NAME": "S4A0"
                    }
                  ]
                },
                {
                  "NAME": "S5",
                  "OFFERS": [
                    {
                      "NAME": "S5A0"
                    }
                  ]
                }
              ]
            }
             
            '
            ;
             
            #Good result S0A0 this ok in mariadb 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[0]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
            #Good result no result, wrong result in 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[0].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;
             
            #Good result S1A1 wrong result in 10.11
            SELECT * FROM json_table(@JSON, '$.SZ[1].OFFERS[1]'
            COLUMNS(NAME VARCHAR(30) PATH '$.NAME')) AS t_sz;

            #Good result in mariadb 10.11
            select JSON_VALUE(@json, '$.SZ[1].OFFERS[1].NAME');

            {code}






            alice Alice Sherepa made changes -
            Affects Version/s 10.11 [ 27614 ]
            Affects Version/s 11.4 [ 29301 ]
            Affects Version/s 11.8 [ 29921 ]
            alice Alice Sherepa made changes -
            Fix Version/s 10.11 [ 27614 ]
            Fix Version/s 11.4 [ 29301 ]
            Fix Version/s 11.8 [ 29921 ]
            alice Alice Sherepa made changes -
            Affects Version/s 10.9.1 [ 27114 ]
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            Assignee Rucha Deodhar [ rucha174 ]
            alice Alice Sherepa made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            alice Alice Sherepa made changes -
            Labels regression-10.9

            People

              rucha174 Rucha Deodhar
              bulepage bulepage
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.