distal-attribute
distal-attribute
distal-attribute
distal-attribute

Range Check Error

whitegold posted 7 years ago in General
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?
rosenfield posted 7 years ago
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.
whitegold posted 7 years ago
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 posted 7 years ago
Using the latest 3.0 final?
thalaion posted 7 years ago
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 posted 7 years ago

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.