![]() |
354 B
![]() |
476 B
![]() |
11 KB
|
247 KB
|
119 KB
Does this occur in v15? v16?
This occurs in prior versions as well. I will look into fixing the script
This occurs in prior versions as well. I will look into fixing the script
Hi Sachin, Tariq,
MySQL index extraction is not wired into the ExtractIndexes.getIndexes() method that is called for Aquascript. As a matter of fact, I don't even see indexes listed in the schema tree, schema compare or schema script generator. I'm going to assign to Ivan. Maybe he knows why the indexes are absent.
Thanks, Tom
Hi Sachin, Tariq,
MySQL index extraction is not wired into the ExtractIndexes.getIndexes() method that is called for Aquascript. As a matter of fact, I don't even see indexes listed in the schema tree, schema compare or schema script generator. I'm going to assign to Ivan. Maybe he knows why the indexes are absent.
Thanks, Tom
Our native MySQL support has never supported extracting all indexes. The index extraction was done via SHOW INDEX statement, which requires a database name and table name. I believe because in older versions there was no information_schema tables that provided catalog data. As of version 5.x we should be able to extract index information from the information_schema.statistics table.
Do we want to add support for a upper level index tree folder node? schema script generator? object search? schema synch? We would need to add extraction for indexes arraylist of objects.
Also, I am not able to reproduce the exceptions mentioned in this issue...
Our native MySQL support has never supported extracting all indexes. The index extraction was done via SHOW INDEX statement, which requires a database name and table name. I believe because in older versions there was no information_schema tables that provided catalog data. As of version 5.x we should be able to extract index information from the information_schema.statistics table.
Do we want to add support for a upper level index tree folder node? schema script generator? object search? schema synch? We would need to add extraction for indexes arraylist of objects.
Also, I am not able to reproduce the exceptions mentioned in this issue...
@shavi: can you still reproduce the exception?
@shavi: can you still reproduce the exception?
Currently the exception is not reproducible, but still, the methods extractIndex() and extractIndexes() are unable to extract the indexes. These methods return null after execution. Please refer latest attached screenshot.
Currently the exception is not reproducible, but still, the methods extractIndex() and extractIndexes() are unable to extract the indexes. These methods return null after execution. Please refer latest attached screenshot.
Issue #13274 |
New |
Completion |
No due date |
No fixed build |
No time estimate |
Does this occur in v15? v16?