[MDEV-9704] ALTER TABLE does not work from client Created: 2016-03-09  Updated: 2016-03-21  Resolved: 2016-03-14

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Scripts & Clients
Affects Version/s: 10.2
Fix Version/s: 10.2.0

Type: Bug Priority: Blocker
Reporter: Elena Stepanova Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: regression
Environment:

351026ca535179abb956c5ad1e1d59aac0835254


 Description   

Execute from MySQL client (not MTR)

 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
 
Your MariaDB connection id is 5
 
Server version: 10.2.0-MariaDB-debug Source distribution
 
 
 
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
 
 
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
 
 
MariaDB [test]> DROP TABLE IF EXISTS t1;
 
Query OK, 0 rows affected (0.06 sec)
 
 
 
MariaDB [test]> CREATE TABLE t1 (a INT, b CHAR(8)) ENGINE=InnoDB;
 
Query OK, 0 rows affected (0.02 sec)
 
 
 
MariaDB [test]> INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c');
 
Query OK, 3 rows affected (0.00 sec)
 
Records: 3  Duplicates: 0  Warnings: 0
 
 
 
MariaDB [test]> ALTER TABLE t1 MODIFY b CHAR(16);
 
ERROR 65535 (HY000): 
MariaDB [test]>

It is not the client problem though, the same happens with old client versions. It must be fixed on the server side.

The problem was introduced by this commit:

commit d4b3a199acb0ddcdedff441ae664b0a2cf2fe8d2
 
Author: Oleksandr Byelkin <sanja@mariadb.com>
 
Date:   Sun Jan 17 21:21:39 2016 +0100
 
 
 
    MDEV-9117: Client Server capability negotiation for MariaDB specific functionality
 
    
    New capability flags space.
 
    Removed old progress flag, added new one.



 Comments   
Comment by Oleksandr Byelkin [ 2016-03-11 ]

revision-id: 66cd0f2f02bb45707b38e983186ab8e7aae21da9 (mariadb-10.1.8-156-g66cd0f2)
parent(s): 75d8544c0bc611e82078b9e5f59caef9105e4892
committer: Oleksandr Byelkin
timestamp: 2016-03-11 16:55:57 +0100
message:

MDEV-9704: ALTER TABLE does not work from client

Do not try to send progress packets if client was not informed about them.

—

Comment by Oleksandr Byelkin [ 2016-03-11 ]

Error 65535 is mark of progress packet because of this when client do not expect it it just shows error.

Generated at Thu Feb 08 07:36:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.