mirror of
https://github.com/MariaDB/server.git
synced 2025-04-26 17:09:57 +02:00
49ca12a107
Remove memory warnings if mysql client aborts early Changed copyright for clients client/mysql.cc: Free memory if get_options fails, so that we don't get warnings from safemalloc include/welcome_copyright_notice.h: Added SkySQL to client copyrights mysql-test/valgrind.supp: Added suppressions for memory leaks from dlopen() for OpenSUSE 12.3 storage/oqgraph/mysql-test/oqgraph/regression_mdev5744.result: Suppress warning storage/oqgraph/mysql-test/oqgraph/regression_mdev5744.test: Suppress warning
42 lines
1.3 KiB
Text
42 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);
|
|
SET @query_cache_size.saved = @@query_cache_size;
|
|
SET GLOBAL query_cache_size = 1024*1024;
|
|
SELECT * FROM graph;
|
|
latch origid destid weight seq linkid
|
|
NULL 1 2 1 NULL NULL
|
|
NULL 2 1 1 NULL NULL
|
|
UPDATE graph_base SET to_id = 20 WHERE from_id = 1;
|
|
SELECT * FROM graph;
|
|
latch origid destid weight seq linkid
|
|
NULL 1 20 1 NULL NULL
|
|
NULL 2 1 1 NULL NULL
|
|
SELECT SQL_NO_CACHE * FROM graph;
|
|
latch origid destid weight seq linkid
|
|
NULL 1 20 1 NULL NULL
|
|
NULL 2 1 1 NULL NULL
|
|
SET GLOBAL query_cache_size = 0;
|
|
SELECT SQL_NO_CACHE * FROM graph;
|
|
latch origid destid weight seq linkid
|
|
NULL 1 20 1 NULL NULL
|
|
NULL 2 1 1 NULL NULL
|
|
DROP TABLE graph_base, graph;
|
|
SET GLOBAL query_cache_size = @query_cache_size.saved;
|