[Bug]: binary(16) DEFAULT value is incorrectly exported · Issue #19679 · phpmyadmin/phpmyadmin · GitHub
Skip to content

[Bug]: binary(16) DEFAULT value is incorrectly exported #19679

Description

@GieltjE

Describe the bug

phpmyadmin result:

CREATE TABLE `test` (
  `IP` binary(16) NOT NULL DEFAULT x AS `00000000000000000000000000000000`,
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

mysqldump result:

CREATE TABLE `test` (
  `IP` binary(16) NOT NULL DEFAULT x'00000000000000000000000000000000'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

How to Reproduce

  1. Export a table with a binary(16) field with a default value
  2. Import the result file

Expected behavior

A correctly formatted default value

Screenshots

No response

Operating System

Linux

Web Server

apache/2.4.63-1

Database Server

MariaDB

Database version

11.8.1-MariaDB-deb12-log

PHP version

8.2.27-1

phpMyAdmin version

5.2.2

browser

Firefox 137.0.2 (64-bit)

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugA problem or regression with an existing feature

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions