Archives of the TeradataForum
Message Posted: Wed, 08 Dec 2004 @ 17:10:22 GMT
| Subj: | | Re: SQL assistant 6.2 and Primary Key |
| |
| From: | | Dieter Noeth |
Haritha Aepala wrote:
| | The following SQL is not throwing an error when run from Sql assistant 6.2 | |
create table t1( i int, j int) primary key (i) ;
| | As far as I know it should throw a syntax error as PRIMARY KEY constraint cannot be defined like above. | |
ACK
| | BTEQ is throwing an error but Queryman is converting the column to NUPI. ( Primary key should be made as UPI but I could see it as
NUPI) | |
| | Is this a bug or am missing something here? | |
IMHO it's a bug because the ODBC driver modifies the SQL. From dbc.AccessLog:
CREATE TABLE t1 ( i INT , j INT ) PRIMARY INDEX ( i ) ;
If you uncheck
Tools -> Options -> Allow use of ODBC SQL Extensions in queries
it throws an error.
Dieter
| 
