diff options
| author | Tom Lane | 2001-02-16 03:22:41 +0000 |
|---|---|---|
| committer | Tom Lane | 2001-02-16 03:22:41 +0000 |
| commit | 60d1d671a8a0743f4701ae3976da40c010adb941 (patch) | |
| tree | 2222e72a2d575a70c9147dcded2b9d298cb14b86 | |
| parent | 13cc7eb3e2ef66de0785be5e67f4575b07692e29 (diff) | |
Fix erroneous sort request in pltcl selftest.
| -rw-r--r-- | src/pl/tcl/test/test.expected | 6 | ||||
| -rw-r--r-- | src/pl/tcl/test/test_queries.sql | 4 |
2 files changed, 5 insertions, 5 deletions
diff --git a/src/pl/tcl/test/test.expected b/src/pl/tcl/test/test.expected index d7037a18486..cefeaf4418d 100644 --- a/src/pl/tcl/test/test.expected +++ b/src/pl/tcl/test/test.expected @@ -156,18 +156,18 @@ select 100 @< 4; f (1 row) -select * from T_pkey1 order by key1, key2 using @<; +select * from T_pkey1 order by key1 using @<, key2; key1 | key2 | txt ------+----------------------+------------------------------------------ + 1 | KEY1-3 | should work 1 | key1-1 | test key 1 | key1-2 | test key 1 | key1-3 | test key - 1 | KEY1-3 | should work 2 | key2-3 | test key 2 | key2-9 | test key (6 rows) -select * from T_pkey2 order by key1, key2 using @<; +select * from T_pkey2 order by key1 using @<, key2; key1 | key2 | txt ------+----------------------+------------------------------------------ 1 | KEY1-3 | test key diff --git a/src/pl/tcl/test/test_queries.sql b/src/pl/tcl/test/test_queries.sql index ba584765ea6..98bc513b4ce 100644 --- a/src/pl/tcl/test/test_queries.sql +++ b/src/pl/tcl/test/test_queries.sql @@ -68,6 +68,6 @@ select tcl_sum(key1) from T_pkey1 where key1 = 99; select 1 @< 2; select 100 @< 4; -select * from T_pkey1 order by key1, key2 using @<; -select * from T_pkey2 order by key1, key2 using @<; +select * from T_pkey1 order by key1 using @<, key2; +select * from T_pkey2 order by key1 using @<, key2; |