Re: 5.1.44 community version select ordno>=' ' error (2)

In the last episode (Mar 04), wang shuming said: > select * from t1 > > ordno qty > 1 > 3 > 5 > 'aaa' 18 > 'b' 20 Are your first three rows really blank, or are there nonprintable characters in 'ordno' that aren't showing up here? You need to provi

5.1.44 community version select ordno>=' ' error (2)

Hi, select * from t1 ordno qty 1 3 5 'aaa' 18 'b' 20 select * from t1 where ordno=' ' or ordno>' ' ordno qty 1 3 5 'aaa' 18 'b' 20 select * from t1 where ordno>=' ' ordno qty 'aaa' 18 'b'

RE: Full Text Searches

>-Original Message- >From: mos [mailto:mo...@fastmail.fm] >Sent: Wednesday, March 03, 2010 5:14 PM >To: mysql@lists.mysql.com >Subject: Tip: Full Text Searches > >Something I didn't realize about full text searches, but they can be used >with multi-table views! >Maybe I'm the last one on th

Tip: Full Text Searches

Something I didn't realize about full text searches, but they can be used with multi-table views! Maybe I'm the last one on the planet to discover this, but I think this is really neat. For example, I can create a view with all the fulltext index column of the customer table (name, address, cu

Re: Re bug#45458

I believe the optimizer does know that InnoDB has a clustered primary key, because ha_innobase::primary_key_is_clustered returns true On Wed, Mar 3, 2010 at 2:22 PM, Gavin Towey wrote: > Yes, but the optimizer doesn't know that. > > -Original Message- > From: vegiv...@gmail.com [mailto:ve

RE: Re bug#45458

Yes, but the optimizer doesn't know that. -Original Message- From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Wednesday, March 03, 2010 6:16 AM To: Zardosht Kasheff Cc: Jonas Oreland; mysql@lists.mysql.com Subject: Re: Re bug#45458 Unless I'm very

Re: Re bug#45458

Unless I'm very much mistaken, InnoDB tables always have a clustered index as their primary key. On Wed, Mar 3, 2010 at 2:58 PM, Zardosht Kasheff wrote: > Hello Jonas, > > Thank you for filing this feature request. Are there plans to add > support for clustered indexes in MySQL soon? This is som

Re: Re bug#45458

Hello Jonas, Thank you for filing this feature request. Are there plans to add support for clustered indexes in MySQL soon? This is something I have been researching on and off for a while now. Here are my thoughts. It seems that there are two parts to this feature request: 1) a new flag that all

Re: Remove 'debian-sys-maint' Account?

On Tue, Mar 2, 2010 at 7:15 PM, Carlos Williams wrote: > I am using Debian 'Squeeze' / Testing on with MySQL 5.1.41-3 > installed. It is a fresh install and I was checking all the system > accounts and noticed that Debian has a 'debian-sys-maint' account on > 'localhost'. Has anyone ever removed t

Re: Remove 'debian-sys-maint' Account?

Hi ALL, You will find all the details you need to set up debian-sys-maint account under /etc/mysql/debian.cnf GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLIC

Re bug#45458

Hi, I just filed http://bugs.mysql.com/bug.php?id=51687 which is very related to your bug#45458. If you would care to look at it and provide feedback, I would appreciate it. /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mys

Re: Remove 'debian-sys-maint' Account?

Hi Carlos, The debian-sys-maint account is used for two things that I am aware of: 1) the /etc/init.d/mysql stop command uses it to perform a controlled shutdown of MySQL. 2) on execution of /etc/init.d/mysql start, it uses this account to run a CHECK TABLE on all of your tables The first funct