diff options
author | unknown <mskold@mysql.com> | 2005-04-21 10:26:14 +0200 |
---|---|---|
committer | unknown <mskold@mysql.com> | 2005-04-21 10:26:14 +0200 |
commit | c1e0972879af796a99f006a6b3b24189acb28af4 (patch) | |
tree | 83a1e9e362286201358b569d0879fa9db6c2f99b /mysql-test | |
parent | f79344100a3c1fc0b53ae4d821805060f8309dd3 (diff) | |
parent | 7f0f4c5875a1b62ecf5467253c1a038c88625ecd (diff) | |
download | mariadb-git-c1e0972879af796a99f006a6b3b24189acb28af4.tar.gz |
Merge
mysql-test/t/ndb_alter_table.test:
Auto merged
mysql-test/t/ndb_autodiscover.test:
Auto merged
mysql-test/t/ndb_basic.test:
Auto merged
mysql-test/t/ndb_cache.test:
Auto merged
mysql-test/t/ndb_charset.test:
Auto merged
mysql-test/t/ndb_index_ordered.test:
Auto merged
mysql-test/t/ndb_index_unique.test:
Auto merged
mysql-test/t/ndb_types.test:
Auto merged
ndb/src/kernel/blocks/dbtc/DbtcMain.cpp:
Auto merged
ndb/src/ndbapi/TransporterFacade.cpp:
Auto merged
sql/ha_ndbcluster.cc:
Auto merged
sql/sql_select.cc:
Auto merged
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/t/ndb_alter_table.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_autodiscover.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_autodiscover2.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_basic.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_blob.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_cache.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_charset.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_index.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_index_ordered.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_index_unique.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_insert.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_limit.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_lock.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_minmax.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_multi.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_replace.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_restore.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_subquery.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_transaction.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_truncate.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_types.test | 1 | ||||
-rw-r--r-- | mysql-test/t/ndb_update.test | 16 |
22 files changed, 34 insertions, 3 deletions
diff --git a/mysql-test/t/ndb_alter_table.test b/mysql-test/t/ndb_alter_table.test index 18c7ff47b18..1e5c31da98e 100644 --- a/mysql-test/t/ndb_alter_table.test +++ b/mysql-test/t/ndb_alter_table.test @@ -1,5 +1,6 @@ -- source include/have_ndb.inc -- source include/have_multi_ndb.inc +-- source include/not_embedded.inc --disable_warnings DROP TABLE IF EXISTS t1; diff --git a/mysql-test/t/ndb_autodiscover.test b/mysql-test/t/ndb_autodiscover.test index 211d8344471..80f6f3f35d3 100644 --- a/mysql-test/t/ndb_autodiscover.test +++ b/mysql-test/t/ndb_autodiscover.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9,t10; diff --git a/mysql-test/t/ndb_autodiscover2.test b/mysql-test/t/ndb_autodiscover2.test index 11e1cc204f7..76baa31a2a9 100644 --- a/mysql-test/t/ndb_autodiscover2.test +++ b/mysql-test/t/ndb_autodiscover2.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc # # Simple test to show use of discover when the server has been restarted diff --git a/mysql-test/t/ndb_basic.test b/mysql-test/t/ndb_basic.test index 5dfc2d5ec58..051a95ca42a 100644 --- a/mysql-test/t/ndb_basic.test +++ b/mysql-test/t/ndb_basic.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7; diff --git a/mysql-test/t/ndb_blob.test b/mysql-test/t/ndb_blob.test index 96e38bfb58e..b265809b75f 100644 --- a/mysql-test/t/ndb_blob.test +++ b/mysql-test/t/ndb_blob.test @@ -1,4 +1,5 @@ --source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings drop table if exists t1; diff --git a/mysql-test/t/ndb_cache.test b/mysql-test/t/ndb_cache.test index e899e94e4ac..b61422a58fb 100644 --- a/mysql-test/t/ndb_cache.test +++ b/mysql-test/t/ndb_cache.test @@ -1,5 +1,6 @@ -- source include/have_query_cache.inc -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings drop table if exists t1; diff --git a/mysql-test/t/ndb_charset.test b/mysql-test/t/ndb_charset.test index 6a191636f1e..becbe9a4d06 100644 --- a/mysql-test/t/ndb_charset.test +++ b/mysql-test/t/ndb_charset.test @@ -1,4 +1,5 @@ --source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings drop table if exists t1; diff --git a/mysql-test/t/ndb_index.test b/mysql-test/t/ndb_index.test index e65b24a9b20..93085dea587 100644 --- a/mysql-test/t/ndb_index.test +++ b/mysql-test/t/ndb_index.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings drop table if exists t1; diff --git a/mysql-test/t/ndb_index_ordered.test b/mysql-test/t/ndb_index_ordered.test index 2ebf06b78a8..9c9d5d5a84f 100644 --- a/mysql-test/t/ndb_index_ordered.test +++ b/mysql-test/t/ndb_index_ordered.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings drop table if exists t1, test1, test2; diff --git a/mysql-test/t/ndb_index_unique.test b/mysql-test/t/ndb_index_unique.test index 6714f0233cf..d6de013c1e2 100644 --- a/mysql-test/t/ndb_index_unique.test +++ b/mysql-test/t/ndb_index_unique.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings drop table if exists t1, t2, t3, t4, t5, t6, t7, t8; diff --git a/mysql-test/t/ndb_insert.test b/mysql-test/t/ndb_insert.test index 611df3d84e9..f88d33f22f4 100644 --- a/mysql-test/t/ndb_insert.test +++ b/mysql-test/t/ndb_insert.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings DROP TABLE IF EXISTS t1; diff --git a/mysql-test/t/ndb_limit.test b/mysql-test/t/ndb_limit.test index c2d7a0ecfec..0df3b2f7566 100644 --- a/mysql-test/t/ndb_limit.test +++ b/mysql-test/t/ndb_limit.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings DROP TABLE IF EXISTS t2; diff --git a/mysql-test/t/ndb_lock.test b/mysql-test/t/ndb_lock.test index 39a8655b972..b93abbd564b 100644 --- a/mysql-test/t/ndb_lock.test +++ b/mysql-test/t/ndb_lock.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc connect (con1,localhost,root,,); connect (con2,localhost,root,,); diff --git a/mysql-test/t/ndb_minmax.test b/mysql-test/t/ndb_minmax.test index 3be193ce602..97ea84f98ef 100644 --- a/mysql-test/t/ndb_minmax.test +++ b/mysql-test/t/ndb_minmax.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings drop table if exists t1, t2; diff --git a/mysql-test/t/ndb_multi.test b/mysql-test/t/ndb_multi.test index 27ddd6508e9..24651913a79 100644 --- a/mysql-test/t/ndb_multi.test +++ b/mysql-test/t/ndb_multi.test @@ -1,5 +1,6 @@ -- source include/have_ndb.inc -- source include/have_multi_ndb.inc +-- source include/not_embedded.inc --disable_warnings diff --git a/mysql-test/t/ndb_replace.test b/mysql-test/t/ndb_replace.test index 59454b5a9fa..1c06a9a6633 100644 --- a/mysql-test/t/ndb_replace.test +++ b/mysql-test/t/ndb_replace.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc # # Test of REPLACE with NDB diff --git a/mysql-test/t/ndb_restore.test b/mysql-test/t/ndb_restore.test index d084461f9be..e3191538a22 100644 --- a/mysql-test/t/ndb_restore.test +++ b/mysql-test/t/ndb_restore.test @@ -1,5 +1,6 @@ -- source include/have_ndb.inc -- source include/ndb_default_cluster.inc +-- source include/not_embedded.inc --disable_warnings use test; diff --git a/mysql-test/t/ndb_subquery.test b/mysql-test/t/ndb_subquery.test index cebc1920eaa..9d3a256a263 100644 --- a/mysql-test/t/ndb_subquery.test +++ b/mysql-test/t/ndb_subquery.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings drop table if exists t1; diff --git a/mysql-test/t/ndb_transaction.test b/mysql-test/t/ndb_transaction.test index f8ed22207ea..ae02059786d 100644 --- a/mysql-test/t/ndb_transaction.test +++ b/mysql-test/t/ndb_transaction.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7; diff --git a/mysql-test/t/ndb_truncate.test b/mysql-test/t/ndb_truncate.test index 63bb8cbefb6..7c0f79bcc59 100644 --- a/mysql-test/t/ndb_truncate.test +++ b/mysql-test/t/ndb_truncate.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings DROP TABLE IF EXISTS t2; diff --git a/mysql-test/t/ndb_types.test b/mysql-test/t/ndb_types.test index 823ca942d57..d4bf4133807 100644 --- a/mysql-test/t/ndb_types.test +++ b/mysql-test/t/ndb_types.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings DROP TABLE IF EXISTS t1; diff --git a/mysql-test/t/ndb_update.test b/mysql-test/t/ndb_update.test index 05b12561ca8..5453e41f937 100644 --- a/mysql-test/t/ndb_update.test +++ b/mysql-test/t/ndb_update.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/not_embedded.inc --disable_warnings DROP TABLE IF EXISTS t1; @@ -14,11 +15,20 @@ DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, - c INT NOT NULL + c INT NOT NULL UNIQUE ) ENGINE=ndbcluster; -INSERT INTO t1 VALUES (0, 0, 1),(1,1,2),(2,2,3); +INSERT INTO t1 VALUES (0, 1, 0),(1,2,1),(2,3,2); UPDATE t1 set b = c; select * from t1 order by pk1; +UPDATE t1 set pk1 = 4 where pk1 = 1; +select * from t1 order by pk1; +-- error 1062 +UPDATE t1 set pk1 = 1, c = 2 where pk1 = 4; +select * from t1 order by pk1; +UPDATE t1 set pk1 = pk1 + 10; +select * from t1 order by pk1; -drop table t1; +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings |