Re: ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!

2011-08-18 Thread Martijn Tonies
Hi all, No SQLite support? http://www.sqlite.org/ Seems curious you wouldn't have this yet, especially given its popularity on both embedded systems and Android to say the least. Indeed, no native SQLite support. Lots of other systems are popular and not supported. The reason for this is

Re: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-18 Thread Johan De Meersman
- Original Message - From: David Lerer dle...@us.univision.com Correct me if I am wrong, but my impression is that usage of DEFINER=user in stored procedures has no impact on runtime and is actually optional. (not to be confused with the clause SQL SECURITY INVOKER which is

RE: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-18 Thread David Lerer
Thanks Bier. I see what you mean. (As a rule we always use SQL SECURITY INVOKER) David. -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Thursday, August 18, 2011 4:20 AM To: David Lerer Cc: mysql@lists.mysql.com Subject: Re: Concerned : Developer getting

Re: Concerned : Developer getting There is no 'root'@'%' registered error message

2011-08-18 Thread Johan De Meersman
- Original Message - From: David Lerer dle...@us.univision.com Thanks Bier. I see what you mean. (As a rule we always use SQL SECURITY INVOKER) Both have their use, although I would very much prefer MySQL to default to INVOKER if not specified, instead of the extremely

Re: Extraneous warning 1292 (Incorrect datetime value)

2011-08-18 Thread Marius Feraru
Found at http://lists.mysql.com/mysql/225525 that hsv wrote on 12 Aug 2011: Function TIME yields a string, not any timestamp type, but d is of some such type. Unhappily, the HTML help that I downloaded is of no help in this case, when the result context has no type, unless it is supposed