JiekerTime opened a new issue #9216:
URL: https://github.com/apache/shardingsphere/issues/9216


   First, it is clear that the single table needs to create a unique table in 
databases.
   
   The logic of H2 loading init.sql is located in 
DatabaseEnvironmentManager.executeInitSQLForSchemaNotSupportedDatabase.
   
   The execution logic here is to load init.sql once with each data source.
   
![image](https://user-images.githubusercontent.com/76552510/106235689-06229480-61b0-11eb-8ff4-e991f4efea41.png)
   If you simply put the logic of creating a single table into init.sql, it may 
cause "Single table conflict, there are multiple tables `t_single_table` 
existed."
   
   
   So I think we need to rewrite H2's init.sql loading method or create single 
table creation method for H2.


----------------------------------------------------------------
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.

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to