phpmyadmin-trk-bugs

Bugs item #762213, was opened at 2003-06-28 02:44
Message generated for change (Comment added) made by rabus
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=762213&group_id=23067
Category: MySQL 4 related
Group: 2.5.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Alexander M. Turek (rabus)
>Summary: (2.5.1) Incorrect record count for subqueries (MySQL 4.1)
Initial Comment:
When submitting a query (with in my case a subquery)
the results shows a wrong count (Showing rows 0 - 0 (1
total, Query took 0.0003 sec)) and it is not possible
to browse the result set (no back and forward arrows).
When I execute the same query in a mysql window
(command line), the result is correct.
Version 2.5.1; Also present in version 2.5.2-dev (just
downloaded and tested)
MySQL version 4.1 alpha
PS. Keep up the good work! phpMyAdmin is wonderful and
very useful!
----------------------------------------------------------------------
>Comment By: Alexander M. Turek (rabus)
Date: 2003-06-28 09:01
Message:
Logged In: YES
user_id=418833
Could you give me an example query that fails? Or does every
subquery fail? Does it work correctly with "normal" queries?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=762213&group_id=23067

Bugs item #762213, was opened at 2003-06-27 17:44
Message generated for change (Comment added) made by nobody
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=762213&group_id=23067
Category: MySQL 4 related
Group: 2.5.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Alexander M. Turek (rabus)
Summary: (2.5.1) Incorrect record count for subqueries (MySQL 4.1)
Initial Comment:
When submitting a query (with in my case a subquery)
the results shows a wrong count (Showing rows 0 - 0 (1
total, Query took 0.0003 sec)) and it is not possible
to browse the result set (no back and forward arrows).
When I execute the same query in a mysql window
(command line), the result is correct.
Version 2.5.1; Also present in version 2.5.2-dev (just
downloaded and tested)
MySQL version 4.1 alpha
PS. Keep up the good work! phpMyAdmin is wonderful and
very useful!
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2003-06-30 01:19
Message:
Logged In: NO
I encounter it only with the MySQL 4.1a db when using
subselects. Other queries work perfect.
This is the query that I used:
SELECT * FROM `fragment`
WHERE f_comment = "Trypsine_P" AND f_seq NOT
IN (
SELECT f_seq
FROM fragment
WHERE f_comment = "Trypsine"
GROUP BY f_seq );
----------------------------------------------------------------------
Comment By: Alexander M. Turek (rabus)
Date: 2003-06-28 00:01
Message:
Logged In: YES
user_id=418833
Could you give me an example query that fails? Or does every
subquery fail? Does it work correctly with "normal" queries?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=762213&group_id=23067

Bugs item #762213, was opened at 2003-06-27 17:44
Message generated for change (Comment added) made by nobody
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=762213&group_id=23067
Category: MySQL 4 related
Group: 2.5.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Alexander M. Turek (rabus)
Summary: (2.5.1) Incorrect record count for subqueries (MySQL 4.1)
Initial Comment:
When submitting a query (with in my case a subquery)
the results shows a wrong count (Showing rows 0 - 0 (1
total, Query took 0.0003 sec)) and it is not possible
to browse the result set (no back and forward arrows).
When I execute the same query in a mysql window
(command line), the result is correct.
Version 2.5.1; Also present in version 2.5.2-dev (just
downloaded and tested)
MySQL version 4.1 alpha
PS. Keep up the good work! phpMyAdmin is wonderful and
very useful!
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2003-06-30 01:20
Message:
Logged In: NO
I encounter it only with the MySQL 4.1a db when using
subselects. Other queries work perfect.
This is the query that I used:
SELECT * FROM `fragment`
WHERE f_comment = "Trypsine_P" AND f_seq NOT
IN (
SELECT f_seq
FROM fragment
WHERE f_comment = "Trypsine"
GROUP BY f_seq );
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2003-06-30 01:19
Message:
Logged In: NO
I encounter it only with the MySQL 4.1a db when using
subselects. Other queries work perfect.
This is the query that I used:
SELECT * FROM `fragment`
WHERE f_comment = "Trypsine_P" AND f_seq NOT
IN (
SELECT f_seq
FROM fragment
WHERE f_comment = "Trypsine"
GROUP BY f_seq );
----------------------------------------------------------------------
Comment By: Alexander M. Turek (rabus)
Date: 2003-06-28 00:01
Message:
Logged In: YES
user_id=418833
Could you give me an example query that fails? Or does every
subquery fail? Does it work correctly with "normal" queries?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=762213&group_id=23067

Bugs item #762213, was opened at 2003-06-28 02:44
Message generated for change (Comment added) made by lukro
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=762213&group_id=23067
Category: MySQL 4 related
Group: 2.5.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Alexander M. Turek (rabus)
Summary: (2.5.1) Incorrect record count for subqueries (MySQL 4.1)
Initial Comment:
When submitting a query (with in my case a subquery)
the results shows a wrong count (Showing rows 0 - 0 (1
total, Query took 0.0003 sec)) and it is not possible
to browse the result set (no back and forward arrows).
When I execute the same query in a mysql window
(command line), the result is correct.
Version 2.5.1; Also present in version 2.5.2-dev (just
downloaded and tested)
MySQL version 4.1 alpha
PS. Keep up the good work! phpMyAdmin is wonderful and
very useful!
----------------------------------------------------------------------
Comment By: Luc Krols (lukro)
Date: 2003-06-30 15:40
Message:
Logged In: YES
user_id=812446
Follow up: (I logged in this time). When executing the same
query in a mysql client window or via ODBC, it works
perfect. Only when executing the query from within the
phpMyAdmin web interface (2.5.2-dev, 2.5.1) that the error
occurs.
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2003-06-30 10:20
Message:
Logged In: NO
I encounter it only with the MySQL 4.1a db when using
subselects. Other queries work perfect.
This is the query that I used:
SELECT * FROM `fragment`
WHERE f_comment = "Trypsine_P" AND f_seq NOT
IN (
SELECT f_seq
FROM fragment
WHERE f_comment = "Trypsine"
GROUP BY f_seq );
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2003-06-30 10:19
Message:
Logged In: NO
I encounter it only with the MySQL 4.1a db when using
subselects. Other queries work perfect.
This is the query that I used:
SELECT * FROM `fragment`
WHERE f_comment = "Trypsine_P" AND f_seq NOT
IN (
SELECT f_seq
FROM fragment
WHERE f_comment = "Trypsine"
GROUP BY f_seq );
----------------------------------------------------------------------
Comment By: Alexander M. Turek (rabus)
Date: 2003-06-28 09:01
Message:
Logged In: YES
user_id=418833
Could you give me an example query that fails? Or does every
subquery fail? Does it work correctly with "normal" queries?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=762213&group_id=23067

Bugs item #762213, was opened at 2003-06-28 02:44
Message generated for change (Settings changed) made by rabus
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=762213&group_id=23067
Category: MySQL 4 related
Group: 2.5.1
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
>Assigned to: Marc Delisle (lem9)
Summary: (2.5.1) Incorrect record count for subqueries (MySQL 4.1)
Initial Comment:
When submitting a query (with in my case a subquery)
the results shows a wrong count (Showing rows 0 - 0 (1
total, Query took 0.0003 sec)) and it is not possible
to browse the result set (no back and forward arrows).
When I execute the same query in a mysql window
(command line), the result is correct.
Version 2.5.1; Also present in version 2.5.2-dev (just
downloaded and tested)
MySQL version 4.1 alpha
PS. Keep up the good work! phpMyAdmin is wonderful and
very useful!
----------------------------------------------------------------------
Comment By: Luc Krols (lukro)
Date: 2003-06-30 15:40
Message:
Logged In: YES
user_id=812446
Follow up: (I logged in this time). When executing the same
query in a mysql client window or via ODBC, it works
perfect. Only when executing the query from within the
phpMyAdmin web interface (2.5.2-dev, 2.5.1) that the error
occurs.
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2003-06-30 10:20
Message:
Logged In: NO
I encounter it only with the MySQL 4.1a db when using
subselects. Other queries work perfect.
This is the query that I used:
SELECT * FROM `fragment`
WHERE f_comment = "Trypsine_P" AND f_seq NOT
IN (
SELECT f_seq
FROM fragment
WHERE f_comment = "Trypsine"
GROUP BY f_seq );
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2003-06-30 10:19
Message:
Logged In: NO
I encounter it only with the MySQL 4.1a db when using
subselects. Other queries work perfect.
This is the query that I used:
SELECT * FROM `fragment`
WHERE f_comment = "Trypsine_P" AND f_seq NOT
IN (
SELECT f_seq
FROM fragment
WHERE f_comment = "Trypsine"
GROUP BY f_seq );
----------------------------------------------------------------------
Comment By: Alexander M. Turek (rabus)
Date: 2003-06-28 09:01
Message:
Logged In: YES
user_id=418833
Could you give me an example query that fails? Or does every
subquery fail? Does it work correctly with "normal" queries?
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=377408&aid=762213&group_id=23067