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

incorrect result of gis function in view protocol

Details

    Description

      After removing disabling view protocol found incorrect result of gis finction:

      --- /home/sanja/maria/git/10.4/mysql-test/main/gis.result	2023-10-12 20:35:38.674266836 +0200
      		 
      +++ /home/sanja/maria/git/10.4/mysql-test/main/gis.reject	2023-10-12 20:37:25.670497807 +0200
      		 
      @@ -698,10 +698,10 @@
      		 
       drop table t1;
      		 
       select (asWKT(geomfromwkb((0x000000000140240000000000004024000000000000)))) as exp;
      		 
       exp
      		 
      -POINT(10 10)
      		 
      +NULL
      		 
       select (asWKT(geomfromwkb((0x010100000000000000000024400000000000002440)))) as exp;
      		 
       exp
      		 
      -POINT(10 10)
      		 
      +NULL
      		 
       create table t1 (g GEOMETRY);
      		 
       select * from t1;
      		 
       Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr

      as test case uncomment disabling of the view protocol marked #enable after MDEV-32456

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27871 View is created with wrong column name if column name > 64 symbols

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            sanja Oleksandr Byelkin created issue -
            sanja Oleksandr Byelkin made changes -
            Field Original Value New Value
            Description After removing disabling view protocol found incorrect result of gis finction:
            {code}
            --- /home/sanja/maria/git/10.4/mysql-test/main/gis.result 2023-10-12 20:35:38.674266836 +0200
            +++ /home/sanja/maria/git/10.4/mysql-test/main/gis.reject 2023-10-12 20:37:25.670497807 +0200
            @@ -698,10 +698,10 @@
             drop table t1;
             select (asWKT(geomfromwkb((0x000000000140240000000000004024000000000000)))) as exp;
             exp
            -POINT(10 10)
            +NULL
             select (asWKT(geomfromwkb((0x010100000000000000000024400000000000002440)))) as exp;
             exp
            -POINT(10 10)
            +NULL
             create table t1 (g GEOMETRY);
             select * from t1;
             Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr

            {code}             		After removing disabling view protocol found incorrect result of gis finction:
            {code}
            --- /home/sanja/maria/git/10.4/mysql-test/main/gis.result 2023-10-12 20:35:38.674266836 +0200
            +++ /home/sanja/maria/git/10.4/mysql-test/main/gis.reject 2023-10-12 20:37:25.670497807 +0200
            @@ -698,10 +698,10 @@
             drop table t1;
             select (asWKT(geomfromwkb((0x000000000140240000000000004024000000000000)))) as exp;
             exp
            -POINT(10 10)
            +NULL
             select (asWKT(geomfromwkb((0x010100000000000000000024400000000000002440)))) as exp;
             exp
            -POINT(10 10)
            +NULL
             create table t1 (g GEOMETRY);
             select * from t1;
             Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr

            {code}

            as test case uncomment test marked #enable after MDEV-32456
            sanja Oleksandr Byelkin made changes -
            Description After removing disabling view protocol found incorrect result of gis finction:
            {code}
            --- /home/sanja/maria/git/10.4/mysql-test/main/gis.result 2023-10-12 20:35:38.674266836 +0200
            +++ /home/sanja/maria/git/10.4/mysql-test/main/gis.reject 2023-10-12 20:37:25.670497807 +0200
            @@ -698,10 +698,10 @@
             drop table t1;
             select (asWKT(geomfromwkb((0x000000000140240000000000004024000000000000)))) as exp;
             exp
            -POINT(10 10)
            +NULL
             select (asWKT(geomfromwkb((0x010100000000000000000024400000000000002440)))) as exp;
             exp
            -POINT(10 10)
            +NULL
             create table t1 (g GEOMETRY);
             select * from t1;
             Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr

            {code}

            as test case uncomment test marked #enable after MDEV-32456             		After removing disabling view protocol found incorrect result of gis finction:
            {code}
            --- /home/sanja/maria/git/10.4/mysql-test/main/gis.result 2023-10-12 20:35:38.674266836 +0200
            +++ /home/sanja/maria/git/10.4/mysql-test/main/gis.reject 2023-10-12 20:37:25.670497807 +0200
            @@ -698,10 +698,10 @@
             drop table t1;
             select (asWKT(geomfromwkb((0x000000000140240000000000004024000000000000)))) as exp;
             exp
            -POINT(10 10)
            +NULL
             select (asWKT(geomfromwkb((0x010100000000000000000024400000000000002440)))) as exp;
             exp
            -POINT(10 10)
            +NULL
             create table t1 (g GEOMETRY);
             select * from t1;
             Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr

            {code}

            as test case uncomment disabling of the view protocol marked #enable after MDEV-32456
            sanja Oleksandr Byelkin made changes -
            sanja Oleksandr Byelkin made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Alexey Botchkov [ holyfoot ]
            julien.fritsch Julien Fritsch made changes -
            Priority Critical [ 2 ] Major [ 3 ]
            julien.fritsch Julien Fritsch made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            serg Sergei Golubchik made changes -
            Assignee Alexey Botchkov [ holyfoot ] Rucha Deodhar [ rucha174 ]
            rucha174 Rucha Deodhar made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            rucha174 Rucha Deodhar added a comment -

            patch: https://github.com/MariaDB/server/commit/9a2cd52964ccd439bfb2af8d7d4ac63a267c3c1c

            rucha174 Rucha Deodhar added a comment - patch: https://github.com/MariaDB/server/commit/9a2cd52964ccd439bfb2af8d7d4ac63a267c3c1c
            rucha174 Rucha Deodhar made changes -
            Assignee Rucha Deodhar [ rucha174 ] Oleksandr Byelkin [ sanja ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            sanja Oleksandr Byelkin added a comment -

            OK to push after changing comment about wrong printimg value

            sanja Oleksandr Byelkin added a comment - OK to push after changing comment about wrong printimg value
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Rucha Deodhar [ rucha174 ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            rucha174 Rucha Deodhar made changes -
            Fix Version/s 10.5.26 [ 29832 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            JIraAutomate JiraAutomate made changes -
            Fix Version/s 10.6.19 [ 29833 ]
            Fix Version/s 10.11.9 [ 29834 ]
            Fix Version/s 11.1.6 [ 29835 ]
            Fix Version/s 11.2.5 [ 29836 ]
            Fix Version/s 11.4.3 [ 29837 ]

            People

              rucha174 Rucha Deodhar
              sanja Oleksandr Byelkin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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