|
| Paste in console |
Posted in 23th, 12/2005 03:28 by beware_the_matrix  |
Trying to past a query in console in free Firebird edition and it gets jumbled.
{example}
query to be pasted:
SELECT I.RDB$INDEX_NAME AS FKINDEXNAME,
I.RDB$RELATION_NAME AS TABLENAME,
S.RDB$FIELD_NAME AS FIELDNAME
FROM RDB$INDICES I
LEFT JOIN RDB$INDEX_SEGMENTS S ON (S.RDB$INDEX_NAME = I.RDB$INDEX_NAME)
WHERE I.RDB$RELATION_NAME =
AND (NOT EXISTS(SELECT 1
FROM RDB$RELATION_CONSTRAINTS R WHERE R.RDB$INDEX_NAME = I.RDB$INDEX_NAME))
Pasted results:
console> INDEX_NAME AS FKINDEXNAME, SELECT I.RDB$
> RELATION_NAME AS TABLENAME, I.RDB$
> INDICES IFROM RDB$
> INDEX_NAME) INDEX_NAME = I.RDB$INDICES IFROM RDB$S.RBD$
> RELATION_NAME = WHERE I.RDB$
> RELATION_NAME - WHERE I.RDB$SELECT 1
> INDEX_NAME))INDEX_NAME = I.RDB$RELATION_CONSTRATINTS R WHERE R.RDB$ FROM RDB$
MB34 / |
| Re: Paste in console |
Posted in 23th, 12/2005 03:58 by support  |
Hi,
Thanks for poiting that up. We will check this and fix it for the next release.
Best Regards,
Support / DBTools Software |
Legends
Topic has Replies
Topic With no Replies
|
|
|