limit bug (with order by)

I think I found a bug, and it might be related to the limit bug already
submitted by Saulius Gurklys. This one with with "order by".

I have a query that joins three tables, it returns three rows. However
if I impost a limit (say 10), it returns none. If I remove the "order
by" clause, it works OK with the limit.


How-to-repeat:

I uploaded a test case to:

ftp://support.mysql.com/pub/mysql/secret/limit_order_bug_404 .tar.gz

Thanks!
Monte



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12732@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Monte Ohrt writes:
> I think I found a bug, and it might be related to the limit bug already
> submitted by Saulius Gurklys. This one with with "order by".
>
> I have a query that joins three tables, it returns three rows. However
> if I impost a limit (say 10), it returns none. If I remove the "order
> by" clause, it works OK with the limit.
>
>
> How-to-repeat:
>
> I uploaded a test case to:
>
> ftp://support.mysql.com/pub/mysql/secret/limit_order_bug_404 .tar.gz
>
> Thanks!
> Monte

A fix for limit bug is pushed already in our BK 4.0 repository.

Can you please first try if our latest source fixes your bug too ??

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12737@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Sinisa Milivojevic wrote:
> Monte Ohrt writes:
>
>>I think I found a bug, and it might be related to the limit bug already
>>submitted by Saulius Gurklys. This one with with "order by".
>>
>>I have a query that joins three tables, it returns three rows. However
>>if I impost a limit (say 10), it returns none. If I remove the "order
>>by" clause, it works OK with the limit.
>>
>>
>>How-to-repeat:
>>
>>I uploaded a test case to:
>>
>>ftp://support.mysql.com/pub/mysql/secret/limit_order_bug_4 04.tar.gz
>>
>>Thanks!
>>Monte
>
>
> A fix for limit bug is pushed already in our BK 4.0 repository.
>
> Can you please first try if our latest source fixes your bug too ??
>

Sure thing, I'll let you know!

Monte


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12740@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Sorry, I haven't used BitKeeper before, what does this mean?

..
..
..
Obsolete LOD data (chk4): ChangeSet|2.2
Obsolete LOD data (chk4): ChangeSet|2.1
Obsolete LOD data (chk4): BitKeeper/etc/logging_ok|2.4
Obsolete LOD data (chk4): BitKeeper/etc/logging_ok|2.3
Obsolete LOD data (chk4): BitKeeper/etc/logging_ok|2.2
Obsolete LOD data (chk4): BitKeeper/etc/logging_ok|2.1
Obsolete LOD data (chk4): scripts/mysqld_safe.sh|2.1
Warning: running BitKeeper as root is not a good idea!
Set the BK_USER environment variable to your real user name.
Consistency check failed, repository left locked.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Does that mean there was a problem?
Monte

Sinisa Milivojevic wrote:
> Monte Ohrt writes:
>
>>I think I found a bug, and it might be related to the limit bug already
>>submitted by Saulius Gurklys. This one with with "order by".
>>
>>I have a query that joins three tables, it returns three rows. However
>>if I impost a limit (say 10), it returns none. If I remove the "order
>>by" clause, it works OK with the limit.
>>
>>
>>How-to-repeat:
>>
>>I uploaded a test case to:
>>
>>ftp://support.mysql.com/pub/mysql/secret/limit_order_bug_4 04.tar.gz
>>
>>Thanks!
>>Monte
>
>
> A fix for limit bug is pushed already in our BK 4.0 repository.
>
> Can you please first try if our latest source fixes your bug too ??
>


--
Monte Ohrt
Director of Technology, ispi Inc.


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12743@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

compile errors with BK, not sure if I should post this to the bugs list
or elsewhere?

checking for Innodb... Using Innodb
checking for aio_read in -lrt... yes
CONFIGURING FOR INNODB
sh: .././innobase/configure: not found
configure: error: could not configure INNODB

This is sparc solaris.

Thanks
Monte


Sinisa Milivojevic wrote:
> Monte Ohrt writes:
>
>>I think I found a bug, and it might be related to the limit bug already
>>submitted by Saulius Gurklys. This one with with "order by".
>>
>>I have a query that joins three tables, it returns three rows. However
>>if I impost a limit (say 10), it returns none. If I remove the "order
>>by" clause, it works OK with the limit.
>>
>>
>>How-to-repeat:
>>
>>I uploaded a test case to:
>>
>>ftp://support.mysql.com/pub/mysql/secret/limit_order_bug_4 04.tar.gz
>>
>>Thanks!
>>Monte
>
>
> A fix for limit bug is pushed already in our BK 4.0 repository.
>
> Can you please first try if our latest source fixes your bug too ??
>



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12744@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Hi,

You had to download bitkeeper 2.x because MySQL bk tree is not yet
compatible with 3.x version of bitkeeper.

Regards,
Jocelyn
----- Original Message -----
From: "Monte Ohrt"
To:
Cc:
Sent: Tuesday, October 15, 2002 9:50 PM
Subject: Re: limit bug (with order by)


> Sorry, I haven't used BitKeeper before, what does this mean?
>
> .
> .
> .
> Obsolete LOD data (chk4): ChangeSet|2.2
> Obsolete LOD data (chk4): ChangeSet|2.1
> Obsolete LOD data (chk4): BitKeeper/etc/logging_ok|2.4
> Obsolete LOD data (chk4): BitKeeper/etc/logging_ok|2.3
> Obsolete LOD data (chk4): BitKeeper/etc/logging_ok|2.2
> Obsolete LOD data (chk4): BitKeeper/etc/logging_ok|2.1
> Obsolete LOD data (chk4): scripts/mysqld_safe.sh|2.1
> Warning: running BitKeeper as root is not a good idea!
> Set the BK_USER environment variable to your real user name.
> Consistency check failed, repository left locked.
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
> Does that mean there was a problem?
> Monte
>
> Sinisa Milivojevic wrote:
> > Monte Ohrt writes:
> >
> >>I think I found a bug, and it might be related to the limit bug already
> >>submitted by Saulius Gurklys. This one with with "order by".
> >>
> >>I have a query that joins three tables, it returns three rows. However
> >>if I impost a limit (say 10), it returns none. If I remove the "order
> >>by" clause, it works OK with the limit.
> >>
> >>
> >>How-to-repeat:
> >>
> >>I uploaded a test case to:
> >>
> >>ftp://support.mysql.com/pub/mysql/secret/limit_order_bug_4 04.tar.gz
> >>
> >>Thanks!
> >>Monte
> >
> >
> > A fix for limit bug is pushed already in our BK 4.0 repository.
> >
> > Can you please first try if our latest source fixes your bug too ??
> >
>
>
> --
> Monte Ohrt
> Director of Technology, ispi Inc.
>
>
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail bugs-thread12743@lists.mysql.com
> To unsubscribe, e-mail
>
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12745@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Monte Ohrt writes:
> compile errors with BK, not sure if I should post this to the bugs list
> or elsewhere?
>
> checking for Innodb... Using Innodb
> checking for aio_read in -lrt... yes
> CONFIGURING FOR INNODB
> sh: .././innobase/configure: not found
> configure: error: could not configure INNODB
>
> This is sparc solaris.
>
> Thanks
> Monte
>
>

Please use compile-pentium-debug-max script from BUILD directory.

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12748@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

I compiled the BK repository version of mysql (Ver 12.16 Distrib
4.0.5-beta), it does NOT fix the limit bug addressed below.

Monte

Sinisa Milivojevic wrote:
> Monte Ohrt writes:
>
>>I think I found a bug, and it might be related to the limit bug already
>>submitted by Saulius Gurklys. This one with with "order by".
>>
>>I have a query that joins three tables, it returns three rows. However
>>if I impost a limit (say 10), it returns none. If I remove the "order
>>by" clause, it works OK with the limit.
>>
>>
>>How-to-repeat:
>>
>>I uploaded a test case to:
>>
>>ftp://support.mysql.com/pub/mysql/secret/limit_order_bug_4 04.tar.gz
>>
>>Thanks!
>>Monte
>
>
> A fix for limit bug is pushed already in our BK 4.0 repository.
>
> Can you please first try if our latest source fixes your bug too ??
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12749@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Hi!

>>>>> "Monte" == Monte Ohrt writes:

Monte> compile errors with BK, not sure if I should post this to the bugs list
Monte> or elsewhere?

Monte> checking for Innodb... Using Innodb
Monte> checking for aio_read in -lrt... yes
Monte> CONFIGURING FOR INNODB
Monte> sh: .././innobase/configure: not found
Monte> configure: error: could not configure INNODB

Monte> This is sparc solaris.

Try the 'BUILD/compile-solaris-sparc' script.

The problem is that you didn't do:

(cd innobase && aclocal && autoheader && aclocal && automake && autoconf)


Regards,
Monty

--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12750@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Monte Ohrt writes:
> I compiled the BK repository version of mysql (Ver 12.16 Distrib
> 4.0.5-beta), it does NOT fix the limit bug addressed below.
>
> Monte
>

Please post the exact queries, with and without limit ...

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12752@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

The second query should not return an empty set. The first and third
queries work fine. It seems to break when using LIMIT in combination
with ORDER BY.

mysql> select DisplayMode from CATEGORY, LISTING_CATEGORY, LISTING where
CATEGORY.CategoryID = 'c8c2d8' and LISTING_CATEGORY.ID = CATEGORY.ID and
LISTING.ListingID = LISTING_CATEGORY.ListingID and LISTING.Status =
'ACTIVE' order by DisplayMode;
+-------------+
| DisplayMode |
+-------------+
| BASIC |
| BASIC |
| BASIC |
+-------------+
3 rows in set (0.01 sec)


mysql> select DisplayMode from CATEGORY, LISTING_CATEGORY, LISTING where
CATEGORY.CategoryID = 'c8c2d8' and LISTING_CATEGORY.ID = CATEGORY.ID and
LISTING.ListingID = LISTING_CATEGORY.ListingID and LISTING.Status =
'ACTIVE' order by DisplayMode limit 10;
Empty set (0.00 sec)

mysql> select DisplayMode from CATEGORY, LISTING_CATEGORY, LISTING where
CATEGORY.CategoryID = 'c8c2d8' and LISTING_CATEGORY.ID = CATEGORY.ID and
LISTING.ListingID = LISTING_CATEGORY.ListingID and LISTING.Status =
'ACTIVE' limit 10;
+-------------+
| DisplayMode |
+-------------+
| BASIC |
| BASIC |
| BASIC |
+-------------+
3 rows in set (0.01 sec)



Sinisa Milivojevic wrote:
> Monte Ohrt writes:
>
>>I compiled the BK repository version of mysql (Ver 12.16 Distrib
>>4.0.5-beta), it does NOT fix the limit bug addressed below.
>>
>>Monte
>>
>
>
> Please post the exact queries, with and without limit ...
>


--
Monte Ohrt
Director of Technology, ispi Inc.


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12753@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Monte Ohrt writes:
> The second query should not return an empty set. The first and third
> queries work fine. It seems to break when using LIMIT in combination
> with ORDER BY.
>

[skip]

> Monte Ohrt
> Director of Technology, ispi Inc.
>

I just checked this with a most recent pull of 4.0 and all three
queries gave identical results.

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12754@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Did you use the db data given in the file that I uploaded? I tried
making a minimal set of data but I couldn't get the error to persist, so
I sent you the complete set of data that this was happening with.

Sinisa Milivojevic wrote:
> Monte Ohrt writes:
>
>>The second query should not return an empty set. The first and third
>>queries work fine. It seems to break when using LIMIT in combination
>>with ORDER BY.
>>
>
>
> [skip]
>
>
>>Monte Ohrt
>>Director of Technology, ispi Inc.
>>
>
>
> I just checked this with a most recent pull of 4.0 and all three
> queries gave identical results.
>


--
Monte Ohrt
Director of Technology, ispi Inc.


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12757@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Monte Ohrt writes:
> Did you use the db data given in the file that I uploaded? I tried
> making a minimal set of data but I couldn't get the error to persist, so
> I sent you the complete set of data that this was happening with.
>
> --
> Monte Ohrt
> Director of Technology, ispi Inc.


Of course.

Do not forget that public reposotiry is cca 24 hours behind our
internal one.

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12758@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

What can I use to tell that I got the latest update? Or if I pull a new
one now from the public repository, will it be up to date for sure?

Sinisa Milivojevic wrote:
> Monte Ohrt writes:
>
>>Did you use the db data given in the file that I uploaded? I tried
>>making a minimal set of data but I couldn't get the error to persist, so
>>I sent you the complete set of data that this was happening with.
>>
>>--
>>Monte Ohrt
>>Director of Technology, ispi Inc.
>
>
>
> Of course.
>
> Do not forget that public reposotiry is cca 24 hours behind our
> internal one.
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12760@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

:-) Can you give me a file name and line number to look for?

Sinisa Milivojevic wrote:
> Monte Ohrt writes:
>
>>What can I use to tell that I got the latest update? Or if I pull a new
>>one now from the public repository, will it be up to date for sure?
>>
>
>
> I truly do not know.
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12763@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Monte Ohrt writes:
> What can I use to tell that I got the latest update? Or if I pull a new
> one now from the public repository, will it be up to date for sure?
>

I truly do not know.

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12762@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Monte Ohrt writes:
> :-) Can you give me a file name and line number to look for?
>

You can see it in commit's in internals@ list ..

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12764@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

It's fixed with this build, thanks!

Monte

Sinisa Milivojevic wrote:
> Monte Ohrt writes:
>
>>:-) Can you give me a file name and line number to look for?
>>
>
>
> You can see it in commit's in internals@ list ..
>


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12767@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Hi!

>>>>> "Monte" == Monte Ohrt writes:

Monte> What can I use to tell that I got the latest update? Or if I pull a new
Monte> one now from the public repository, will it be up to date for sure?

The easy way to do that is to do 'bk sccstool' in the source
repository and check the latest change set that they have a note that
describes a bug fix for the case you are looking after.

Another way is to check the output from:

bk prs ChangeSet | less

In my case I get when I do a search after ORDER BY.

.....

D 1.1284.33.1 02/10/15 16:47:55+03:00 monty@hundin.mysql.fi 5083 5076 00002/0000
0/00001
P ChangeSet
C Fixed bug in ORDER BY ... LIMIT

Regards,
Monty

--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12769@lists.mysql.com
To unsubscribe, e-mail

Re: limit bug (with order by)

Monte Ohrt writes:
> It's fixed with this build, thanks!
>
> Monte
>

You are welcome.

--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12772@lists.mysql.com
To unsubscribe, e-mail