Bugs item #802978, was opened at 2003-09-09 10:07 Message generated for change (Comment added) made by colemarcus You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=802978&group_id=22866
Category: JBossCMP Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: Klebermass Martin (colemarcus) Assigned to: Heiko W.Rupp (pilhuhn) Summary: mysql database name in sql-query not encoded Initial Comment: When using Database Names like abc-def using this database ( or table or field name) in the sql statement without ` arround it, causes a mysql query error. The simplest solution would be to put ` arroung every databasename,tablename and fieldname. example: using the database name w10222-test i got a show table w10222-test as 'blabla' send to the mysql server. Martin [EMAIL PROTECTED] ---------------------------------------------------------------------- >Comment By: Klebermass Martin (colemarcus) Date: 2003-10-03 17:56 Message: Logged In: YES user_id=129118 for more Information about Legal Names for tables,DBs etc have a look at http://www.mysql.com/doc/en/Legal_names.html ---------------------------------------------------------------------- Comment By: Heiko W.Rupp (pilhuhn) Date: 2003-09-26 17:21 Message: Logged In: YES user_id=217112 I'll have a look at it. ---------------------------------------------------------------------- Comment By: Klebermass Martin (colemarcus) Date: 2003-09-26 17:14 Message: Logged In: YES user_id=129118 Well i am sure that it is allowed in mysql. well first it works and second, a few days ago i submitted another bug concerning dashes in the name to mysql , and at the moment they are fixing it ( or at least one of the developer sayed that that problem will be fixed). ---------------------------------------------------------------------- Comment By: Heiko W.Rupp (pilhuhn) Date: 2003-09-26 17:04 Message: Logged In: YES user_id=217112 I am currently not sure if database names with dashes in them are correct sql even if mysql allows them. So I am not sure, if this should be supported or not. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=802978&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
