db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4187) Convert altertable.sql to JUnit
Date Mon, 27 Apr 2009 11:59:30 GMT

    [ 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.


Mime
View raw message