Almost all the error messages of Firebird are insuficient, don't give
enough information, they would be very more useful when in all cases naming
the table and the column that have the error.
For example, the message "data truncated" never says which is the column
with that error, and if the table has many columns (as usual) the only
solution is verify one by one, something bored and a waste of time.
Greetings.
Walter.
On Fri, Oct 25, 2013 at 11:54 AM, Adriano dos Santos Fernandes <
[email protected]> wrote:
> On 25/10/2013 13:50, Vlad Khorsun wrote:
> >>>> BTW: Would it be possible to include the name of the actual constraint
> >>>> that was violated?
> >>> CREATE TABE T
> >>> (
> >>> F1 INT NOT NULL,
> >>> F2 INT CHECK(F2 >= 0)
> >>> )
> >>>
> >>> what constraint name would you like to report in both cases ? :)
> >> Doesn't that get assigned an internal name (I honestly don't remember
> and
> >> I don't have Firebird at hand to check)?
> > NOT NULL constraints have such name and other constraints implemented
> > using system triggers and have names like CHECK_NNN. Are you sure it will
> > be really useful to show such name ?
> >
> >
> If ISQL and others tools does not hidden them, just because they were
> generated names, yes, it will be useful.
>
>
> Adriano
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
