user() is a function.
[EMAIL PROTECTED] wrote:
>> Description:
>
> I try to run mysql in conjunction with Apple WebObjects5 (the
>EnterpriseObjects Framework).
> This framework generates certain SQL Statements which fail (see How-To-Repeat).
>
>
>> How-To-Repeat:
>
> Ok first the "positive test":
>
> create table test ( name varchar(255), test_id varchar(255));
> insert into test(name, test_id) values ('1','2');
>
> The above works without flaws..
>
> The "negative test":
>
> mysql> create table user (
> address int not null,
> email varchar(255) not null,
> first_name varchar(255) not null,
> last_name varchar(255) not null,
> login varchar(255) not null,
> pwd varchar(255) not null,
> state int not null,
> user_id int not null primary key);
>
> insert into user(address, email, first_name, last_name, login, pwd, state,
>user_id) values (1,'a','a','a','a','a',1,1);
>
> The above statement returns:
>
> ERROR 1064: You have an error in your SQL syntax near 'user(address, email,
>first_name, last_name, login,
> pwd, state, user_id) values (' at line 1
>
> When I insert a whitespace between the tablename and the "(" everything works
>fine.
> In the "positive test" it works without whitespace...
>
>
>> Fix:
>
>
>
>
>> Submitter-Id: <submitter ID>
>> Originator:
>> Organization:
>
>
>
>> MySQL support: none
>> Synopsis: SQL Parser woes
>> Severity: non-critical
>> Priority: medium
>> Category: mysql
>> Class: sw-bug
>> Release: mysql-3.23.39 (Source distribution)
>> Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.39, for apple-darwin1.3.3
>on powerpc
>
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version 3.23.39
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 1 day 3 hours 12 min 32 sec
>
> Threads: 1 Questions: 95 Slow queries: 0 Opens: 26 Flush tables: 1 Open tables:
>4 Queries per second avg: 0.001
>
>> Environment:
>
>
> System: Darwin localhost 1.3.7 Darwin Kernel Version 1.3.7: Sat Jun 9 11:12:48 PDT
>2001; root:xnu/xnu-124.13.obj~1/RELEASE_PPC Power Macintosh powerpc
>
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/2.95.2/specs
> Apple Computer, Inc. version gcc-926, based on gcc version 2.95.2 19991024 (release)
> Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
> LIBC:
>
>
> lrwxr-xr-x 1 root wheel 15 Jul 14 00:11 /usr/lib/libc.dylib -> libSystem.dylib
> Configure command: ./configure --mandir=/usr/local/share/man/ --with-innodb
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
