Lordworms commented on issue #9130: URL: https://github.com/apache/arrow-datafusion/issues/9130#issuecomment-1931186121
The rule is here, basically, we need to implement two things I. first one, in select * from (t1 cross join t2) as t cross join t3. if t is a tmp table and there are no other actions on that tmp table. we just ignore the 'as t' since this works <img width="569" alt="image" src="https://github.com/apache/arrow-datafusion/assets/48054792/758e1301-6c8d-4550-bdd9-43296393c56c";> II. the rest following the design of sqlite3, when create a real table, change its schema and add a ':num' to the name of the column inorder to make this works <img width="570" alt="image" src="https://github.com/apache/arrow-datafusion/assets/48054792/90bd5057-23fe-412f-bd45-b9e8a1b3e200";> -- 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]
