diff options
| author | unknown <monty@mashka.mysql.fi> | 2002-12-06 22:49:16 +0200 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2002-12-06 22:49:16 +0200 |
| commit | 74f2250839a552d8acd68c3456e9240f5e36f1e4 (patch) | |
| tree | f60fd431bb804b5add23cd9dd5b6efb5af3f243c /mysql-test/r/multi_update.result | |
| parent | d5b77c0a8e320d91ca1f7a8de139b7cdd373399a (diff) | |
| download | mariadb-git-74f2250839a552d8acd68c3456e9240f5e36f1e4.tar.gz | |
Don't initialize fulltext functions twice in multi-table-update
mysql-test/mysql-test-run.sh:
Added option --extern (from 4.1)
mysql-test/r/multi_update.result:
Portability fix
mysql-test/t/multi_update.test:
Portability fix
Diffstat (limited to 'mysql-test/r/multi_update.result')
| -rw-r--r-- | mysql-test/r/multi_update.result | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result index 7d1f5bd53f6..8cf035343b1 100644 --- a/mysql-test/r/multi_update.result +++ b/mysql-test/r/multi_update.result @@ -182,13 +182,13 @@ insert into t1 values(1,1,NULL); insert into t2 values(1,10,NULL),(2,20,NULL); set timestamp=1038000000; UPDATE t1,t2 SET t1.d=t2.d WHERE t1.n=t2.n; -select * from t1; -n d t -1 10 20021123002000 -select * from t2; -n d t -1 10 20021127154957 -2 20 20021127154957 +select n,d,unix_timestamp(t) from t1; +n d unix_timestamp(t) +1 10 1038000000 +select n,d,unix_timestamp(t) from t2; +n d unix_timestamp(t) +1 10 1038401397 +2 20 1038401397 UPDATE t1,t2 SET 1=2 WHERE t1.n=t2.n; You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '1=2 WHERE t1.n=t2.n' at line 1 drop table t1,t2; |