gfphoenix78 commented on PR #1163: URL: https://github.com/apache/cloudberry/pull/1163#issuecomment-3002319441
> > > What's the behavior if we drop the aocs table to zero column? > > > Is it possible to convert other type of table with zero column to aocs table? > > > > > > @gfphoenix78 can you provide sql ? > > create a table with one column, then drop the column. > > Same concern, create a table with zero column is valid in Postgres/GPDB. Yes. The normal table with columns may drop columns one by one, until to have no column. This PR only disallow aocs table to create a zero-column table, but we may still have zero-column table in other table storage. `ALTER TABLE ... SET ACCESS METHOD` may convert other table storage to aocs, which is also invalid. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
