Range Check Error

[expired user #2585]'s profile image [expired user #2585] posted 17 years ago in General Permalink
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?
[expired user #1125]'s profile image [expired user #1125] posted 17 years ago Permalink
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.
[expired user #2585]'s profile image [expired user #2585] posted 17 years ago Permalink
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.
ansgar's profile image ansgar posted 17 years ago Permalink
Using the latest 3.0 final?
[expired user #2688]'s profile image [expired user #2688] posted 17 years ago Permalink
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
ansgar's profile image ansgar posted 17 years ago Permalink

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? :)

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.