>> +1, This is a smart idea. How did you test it? AFAIK, we can test it > with: > > 1. For any query like SELECT xxx, we create view like CREATE MATERIAL VIEW > mv_name as SELECT xxx; to test if the features in the query are supported.
No I didn't test the correctness of IVM with TPC-DS data for now. TPC-DS comes with a data generator and we can test IVM something like: SELECT * FROM IVM_vew EXCEPT SELECT ... (TPC-DS original query); If this produces 0 row, then the IVM is correct for the initial data. (of course actually we need to add appropreate ORDER BY and LIMIT clause to the SELECT statement for IVM if neccessary). > 2. Update the data and then compare the result with SELECT XXX with SELECT > * from mv_name to test if the data is correctly sync. I wanted to test the data updating but I am still struggling how to extract correct updating data from TPC-DS data set. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp
