A QBE bug!

I use this this sql to query data:

=================================================
SELECT otta.TRANSACTION_TYPE_ID AS "TYPE", otta.*
FROM OE_TRANSACTION_TYPES_ALL otta
=================================================

The QBE return this SQL:
=================================================
SELECT otta.TRANSACTION_TYPE_ID AS "TYPE", otta.*
FROM OE_TRANSACTION_TYPES_ALL otta
where type = 1003
=================================================

I found two bug in QBE:
1. The QBE use the "TYPE" column name in WHERE,
and the oracle return "ORA-00904 "TYPE": invalid identifier
error message.

2. I can't edit the SQL window anymore after Error.

the PL/SQL version is 6.0.2.880
 
Back
Top