diff options
| author | magnus@neptunus.(none) <> | 2004-04-15 12:03:13 +0200 |
|---|---|---|
| committer | magnus@neptunus.(none) <> | 2004-04-15 12:03:13 +0200 |
| commit | 855fcf1411679119196a8876035999608c90128f (patch) | |
| tree | 78fd0a67df020857c680cdaa6cfc4c98510250db /mysql-test/r/ndb_basic.result | |
| parent | 88478c28b1ebf6b02f7fb23e4fc37e10e7637857 (diff) | |
| download | mariadb-git-855fcf1411679119196a8876035999608c90128f.tar.gz | |
Updated mysql-test-run to work with the started NDB Cluster
Added one test case for ndb to mysql-test-run, ndb_basic. It will show that
NDB Cluster is supported.
Diffstat (limited to 'mysql-test/r/ndb_basic.result')
| -rw-r--r-- | mysql-test/r/ndb_basic.result | 82 |
1 files changed, 82 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_basic.result b/mysql-test/r/ndb_basic.result new file mode 100644 index 00000000000..ac550937146 --- /dev/null +++ b/mysql-test/r/ndb_basic.result @@ -0,0 +1,82 @@ +DROP TABLE IF EXISTS t1; +CREATE TABLE t1 ( +pk1 INT NOT NULL PRIMARY KEY, +attr1 INT NOT NULL +) ENGINE=ndbcluster; +INSERT INTO t1 VALUES (9410,9412); +SELECT pk1 FROM t1; +pk1 +9410 +SELECT * FROM t1; +pk1 attr1 +9410 9412 +SELECT t1.* FROM t1; +pk1 attr1 +9410 9412 +UPDATE t1 SET attr1=1 WHERE pk1=9410; +SELECT * FROM t1; +pk1 attr1 +9410 1 +UPDATE t1 SET pk1=2 WHERE attr1=1; +ERROR 42000: Table 't1' uses an extension that doesn't exist in this MySQL version +SELECT * FROM t1; +pk1 attr1 +9410 1 +DELETE FROM t1; +SELECT * FROM t1; +pk1 attr1 +INSERT INTO t1 VALUES (9410,9412); +DELETE FROM t1 WHERE pk1 = 9410; +SELECT * FROM t1; +pk1 attr1 +INSERT INTO t1 VALUES (9410,9412), (9411, 9413), (9408, 8765); +DELETE FROM t1; +SELECT * FROM t1; +pk1 attr1 +INSERT INTO t1 values (1, 4), (2, 4), (3, 5), (4, 4), (5, 5); +DELETE FROM t1 WHERE attr1=4; +SELECT * FROM t1 order by pk1; +pk1 attr1 +3 5 +5 5 +DELETE FROM t1; +INSERT INTO t1 VALUES (9410,9412), (9411, 9413); +DELETE FROM t1 WHERE pk1 = 9410; +SELECT * FROM t1; +pk1 attr1 +9411 9413 +DROP TABLE t1; +CREATE TABLE t1 (id INT, id2 int) engine=ndbcluster; +INSERT INTO t1 values(3456, 7890); +SELECT * FROM t1; +id id2 +3456 7890 +UPDATE t1 SET id=2 WHERE id2=12; +SELECT * FROM t1; +id id2 +3456 7890 +UPDATE t1 SET id=1234 WHERE id2=7890; +SELECT * FROM t1; +id id2 +1234 7890 +DELETE FROM t1; +INSERT INTO t1 values(3456, 7890), (3456, 7890), (3456, 7890); +SELECT * FROM t1; +id id2 +3456 7890 +3456 7890 +3456 7890 +DELETE FROM t1 WHERE id = 3456; +DROP TABLE t1; +CREATE TABLE t1 ( +pk1 INT NOT NULL PRIMARY KEY, +attr1 INT NOT NULL +) ENGINE=NDBCLUSTER; +INSERT INTO t1 values(1, 9999); +DROP TABLE t1; +CREATE TABLE t1 ( +pk1 INT NOT NULL PRIMARY KEY, +attr1 INT NOT NULL +) ENGINE=NDB; +INSERT INTO t1 values(1, 9999); +DROP TABLE t1; |