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
When I drag a column from a table and drop it into query analyzer, I only want the column name to be dropped, not the column name and property…i.e. YYYYMMDD (int8(10))….when I drag this column from the Servers view and drop it into the query analyzer it drops YYYYMMDD (int8(10)), I only want YYYYMMDD.
To reproduce:
1. Connect to Vertica using a generic JDBC driver and drag and drop a column. This will append the data type as well.
2. Connect to Oracle and Drag and drop a column and same issue occurs as well
Fixed: for Generic JDBC, Oracle, and TeraData
SVN r35451/14.0.7-2
SVN r35453/15.0.0-dev-67
Fix made by issue 6096 seems to add a 'public boolen isColumnNode()' API to the tree node, and, a DB column tree node supposes to redefine this method to return ture. Since ADS column tree nodes do not share a common base column node class, hence, we need to modify each DB column tree node and add isColumnNode() manually.
(1) Modified the column tree node class and added 'isColumnNode()' for the following databases:
Generic JDBC, Oracle, TeraData.
(2) I have access to the following databases, and verified DnD does work:
Cassandra, DB2, Informix, MongoDB, MySQL, nCluster, ParAccel PostgreSQL, SQL Server, Sybase Anywhere, Sybase ASE, Sybase IQ.
(3) I don't have access to the following databases, but their implementation looks good to me:
Azure, Derby, Greenplum, HBase, Hive, Netezza, SQLite, Vertica.
(4) I don't have access to the following databases, and 'isColumnNode()' API is not implemented in the column tree node class owned by these databases. Since I cannot access these databases, I did not change their implementation.
DB2iSeries, DB2zOS.
Issue #11030 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 14.0.7-2/15.0.0-dev-67 |
| No time estimate |
4 issue links |
relates to #11329
Issue #11329Drag and Drop column in Query Analyzer datatype is also appends with column name |
relates to #12078
Issue #12078In MongoDB, columns having "record" or "array(record)" datatype are dropped in query analyzer window with datatype appended to column name |
relates to #13404
Issue #13404Drag and Drop columns appends the datatype as well. |
relates to #6096
Issue #6096DnD table columns into editors should copy name only |
Fixed: for Generic JDBC, Oracle, and TeraData
SVN r35451/14.0.7-2
SVN r35453/15.0.0-dev-67
Fix made by issue 6096 seems to add a 'public boolen isColumnNode()' API to the tree node, and, a DB column tree node supposes to redefine this method to return ture. Since ADS column tree nodes do not share a common base column node class, hence, we need to modify each DB column tree node and add isColumnNode() manually.
(1) Modified the column tree node class and added 'isColumnNode()' for the following databases:
Generic JDBC, Oracle, TeraData.
(2) I have access to the following databases, and verified DnD does work:
Cassandra, DB2, Informix, MongoDB, MySQL, nCluster, ParAccel PostgreSQL, SQL Server, Sybase Anywhere, Sybase ASE, Sybase IQ.
(3) I don't have access to the following databases, but their implementation looks good to me:
Azure, Derby, Greenplum, HBase, Hive, Netezza, SQLite, Vertica.
(4) I don't have access to the following databases, and 'isColumnNode()' API is not implemented in the column tree node class owned by these databases. Since I cannot access these databases, I did not change their implementation.
DB2iSeries, DB2zOS.