Hi,
My license number is 7697. I don't know what the expiration date is. I'm running
3.23.28-gamma msqld-opt under w2k.
I'm trying to use a HEAP table to speed up data access, but every select I do which
references an indexed column gives me:
ERROR 1030: Got error 124 from table handler
Other select statements work. I don't know what this means, and can't find any
documentation on it in the manual. perror says 124 is "wrong index given to function",
which isn't much more helpful.
The heap table is created like this:
DROP TABLE IF EXISTS data_series_heap;
CREATE TABLE data_series_heap TYPE=HEAP select * from data_series;
CREATE INDEX stock_id_index ON data_series_heap(stock_id);
where the original table was created as:
DROP TABLE IF EXISTS data_series;
CREATE TABLE data_series (
id INTEGER PRIMARY KEY AUTO_INCREMENT,
stock_id INTEGER NOT NULL REFERENCES stocks,
data_type ENUM('LTG', 'EPS', 'REC', 'PRC') NOT NULL,
periodicity ENUM('NONE', 'ANN', 'SEM', 'QTR') NOT NULL,
period_y INTEGER,
period_m INTEGER,
unique index(stock_id,data_type,periodicity,period_y,period_m)
);
What's going on?
Thanks,
-David Mechner
