phpMyAdmin / Bugs / #4975 (ok 4.4.12) Move/ Copy/ Rename operations on Table/ Db fail on Drizzle server

#4975 (ok 4.4.12) Move/ Copy/ Rename operations on Table/ Db fail on Drizzle server

Milestone: 4.4.10

Status: resolved

Owner: Madhura Jayaratne

Labels: drizzle (3) table_ops (1) db_ops (1)

Priority: Normal

Updated: 2015-07-10

Created: 2015-07-04

Creator: Deven Bansod

Private: No

Hi,
The operations like 'Move', 'Copy', 'Rename' etc. on Table and Database fail on a Drizzle server.

The reason is we run a query 'SET SQL_MODE = NO_AUTO_VALUE_ON_ZERO' while performing these operations.
But, SQL_MODE variable is not present in Drizzle.

They have implicitly assumed it set by default as per discussion here :

https://lists.launchpad.net/drizzle-discuss/msg04101.html
https://bugs.launchpad.net/drizzle/+bug/314567

Discussion

Deven Bansod - 2015-07-04

PR : https://github.com/phpmyadmin/phpmyadmin/pull/1775

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2015-07-10

assigned_to: Madhura Jayaratne
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2015-07-10

summary: Move/ Copy/ Rename operations on Table/ Db fail on Drizzle server --> (ok 4.4.12) Move/ Copy/ Rename operations on Table/ Db fail on Drizzle server

status: open --> resolved
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Madhura Jayaratne - 2015-07-10

Fixed with https://github.com/phpmyadmin/phpmyadmin/pull/1775

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

(ok 4.4.12) Move/ Copy/ Rename operations on Table/ Db fail on Drizzle server

A software tool to bring MySQL to the Web

Group

Searches

Help

#4975 (ok 4.4.12) Move/ Copy/ Rename operations on Table/ Db fail on Drizzle server

Discussion