mysql >>Connector J 5.1.0 is Production ?

Connector J 5.1.0 is Production ?

Index ‹ mysql

Previous
- 1
 - Fulltext - stop words!?Hi!
 
 I'm running MySQL 4.0.13 and have problem with fulltext search.
 I have a column of type 'text' which I fulltext index.
 
 I want to search for an e-mail address but I don't get any matches.
 I assume characters like @ . are ignored (stop words).
 
 How can I create an index which contains e-mail addresses?
 Eg. How can I edit the list of stop words?
 Which are the current stop words?
 
 I'm running MySQL on both Windows and Linux.
 
 Best regards
 /Peter
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe: http://lists.mysql.com/mysql?unsub=email***@***.com
- 1
 - Importing MySQL in MS AccessHi,
 I'm building a shell script that store information in a MySQL 5.0
 database. One of the data I store in the table is a text file. I use a
 BLOB type for this text data.
 
 If I try to import it in MS Access 2002 the BLOB column is converted
 to a OLE type, but when I try to open it in access I get this error:
 
 "A problem occurred while Miscrosoft Access was communicating with the
 OLE server or ActiveX Control. Close the OLE server and restart it
 outside of Microsoft Access. Then try the original operation again in
 Microsoft Access."
 
 I know that it's because MS access doesn't know what type of object it
 is and with which program it should open it. But I don't know how I can
 tell access the type of object it is. Should I create a module to
 handle these objects? I'm new to access databases so I don't know where
 I should start. If someone has any tips or codes I should use please le
 me know.
 
 Should I use another type instead of BLOB?
 
 By the way the MySQL database is created from mysql command line inside
 a shell script.
 
 Thanks in advance
- 1
 - CONTRACT PAYMENT
 Attn : plz. Reply me through this e-mail address : email***@***.com
 
 IMMEDIATE CONTRACT PAYMENT.CONTRACT #:MAV/NNPC/FGN/MIN/009.
 
 From the records of outstanding contractors due for payment with the federal government of Nigeria your name and company was discovered as next on the list of the outstanding contractors who have not received their payments.
 
 I wish to inform you that your payment is being processed and will be released to you as soon as you respond to this letter.Also note that from my record in my file your outstanding contract payment is us$65.7 million dollars(sixty five million seven hundred thousand united states
 dollars).
 
 Please re-confirm to me if this is inline with what you have in your record and also re-confirm to me the followings
 
 1) Your full name.
 
 2) Phone, fax and mobile #.
 
 3) company name,position and address.
 
 4)profession, age and marital status.
 
 5) Copy of int'l passport.
 
 As soon as this informations are received, your payment will be made to you in a certified bank draft from central bank of Nigeria and a copy will be given to you for you to take to your bank and confirm it.
 
 You must call me on my direct number as soon as you receive this letter for a serious discussion with me and also get back to me on this e-mail email***@***.com
 
 Regards,
 
 PROF CHARLES SOLUDO.
 
 Executive Governor,Central Bank Of Nigeria.
 
 Direct line : 234-80-33595444.
 
 ___________________________________________________________________________
 Mail sent from WebMail service at PHP-Nuke Powered Site
 - http://www.akkuaria.com
- 2
 - MySQL & API C on DEVCPPI need to write a simple C program to pick up the input and then puts
 it into a MySQL database.
 Unfortunately the mysql API C, provided with the download edition,
 don't work on DEVCPP.
 Do you use this API on Win-32? by which compiler? Have you a simple C
 program that connect to a database MySQL?
 I've posted a message like it on sourceforce and a friend replied to
 me that I'd have to download a "DevPak". Where can I get it?
 Could You suggest to me a compiler that works with the API C of MySQL.
 Thanks
 Sergio
- 2
 - Problems with migration from 4.0.24 to 5.0.32 with unique varchar-----BEGIN PGP SIGNED MESSAGE-----
 Hash: SHA1
 
 Hi,
 
 I'm having trouble with the following:
 
 In the MySQL 4 database I had the following values in an unique varchar
 and there was no problem:
 
 Gross
 Gro?
 (the latter has the german sharp "s" character)
 
 Now whenever I import this into the MySQL5 database I get a duplicate
 key error; I tried the collcations utf8_bin and latin1_bin already
 (started out with latin1_german1 and latin1_german2).
 
 How can I solve this?
 
 thanks,
 - - Markus
 -----BEGIN PGP SIGNATURE-----
 Version: GnuPG v1.4.6 (MingW32)
 Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
 
 iD8DBQFF7XxV1nS0RcInK9ARAjNeAKDYU0y+Np0ssQt+bhpEwNb5jb7IWgCfZG1H
 AfEHWvhiwlrLlCmaEpcxZJ0=
 =O7H4
 -----END PGP SIGNATURE-----
- 4
 - Can you afford to lose 300.000 potential customers per year!?<HTML><HEAD><TITLE>New Page 1</TITLE>
 <META http-equiv=3DContent-Type content=3D"text/html; charset=3Dwindows-1252=
 ">
 <META content=3D"MSHTML 6.00.2462.0" name=3DGENERATOR>
 <META content=3DFrontPage.Editor.Document name=3DProgId></HEAD>
 <BODY>
 Can you=
 afford to loose 300,000 potential customers per year ?
 How wou=
 ld You like to divert 1000s of fresh, new visitors daily to Your web site=
 or affiliate web site from Google, Yahoo, MSN and others At $0 cost to y=
 ou...?
 Never s=
 een before! Brand new for 2007!
 <A href=3D"http://www.promote-biz.net/promo/instantbooste=
 r/">Click here </A>to visit my website 
 
 
 <A h=
 ref=3D"mailto:email***@***.com">Click here</A> to unsubscribe by se=
 nding email</BODY></HTML>
- 5
 - bk commit - mysqldoc tree (jon:1.2824)Below is the list of changes that have just been committed into a local
 mysqldoc repository of jon. When jon does a push these changes will
 be propagated to the main repository and, within 24 hours after the
 push, to the public repository.
 For information on how to access the public repository
 see http://www.mysql.com/doc/I/n/Installing_source_tree.html
 
 ChangeSet
 1.2824 05/04/06 21:13:27 email***@***.com +1 -0
 Fixed typo in Cluster chapter.
 
 Docs/manual.texi
 1.2661 05/04/06 21:13:22 email***@***.com +1 -1
 Fixed typo in Cluster chapter.
 (Oops, that "<" should have been a ">".)
 
 # This is a BitKeeper patch. What follows are the unified diffs for the
 # set of deltas contained in the patch. The rest of the patch, the part
 # that BitKeeper cares about, is below these diffs.
 # User: jon
 # Host: gigan.site
 # Root: /home/jon/bk/mysqldoc
 
 --- 1.2660/Docs/manual.texi 2005-04-06 11:47:36 +10:00
 +++ 1.2661/Docs/manual.texi 2005-04-06 21:13:22 +10:00
 @@ -71913,7 +71913,7 @@
 definition for the @code{CITY} table:
 
 @example
 - shell> mysqldump --add-drop-table world City < city_table.sql
 + shell> mysqldump --add-drop-table world City > city_table.sql
 @end example
 
 The resulting @file{city_table.sql} file will contain this table creation
 
 --
 MySQL Internals Mailing List
 For list archives: http://lists.mysql.com/internals
 To unsubscribe: http://lists.mysql.com/internals?unsub=email***@***.com
- 5
 - loading shared library errorHi,
 
 I installed MySQL++ to a local directory, but could not run the
 example code. What was I missing?
 
 [mysql++-3.0.3]$ ./configure --prefix=/home/my/Install
 [mysql++-3.0.3]$ make
 [mysql++-3.0.3]$ make install
 
 [mysql++-3.0.3]$ ./simple1
 ./simple1: error while loading shared libraries: libmysqlpp.so.3:
 cannot open shared object file: No such file or directory
 
 Thank you.
 
 Jim
 
 --
 MySQL++ Mailing List
 For list archives: http://lists.mysql.com/plusplus
 To unsubscribe: http://lists.mysql.com/plusplus?unsub=email***@***.com
- 7
 - UPDATE instead of DELETEHi all,
 is it possible to avoid deleting of a row when a DELETE query is
 executed? I want to UPDATE row (setting for example a boolean field)
 insted of deleting it.
 
 I can do this in Oracle and Postgres (with INSTEAD OF rule). Is it
 possible to do this in MySQL?
 
 Thank you in advance.
- 7
 - Newbie question, how do I respond to post?Hello,
 I feel stupid here... How do I respond to a specific post?
 I posted last night, I got a response... now I want to post a response to the
 response.
 Don't see a way to do that...
 Thanks,
 Lee
 
 **************
 Start the year off right. Easy ways to stay in shape.
 
 http://body.aol.com/fitness/winter-exercise?NCID=aolcmp00300000002489
- 9
 - Running two different binary .tar.gz versions
 Hi all.
 
 I have downloaded the statically linked binary,
 
 mysql-standard-5.0.18-linux-i686.tar.gz
 
 and got it working under the default prefix of
 /usr/local/mysql, with the RPM version installed as well.
 
 My problem is this. I would like to use the .tar.gz to
 install the next update in parallel with this version.
 
 i.e. two statically linked mysql binaries on the same
 machine, with the latest version for testing on a different
 port/socket/pid/datadir.
 
 Can you please include the version number of the
 distribution in the --prefix=xyz configure directive.
 
 So this version would be --prefix=/usr/local/mysql-5.0.18
 
 And the next version would be something like
 --prefix=/usr/local/mysql-5.0.20
 
 This would enable mysql users to then install the updated
 binary version along with the previous version.
 
 I could compile from source, but I would prefer not to, as
 it takes a while, and I'd rather use the .tar.gz binary
 provided by mysql.
 
 I'm sure other's would appreciate this option for installing
 mysql.
 
 TIA
 
 Keith Roberts
 
 In theory, theory and practice are the same;
 In practice they are not.
 
 --
 MySQL Internals Mailing List
 For list archives: http://lists.mysql.com/internals
 To unsubscribe: http://lists.mysql.com/internals?unsub=email***@***.com
- 13
 - Dynamic record sizes for HEAP engineHi All,
 
 I've implemented dynamic record sizes for Heap Engine.
 In a few words, if you have many large VARCHAR
 columns, the record will take much less memory now. So
 far, it works on my box and passes standard MySQL
 tests. I'm wrapping up the code and preparing it to
 commit back to MySQL.
 
 Please, review the design notes and let me know what
 you think about design. Please, take a look at the
 issues listed at the end as well. The text below
 covers some basics of the Heap Engine and explains how
 variable-size records are implemented.
 
 Thanks for providing this great product : )
 
 Igor
 
 === Here is the design notes ===
 
 /*
 MySQL Heap (Memory) tables keep data in arrays of
 fixed-size chunks.
 These chunks are organized into two groups of
 HP_BLOCK structures:
 - group1 contains indexes, with one HP_BLOCK per
 key (part of HP_KEYDEF)
 - group2 contains record data, with single
 HP_BLOCK for all records,
 referenced by HP_SHARE.recordspace.block
 
 While columns used in index are usually small, other
 columns in the table
 may need to accommodate larger data. Typically,
 larger data is placed into
 VARCHAR or BLOB columns. With actual sizes varying,
 Heap Engine has to support
 variable-sized records in memory. Heap Engine
 implements the concept of
 dataspace (HP_DATASPACE), which incorporates
 HP_BLOCK for the record data,
 and adds more information for managing
 variable-sized records.
 
 Variable-size records are stored in multiple
 "chunks", which means
 that a single record of data (database "row") can
 consist of multiple
 chunks organized into one "chain". HP_BLOCK contains
 chunks. In variable-size
 format, one record is represented as one or many
 chunks, depending on the actual
 data, while in fixed-size mode, one record is always
 represented as one chunk.
 The index structures would always point to the first
 chunk in the chain.
 
 At the time of table creation, Heap Engine attempts
 to find out if variable-size
 records are desired. If it determines that
 fixed-sized records are sufficient,
 it will always use one chunk per record and it will
 not allocate space for any
 chaining pointers inside the chunks. The text below
 explains how the
 decision is made.
 
 The first parameter involved in the decision process
 is HEAP_CHUNK_SIZE
 parameter of the table. If it is not specified, we
 assume that table should
 use fixed-size record format. HEAP_CHUNK_SIZE has to
 be able to cover
 space needed for all null bits and columns used as
 keys. In order to improve
 index search performance, Heap Engine needs to keep
 all null flags and all
 columns used as keys inside the first chunk of a
 chain. In particular,
 this means that all columns used as keys should be
 defined first in the table
 creation SQL. The length of data used by null bits
 and key columns is stored as
 fixed_data_length inside HP_SHARE. fixed_data_length
 will go beyond last
 key column if more fixed-length fields can fit into
 the first chunk.
 
 Variable-size records are necessary only in the
 presence of variable-size
 columns. Heap Engine will be looking for VARCHAR
 columns, which declare length
 of 64 or more. If no such columns are found, table
 will be switched to
 fixed-size format. You should always try to put such
 columns at the end of
 the table definition.
 
 Whenever data is being inserted or updated in the
 table, Heap Engine will
 calculate how many chunks are necessary. For insert
 operations, Heap Engine
 allocates new chain of chunks in the recordspace.
 For update operations
 it will modify length of the existing chain,
 unlinking unnecessary chunks
 at the end, or allocating and adding more if larger
 length is necessary.
 
 When writing data to chunks or copying data back to
 record, Heap Engine
 will first copy fixed_data_length of data using a
 single memcpy call.
 The rest of the columns are processed one-by-one.
 Non-VARCHAR columns
 are copied in their full format, while only
 VARCHAR's are copied based
 on their actual length. Any NULL values are skipped.
 
 The allocation and contents of the actual chunks
 varies between fixed and
 variable-size modes. Total chunk length is always
 aligned to the next
 sizeof(byte*). Here is fixed-size chunk:
 byte[] - capacity is chunk_dataspace_length, but
 at least sizeof(byte*) bytes.
 keeps actual data or pointer to the
 next deleted chunk.
 chunk_dataspace_length equals to full
 record length
 byte - status field (1 means "in use", 0 means
 "deleted")
 Variable size uses different format:
 byte[] - capacity is chunk_dataspace_length, but
 at least sizeof(byte*) bytes.
 keeps actual data or pointer to the
 next deleted chunk.
 chunk_dataspace_length is set according
 to table setup
 byte* - pointer to the next chunk in this
 chain, or NULL for the last chunk
 byte - status field (1 means "first", 0 means
 "deleted", 2 means "chained")
 
 When allocating a new chain of N chunks, Heap Engine
 will try to allocate chunks
 one-by-one, linking them as they become allocated.
 Allocation of a single chunk
 will attempt to reuse a deleted (freed) chunk. If no
 free chunks are available,
 it will attempt to allocate a new area inside
 HP_BLOCK. Freeing chunks will place
 them at the front of free list referenced by
 del_link in HP_DATASPACE. The newly
 freed chunk will contain reference to the previously
 freed chunk in its first
 sizeof(byte*) of the payload space.
 
 Here is open issues:
 1. It is not very nice to require people to keep
 key columns at the beginning
 of the table creation SQL. There are three
 proposed resolutions:
 a. Leave it as is. It's a reasonable limitation
 b. Add new HA_KEEP_KEY_COLUMNS_TO_FRONT flag to
 handler.h and make table.cpp
 align columns when it creates the table
 c. Make HeapEngine reorder columns in the chunk
 data, so that key columns
 go first. Add parallel HA_KEYSEG structures
 to distinguish positions
 in record vs. positions in the first chunk.
 Copy all data field-by-field
 rather than using single memcpy unless DBA
 kept key columns to the beginning.
 2. "Chunk" does not sound very pretty in some
 cases, like "chain of chunks".
 A different (supposedly better!) name is not
 necessary, but would be welcome.
 3. HEAP_CHUNK_SIZE is a new parameter in table
 definition SQL, please confirm it's OK
 4. More stats may need to be exposed to display
 effective table setup and stats,
 such as chunk_length, chunk_dataspace_length,
 average chain length, etc.
 5. Handling of multibyte VARCHAR contents needs to
 be verified
 6. heap_check_heap needs verify chained chunks,
 looking for issues such as orphans,
 cycles, and bad links. However, Heap Engine
 today does not do similar things
 even for free list.
 7. With new HP_DATASPACE allocation mechanism,
 BLOB will become increasingly simple
 to implement, but I may not have time for that.
 In one approach, BLOB data can
 be placed at the end of the same record. In
 another approach (which I prefer)
 BLOB data would have its own HP_DATASPACE with
 variable-size entries.
 8. In a more sophisticated implementation, some
 space can be saved even with all
 fixed-size columns if many of them have NULL
 value, as long as these columns
 are not used in indexes
 */
 
 ____________________________________________________________________________________
 Never miss a thing. Make Yahoo your home page.
 http://www.yahoo.com/r/hs
 
 --
 MySQL Internals Mailing List
 For list archives: http://lists.mysql.com/internals
 To unsubscribe: http://lists.mysql.com/internals?unsub=email***@***.com
- 15
 - [mysql] Text = Tinytext = MediumText = LongText?
 Hello everyone, hopefully a quick question: is there a functional
 difference between the various text field sizes other than size? For
 example if I wanted to could I run a FULLTEXT index against a LongText
 field?
 
 The collary is of course how good of an idea is this, assuming that MOST
 of the data isn't even long enough to fill a text field.
 
 Thanks,
 
 Craig
 --------------------------------------------------------
 This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.
- 15
 - backup challengeshello
 I am trying to backup my database and i get a strange prompt. dunno
 how to do it now.
 Enter password:
 Welcome to the MySQL monitor. Commands end with ; or \g.
 Your MySQL connection id is 24
 Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
 
 Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
 mysql> mysqldump -u root dbTorontoTrader <backup.sql
 ->
 
 As you can see above, i get a new prompt -> . what do i do.
 
 thanks
 
 seede
- 16
 - DBD::mysql timeout------=_NextPart_000_0011_01C49F08.0B15A860
 Content-Type: text/plain;
 charset="iso-8859-1"
 Content-Transfer-Encoding: quoted-printable
 
 Hello,
 
 I have a script that runs a series of summary queries. On the last =
 query, it is timing out, returning the message:=20
 
 DBD::mysql::st execute failed: Lost connection to MySQL server during =
 query at stats_tester.pl line 56.=20
 
 If run from the mysql prompt, the problem query takes about 31 =
 seconds. The column in question is a tinytext and it is indexed with =
 about 2 million rows.
 
 The script is only being run from the command line at the moment, so =
 it's not a server issue. I am using the default mysql-huge settings that =
 came with the install. Is there a param I can pass to the connect() to =
 make the script wait for longer before quitting?=20
 
 Thanks in advance for any help.
 
 Rob
 ------=_NextPart_000_0011_01C49F08.0B15A860--

Author

Message

dyego

Posted: 2007-4-17 2:42:47

Top

mysql, Connector J 5.1.0 is Production ? In my Connector/J Costumer Page the 5.1.0 is a Production release... and
the dev.mysql.com is ALPHA...

really ? JDBC 4.0 is ready to use in production enviroments ?

--

-------------------------------------------------------------------------
++ Dyego Souza Dantas Leal ++ Dep. Desenvolvimento -------------------------------------------------------------------------
E S C R I B A I N F O R M A T I C A
*** http://www.go-java.com/blog ***
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
-- ICQ : 1647350
$ look into "my eyes" Phone : +55 041 2106-1212

look: cannot open my eyes Fax : +55 041 3296-6640 -------------------------------------------------------------------------
Reply: email***@***.com

Index ‹ mysql

Next
- 1
 - Need help with one line insertI need to do a one line insert to a MySQL database from a Linux Shell.
 
 I have a program that collects data and I can do a one-line shell call
 after the data-update is finished. On this line I would like to send
 the data from the program to a MySQL database.
 
 The problem is that the program has all data in variables so I would
 like to do something like this (postlog = after update):
 
 postlog "insert var1, var2, var3 into database.table"
 
 Can this be done in only one line shell call (program limit) or do I
 have to write a script and pass variables?
 
 If it can be done, how...
 
 /Micke
- 2
 - MAX() and GROUP BY questionHello everybody
 Can you explain me please how to get the entire row where ID is maximum per given status_id
 Mysql 4.0.xx
 
 for example:
 
 id status_id name date
 6 3 name0 date0
 5 1 name1 date1
 7 4 name3 date3
 10 3 name2 date2
 
 If I execute
 
 SELECT MAX(id), status, name, date FROM table_name WHERE status=3 GROUP BY staus_id
 or
 SELECT MAX(id), status, name, date GROUP BY staus_id
 
 only id and status_id will be returned correctly, while name and date can well be from another row
 for example: 10 3 name0 date0
 
 Thanks a lot for any suggestions
 Yannis
- 3
 - Final Winning Notification
 --
 Dear Lucky Winner,
 
 We are pleased to inform you of the result of the just concluded
 annual finaldraws of UNITED KINGDOM NATIONAL PROGRAM. international programs.
 After this automated computer ballot, your e-mail address emerged as
 one of two winners in the category \\"A\\" You are therefore been
 approve to claim the sum of 1,000,000 (One Million Pounds Sterling) with the
 information below:
 
 Secret pin code x7pwyz2005
 Serial number 5368/02
 REF No: UK/9420X2/68
 TICKET No: 56475600545188
 BATCH No: 2005MJL-01
 LUCKY No: 887-13-865-37-10-83
 
 Contact Person: Mr.Owen Brown
 Telephone: {+44} 703 192 8130
 E-mail: email***@***.com
 
 (1) FULL NAME
 (2) FULL ADDRESS
 (3) NATIONALITY
 (4) DATE OF BIRTH
 (5) OCCUPATION
 (6) TELEPHONE NUMBER
 (7) SEX
 
 Mrs.Cindy Howard
 For UK National Lottery.
- 4
 - How to edit DB with mySQL?Hi,
 
 To create a new DB, do I have to use the "MySQL Administrator" ro the
 "MySQL Query Browser" ?
 
 Is there a "How to" to do that?
 
 Thank you!
 Marty
- 5
 - query optimization help pleasehello,
 i have a database where there is a main table, documents, and then a
 relationship table doc_topics with one entry for each topic into which
 a document falls. (any document may have an arbitrary number of
 topics, but always at least one.) this structure is repeated for other
 relationships such as doc_states, doc_types, et cetera. i want a query
 that uses one or more of the relationships as search criteria (example,
 return only documents with a doc_state entry of "NY"), but i need the
 query to return ALL of the states that document pertains to. my
 version of mysql does not support subqueries or exist clauses. a
 sample query is
 
 select distinct *, t2.topic_id as tid, t2.topic_desc as tdsc from
 cap_documents d, cap_doc_topics dt, cap_topics t, cap_doc_states ds
 left join cap_doc_topics dt2 on dt2.doc_id = d.doc_id left join
 cap_topics t2 on t2.topic_id = dt2.topic_id left join cap_doc_states
 ds2 on ds2.doc_id = d.doc_id where d.doc_id = dt.doc_id and dt.topic_id
 = t.topic_id and d.doc_id = dt2.doc_id and d.doc_id = ds.doc_id and
 d.doc_id = ds2.doc_id and d.display='Y' and match(d.doc_title,
 d.summary, t.topic_desc) against('medicare* ' IN BOOLEAN MODE) order by
 doc_year desc, d.doc_year desc, d.doc_title, d.author,
 d.author_first_name
 
 however, this query takes ten seconds or more to execute. output of
 explain is as follows:
 
 +-------+--------+-------------------------+---------+---------+--------------+------+----------------------------------------------+
 | table | type | possible_keys | key | key_len | ref
 | rows | Extra |
 +-------+--------+-------------------------+---------+---------+--------------+------+----------------------------------------------+
 | d | ref | PRIMARY,display | display | 1 | const
 | 51 | Using where; Using temporary; Using filesort |
 | ds | ref | PRIMARY,doc_id | PRIMARY | 8 |
 d.doc_id | 1 | Using index |
 | ds2 | ref | PRIMARY,doc_id | PRIMARY | 8 |
 d.doc_id | 1 | Using where; Using index |
 | dt | ref | PRIMARY,doc_id,topic_id | PRIMARY | 8 |
 d.doc_id | 3 | Using index |
 | dt2 | ref | PRIMARY,doc_id | PRIMARY | 8 |
 d.doc_id | 3 | Using where; Using index |
 | t2 | eq_ref | PRIMARY | PRIMARY | 8 |
 dt2.topic_id | 1 | |
 | t | eq_ref | PRIMARY | PRIMARY | 8 |
 dt.topic_id | 1 | Using where |
 +-------+--------+-------------------------+---------+---------+--------------+------+----------------------------------------------
 
 i have indices in place, and all the join fields are the same type and
 size in each table.
 
 any help PLEASE ?
 
 thanks,
 -k
- 6
 - do you have your Degree? upa
 --F0_D0.DB.BEEC
 Content-Type: text/html;
 Content-Transfer-Encoding: quoted-printable
 
 <HTML>
 <HEAD>
 <BODY bgColor=3D#ffffff topMargin=3D0>
 <DIV align=3Dcenter> 
 <TABLE borderColor=3D#000000 cellSpacing=3D0 cellPadding=3D2
 width=3D650 border=3D1>
 <TBODY>
 <TR>
 <TD>
 <TABLE cellSpacing=3D0 cellPadding=3D4 width=3D650
 align=3Dcenter border=3D0>
 <TBODY>
 <TR>
 <TD bgColor=3D#003366>. U N I V E R S I T Y
 D I P L O M A S
 .</TD></TR>
 <TR>
 <TD vAlign=3Dcenter bgColor=3D#000000 height=3D40>
 <DIV align=3Dcenter>Do you want a
 prosperous future,
 increased money earning power, and the
 respect of
 all? </DIV></TD></TR>
 <TR>
 <TD bgColor=3D#cc0033>
 <DIV align=3Dcenter>
 We can assist with Diplomas from
 prestigious non-accredited
 universities based on your present
 knowledge and life
 
 experience.</DIV></TD></TR>
 <TR>
 <TD background=3D"">
 <DIV align=3Dcenter> No
 required tests, classes, books,
 or interviews. </DIV>
 Bachelors, masters, MBA, and
 doctorate (PhD) diplomas
 available in the field of your choice -
 that's right, you can become
 a Doctor and receive all the benefits and
 admiration that comes with
 it!
 No
 one is turned
 down.
 Confidentiality
 assured </TD></TR>
 <TR>
 <TD bgColor=3D#000000>
 <DIV align=3Dcenter>
 CALL US 24 HOURS A DAY, 7
 DAYS A
 WEEK
 (including
 Sundays and
 holidays):
 1-646-304-8665 </DIV></TD></TR>
 <TR>
 <TD bgColor=3D#003366>
 <DIV align=3Dcenter>Contact us NOW to
 receive your diploma
 within days, and start improving your
 life!</DIV></TD></TR></TBODY></TABLE></TD></TR></TBODY>=
 </TABLE></DIV></BODY></HTML>tddaszwnzazog rr ntpdxwrebvbuv wkfz ptsyfzes
 
 --F0_D0.DB.BEEC--
- 7
 - bk commit - mysqldoc tree (paul:1.2580)Below is the list of changes that have just been committed into a local
 mysqldoc repository of paul. When paul does a push these changes will
 be propagated to the main repository and, within 24 hours after the
 push, to the public repository.
 For information on how to access the public repository
 see http://www.mysql.com/doc/I/n/Installing_source_tree.html
 
 ChangeSet
 1.2580 05/02/21 12:40:47 email***@***.com +1 -0
 manual.texi:
 Additional information about UCA.
 Information about Spanish collations.
 
 Docs/manual.texi
 1.2380 05/02/21 12:40:24 email***@***.com +17 -5
 Additional information about UCA.
 Information about Spanish collations.
 
 # This is a BitKeeper patch. What follows are the unified diffs for the
 # set of deltas contained in the patch. The rest of the patch, the part
 # that BitKeeper cares about, is below these diffs.
 # User: paul
 # Host: frost.snake.net
 # Root: /Volumes/frost2/MySQL/bk/mysqldoc
 
 --- 1.2379/Docs/manual.texi 2005-02-21 10:53:53 -06:00
 +++ 1.2380/Docs/manual.texi 2005-02-21 12:40:24 -06:00
 @@ -43951,9 +43951,6 @@
 texts in about 650 languages using these character sets. We have
 added several collations for these two new sets, with more to come.
 
 -@c Currently, the @code{ucs2_unicode_ci} collation has only partial support
 -@c for the Unicode Collation Algorithm. Some characters are not supported yet.
 -
 @itemize @bullet
 
 @item @code{ucs2} (UCS-2 Unicode) collations:
 @@ -44011,6 +44008,14 @@
 @uref{http://www.unicode.org/reports/tr10/}.
 The collation uses the default UCA weight keys:
 @uref{http://www.unicode.org/Public/UCA/latest/allkeys.txt}.
 +(The following discussion uses @code{utf8_unicode_ci}, but it is also
 +true for @code{ucs2_unicode_ci}.)
 +
 +Currently, the @code{utf8_unicode_ci} collation has only partial support for
 +the Unicode Collation Algorithm. Some characters are not supported yet.
 +Also, combining marks are not fully supported. This affects primarily
 +Vietnamese and some minority languages in Russia such as Udmurt, Tatar,
 +Bashkir, and Mari.
 
 The most significant feature in @code{utf8_unicode_ci} is that it supports
 expansions, that is, when one character compares equal to several characters.
 @@ -44065,6 +44070,13 @@
 @"U = Y < @"O
 @end example
 
 +The @code{utf8_spanish_ci} and @code{utf8_spanish2_ci} collations correspond
 +to modern Spanish and traditional Spanish, respectively. In both
 +collations, @samp{@~n} (n-tilde) is a separate letter between @samp{n} and
 +@samp{o}. In addition, for traditional Spanish, @samp{ch} is a separate
 +letter between @samp{c} and @code{d}, and @samp{ll} is a separate letter
 +between @samp{l} and @samp{m}
 +
 
 @node Charset-we-sets, Charset-ce-sets, Charset-Unicode-sets, Charset-charsets
 @subsection West European Character Sets
 @@ -44147,8 +44159,8 @@
 
 @end itemize
 
 -In the @code{latin1_spanish_ci} collation, @samp{@~N} (N-tilde) is a
 -separate letter between @samp{N} and @samp{O}.
 +In the @code{latin1_spanish_ci} collation, @samp{@~n} (n-tilde) is a
 +separate letter between @samp{n} and @samp{o}.
 
 @item @code{macroman} (Mac West European) collations:
 @itemize
 
 --
 MySQL Internals Mailing List
 For list archives: http://lists.mysql.com/internals
 To unsubscribe: http://lists.mysql.com/internals?unsub=email***@***.com
- 8
 - *****SPAM***** wardroomThis is a multi-part message in MIME format.
 
 ------------=_3FCA3B9E.F95806AD
 Content-Type: text/plain
 Content-Disposition: inline
 Content-Transfer-Encoding: 8bit
 
 Spam detection software, running on the system "DcMg.NCTU.edu.tw", has
 identified this incoming email as possible spam. The original message
 has been attached to this so you can view it (if it isn't spam) or block
 similar future email. If you have any questions, see
 the administrator of that system for details.
 
 Content preview: VIBRATORS ARE A GIRLS BEST FRIEND! THEY WILL MAKE HER
 CUM OR YOUR MONEY BACK! THE BEST 2 VIBRATORS ON THE MARKET! Jack Rabbit
 and Pocket Rocket Can be all yours! [...]
 
 Content analysis details: (21.4 points, 10.0 required)
 
 pts rule name description
 ---- ---------------------- --------------------------------------------------
 4.4 DATE_SPAMWARE_Y2K Date header uses unusual Y2K formatting
 1.1 BANG_GUARANTEE BODY: Something is emphatically guaranteed
 1.2 GUARANTEED_STUFF BODY: Guaranteed Stuff
 0.7 ALL_CAP_PORN BODY: Possible porn - in ALL CAPS
 1.1 GUARANTEED_100_PERCENT BODY: One hundred percent guaranteed
 0.7 HTML_TABLE_THICK_BORD BODY: HTML table has thick border
 0.1 LINES_OF_YELLING_2 BODY: 2 WHOLE LINES OF YELLING DETECTED
 0.1 HTML_FONTCOLOR_BLUE BODY: HTML font color is blue
 0.1 MIME_HTML_ONLY BODY: Message only has text/html MIME parts
 0.0 HTML_MESSAGE BODY: HTML included in message
 0.1 HTML_FONT_BIG BODY: HTML has a big font
 0.0 LINES_OF_YELLING BODY: A WHOLE LINE OF YELLING DETECTED
 0.7 MIME_HTML_NO_CHARSET RAW: Message text in HTML without charset
 0.8 REMOVE_PAGE URI: URL of page called "remove"
 1.6 FORGED_MUA_OUTLOOK Forged mail pretending to be from MS Outlook
 1.1 FORGED_OUTLOOK_TAGS Outlook can't send HTML in this format
 4.3 OBFUSCATING_COMMENT HTML comments which obfuscate text
 1.2 MISSING_MIMEOLE Message has X-MSMail-Priority, but no X-MimeOLE
 0.0 UPPERCASE_25_50 message body is 25-50% uppercase
 1.1 FORGED_OUTLOOK_HTML Outlook can't send HTML message only
 1.1 MIME_HTML_ONLY_MULTI Multipart message only has text/html MIME parts
 
 The original message was not completely plain text, and may be unsafe to
 open with some email clients; in particular, it may contain a virus,
 or confirm that your address can receive spam. If you wish to view
 it, it may be safer to save it to a file and open it with an editor.
 
 ------------=_3FCA3B9E.F95806AD
 Content-Type: message/rfc822; x-spam-type=original
 Content-Description: original message before SpamAssassin
 Content-Disposition: attachment
 Content-Transfer-Encoding: 8bit
 
 X-Envelope-From: <email***@***.com>
 X-Envelope-To: <email***@***.com>
 Received: from lsanca1-ar21-4-63-027-248.lsanca1.dsl-verizon.net (lsanca1-ar21-4-63-027-248.lsanca1.dsl-verizon.net [4.63.27.248]) by DcMg.NCTU.edu.tw;
 Received: from [136.61.227.161]
 by lsanca1-ar21-4-63-027-248.lsanca1.dsl-verizon.net with ESMTP id 6407A632F72;
 Sun, 30 Nov 2003 17:43:44 -0100
 Message-ID: <5-27da88-f9$3j60-$bd$2rd@l6u2qr>
 From: "Nellie Corcoran" <email***@***.com>
 Reply-To: "Nellie Corcoran" <email***@***.com>
 To: <email***@***.com>
 Subject: wardroom
 Date: Sun, 30 Nov 03 17:43:44 GMT
 X-Mailer: Microsoft Outlook Express 6.00.2600.0000
 MIME-Version: 1.0
 Content-Type: multipart/alternative;
 boundary="_330731461D"
 X-Priority: 3
 X-MSMail-Priority: Normal
 
 --_330731461D
 Content-Type: text/html;
 Content-Transfer-Encoding: quoted-printable
 
 <html><base target=3D"_blank"><body><center><table width=3D"85=
 %" height=3D"85" border=3D"0"><tr><td bgcolor=3D"#339966"><div align=3D"ce=
 nter">VIBRATORS ARE A GIRLS BEST FRIEND! THEY WILL MAKE HER CUM OR YOUR MONEY BACK!</div></td></tr><tr><td bgcolor=3D"#EAEAFF">THE B=
 EST 2 VIBRATORS ON THE MARKET!</td></tr><tr><td bgcolor=3D"#EAEAFF"=
 ><ul><li>Jack Rabbit and Pocket Rocket Can be all yours!</li><li>These vibrators will give you an orgasm! <a href=3D"http://www.car-co.com/main2.php?rx=3D1605=
 5">100% GUARANTEED</a></li=
 ><li>Your satisfaction is Guaranteed! or your money back!</li><l=
 i>Click for det<!=
 --easel-->ails on worldwide overnight shipment.</li></ul></td></tr><tr><td bgco=
 lor=3D"#EAEAFF"><table width=3D"95" height=3D"25" border=3D"4" align=3D"ce=
 nter"><tr><td bgcolor=3D"#339966"><a href=3D"http://ww=
 w.car-co.com/main2.php?rx=3D16055">Order Here</a></td></tr></table></td></tr></tab=
 le> </center> <a href=3D"h=
 ttp://www.jumbolove.com/rm/remove.php">no more please!</a> </p=
 > </body></html>
 
 --_330731461D--
 
 ------------=_3FCA3B9E.F95806AD--
- 9
 - how to use index with order by hereHi, im having troubles with one query, hope someone can help.
 
 on this table:
 
 messages:
 id_from int(10)
 id_to int(10)
 text varchar(1000)
 time
 
 with index on id_form and id_to
 
 i want to get messages sent from one user to another and vice versa order by
 time.
 let say we want to search messages between user 1 and 2:
 i'm doing:
 
 SELECT *
 FROM messages
 WHERE id_from in (1,2)
 AND id_to in (1,2)
 ORDER BY time
 
 but that gives me a filesort in all rows matching the where clause, and
 thats not good. I tried by indexing id_from, id_to, time but thats not
 working of course.
 
 any help would be really appreciate.
- 10
 - mysql BUG, again ;)Hi,
 
 I would like to know if you could fix the bug I reported to you
 some days ago.
 
 The error is: "ERROR 1030: Got error 139 from table handler" after
 running an update command using several blobs.
 
 Now I am using mySql 4.0.15 and Linux. If you try to do the same
 with mySql 4.0.14, the record that is updated is simple deleted.
 
 My System is a Debian Linux box , with kernel 2.4.20 with 768 of RAM
 using InnoDB tables ;)
 
 InnoDB,MyISAM,SQL
 
 -------------------------------------------------------------------------
 ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
 -------------------------------------------------------------------------
 E S C R I B A I N F O R M A T I C A
 -------------------------------------------------------------------------
 The only stupid question is the unasked one (somewhere in Linux's HowTo)
 Linux registred user : #230601
 -- ICQ : 1647350
 $ look into "my eyes" Phone : +55 041 296-2311
 look: cannot open my eyes Fax : +55 041 296-6640
 -------------------------------------------------------------------------
 Reply: email***@***.com
 
 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe: http://lists.mysql.com/mysql?unsub=email***@***.com
- 11
 - mysqldump restore db syntaxMany thanks to you :)
- 12
 - bk commit into 4.0 tree (igor:1.2082) BUG#8669Below is the list of changes that have just been committed into a local
 4.0 repository of igor. When igor does a push these changes will
 be propagated to the main repository and, within 24 hours after the
 push, to the public repository.
 For information on how to access the public repository
 see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html
 
 ChangeSet
 1.2082 05/03/09 00:15:51 email***@***.com +3 -0
 func_str.result, func_str.test:
 Added a test case for bug #8669.
 item_strfunc.cc:
 Fixed bug #8669.
 Function AES_DECRYPT can return NULL value.
 
 mysql-test/r/func_str.result
 1.33 05/03/09 00:15:26 email***@***.com +15 -0
 Added a test case for bug #8669.
 
 mysql-test/t/func_str.test
 1.33 05/03/09 00:14:54 email***@***.com +17 -0
 Added a test case for bug #8669.
 
 sql/item_strfunc.cc
 1.85 05/03/09 00:13:35 email***@***.com +1 -0
 Fixed bug #8669.
 Function AES_DECRYPT can return NULL value.
 
 # This is a BitKeeper patch. What follows are the unified diffs for the
 # set of deltas contained in the patch. The rest of the patch, the part
 # that BitKeeper cares about, is below these diffs.
 # User: igor
 # Host: rurik.mysql.com
 # Root: /home/igor/dev/mysql-4.0-0
 
 --- 1.84/sql/item_strfunc.cc Mon Mar 7 07:55:55 2005
 +++ 1.85/sql/item_strfunc.cc Wed Mar 9 00:13:35 2005
 @@ -208,6 +208,7 @@
 void Item_func_aes_decrypt::fix_length_and_dec()
 {
 max_length=args[0]->max_length;
 + maybe_null= 1;
 }
 
 --- 1.32/mysql-test/r/func_str.result Tue Feb 1 18:28:33 2005
 +++ 1.33/mysql-test/r/func_str.result Wed Mar 9 00:15:26 2005
 @@ -304,3 +304,18 @@
 'A'
 'A'
 DROP TABLE t1;
 +CREATE TABLE t1 (id int PRIMARY KEY, str char(255) NOT NULL);
 +CREATE TABLE t2 (id int NOT NULL UNIQUE);
 +INSERT INTO t2 VALUES (1),(2);
 +INSERT INTO t1 VALUES (1, aes_encrypt('foo', 'bar'));
 +INSERT INTO t1 VALUES (2, 'not valid');
 +SELECT t1.id, aes_decrypt(str, 'bar') FROM t1, t2 WHERE t1.id = t2.id;
 +id aes_decrypt(str, 'bar')
 +1 foo
 +2 NULL
 +SELECT t1.id, aes_decrypt(str, 'bar') FROM t1, t2 WHERE t1.id = t2.id
 +ORDER BY t1.id;
 +id aes_decrypt(str, 'bar')
 +1 foo
 +2 NULL
 +DROP TABLE t1, t2;
 
 --- 1.32/mysql-test/t/func_str.test Tue Feb 1 18:27:45 2005
 +++ 1.33/mysql-test/t/func_str.test Wed Mar 9 00:14:54 2005
 @@ -198,3 +198,20 @@
 CREATE TABLE t1 SELECT 1 UNION SELECT 2 UNION SELECT 3;
 SELECT QUOTE('A') FROM t1;
 DROP TABLE t1;
 +
 +#
 +# Test case for bug #8669: null aes_decrypt result in order by query
 +#
 +
 +CREATE TABLE t1 (id int PRIMARY KEY, str char(255) NOT NULL);
 +CREATE TABLE t2 (id int NOT NULL UNIQUE);
 +INSERT INTO t2 VALUES (1),(2);
 +INSERT INTO t1 VALUES (1, aes_encrypt('foo', 'bar'));
 +INSERT INTO t1 VALUES (2, 'not valid');
 +
 +SELECT t1.id, aes_decrypt(str, 'bar') FROM t1, t2 WHERE t1.id = t2.id;
 +SELECT t1.id, aes_decrypt(str, 'bar') FROM t1, t2 WHERE t1.id = t2.id
 + ORDER BY t1.id;
 +
 +DROP TABLE t1, t2;
 +
 
 --
 MySQL Internals Mailing List
 For list archives: http://lists.mysql.com/internals
 To unsubscribe: http://lists.mysql.com/internals?unsub=email***@***.com
- 13
 - bk commit - mysqldoc@docsrva tree (paul:1.3354)Below is the list of changes that have just been committed into a local
 mysqldoc repository of paul. When paul does a push these changes will
 be propagated to the main repository and, within 24 hours after the
 push, to the public repository.
 For information on how to access the public repository
 see http://www.mysql.com/doc/I/n/Installing_source_tree.html
 
 ChangeSet
 1.3354 05/08/21 19:14:28 email***@***.com +4 -0
 Remove questionable advice.
 
 refman/functions.xml
 1.35 05/08/21 19:14:25 email***@***.com +0 -12
 Remove questionable advice.
 
 refman-5.1/functions.xml
 1.16 05/08/21 19:14:25 email***@***.com +7 -16
 Sync.
 
 refman-5.0/functions.xml
 1.29 05/08/21 19:14:25 email***@***.com +0 -12
 Sync.
 
 refman-4.1/functions.xml
 1.51 05/08/21 19:14:24 email***@***.com +31 -46
 Sync.
 
 # This is a BitKeeper patch. What follows are the unified diffs for the
 # set of deltas contained in the patch. The rest of the patch, the part
 # that BitKeeper cares about, is below these diffs.
 # User: paul
 # Host: frost.snake.net
 # Root: /Volumes/frost2/MySQL/bk/mysqldoc
 
 --- 1.15/refman-5.1/functions.xml 2005-08-21 18:35:38 -05:00
 +++ 1.16/refman-5.1/functions.xml 2005-08-21 19:14:25 -05:00
 @@ -10731,18 +10731,6 @@
 </programlisting>
 
 <para>
 - You can get even better security by not transferring the key
 - over the connection for each query, which can be
 - accomplished by storing it in a server-side variable at
 - connection time. For example:
 - </para>
 -
 -<programlisting>
 -SELECT @password:='my password';
 -INSERT INTO t VALUES (1,AES_ENCRYPT('text',@password));
 -</programlisting>
 -
 - <para>
 <literal>AES_ENCRYPT()</literal> and
 <literal>AES_DECRYPT()</literal> can be considered the most
 cryptographically secure encryption functions currently
 @@ -13313,14 +13301,17 @@
 <indexterm type="function">
 <primary>ROLLUP</primary>
 </indexterm>
 -
 - <remark role="todo">Comparison with UNION, WRT complexity, table
 - accesses, optimization.
 +
 + <remark role="todo">
 + Comparison with UNION, WRT complexity, table accesses,
 + optimization.
 </remark>
 +
 <remark role="note">
 - Statements to create and populate the sales table used in the
 + Statements to create and populate the sales table used in the
 ROLLUP examples...
 </remark>
 +
 <!--
 DROP TABLE IF EXISTS sales;
 CREATE TABLE sales
 
 --- 1.50/refman-4.1/functions.xml 2005-08-21 18:35:37 -05:00
 +++ 1.51/refman-4.1/functions.xml 2005-08-21 19:14:24 -05:00
 @@ -3430,8 +3430,7 @@
 </row>
 <row>
 <entry><literal>%</literal></entry>
 - <entry>Matches any number of characters, even zero
 - characters</entry>
 + <entry>Matches any number of characters, even zero characters</entry>
 </row>
 <row>
 <entry><literal>_</literal></entry>
 @@ -3470,13 +3469,11 @@
 </row>
 <row>
 <entry><literal>\%</literal></entry>
 - <entry>Matches one ‘<literal>%</literal>’
 - character</entry>
 + <entry>Matches one ‘<literal>%</literal>’ character</entry>
 </row>
 <row>
 <entry><literal>\_</literal></entry>
 - <entry>Matches one ‘<literal>_</literal>’
 - character</entry>
 + <entry>Matches one ‘<literal>_</literal>’ character</entry>
 </row>
 </tbody>
 </tgroup>
 @@ -5766,9 +5763,8 @@
 </row>
 <row>
 <entry><literal>%r</literal></entry>
 - <entry>Time, 12-hour (<literal>hh:mm:ss</literal>
 - followed by <literal>AM</literal> or
 - <literal>PM</literal>)</entry>
 + <entry>Time, 12-hour (<literal>hh:mm:ss</literal> followed by
 + <literal>AM</literal> or <literal>PM</literal>)</entry>
 </row>
 <row>
 <entry><literal>%S</literal></entry>
 @@ -5784,30 +5780,27 @@
 </row>
 <row>
 <entry><literal>%U</literal></entry>
 - <entry>Week (<literal>00</literal>..<literal>53</literal>),
 - where Sunday is the first day of the week</entry>
 + <entry>Week (<literal>00</literal>..<literal>53</literal>), where Sunday is the
 + first day of the week</entry>
 </row>
 <row>
 <entry><literal>%u</literal></entry>
 - <entry>Week (<literal>00</literal>..<literal>53</literal>),
 - where Monday is the first day of the week</entry>
 + <entry>Week (<literal>00</literal>..<literal>53</literal>), where Monday is the
 + first day of the week</entry>
 </row>
 <row>
 <entry><literal>%V</literal></entry>
 - <entry>Week (<literal>01</literal>..<literal>53</literal>),
 - where Sunday is the first day of the week; used with
 - <literal>%X</literal></entry>
 + <entry>Week (<literal>01</literal>..<literal>53</literal>), where Sunday is the
 + first day of the week; used with <literal>%X</literal></entry>
 </row>
 <row>
 <entry><literal>%v</literal></entry>
 - <entry>Week (<literal>01</literal>..<literal>53</literal>),
 - where Monday is the first day of the week; used with
 - <literal>%x</literal></entry>
 + <entry>Week (<literal>01</literal>..<literal>53</literal>), where Monday is the
 + first day of the week; used with <literal>%x</literal></entry>
 </row>
 <row>
 <entry><literal>%W</literal></entry>
 - <entry>Weekday name
 - (<literal>Sunday</literal>..<literal>Saturday</literal>)</entry>
 + <entry>Weekday name (<literal>Sunday</literal>..<literal>Saturday</literal>)</entry>
 </row>
 <row>
 <entry><literal>%w</literal></entry>
 @@ -5816,15 +5809,13 @@
 </row>
 <row>
 <entry><literal>%X</literal></entry>
 - <entry>Year for the week where Sunday is the first day
 - of the week, numeric, four digits; used with
 - <literal>%V</literal></entry>
 + <entry>Year for the week where Sunday is the first day of the week, numeric,
 + four digits; used with <literal>%V</literal></entry>
 </row>
 <row>
 <entry><literal>%x</literal></entry>
 - <entry>Year for the week, where Monday is the first day
 - of the week, numeric, four digits; used with
 - <literal>%v</literal></entry>
 + <entry>Year for the week, where Monday is the first day of the week, numeric,
 + four digits; used with <literal>%v</literal></entry>
 </row>
 <row>
 <entry><literal>%Y</literal></entry>
 @@ -7409,8 +7400,7 @@
 <entry><emphasis role="bold">Mode</emphasis></entry>
 <entry><emphasis role="bold">of week</emphasis></entry>
 <entry><emphasis role="bold">Range</emphasis></entry>
 - <entry><emphasis role="bold">Week 1 is the first
 - week...</emphasis></entry>
 + <entry><emphasis role="bold">Week 1 is the first week...</emphasis></entry>
 </row>
 <row>
 <entry>0</entry>
 @@ -7691,8 +7681,12 @@
 </indexterm>
 
 <para>
 - MySQL uses what is known as a <firstterm>proleptic Gregorian
 - calendar</firstterm>.
 + MySQL uses what is known as a
 +
 + <firstterm>proleptic Gregorian
 + calendar</firstterm>
 +
 + .
 </para>
 
 <para>
 @@ -7754,9 +7748,12 @@
 
 <para>
 There are no dates between October 4 and October 15. This
 - discontinuity is called the <firstterm>cutover</firstterm>. Any
 - dates before the cutover are Julian, and any dates following the
 - cutover are Gregorian. Dates during a cutover are nonexistent.
 + discontinuity is called the
 +
 + <firstterm>cutover</firstterm>
 +
 + . Any dates before the cutover are Julian, and any dates following
 + the cutover are Gregorian. Dates during a cutover are nonexistent.
 </para>
 
 <para>
 @@ -9533,18 +9530,6 @@
 
 <programlisting>
 INSERT INTO t VALUES (1,AES_ENCRYPT('text','password'));
 -</programlisting>
 -
 - <para>
 - You can get even more security by not transferring the key
 - over the connection for each query, which can be
 - accomplished by storing it in a server-side variable at
 - connection time. For example:
 - </para>
 -
 -<programlisting>
 -SELECT @password:='my password';
 -INSERT INTO t VALUES (1,AES_ENCRYPT('text',@password));
 </programlisting>
 
 <para>
 
 --- 1.34/refman/functions.xml 2005-08-21 18:35:38 -05:00
 +++ 1.35/refman/functions.xml 2005-08-21 19:14:25 -05:00
 @@ -9869,18 +9869,6 @@
 </programlisting>
 
 <para>
 - You can get even more security by not transferring the key
 - over the connection for each query, which can be
 - accomplished by storing it in a server-side variable at
 - connection time. For example:
 - </para>
 -
 -<programlisting>
 -SELECT @password:='my password';
 -INSERT INTO t VALUES (1,AES_ENCRYPT('text',@password));
 -</programlisting>
 -
 - <para>
 <literal>AES_ENCRYPT()</literal> and
 <literal>AES_DECRYPT()</literal> were added in MySQL 4.0.2,
 and can be considered the most cryptographically secure
 
 --- 1.28/refman-5.0/functions.xml 2005-08-21 18:35:38 -05:00
 +++ 1.29/refman-5.0/functions.xml 2005-08-21 19:14:25 -05:00
 @@ -9568,18 +9568,6 @@
 </programlisting>
 
 <para>
 - You can get even better security by not transferring the key
 - over the connection for each query, which can be
 - accomplished by storing it in a server-side variable at
 - connection time. For example:
 - </para>
 -
 -<programlisting>
 -SELECT @password:='my password';
 -INSERT INTO t VALUES (1,AES_ENCRYPT('text',@password));
 -</programlisting>
 -
 - <para>
 <literal>AES_ENCRYPT()</literal> and
 <literal>AES_DECRYPT()</literal> can be considered the most
 cryptographically secure encryption functions currently
 
 --
 MySQL Internals Mailing List
 For list archives: http://lists.mysql.com/internals
 To unsubscribe: http://lists.mysql.com/internals?unsub=email***@***.com
- 14
 - bk commit into 5.0 tree (jimw:1.1894)Below is the list of changes that have just been committed into a local
 5.0 repository of jimw. When jimw does a push these changes will
 be propagated to the main repository and, within 24 hours after the
 push, to the public repository.
 For information on how to access the public repository
 see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html
 
 ChangeSet
 1.1894 05/04/15 14:13:28 email***@***.com +1 -0
 Merge email***@***.com:my/mysql-5.0-build
 into mysql.com:/home/jimw/my/mysql-5.0-build
 
 sql/mysqld.cc
 1.453 05/04/15 14:13:27 email***@***.com +0 -0
 Auto merged
 
 # This is a BitKeeper patch. What follows are the unified diffs for the
 # set of deltas contained in the patch. The rest of the patch, the part
 # that BitKeeper cares about, is below these diffs.
 # User: jimw
 # Host: rama.(none)
 # Root: /home/jimw/my/mysql-5.0-build/RESYNC
 
 --- 1.452/sql/mysqld.cc 2005-04-11 13:16:43 -07:00
 +++ 1.453/sql/mysqld.cc 2005-04-15 14:13:27 -07:00
 @@ -4704,7 +4704,7 @@
 "Specify number of autoincrement values that are prefetched.",
 (gptr*) &global_system_variables.ndb_autoincrement_prefetch_sz,
 (gptr*) &global_system_variables.ndb_autoincrement_prefetch_sz,
 - 0, GET_INT, REQUIRED_ARG, 32, 1, 256, 0, 0, 0},
 + 0, GET_ULONG, REQUIRED_ARG, 32, 1, 256, 0, 0, 0},
 {"ndb-force-send", OPT_NDB_FORCE_SEND,
 "Force send of buffers to ndb immediately without waiting for "
 "other threads.",
 
 --
 MySQL Internals Mailing List
 For list archives: http://lists.mysql.com/internals
 To unsubscribe: http://lists.mysql.com/internals?unsub=email***@***.com
- 15
 - bought----answerovercant
 Content-Type: text/html; charset=ascii-us
 Content-Transfer-Encoding: quoted-printable
 
 <html>
 <body>
 Yo Myodbc Mon, 19 Apr 2004 21:27:34 -0600
 
 
 <h3>Orde.r Prescr.iption Med.s L.ow C.ost</h3>
 
 
 
 <h2><a href=3D"http://2TJ32kCcBCHAR.diego050pills.biz/f75/">Sp.ecial Of=
 fe.r End.s Soo.n, Ord.er No.w and Sav.e</a></h2>
 
 <a href=3D"http://x5C7HCHAR.diego050pills.biz/unsubscribe.ddd">No TY</a>
 
 13kVOpTEXT
 </body>
 </html>
 
 ----answerovercant--