i am try to run one test, I got below error, So can you guys pls help me on this to fix this?
pub_id | avg_price |
---|---|
0736 | 9.784 |
0877 | 15.41 |
1389 | 18.976 |
ALL | 14.7662 |
CREATE PROCEDURE DemoUnitTestClass.[testrepq1] AS BEGIN IF OBJECT_ID('actual') IS NOT NULL DROP TABLE actual; IF OBJECT_ID('expected') IS NOT NULL DROP TABLE expected; CREATE TABLE actual ( pub_id varchar(10), avg_price varchar(10) ); INSERT INTO actual (pub_id, avg_price) exec reptq1 CREATE TABLE expected ( pub_id varchar(10), avg_price varchar(10) ); INSERT INTO expected (pub_id, avg_price) SELECT '0736','9.784'; INSERT INTO expected (pub_id, avg_price) SELECT '0877','15.41'; INSERT INTO expected (pub_id, avg_price) SELECT '1389','18.976'; INSERT INTO expected (pub_id, avg_price) SELECT 'ALL','14.7662'; EXEC tSQLt.AssertEqualsTable 'expected', 'actual'; END; (2 rows affected) [DemoUnitTestClass].[testrepq1] failed: (Failure) Unexpected/missing resultset rows! |_m_|pub_id|avg_price| +---+------+---------+ | |1389 |18.98 | |> |0736 |9.78 | |> |ALL |14.77 | +----------------------+ |Test Execution Summary| +----------------------+ |No|Test Case Name |Dur(ms)|Result | +--+-------------------------------+-------+-------+ |1 |[DemoUnitTestClass].[testrepq1]| 14|Failure|
in rept1 i used order by id so it always return in order but this is failing the result because of order.