[interchange-cvs] interchange - jon modified dist/test/products/tests.asc

interchange-cvs at icdevgroup.org interchange-cvs at icdevgroup.org
Sun Nov 16 05:04:07 UTC 2008


User:      jon
Date:      2008-11-16 05:04:07 GMT
Modified:  dist/test/products tests.asc
Log:
Fix two occasionally broken tests.

Two tests of the [query] tag and built-in SQL parser relied on the results
being returned in a particular, even though SQL's result sets are not ordered
by default.

Fixed this by specifying a sort order and setting the results to match.

Revision  Changes    Path
2.33                 interchange/dist/test/products/tests.asc


rev 2.33, prev_rev 2.32
Index: tests.asc
===================================================================
RCS file: /var/cvs/interchange/dist/test/products/tests.asc,v
retrieving revision 2.32
retrieving revision 2.33
diff -u -u -r2.32 -r2.33
--- tests.asc	21 Mar 2008 19:03:13 -0000	2.32
+++ tests.asc	16 Nov 2008 05:04:07 -0000	2.33
@@ -257,9 +257,9 @@
 %%%
 000020
 %%
-[query list=1 sql="select artist from products where category like 'Americana'" tolerant-like=1][sql-param artist] [/query]
+[query list=1 sql="select artist from products where category like 'Americana' order by artist" tolerant-like=1][sql-param artist] [/query]
 %%
-Grant Wood The Art Store Jean Langan
+Grant Wood Jean Langan The Art Store
 %%
 
 %%
@@ -269,9 +269,9 @@
 %%%
 000021
 %%
-[query list=1 sql="select * from products where category like '%Americana%'"][sql-field artist] [/query]
+[query list=1 sql="select * from products where category like '%Americana%' order by artist desc"][sql-field artist] [/query]
 %%
-Grant Wood The Art Store Jean Langan
+The Art Store Jean Langan Grant Wood
 %%
 
 %%







More information about the interchange-cvs mailing list