Version: 13.0-dev-37
Build #: 30377
Build Date: 2012-Nov-29 06:07:41 PM
Operating Environment: Windows XP (5.2, amd64) / Cp1252 / en / US / Sun Microsystems Inc. 1.6.0_35-b10
Memory: Max=891,092,992; Total=391,708,672; Free=240,193,904; CPUs=8
Feel free to mark this as invalid if this is as designed.
This threw me off when I was trying to use the GUI to create a user, and when I was trying to write a CREATE USER script in the query analyzer.
see attached.
If I use "Script Object to Window as CREATE" on a user, the following is generated
CREATE USER jonathan4
RESOURCE POOL general
IDENTIFIED BY 'md5acdafe82d6bba059bdadb15ec1dbe5bb'
ACCOUNT UNLOCK
PROFILE default
MEMORYCAP 'unlimited'
RUNTIMECAP 'unlimited'
TEMPSPACECAP 'unlimited'
GO
if I use "Server Script Generator" to create a script from an existing user it writes out like
DROP USER "jonathan2"
GO
CREATE USER "jonathan2"
RESOURCE POOL general
IDENTIFIED BY 'md591e67b9e4bdca6002ce63dd04f9497f2'
ACCOUNT UNLOCK
PROFILE default
MEMORYCAP 'unlimited'
RUNTIMECAP 'unlimited'
TEMPSPACECAP 'unlimited'
GO
However, given both of those, If I want to create a user in an SQL statement, I have to leave out the
'unlimited'
and just have two single quotes instead, like below.
CREATE USER "jonathan4"
RESOURCE POOL general
password 'password'
ACCOUNT UNLOCK
PROFILE default
MEMORYCAP ''
RUNTIMECAP ''
TEMPSPACECAP ''
GO
If I do not leave out unlimited in a user creation script, or in the create user gui, I get the following exception
java.sql.SQLException: [Vertica][VJDBC](2071) ROLLBACK: 'unlimited' is not a valid size description
at com.vertica.util.ServerErrorData.buildException(Unknown Source)
at com.vertica.dataengine.VQueryExecutor.executeSimpleProtocol(Unknown Source)
at com.vertica.dataengine.VQueryExecutor.execute(Unknown Source)
at com.vertica.jdbc.SStatement.executeNoParams(Unknown Source)
at com.vertica.jdbc.SStatement.execute(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.sꐱꌿᢎ⢞ 7.execute(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Xꑎ⣗ꂣꌠ case.a(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.Z⢯ꈖᢐꀳ.run(Unknown Source)
Caused by: com.vertica.util.ServerException: [Vertica][VJDBC](2071) ROLLBACK: 'unlimited' is not a valid size description
... 8 more
Also, if I use the GUI to create a user, I need to leave the MEMORYCAP, RUNTIME, TEMPSPACECAP fields completely blank. I assumed I had to type
unlimited
in them because of what I saw when I used the Server Script Generator on existing users.
