View Rows

--part1_3b.391f9cc0.2c12345a_boundary
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

When trying to view and edit rows in a table in 0.9.2-beta Control Center,
all I get is the following message and a blank editing window:

[arty] ERROR 1104: The SELECT would examine more rows than MAX_JOIN_SIZE.
Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the
SELECT is ok

This only happens when there is more than one row.

I have no idea what to do about this, but it could be a bug so I thought i'd
better report it.

Thanks,
Josh Harrison

--part1_3b.391f9cc0.2c12345a_boundary--

Re: View Rows

BirchamGal@aol.com writes:
> When trying to view and edit rows in a table in 0.9.2-beta Control Center,
> all I get is the following message and a blank editing window:
>
> [arty] ERROR 1104: The SELECT would examine more rows than MAX_JOIN_SIZE.
> Check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the
> SELECT is ok
>
> This only happens when there is more than one row.
>
> I have no idea what to do about this, but it could be a bug so I thought i'd
> better report it.
>
> Thanks,
> Josh Harrison

It is quite possible that this is not MySQLCC bug.

Can you run the same query from mysql program and see whether you get
the same message ???

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: View Rows

Hi,

> When trying to view and edit rows in a table in 0.9.2-beta Control Center=
,
> all I get is the following message and a blank editing window:
>=20
> [arty] ERROR 1104: The SELECT would examine more rows than MAX_JOIN_SIZE.
> Check your WHERE and use SET SQL_BIG_SELECTS=3D1 or SET SQL_MAX_JOIN_SIZE=3D#=
if
> the=20
> SELECT is ok
>=20
> This only happens when there is more than one row.
>=20
> I have no idea what to do about this, but it could be a bug so I thought =
i'd
> better report it.

Yes, it's a known bug in 0.9.2 and will be fixed in the upcoming 0.9.3
release.

The problem is that the values above default to a too low value. To fix
this, edit your server connection and in the "MySQL Options" tab, set a
reasonable value for "Automatically limit SELECT queries to" and set the
value for "Maximum Join Size" to 1000000. That should fix these problems.


Rgds,
Indrek

--=20
Are you MySQL certified? - http://www.mysql.com/certification/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Indrek Siitan
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Support Guy
/_/ /_/\_, /___/\___\_\___/ Uuem=F5isa, Haapsalu, Estonia
<___/ www.mysql.com


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org