#12081: Unable to edit interval datatype value in Table data editor in vertica 7.0 | Aqua Data Studio

Issues
Search Tips

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
You can use:
- Boolean operators AND, OR and NOT (must be in caps, e.g. oracle AND debugger, debugger NOT oracle)
- Single and multiple character wildcard (e.g. de?ug, debug*)
- Grouping (e.g. ((oracle debugger) AND exception))
- Quoted phrase (e.g. "Oracle Debugger")

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

Follow 828

IDE for Relational Databases

Back

Vaibhav Laddha

vaibhavladdha271(*) reported 2014-05-08T10:12:12Z · last modified 2014-11-20T21:47:10Z

Unable to edit interval datatype value in Table data editor in vertica 7.0

Dev	SachinPrakash
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - Vertica
Version	16.0

Aqua Data Studio 15.0.0-dev-269
Build #: 37723
Built on: 2014-May-06 06:22:23 PM

Operating system: Windows 7 x64

Database: Vertica 7.0.0

Steps to reproduce:
1)Create a table containing all interval datatypes
Create table script:

CREATE TABLE "dbschema"."test_interval" (

"col1" interval,

"col2" interval day,

"col3" interval day to hour,

"col4" interval day to minute,

"col5" interval,

"col6" interval hour,

"col7" interval hour to minute,

"col8" interval hour to second,

"col9" interval minute,

"col10" interval minute to second,

"col11" interval month,

"col12" interval second,

"col13" interval year,

"col14" interval year to month

)

GO

2)Right click on created table->Select Edit table data
Try to insert any data or try to edit any inserted data

Insert scripts:

INSERT INTO "dbschema"."test_interval"("col1", "col2", "col3", "col4", "col5", "col6", "col7", "col8", "col9", "col10", "col11", "col12", "col13", "col14")

VALUES('1700 15:37:51', '2065', '1700 15', '1700 15:37', '1700 15:37:51', '15', '15:37', '15:37:51', '00', '937:51', '24173', '85139', '2014', '2014-04')

GO

INSERT INTO "dbschema"."test_interval"("col1", "col2", "col3", "col4", "col5", "col6", "col7", "col8", "col9", "col10", "col11", "col12", "col13", "col14")

VALUES('1700 15:37:51', '2065', '1700 15', '1700 15:37', '1700 15:37:51', '15', '15:37', '15:37:51', '02', '937:51', '24173', '35434', '2014', '2014-04')

GO

INSERT INTO "dbschema"."test_interval"("col1", "col2", "col3", "col4", "col5", "col6", "col7", "col8", "col9", "col10", "col11", "col12", "col13", "col14")

VALUES('1700 15:37:51', '2065', '1700 15', '1700 15:37', '1700 15:37:51', '15', '15:37', '15:37:51', '06', '937:51', '24173', '4677', '2014', '2014-04')

GO

INSERT INTO "dbschema"."test_interval"("col1", "col2", "col3", "col4", "col5", "col6", "col7", "col8", "col9", "col10", "col11", "col12", "col13", "col14")

VALUES('1700 15:37:51', '2065', '1700 15', '1700 15:37', '1700 15:37:51', '15', '15:37', '15:37:51', '15', '937:51', '24173', '75975', '2014', '2014-04')

GO

INSERT INTO "dbschema"."test_interval"("col1", "col2", "col3", "col4", "col5", "col6", "col7", "col8", "col9", "col10", "col11", "col12", "col13", "col14")

VALUES('1700 15:37:51', '2065', '1700 15', '1700 15:37', '1700 15:37:51', '15', '15:37', '15:37:51', '17', '937:51', '24173', '32567', '2014', '2014-04')

GO

INSERT INTO "dbschema"."test_interval"("col1", "col2", "col3", "col4", "col5", "col6", "col7", "col8", "col9", "col10", "col11", "col12", "col13", "col14")

VALUES('1700 15:37:52', '2065', '1700 15', '1700 15:37', '1700 15:37:52', '15', '15:37', '15:37:52', '00', '937:52', '24173', '43486', '2014', '2014-04')

GO

INSERT INTO "dbschema"."test_interval"("col1", "col2", "col3", "col4", "col5", "col6", "col7", "col8", "col9", "col10", "col11", "col12", "col13", "col14")

VALUES('1700 15:37:52', '2065', '1700 15', '1700 15:37', '1700 15:37:52', '15', '15:37', '15:37:52', '19', '937:52', '24173', '46731', '2014', '2014-04')

GO

INSERT INTO "dbschema"."test_interval"("col1", "col2", "col3", "col4", "col5", "col6", "col7", "col8", "col9", "col10", "col11", "col12", "col13", "col14")

VALUES('1700 15:37:52', '2065', '1700 15', '1700 15:37', '1700 15:37:52', '15', '15:37', '15:37:52', '19', '937:52', '24173', '48654', '2014', '2014-04')

GO

INSERT INTO "dbschema"."test_interval"("col1", "col2", "col3", "col4", "col5", "col6", "col7", "col8", "col9", "col10", "col11", "col12", "col13", "col14")

VALUES('1700 15:37:52', '2065', '1700 15', '1700 15:37', '1700 15:37:52', '15', '15:37', '15:37:52', '21', '937:52', '24173', '6562', '2014', '2014-04')

GO

User is not allowed to insert or edit data through table data editor

All Comments (1) Change History

Sachin Prakash

SachinPrakash 2014-11-20T20:18:05Z

Unless we have user demand for this feature, we will not be adding it.

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017