[GitHub] [doris] yixiutt opened a new issue, #10989: [Bug] tpcds_sf1_unqiue_sql result error

[GitBox <gi...@apache.org>]

yixiutt opened a new issue, #10989:
URL: https://github.com/apache/doris/issues/10989

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   master
   
   ### What's Wrong?
   
   Exception in tpcds_sf1_unique_sql/sql/q06.sql:
   java.lang.IllegalStateException: Check tag 'q06' failed:
   Check tag 'q06' failed, line 29, CHAR result mismatch.
   Expect cell is: 
   But real is: \\N
   
   Exception in tpcds_sf1_unique_sql/sql/q30.sql:
   java.lang.IllegalStateException: Check tag 'q30' failed:
   Check tag 'q30' failed, line 4, CHAR result mismatch.
   Expect cell is: AAAAAAAAADBDAAAA
   But real is: AAAAAAAAAFCGBAAA
   
   Exception in tpcds_sf1_unique_sql/sql/q15.sql:
   java.lang.IllegalStateException: Check tag 'q15' failed:
   Check tag 'q15' failed, line 1, CHAR result mismatch.
   Expect cell is: 
   But real is: \\N
   
   Exception in tpcds_sf1_unique_sql/sql/q81.sql:
   java.lang.IllegalStateException: Check tag 'q81' failed:
   Check tag 'q81' failed, line 6, CHAR result mismatch.
   Expect cell is: AAAAAAAAAIECBAAA
   But real is: AAAAAAAAAIEHBAAA
   
   Exception in tpcds_sf1_unique_sql/sql/q34.sql:
   java.lang.IllegalStateException: Check tag 'q34' failed:
   Check tag 'q34' failed, line 16, CHAR result mismatch.
   Expect cell is: Acosta
   But real is: Adams
   
   Exception in tpcds_sf1_unique_sql/sql/q99.sql:
   java.lang.IllegalStateException: Check tag 'q99' failed:
   Check tag 'q99' failed, line 1, CHAR result mismatch.
   Expect cell is: \\N
   But real is: 
   
   Exception in tpcds_sf1_unique_sql/sql/q04.sql:
   java.lang.IllegalStateException: Check tag 'q04' failed:
   Check tag 'q04' failed, line 5, CHAR result mismatch.
   Expect cell is: AAAAAAAAMFPFBAAA
   But real is: AAAAAAAANJOLAAAA
   
   Exception in tpcds_sf1_unique_sql/sql/q62.sql:
   java.lang.IllegalStateException: Check tag 'q62' failed:
   Check tag 'q62' failed, line 1, CHAR result mismatch.
   Expect cell is: \\N
   But real is:
   
   Exception in tpcds_sf1_unique_sql/sql/q68.sql:
   java.lang.IllegalStateException: Check tag 'q68' failed:
   Check tag 'q68' failed, line 27, CHAR result mismatch.
   Expect cell is: Springfield
   But real is: Fairview
   
   Exception in tpcds_sf1_unique_sql/sql/q19.sql:
   java.lang.IllegalStateException: Check tag 'q19' failed:
   Check tag 'q19' failed, line 1, DECIMAL result mismatch.
   Expect cell is: 39779.2
   But real is: 41146.94
   relative error is: 0.03324038190932315, bigger than 1.0E-10
   
   Exception in tpcds_sf1_unique_sql/sql/q74.sql:
   java.lang.IllegalStateException: Check tag 'q74' failed:
   Check tag 'q74' failed, line 4, CHAR result mismatch.
   Expect cell is: AAAAAAAABLEIBAAA
   But real is: AAAAAAAABNBBAAAA
   
   Exception in tpcds_sf1_unique_sql/sql/q49_rewrite.sql:
   java.lang.IllegalStateException: Check tag 'q49_rewrite' failed:
   Check tag 'q49_rewrite' failed, line 13, BIGINT result mismatch.
   Expect cell is: 12641
   But real is: 1171
   
   Exception in tpcds_sf1_unique_sql/sql/q27.sql:
   java.lang.IllegalStateException: Check tag 'q27' failed:
   Check tag 'q27' failed, line 1, DOUBLE result mismatch.
   Expect cell is: 51.05758807588076
   But real is: 51.32573632538569
   relative error is: 0.005224440382208532, bigger than 1.0E-10
   
   Exception in tpcds_sf1_unique_sql/sql/q46.sql:
   java.lang.IllegalStateException: Check tag 'q46' failed:
   Check tag 'q46' failed, line 1, CHAR result mismatch.
   Expect cell is: Bunker Hill
   But real is: Plainview
   
   Exception in tpcds_sf1_unique_sql/sql/q11.sql:
   java.lang.IllegalStateException: Check tag 'q11' failed:
   Check tag 'q11' failed, line 4, CHAR result mismatch.
   Expect cell is: AAAAAAAABLEIBAAA
   But real is: AAAAAAAABNBBAAAA
   
   Exception in tpcds_sf1_unique_sql/sql/q79.sql:
   java.lang.IllegalStateException: Check tag 'q79' failed:
   Check tag 'q79' failed, line 18, BIGINT result mismatch.
   Expect cell is: 362
   But real is: 2018
   
   Exception in tpcds_sf1_unique_sql/sql/q75.sql:
   java.lang.IllegalStateException: Check tag 'q75' failed:
   Check tag 'q75' failed, line 1, BIGINT result mismatch.
   Expect cell is: 3927
   But real is: 3396
   
   ### What You Expected?
   
   fix
   
   ### How to Reproduce?
   
   _No response_
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org