List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 17 2001 2:22pm
Subject:Re: SQL Parser woes
View as plain text  
user() is a function.

sascha@stripped 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 <mysql-thread79792@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
SQL Parser woessascha16 Jul
  • Re: SQL Parser woesGerald Clark17 Jul