diff options
| author | unknown <magnus@neptunus.(none)> | 2004-04-15 12:03:13 +0200 |
|---|---|---|
| committer | unknown <magnus@neptunus.(none)> | 2004-04-15 12:03:13 +0200 |
| commit | 689d0a0ad571ac8185c0df799ac65b8b34f3ea48 (patch) | |
| tree | 78fd0a67df020857c680cdaa6cfc4c98510250db /mysql-test/r | |
| parent | 90cf174529bbdf102890aed3e5f91c09d97b1c72 (diff) | |
| download | mariadb-git-689d0a0ad571ac8185c0df799ac65b8b34f3ea48.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.
mysql-test/install_test_db.sh:
Added --skip-ndb wile installing test db
mysql-test/mysql-test-run.sh:
To enable NDB use --ndbcluster and to disable it --skip-ndbcluster or --skip-ndb
mysql-test/r/ndb_basic.result:
Updated testcase to use all uppercase
mysql-test/t/ndb_basic.test:
Updated testcase to use all uppercase
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/have_ndb.require | 2 | ||||
| -rw-r--r-- | mysql-test/r/ndb_basic.result | 82 |
2 files changed, 84 insertions, 0 deletions
diff --git a/mysql-test/r/have_ndb.require b/mysql-test/r/have_ndb.require new file mode 100644 index 00000000000..f0402b72c6a --- /dev/null +++ b/mysql-test/r/have_ndb.require @@ -0,0 +1,2 @@ +Variable_name Value +have_ndbcluster YES 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; |