diff options
| author | Jan Wieck | 2000-07-18 11:28:20 +0000 |
|---|---|---|
| committer | Jan Wieck | 2000-07-18 11:28:20 +0000 |
| commit | ec1ea5295a001ca6ff3a02d559c785a922bbf3d4 (patch) | |
| tree | 1c2b1625fa9f610e68b1993a62149aff1ff98d01 | |
| parent | ba930a016c96f8cf57255b6f3adaa73564a7965d (diff) | |
Fixed an ordering problem in test queries and
formatting differences due to new psql.
Jan
| -rw-r--r-- | src/pl/tcl/test/test.expected | 10 | ||||
| -rw-r--r-- | src/pl/tcl/test/test_queries.sql | 4 |
2 files changed, 7 insertions, 7 deletions
diff --git a/src/pl/tcl/test/test.expected b/src/pl/tcl/test/test.expected index dd324a635e0..351643ade41 100644 --- a/src/pl/tcl/test/test.expected +++ b/src/pl/tcl/test/test.expected @@ -152,23 +152,23 @@ select 100 @< 4; f (1 row) -select * from T_pkey1 order by key1 using @<; +select * from T_pkey1 order by key1, key2 using @<; key1 | key2 | txt ------+----------------------+------------------------------------------ - 1 | key1-2 | test key 1 | key1-1 | test key + 1 | key1-2 | test key 1 | key1-3 | test key 1 | KEY1-3 | should work - 2 | key2-9 | test key 2 | key2-3 | test key + 2 | key2-9 | test key (6 rows) -select * from T_pkey2 order by key1 using @<; +select * from T_pkey2 order by key1, key2 using @<; key1 | key2 | txt ------+----------------------+------------------------------------------ 1 | KEY1-3 | test key 1 | KEY1-9 | test key - 2 | KEY2-9 | test key 2 | KEY2-3 | test key + 2 | KEY2-9 | test key (4 rows) diff --git a/src/pl/tcl/test/test_queries.sql b/src/pl/tcl/test/test_queries.sql index ff652135a57..ba584765ea6 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 using @<; -select * from T_pkey2 order by key1 using @<; +select * from T_pkey1 order by key1, key2 using @<; +select * from T_pkey2 order by key1, key2 using @<; |