> Sandeep wrote,
> Following sql statement works fine
> select first 10 tbl.* from "My_Table" tbl
> but following doesn't
> select first 10 * from "My_Table"
> Is it necessary to have table alias in dialect 3 ?

No bug, I think your problem is related to quotes and case in the
tablenames.

Quoted from a previous post by Martijn Tonies....

If you create your objects like "TABLENAME", they aren't case sensitive.

eg:

CREATE TABLE MyTable
can be used as:
MyTable - MYTaBLE - "MYTABLE"

CREATE TABLE "MyTable"
can be used as:
"MyTable" only

CREATE TABLE "MYTABLE"
can be used as:
MyTable - MYTaBLE - "MYTABLE"


so, try
select first 10 * from My_Table
or
select first 10 * from MY_TABLE
instead.

Regards
Gary