diff options
| author | unknown <tomas@poseidon.ndb.mysql.com> | 2004-10-07 09:51:30 +0000 |
|---|---|---|
| committer | unknown <tomas@poseidon.ndb.mysql.com> | 2004-10-07 09:51:30 +0000 |
| commit | 1d7ae13349e60cb04c952ba6e5ccf9bb99928659 (patch) | |
| tree | c6f6140081e6c3d36e760c2410e13ff7f32e85ee /mysql-test/r | |
| parent | d8a0fbafc175c92220d8ca42978853c3db4346f4 (diff) | |
| download | mariadb-git-1d7ae13349e60cb04c952ba6e5ccf9bb99928659.tar.gz | |
more order by for ndb
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/ps_2myisam.result | 2 | ||||
| -rw-r--r-- | mysql-test/r/ps_3innodb.result | 2 | ||||
| -rw-r--r-- | mysql-test/r/ps_4heap.result | 2 | ||||
| -rw-r--r-- | mysql-test/r/ps_5merge.result | 4 | ||||
| -rw-r--r-- | mysql-test/r/ps_6bdb.result | 2 | ||||
| -rw-r--r-- | mysql-test/r/ps_7ndb.result | 4 |
6 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/r/ps_2myisam.result b/mysql-test/r/ps_2myisam.result index a6c2c65a25e..63463baabfd 100644 --- a/mysql-test/r/ps_2myisam.result +++ b/mysql-test/r/ps_2myisam.result @@ -439,7 +439,7 @@ set @arg00=0 ; execute stmt1 using @arg00; ERROR 42S22: Unknown column '?' in 'order clause' set @arg00=1; -prepare stmt1 from ' select a,b from t1 +prepare stmt1 from ' select a,b from t1 order by a limit 1 '; execute stmt1 ; a b diff --git a/mysql-test/r/ps_3innodb.result b/mysql-test/r/ps_3innodb.result index ebba84f1a6c..70ba4a109d7 100644 --- a/mysql-test/r/ps_3innodb.result +++ b/mysql-test/r/ps_3innodb.result @@ -439,7 +439,7 @@ set @arg00=0 ; execute stmt1 using @arg00; ERROR 42S22: Unknown column '?' in 'order clause' set @arg00=1; -prepare stmt1 from ' select a,b from t1 +prepare stmt1 from ' select a,b from t1 order by a limit 1 '; execute stmt1 ; a b diff --git a/mysql-test/r/ps_4heap.result b/mysql-test/r/ps_4heap.result index f82fc1a8312..4c68f0c8593 100644 --- a/mysql-test/r/ps_4heap.result +++ b/mysql-test/r/ps_4heap.result @@ -440,7 +440,7 @@ set @arg00=0 ; execute stmt1 using @arg00; ERROR 42S22: Unknown column '?' in 'order clause' set @arg00=1; -prepare stmt1 from ' select a,b from t1 +prepare stmt1 from ' select a,b from t1 order by a limit 1 '; execute stmt1 ; a b diff --git a/mysql-test/r/ps_5merge.result b/mysql-test/r/ps_5merge.result index 86f0fe874fd..af5d08d5eb4 100644 --- a/mysql-test/r/ps_5merge.result +++ b/mysql-test/r/ps_5merge.result @@ -482,7 +482,7 @@ set @arg00=0 ; execute stmt1 using @arg00; ERROR 42S22: Unknown column '?' in 'order clause' set @arg00=1; -prepare stmt1 from ' select a,b from t1 +prepare stmt1 from ' select a,b from t1 order by a limit 1 '; execute stmt1 ; a b @@ -3490,7 +3490,7 @@ set @arg00=0 ; execute stmt1 using @arg00; ERROR 42S22: Unknown column '?' in 'order clause' set @arg00=1; -prepare stmt1 from ' select a,b from t1 +prepare stmt1 from ' select a,b from t1 order by a limit 1 '; execute stmt1 ; a b diff --git a/mysql-test/r/ps_6bdb.result b/mysql-test/r/ps_6bdb.result index 0982baccd6a..75358bd201b 100644 --- a/mysql-test/r/ps_6bdb.result +++ b/mysql-test/r/ps_6bdb.result @@ -439,7 +439,7 @@ set @arg00=0 ; execute stmt1 using @arg00; ERROR 42S22: Unknown column '?' in 'order clause' set @arg00=1; -prepare stmt1 from ' select a,b from t1 +prepare stmt1 from ' select a,b from t1 order by a limit 1 '; execute stmt1 ; a b diff --git a/mysql-test/r/ps_7ndb.result b/mysql-test/r/ps_7ndb.result index e274329388c..e33bbd7002c 100644 --- a/mysql-test/r/ps_7ndb.result +++ b/mysql-test/r/ps_7ndb.result @@ -440,11 +440,11 @@ set @arg00=0 ; execute stmt1 using @arg00; ERROR 42S22: Unknown column '?' in 'order clause' set @arg00=1; -prepare stmt1 from ' select a,b from t1 +prepare stmt1 from ' select a,b from t1 order by a limit 1 '; execute stmt1 ; a b -2 two +1 one prepare stmt1 from ' select a,b from t1 limit ? '; ERROR 42000: 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 '?' at line 2 |