Omega359 commented on PR #14824: URL: https://github.com/apache/datafusion/pull/14824#issuecomment-2682103367
> anyone familiar with sqlite test? > > I update test with `--complete`, ends up the format like what we have in datafusion `0 Null` and not > > ``` > 0 > Null > ``` > > But execute it again comes out error > > ``` > External error: query result mismatch: > [SQL] SELECT ALL - + COUNT ( * ) * + + 51 AS col2, - CAST ( NULL AS INTEGER ) FROM tab0 AS cor0 WHERE NULL <> - col0 > [Diff] (-expected|+actual) > 0 NULL > at ../../datafusion-testing/data/sqlite/index/random/1000/slt_good_0.slt:6333 > > External error: query result mismatch: > [SQL] SELECT DISTINCT - COUNT ( * ), CAST ( NULL AS INTEGER ) FROM tab0 AS cor0 WHERE NOT NULL IS NULL > [Diff] (-expected|+actual) > 0 NULL > at ../../datafusion-testing/data/sqlite/index/random/1000/slt_good_7.slt:7248 > > External error: query result mismatch: > [SQL] SELECT DISTINCT 99, + 16 * + + 75 AS col3 FROM tab0 WHERE + 15 IS NOT NULL > [Diff] (-expected|+actual) > 99 1200 > at ../../datafusion-testing/data/sqlite/index/random/1000/slt_good_8.slt:21878 > ``` > >  > > @Omega359 Have you experienced similar issue before? Is this to just get the tests passing for now by having those failures be ignored? Otherwise I am unsure why you would want to regenerate the results ... were they not correct before? -- 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: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
