|
Re: Error create data set with computed column [message #207159 is a reply to message #206967] |
Mon, 18 December 2006 20:47 ![Go to previous message Go to previous message](theme/Solstice/images/up.png) |
|
Take a look at https://bugs.eclipse.org/bugs/show_bug.cgi?id=160724
Jason
"Sergey A. Lisovoy" <s.lisovoy@spb.solidworks.ru> wrote in message
news:em5s2l$lmj$1@utils.eclipse.org...
>I try to create simple query with computed column like folowing:
>
> select o.InsertTime/1000 myValue
> from orders o
>
> And I got an error:
>
> A BIRT exception occurred.
> Plug-in Provider:Eclipse.org
> Plug-in Name:BIRT Data Engine
> Plug-in ID:org.eclipse.birt.data
> Version:2.1.1.v20060922-1058
> Error Code:odaconsumer.CannotGetResultSetMetaData
> Error Message:Cannot get the result set metadata.
> SQL statement does not return a ResultSet object.
> SQL error #1: General error, message from server: "Unknown table 'o' in
> field list"
>
> Its query successfully selects data in mysql console on the same database.
>
> PS. Eclipse 3.2.1, BIRT 2.1.1.v20060926-0959
|
|
|
Powered by
FUDForum. Page generated in 0.04671 seconds