Seeking contribution for MySQL Quality Assurance

Hi, all. MySQL is about to launch yet another contribution project. We are still in the planning phase, and I have outlined the issue in this article: http://datacharmer.blogspot.com/2006/10/contributing-to-mysql-qa-ideas-wanted.html Comments welcome! Giuseppe -- Giuseppe Maxia, QA Developer

Instance manager and starting instances on demand

When setting up several instances in the instance manager, if you don't want them all to start at once, but you want to start instances on demand (like when you have instances of different MySQL versions) the only way I found to achieve this goal is is to set the option nonguarded. Then, when

Re: Getting every other value in a select

[EMAIL PROTECTED] wrote: This might be a bit odd, but here we go.. I have some data in a table that has the following structure: [SNIP] The data is logged once a second. The StartTimeAndDate will be the same for the particular workpiece that I am interested in. I pull out the data

puzzled by date functions (long)

Yesterday I was analyzing the behavior of the query optimizer, and I stumbled into a most curious case. I created two functions returning the extremes of a date range, and I wanted to see how many times those functions were called when used in a WHERE clause So I added log tracing instructions

Re: subquery fails when a NOT IN operator tests a subset with NULL valu

Dan Nelson wrote: In the last episode (Mar 16), Giuseppe Maxia said: Here is a description of what looks like a serious bug. This is related to bugs #7294 and #6247 Tested against mysql 4.1.9 and 4.1.10. Description: operator NOT IN fails when a subquery returns one or more NULL values. How

Re: subquery fails when a NOT IN operator tests a subset with NULL valu

the values using '=' and correctly returns NULL if any value is NULL ie missing, eg for Oracle see http://builder.com.com/5100-6388_14-5319615.html I see now that this mechanism is intentional. Thanks for your link. Giuseppe -- Giuseppe Maxia CTO http://www.StarData.it MySQL Certified Professional

subquery fails when a NOT IN operator tests a subset with NULL valu

Hi. Here is a description of what looks like a serious bug. This is related to bugs #7294 and #6247 Tested against mysql 4.1.9 and 4.1.10. Cheers Giuseppe Maxia Description: operator NOT IN fails when a subquery returns one or more NULL values. How-To-Repeat: simple proof

Error in NULLIF documentation

expr1 and expr2 were not equal. Fix: Correct the documentation Submitter-Id: submitter ID Originator:Giuseppe Maxia Organization: MySQL support: none Synopsis: error in documentation Severity: non-critical Priority: low Category: mysql Class: doc-bug

unable to drop table

I created a table with a buggy script. The name of the table is dbimport-import. drop table `dbimport-import`; # note: inverted quotes gmax - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Comparing an alias ...

is bigger than 10. Bye Giuseppe Maxia Hi ... I am need the following query to work : SELECT min(my_colum) as MINIMAL_VALUE WHERE MINIMAL_VALUE 10 The query is not EXACTLY as this one, but i think it is enough to get you the idea of my problem... Thnx for any help ! []~S julio

GUIfront-end in Linux?

/Database/MySQL_Navigator/mysqlnavigator-1.3.3.3.tar.gz It is not Mascon (BTW, they are planning a Linux version, but I don't know when), but it has a nice graphical interface. Giuseppe Maxia - Before posting, please check

How Auto_INCREMENT works

. or INSERT INTO tablename (f1, f2) VALUES (NULL, xyz); will have the same effect. The difference is that in the first example the null value is implicit, while in the second one it is explicit. Bye Giuseppe Maxia Or I understood wrong the auto_increment property? If so, then what should I do

affected rows and found rows

1), but only TWO will be affected, since one of the matching ones has already the value you wanted to enter. Hope it helps Giuseppe Maxia - Before posting, please check: http://www.mysql.com/manual.php (the manual

Problem creating primary key on blob column

ERROR 1170 : BLOB column 'MY COLUMN' used in key specification without a key length. What is the syntax to settle a key length ? ALTER TABLE your_table add key blob_field (blob_field(50)); Or, you can create a table like this one: CREATE TABLE `your_table` ( `id` int(10) unsigned NOT

a select n a regexp expression

. Giuseppe Maxia - 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

SOURCE command somewhere in manual?

Is there really a SOURCE command? Where is it in the official manual? source is a command available within the mysql client only. It is not a SQL command. The client can also get external batch files by piping the commands, in Unix style. Once you have your file of SQL instructions (say

Exporting Data

You can export using SELECT fieldlist INTO OUTFILE filename FROM table; This will create a file with tab separated fields. It is Excel default separator. Within Excel, you can open the file, by giving filetype text, and a wizard will guide you through the translation. You can create a CSV file

Re: Selling MySQL to Government

Hi, I have been through a similar case. I am working for a large organization, which had the Human Resources data scattered through seven different Access databases counting about 200K records. The challange was not only to migrate them, but also to unify into one armonized structure. I made

Re: Unique and case-insensitivity with indexes

12/11/2001 17:34:07, Fulko Hew [EMAIL PROTECTED] wrote: I am using mySQL 3.22.4a-beta yes, I know its old :-( I have just stumbled across a problem with how it treats 'uniqueness' in table contents. I have a table with a column defined as: create table test (name varchar(80) not null);

Re: How to Run SQL Commands from a Text File stably?

12/11/2001 05:32:28, PI Xu [EMAIL PROTECTED] wrote: Hi, Buddies: I used perl to run sql commands from a Text file, it always can't finish totally and report error in unstable lines . The error report that sql syntax error, but the syntax is same, just same, and many sql lines; Would you please