[MCOL-364] Create table doesn't replicate correctly when default_storage_engine is used Created: 2016-10-16 Updated: 2016-11-03 Resolved: 2016-11-03 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | Documentation |
| Affects Version/s: | None |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Major |
| Reporter: | Andrew Hutchings (Inactive) | Assignee: | Andrew Hutchings (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | relnote | ||
| Sprint: | 2016-21 |
| Description |
|
When default_storeage_engine is set to columnstore and tables are created without an explicit engine name the other UMs end up with InnoDB tables instead of ColumnStore tables when the statements are replicated. They therefore cannot be queried. |
| Comments |
| Comment by David Hall (Inactive) [ 2016-10-18 ] |
|
InfiniDB always told users to not use InfiniDB as default, thus the issue never arose. |
| Comment by Andrew Hutchings (Inactive) [ 2016-10-27 ] |
|
I'm happy to actually close this. On reflection this has been a known bug in MySQL and MariaDB for a long time (see http://bugs.mysql.com/bug.php?id=41101) |
| Comment by Andrew Hutchings (Inactive) [ 2016-10-27 ] |
|
After discussions it was decided that we should document the fact that this variable is not replicated so needs to be set as a my.cnf option on both ends. |
| Comment by Andrew Hutchings (Inactive) [ 2016-11-03 ] |
|
Added note in https://mariadb.com/kb/en/mariadb/create-table/ |