db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-602) SELECT statement does not return the first colum data correctly
Date Wed, 05 Oct 2005 13:46:48 GMT
    [ http://issues.apache.org/jira/browse/DERBY-602?page=comments#action_12331379 ] 

Daniel John Debrunner commented on DERBY-602:
---------------------------------------------

USER is a functio/reserved word in Derby that returns the current user name, see http://db.apache.org/derby/docs/10.1/ref/rrefsqlj42476.html

Thus I think the statement is returning the correct values. In order to return the contents
of the table you need to quote USER, like

SELECT "USER", PASSWORD FROM USERS

Just like you had to quote USER in the create table.

> SELECT statement does not return the first colum data correctly
> ---------------------------------------------------------------
>
>          Key: DERBY-602
>          URL: http://issues.apache.org/jira/browse/DERBY-602
>      Project: Derby
>         Type: Bug
>     Versions: 10.1.1.0
>  Environment: Win XP, Sun JDK 142
>     Reporter: Vamsavardhana Reddy

>
> SELECT statement does not return the first colum data correctly.  Here is the scenario.
 I have used "ij" for executing SQL.
> I have used the EmbeddedDriver and created a database.   JDBC URL: 'jdbc:derby:mydb;create=true'
> I have created one table using the SQL given below:
>      CREATE TABLE "USERS" ("USER" CHAR(10), "PASSWORD" CHAR(10));
> I have inserted one row into this table using the SQL given below:
>    INSERT INTO USERS VALUES ('user1', 'password1');
> Retrieving  rows from this table using the SQL statement "SELECT * FROM USERS"  returns
the data properly.  Where as "SELECT USER, PASSWORD FROM USERS" retuns a value 'APP' for USER
column data.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message