[Firebird-devel] [ firebird-Bugs-229860 ] Error in error message

[<no...@so...>]

Bugs item #229860, was opened at 2001-01-23 14:36
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=229860&group_id=9028

Category: DSQL
>Group: Fixed v0.9-5
Status: Closed
Resolution: Fixed
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Claudio Valderrama C. (robocop)
Summary: Error in error message

Initial Comment:
I have just found one very minor bug when issuing this statement:

alter table drawings add F1 date, add F2 image;

You see it contains word IMAGE that was copied by mistake from MS SQL script. Of course this command did not pass but the error message was misleading:

SQL error code = -607
Invalid command
Specified domain or source column does not exist
SQL warning code = 301
DATE data type is now called TIMESTAMP
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Statement: alter table drawings add F1 date, add F2 image

I played a little with the command and found that, if adding new DATE column when there is some mistake in a SQL sentence, the same error statement always appears.

I found this, working with the latest version of Firebird, though IB6 has it too.

Regards,

George Kozaderov
Practical Programs
Australia
ge...@pr...


----------------------------------------------------------------------

Comment By: Claudio Valderrama C. (robocop)
Date: 2001-06-30 18:16

Message:
Logged In: YES 
user_id=62823

The SQL error message stops where the warning begins. There 
are two messages here. The error says that it doesn't 
recognize a data type for a field, but I doesn't tell you 
which data type. The warning simply says that the preferred 
name for DATE type IN DIALECT 1 is TIMESTAMP, to make 
migration to dialect 3 clearer. This dialect 1 warning are 
explained in the documentation. You won't see it in dialect 
3 since DATE and TIMESTAMP are separate data types.

But regarding the error message that's confusing, the 
server from now will say:

Dynamic SQL Error
SQL error code = -607
Invalid command
Specified domain or source column IMAGE does not exist
Statement: alter table tclean add F1 date, add F2 image

so you'll know which is the data type or domain it didn't 
recognize: IMAGE in this example.

Furthermore, you will be able to know -while building a 
stored procedure- which is the variable name that FB 
doesn't recognize (instead of the silly COLUMN UNKNOWN msg) 
and hopefully you will get the correct line and column 
where the problem happens.

C.


----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=109028&aid=229860&group_id=9028