db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "George Baklarz (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-180) XCL47 SQLState duplicated in messages_en.properties?
Date Thu, 24 Mar 2005 21:16:22 GMT
XCL47 SQLState duplicated in messages_en.properties?

         Key: DERBY-180
         URL: http://issues.apache.org/jira/browse/DERBY-180
     Project: Derby
        Type: Bug
  Components: SQL  
 Environment: Windows XP SP1 Professional
    Reporter: George Baklarz
    Priority: Minor

In the messages_en.properties file, there are two items that are similar:

XCL47.S=Use of ''{0}'' requires database to be upgraded from version {1} to version {2} or
XCL478.S=The requested function can not reference tables in SESSION schema.

SQLSTATEs are supposed to be 5 characters long. When I issue a CREATE VIEW on a SESSION table,
I receive the proper error message:

ij> declare global temporary table x (a int) not logged;
0 rows inserted/updated/deleted
ij> create view z as (select * from session.x);
ERROR XCL47: The requested function can not reference tables in SESSION schema.

So, was XCL478 truncated to XCL47? Does this mean that if I tried to do something that invokes
the other version of XCL47 that I will get the wrong message? I suspect one of the message
numbers needs to be changed and that the SQL error be fixed to be 5 characters long instead
of 6.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
If you want more information on JIRA, or have a bug to report see:

View raw message