Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Tools - ER Modeler |
| Version | 14.0 |
|
|
371 KB
|
|
234 KB
We do some validation on the client side but for most sql generated we allow the GUI's to create what the user is asking for and then display any server sql exceptions back to the user. In this case, you will notice that if you are doing it in ERM it does allow you to create the sql, but when you run the sql it will tell you that DISTRIBUTE BY must be hash() if its a fact table. In the regular tree, the sql is also generated but that ok button actually sends the ddl to the server and then displays the server exception. We do not keep track of all validations for object creation in ERM.
Issue #11769 |
| Closed |
| Invalid |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
We do some validation on the client side but for most sql generated we allow the GUI's to create what the user is asking for and then display any server sql exceptions back to the user. In this case, you will notice that if you are doing it in ERM it does allow you to create the sql, but when you run the sql it will tell you that DISTRIBUTE BY must be hash() if its a fact table. In the regular tree, the sql is also generated but that ok button actually sends the ddl to the server and then displays the server exception. We do not keep track of all validations for object creation in ERM.