Your message dated Sat, 29 Dec 2007 18:35:39 +0100
with message-id <[EMAIL PROTECTED]>
and subject line Fixed in phpmyadmin 2.11.0
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--- Begin Message ---
Package: phpmyadmin
Version: 4:2.6.2-3sarge1
Severity: normal
When selecting from one single table in the SQL tab, it should be
possible to export the selected data in an SQL script.
However, if the query contains a subquery, the exported data is right,
but the target table for INSERT and CREATE TABLE is wrong.
---------------------------------------
-- Sample data to reproduce the bug: --
---------------------------------------
--
-- Structure de la table `header1`
--
CREATE TABLE `header1` (
`id_header1` int(11) NOT NULL default '0',
`label` varchar(100) NOT NULL default '',
PRIMARY KEY (`id_header1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `header1`
--
INSERT INTO `header1` VALUES (1, 'Chapter 1');
INSERT INTO `header1` VALUES (2, 'Chapter 2');
INSERT INTO `header1` VALUES (3, 'Chapter 3');
--
-- Structure de la table `header2`
--
CREATE TABLE `header2` (
`id_header2` int(11) NOT NULL auto_increment,
`id_header1` int(11) NOT NULL default '0',
`label` varchar(100) NOT NULL default '',
PRIMARY KEY (`id_header2`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `header2`
--
INSERT INTO `header2` VALUES (1, 1, 'Item 1.1');
INSERT INTO `header2` VALUES (2, 1, 'Item 1.2');
INSERT INTO `header2` VALUES (3, 2, 'Item 2.1');
INSERT INTO `header2` VALUES (4, 2, 'Item 2.2');
INSERT INTO `header2` VALUES (5, 2, 'Item 2.3');
INSERT INTO `header2` VALUES (6, 3, 'Item 3.1');
INSERT INTO `header2` VALUES (7, 3, 'Item 3.2');
---------------
-- SQL query --
---------------
SELECT label
FROM header2 h2
WHERE h2.id_header1 = (
SELECT h1.id_header1
FROM header1 h1
WHERE h1.label = 'Chapter 2' );
-----------------------------------------
-- SQL export result (header stripped) --
-----------------------------------------
--
-- Structure de la table `header1`
--
CREATE TABLE `header1` (
`id_header1` int(11) NOT NULL default '0',
`label` varchar(100) NOT NULL default '',
PRIMARY KEY (`id_header1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `header1`
--
INSERT INTO `header1` (`id_header1`, `label`) VALUES (2, 'Item 2.1');
INSERT INTO `header1` (`id_header1`, `label`) VALUES (2, 'Item 2.2');
INSERT INTO `header1` (`id_header1`, `label`) VALUES (2, 'Item 2.3');
---------------------
-- Expected result --
---------------------
--
-- Structure de la table `header2`
--
CREATE TABLE `header2` (
`id_header2` int(11) NOT NULL auto_increment,
`id_header1` int(11) NOT NULL default '0',
`label` varchar(100) NOT NULL default '',
PRIMARY KEY (`id_header2`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `header2`
--
INSERT INTO `header2` (`id_header1`, `label`) VALUES (2, 'Item 2.1');
INSERT INTO `header2` (`id_header1`, `label`) VALUES (2, 'Item 2.2');
INSERT INTO `header2` (`id_header1`, `label`) VALUES (2, 'Item 2.3');
-- System Information:
Debian Release: 3.1
Architecture: i386 (i686)
Kernel: Linux 2.6.8-2-386
Locale: [EMAIL PROTECTED], [EMAIL PROTECTED] (charmap=ISO-8859-15)
Versions of packages phpmyadmin depends on:
ii apache2-mpm-prefork [httpd] 2.0.54-5 traditional model for Apache2
ii debconf 1.4.30.13 Debian configuration management sy
ii php4 4:4.3.10-16 server-side, HTML-embedded scripti
ii php4-mysql 4:4.3.10-16 MySQL module for php4
ii ucf 1.17 Update Configuration File: preserv
-- debconf information:
* phpmyadmin/reconfigure-webserver: apache2
* phpmyadmin/restart-webserver: true
--- End Message ---
--- Begin Message ---
Version: 4:2.11.0-1
Hi,
This bug has been fixed in version 2.11.0 of phpMyAdmin, uploaded a couple of
months ago.
thanks for reporting!
Thijs
pgpx0j7pS44zS.pgp
Description: PGP signature
--- End Message ---
