[
https://issues.apache.org/jira/browse/DERBY-4187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12703089#action_12703089
]
Knut Anders Hatlen commented on DERBY-4187:
-------------------------------------------
To convert the unconverted parts, I think you'll need to find some way to do
the same thing as the IJ commands via JDBC, possibly using DatabaseMetaData.
For instance this code
+ /*[**:: UNCONVERTED ::**] describe renc_vw_1
+
+ [**:: UNCONVERTED ::**] COLUMN_NAME
|TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
+------------------------------------------------------------------------------
+V1 |VARCHAR |NULL|NULL|10 |NULL |20 |YES
+V2 |DOUBLE |NULL|2 |52 |NULL |NULL |YES
+
+ */
could perhaps be replaced with a call to DatabaseMetaData.getColumns() and
verify that the table has the expected columns.
I guess that those looking like this could be removed:
+ [**:: UNCONVERTED ::**] Issue the 'help' command for general
information on IJ command syntax.
+Any unrecognized commands are treated as potential SQL commands and executed
directly.
+Consult your DBMS server reference documentation for details of the SQL syntax
supported by your server.
+
+ */
> Convert altertable.sql to JUnit
> -------------------------------
>
> Key: DERBY-4187
> URL: https://issues.apache.org/jira/browse/DERBY-4187
> Project: Derby
> Issue Type: Test
> Components: Test
> Affects Versions: 10.4.2.1
> Reporter: Eranda Sooriyabandara
> Priority: Minor
> Fix For: 10.5.1.2
>
> Attachments: AlterTable.diff, AlterTable.java, AlterTableTest.diff
>
> Original Estimate: 486.08h
> Remaining Estimate: 486.08h
>
> Converting altertable.sql harness test to JUnit
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
