>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