Range Check Error

User, date Message
Written by whitegold
6 years ago
Category: General
2 posts since Tue, 05 Jun 07 		I just downloaded the HeidiSQL software, with great enthusiasm as I used to use MYSQL-Front back in the day.

However, every time I try to run a query I get "Range check error". Unfortunately this makes the software relatively useless, as its main purpose is testing and checking queries.

Initially I thought the query itself might be at fault, as it was quite complex. But I ended up with literally "SELECT id FROM events" and still got a range check error. (There are two records in that table, so it's not an overloading issue.)

I did notice a bug report mentioning this, and have commented on it, though that suggested an error only under limited conditions.

It would appear that this affects only me, or there would be more commentary on it?
Written by rosenfield
6 years ago
127 posts since Wed, 24 Jan 07 		Sounds like a new issue. Probably unrelated to the bug report you found, except that this may too be a bug residing in Zeos - who knows..

How about all the internal queries that HeidiSQL executes? Like SELECT VERSION() etc at startup, do those succeed?

It would be helpful if you could open a new bug report, and include the entire SQL log from program startup to failed query execution.
Written by whitegold
6 years ago
2 posts since Tue, 05 Jun 07 		My thanks. I'll look into that.

And no, by the way. All internal functions appear to be unaffected. Browsing, inserting, table displays, etc. All works perfectly. The ONLY thing affected is direct SQL Query execution, but that's affected completely.

Regarding the log you referred to I don't believe that will be of any help. There are no errors of any kind in it.
Written by ansgar
6 years ago
3975 posts since Fri, 07 Apr 06 		Using the latest 3.0 final?
Written by thalaion
6 years ago
1 posts since Wed, 13 Jun 07 		Jepp, just downloaded it again (to be sure)...

Discription:
It didnt happen some queries before...
... i played with the data-tab and the limit form at the top.

Now i cant execute my queries any longer:
select * from DB.mytable limit 100;
results in "Range Check Error"

Table has >100000 entries...
SQL Output:
/* Connection established with host "10.30.42.254" on port 3306 */
/* Connection-ID: 6557 */
SELECT VERSION()
SET NAMES latin1
SHOW VARIABLES
SHOW /*!50002 GLOBAL */ STATUS
SHOW FULL PROCESSLIST
SHOW DATABASES
SHOW TABLES FROM `DB`
SHOW ENGINES
SHOW DATABASES
USE `DB`
SHOW TABLE STATUS
SHOW COLUMNS FROM `DB`
/* SQL Error: Table 'DB.DB' doesn't exist */
select * from DB.mytable limit 100
SHOW TABLES LIKE 'mytable'
SHOW COLUMNS FROM `DB`.`mytable` LIKE '%'
/* Range check error */

... ok thats all,
regards thalaion
Written by ansgar
6 years ago
3975 posts since Fri, 07 Apr 06

thalaion wrote: USE `DB`
SHOW TABLE STATUS
SHOW COLUMNS FROM `DB`
/* SQL Error: Table 'DB.DB' doesn't exist */



Here we have it. I gues the above error is the reason why the following queries fail. So the log is quite helpful, isn't it? :)

thalaion wrote: select * from DB.mytable limit 100
SHOW TABLES LIKE 'mytable'
SHOW COLUMNS FROM `DB`.`mytable` LIKE '%'
/* Range check error */



Indeed the first error seems to crash something in the ZEOS library.

However, the log looks a bit odd, as it says you're trying to show a non existing table called "DB" in a database also called "DB". Is that correct?
 

Please login to leave a reply, or register at first.