Em 03/04/2016 14:51, Carsten Schäfer escreveu:
> Hi,
> i get an error in flamerobin when executing the following select in the
> most current FB3 build.
> Select distinct(t_frachtbrief.*) from t_frachtbrief;
>
> Error: *** IBPP::SQLException ***
> Context: Statement::Prepare( Select distinct(t_frachtbrief.*) from
> t_frachtbrief )
> Message: isc_dsql_prepare failed
>
> SQL Message : -104
> can't format message 13:896 -- message file C:\Program Files
> (x86)\FlameRobinFB3\firebird.msg not found
>
> Engine Code : 335544569
> Engine Message :
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 1, column 31
> *
>
> In Firebird 2.5.5 it works without a problem.
> Following Selects are also working in Firebid3:
> Select distinct(t_frachtbrief.id_frachtbrief) from t_frachtbrief;
> Select distinct t_frachtbrief.* from t_frachtbrief;
>
> Is it a bug or a feature?
>
Accordingly to the standard, 2.5 is wrong. A table.* cannot be inside an
expression (parenthesis).
----------------
<query specification> ::=
SELECT [ <set quantifier> ] <select list> <table expression>
<select list> ::=
<asterisk>
| <select sublist> [ { <comma> <select sublist> }... ]
<select sublist> ::=
<derived column>
| <qualified asterisk>
<qualified asterisk> ::=
<asterisked identifier chain> <period> <asterisk>
| <all fields reference>
<asterisked identifier chain> ::=
<asterisked identifier> [ { <period> <asterisked identifier> }... ]
<asterisked identifier> ::=
<identifier>
<derived column> ::=
<value expression> [ <as clause> ]
<as clause> ::=
[ AS ] <column name>
----------------
Adriano
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
