[dugshnay]

This is MyEclipse 5.0 (build 20060810-5.0.1-GA) with Sybase (11.5) using jconnect 5.5 or 6.0 drivers.

This does not occur with MyEclipse 4.1 using the same database and drivers.

When choosing a table in the database explorer and selecting Generate->Select Statement, the generated statement is constructed with square brackets surrounding the database name. This results in a syntax error while trying to execute.

I can remove these in generated sql, but it also affects the “Preview” panel, in which I haven’t been able to find a way to work around.

Is this a bug, or is there something I can change/configure that I have not yet found that will make this work properly?

Thanks.

Doug

[dugshnay]

Just for reference, here’s an example:

select
task_name
from
[DB_ONE].dbo.task

The [ breaks things.

[Haris Peco]

Doug,

We have tested on sybase 12.5 and this query works fine in this database.Syntax [] is introduced, because problems with special character in catalog name (for example, catalog ‘CAT-MY’).I will file PR for this and we will fix it in next release

Thank you for feedback and sorry for the inconvenience caused.

Best
Peco

[Author]

Posts