db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eranda Sooriyabandara (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4187) Convert altertable.sql to JUnit
Date Sat, 02 May 2009 21:20:30 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12705334#action_12705334
] 

Eranda Sooriyabandara commented on DERBY-4187:
----------------------------------------------

Hi Bryan/Knut,
I tested some of the function include in AlterTableTest.java after
remove unconverted cords.
Here are my testings,
ij> connect 'jdbc:derby:Movies;create=true';
ij> CREATE TABLE Persons ( P_Id int, LastName varchar(255), FirstName
varchar(255), Address varchar(
255), City varchar(255) );
0 rows inserted/updated/deleted
ij> rename table Persons to Studentdetails;
0 rows inserted/updated/deleted
ij> ALTER TABLE Studentdetails DROP LastName;
0 rows inserted/updated/deleted
ij> select *from Studentdetails;
P_ID       |FIRSTNAME        |ADDRESS        |CITY
----------------------------------------------------------------------------------------------------
0 rows selected
ij> ALTER TABLE Studentdetails ADD COLUMN LastName varchar(255);
0 rows inserted/updated/deleted
ij> select *from Studentdetails;
P_ID       |FIRSTNAME    |ADDRESS   |CITY       |L ASTNAME
----------------------------------------------------------------------------------------------------
0 rows selected
ij> ALTER TABLE Studentdetails CHANGE address address1 varchar(255);
ERROR 42X01: Syntax error: Encountered "CHANGE" at line 1, column 28.
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 ser
ver.
After testing I can say that, in alter table
	Functions like Rename table, Drop column, Add column, Add constraint,
Drop constraint are working properly but “Change Column name” does
not.
Thanks
Eranda


> 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, 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