mirror of
https://github.com/MariaDB/server.git
synced 2025-09-28 11:59:12 +02:00
43 lines
1.3 KiB
Text
43 lines
1.3 KiB
Text
DROP TABLE IF EXISTS graph_base;
|
|
DROP TABLE IF EXISTS graph;
|
|
call mtr.add_suppression("graph_base is open on delete");
|
|
CREATE TABLE graph_base (
|
|
from_id INT UNSIGNED NOT NULL,
|
|
to_id INT UNSIGNED NOT NULL,
|
|
PRIMARY KEY (from_id,to_id),
|
|
INDEX (to_id)
|
|
) ENGINE=MyISAM;
|
|
CREATE TABLE graph (
|
|
latch VARCHAR(32) NULL,
|
|
origid BIGINT UNSIGNED NULL,
|
|
destid BIGINT UNSIGNED NULL,
|
|
weight DOUBLE NULL,
|
|
seq BIGINT UNSIGNED NULL,
|
|
linkid BIGINT UNSIGNED NULL,
|
|
KEY (latch, origid, destid) USING HASH,
|
|
KEY (latch, destid, origid) USING HASH
|
|
) ENGINE=OQGRAPH DATA_TABLE='graph_base' ORIGID='from_id', DESTID='to_id';
|
|
INSERT INTO graph_base(from_id, to_id) VALUES (1,2), (2,1);
|
|
INSERT INTO graph_base(from_id, to_id) VALUES (3,2), (2,3);
|
|
INSERT INTO graph_base(from_id, to_id) VALUES (1,3), (3,1);
|
|
insert into graph values (NULL, 1, 2, 3.0, NULL, NULL);
|
|
ERROR HY000: Table 'graph' is read only
|
|
delete from graph;
|
|
ERROR HY000: Table 'graph' is read only
|
|
truncate graph;
|
|
ERROR HY000: Table 'graph' is read only
|
|
update graph set origid=123;
|
|
ERROR HY000: Table 'graph' is read only
|
|
DROP TABLE graph_base;
|
|
DROP TABLE graph;
|
|
#
|
|
# End of 10.0 tests
|
|
#
|
|
#
|
|
# MDEV-25373 DROP TABLE doesn't raise error while dropping non-existing table in MariaDB 10.5.9 when OQGraph SE is loaded to the server
|
|
#
|
|
drop table foobar;
|
|
ERROR 42S02: Unknown table 'test.foobar'
|
|
#
|
|
# End of 10.5 tests
|
|
#
|