Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5709

ExtractValue() with XPath variable references returns wrong result

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 5.5.35
        • Fix Version/s: 5.5
        • Component/s: None
        • Labels:
          None

          Description

          This script returns correct results:

          DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a INT, b VARCHAR(10));
INSERT INTO t1 VALUES (1,'b1'),(2,'b2');
SELECT *,IF(@i:=a,ExtractValue('<a><b>b1</b><b>b2</b></a>','//b[$@i]'),0) AS xpath FROM t1;
+------+------+-------+
| a    | b    | xpath |
+------+------+-------+
|    1 | b1   | b1    |
|    2 | b2   | b2    |
+------+------+-------+
2 rows in set (0.00 sec)

          If I move ExtractValue() from the SELECT list to the WHERE condition,
          the results are not as expected:

          mysql> SELECT * FROM t1 WHERE b=IF(@i:=a,ExtractValue('<a><b>b1</b><b>b2</b></a>','//b[$@i]'),0);
+------+------+
| a    | b    |
+------+------+
|    1 | b1   |
+------+------+
1 row in set (0.00 sec)

          The expected result would be to return both rows.

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5689 ExtractValue(xml, 'substring(/x,/y)') crashes

                • Major - Major loss of function.
                • Closed

                  Activity

                  Hide
                  Permalink
                  bar Alexander Barkov added a comment -

                  Pushed into 10.0 as a joint patch for MDEV-5689
                  TODO: backport to 5.5.

                  Show
                  bar Alexander Barkov added a comment - Pushed into 10.0 as a joint patch for MDEV-5689 TODO: backport to 5.5.

                    People

                    • Assignee:
                      bar Alexander Barkov
                      Reporter:
                      bar Alexander Barkov
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated: