Aqua Data Studio 15.0.0-dev-263
Build #: 37662
Built on: 2014-May-01 05:25:32 PM
Operating system: Windows 7 x64
Database: Vertica 7.0.0
Steps to reproduce
1)Connect to Vertica 7.0.0
2)Right click on profile node
3)Select Create profile
4)Enter profile1 in Name field
5)Enter -1 in Max length field
6)Switch to Preview sql tab
7)It shows default value for -1
8)Enter -2 in Max length field
9)Switch back to Preview sql tab
10)it shows Unlimited for -2
11)Enter 0 in Max length field
12)Click on create button
13)It gives an error message:"[Vertica][VJDBC](4344) ROLLBACK: PASSWORD_MAX_LENGTH must be within the range from 8 to 100"
14)Also it shows default for -3 & alphabets & displays error message for -4
Also it does not show anything for large numeric values eg.111111111111111,but after creating profile it shows default in profile properties window
Same is applicable for all fields in create or alter profile window
|
59 KB
This works as designed as for now in the Visual Editor. If user gives an invalid entry, the default kicks in. You are comparing ADS visual editor to command line in Vertica.
If you take the invalid SQL and run in a Query window, you will also get the same error.
Issue #12016 |
Closed |
Won't Fix |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
This works as designed as for now in the Visual Editor. If user gives an invalid entry, the default kicks in. You are comparing ADS visual editor to command line in Vertica.
If you take the invalid SQL and run in a Query window, you will also get the same error.