Zhang Mingli
Zhang Mingli
@jiaqizho have found some useful info: https://github.com/cloudberrydb/cloudberrydb/pull/515#issuecomment-2224388539
> Noting that we have ignored this test case, can we close this issue? @avamingli Sure.
https://github.com/orgs/cloudberrydb/discussions/36 IVM general summary
### Planner use Materialized Views Articles [Optimizing Queries Using Materialized Views: A Practical, Scalable Solution](https://courses.cs.washington.edu/courses/cse591d/01sp/opt_views.pdf)
[Automated Selection of Materialized Views and Indexes for SQL Databases](https://www.vldb.org/conf/2000/P496.pdf)
@my-ship-it This might not be a `good-first-issue` for new comers. Someone have interest could take this one.
This is added by CBDB by a commit `Fix configure.ac for escaping string in pg_config.h` try to resolve a C string issue and it has been squashed into CBDB init...
Actual result: 9 rows, Expected result: 8 rows? fewer lock or more locks?
> Actual result: 9 rows, > Expected result: 8 rows? I think you want to show Actual result: 8 rows, Expected result: 9 rows, right? If so, it's called by...
Offhand, I don't think it's a bug. > SELECT * FROM cte1, exttab_limit_2 e3 where cte1.i = e3.i LIMIT 3; SQL standard doesn't guarantee the results with only LIMIT. The...