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

federated.federatedx_create_handlers fails under view protocol

Details

    Description

      federated.federatedx_create_handlers 'X' w1 [ fail ]
      		 
              Test ended at 2025-03-26 01:02:44
      		 
       
      		 
      CURRENT_TEST: federated.federatedx_create_handlers
      		 
      mysqltest: At line 65: query 'SELECT count(*), name FROM federated.t1 WHERE id < 5 GROUP BY name' failed: ER_GET_ERRNO (1030): Got error 10000 "Unknown error 10000" from storage engine FEDERATED

      Attachments

        Issue Links

          is part of

          Technical task - A technical task. MDEV-27691 make working view-protocol

          • Major - Major loss of function.
          • Closed

          Activity

            danblack Daniel Black added a comment -

            note while here - fails under cursor too

            bb-12.0-release first

            		 
            federated.federatedx_create_handlers 'X' [ fail ]
            		 
                    Test ended at 2025-05-01 08:57:37
            		 
             
            		 
            CURRENT_TEST: federated.federatedx_create_handlers
            		 
            --- /source/mysql-test/suite/federated/federatedx_create_handlers.result	2025-04-29 05:44:51.931437742 +0000
            		 
            +++ /build/mysql-test/var/log/federatedx_create_handlers.reject	2025-05-01 08:57:37.038217540 +0000
            		 
            @@ -574,8 +574,8 @@
            		 
             WHERE id=2) dt2) dt
            		 
             ) ON t10.a=t11.a;
            		 
             a	b	a	b	id	name
            		 
            -1	1	NULL	NULL	NULL	NULL
            		 
            -2	2	NULL	NULL	NULL	NULL
            		 
            +1	1	NULL	NULL	0	
            +2	2	NULL	NULL	0	
             #
            		 
             # MDEV-31361: Second execution of PS for query with derived table

            danblack Daniel Black added a comment - note while here - fails under cursor too bb-12.0-release first federated.federatedx_create_handlers 'X' [ fail ] Test ended at 2025-05-01 08:57:37   CURRENT_TEST: federated.federatedx_create_handlers --- /source/mysql-test/suite/federated/federatedx_create_handlers.result 2025-04-29 05:44:51.931437742 +0000 +++ /build/mysql-test/var/log/federatedx_create_handlers.reject 2025-05-01 08:57:37.038217540 +0000 @@ -574,8 +574,8 @@ WHERE id=2) dt2) dt ) ON t10.a=t11.a; a b a b id name -1 1 NULL NULL NULL NULL -2 2 NULL NULL NULL NULL +1 1 NULL NULL 0 +2 2 NULL NULL 0 # # MDEV-31361: Second execution of PS for query with derived table

            People

              Unassigned Unassigned
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.