BUG: ESQL: Error -19104 If Column, Table, or Alias Name Starts with CURRENT (191234)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q191234
BUG #: 17729 (SQLBUG_65)
SYMPTOMS
If the WHERE clause of a SELECT statement is followed by a column name, a
table name, or an alias that starts with "CURRENT", the precompilation will
fail with the following error:
Error code -19104
Incorrect SQL statement syntax.
This occurs only when using a SELECT statement (whether it is a SELECT INTO
or part of a DECLARE CURSOR statement). It does not occur when using a
DELETE or an UPDATE statement.
WORKAROUND
If an alias name starts with CURRENT, change the alias name so that it
does not begin with CURRENT.
If a table name or column name itself starts with CURRENT, use an alias.
(Do not use an alias that begins with CURRENT.)
Starting with SQL Server 7.0, you can use delimited identifiers:
select * from pubs [current] where [current].au_lname = 'White'
create table [current] (col1 int)
create table mytable([current] int)
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbpending KB191234 |
|---|
|