RE: No Warnings after changed data
Hello, I think that my problem boils down to the unimplemented getWarnings() method in the mm. JDBC driver. If it was implemented, I could detect if the data was e.g. truncated. Can anybody help me find an implementation for this method? Thank you again, Charlie Hi. :I'd like to find out how I could convince mysql to generate warnings :whenever the data I want to insert is modified by the server. I believe there's no built-in way of doing that. I keep a checksum of a data stored. And when i want to write to that raw next time I just check the checksum (md5 digest) _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
No Warnings after changed data
Hi All, I'd like to find out how I could convince mysql to generate warnings whenever the data I want to insert is modified by the server. E.G. CREATE TABLE test (value real); INSERT INTO test VALUES ('a1'); I am programming in JAVA using JDBC. Thanks for any answers! Charlie _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Comparing UNSIGNED and INDEXED columns with negative numbers
Hi All, Using MySQL server version 3.23.49-nt I get strange results when running the following very simple test. I am wondering if this is a bug, feature or perhaps a standart SQL behaviour?? CREATE TABLE test(id BIGINT UNSIGNED); CREATE INDEX test_idx on test(id); INSERT INTO test VALUES (0), (1), (2), (3); SELECT * FROM test WHERE id -1; I get an empty result. With column type INT UNSIGNED, it's a little bit better; only the 0 is not included in the result set! However if I don't put an index on the column, everything seems to behave good. I recon it has something to do with casting (-1) to an unsigned value. Is (id -1) a valid and supported comparison on that column after all??? Thanks for any answers! Charlie _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SLOW MULTI COLUMN INDEXES, ESPECIALLY FOR MERGE TABLES
Hi all, I seem to have difficulties efficiently using multiple column unique indexes. I notice major performance differences in the following example. Is this a known problem, or am I not doing the right thing? The following scenario takes for me 0.76 seconds: CREATE TABLE test(d_id INT, t_id INT, value VARCHAR(255)); CREATE UNIQUE INDEX test_idx on test(d_id, t_id); SELECT * FROM test WHERE d_id 500 AND t_id 500; This takes nearly 1 minute if I try to use MERGE tables (the index would still remain UNIQUE) The data in the test table has the following features: Both d_id and t_id values occure 2-3000 times (it't probably not good for the b-tree) It seems like first the query evaluates (d_id 500) and slowly comes up with 500,000 results. Finally (t_id 500) dramatically reduces the result set to 200. If I set PACK_KEYS = 1, and even rebuild the indexes, nothing really changes. I don't know how multiple column keys are handled, are they treated as one primary key or are they looked up separately, butif I combine the d_id and t_id keys in a new table to produce a primary key e.g. as (d_id*10,000,000+t_id) everything is fast (0.01 sec), (but wierd). Could anyone recommend a better solution in this case? Thanks for any comments! Charlie _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GRANT TEMPORARY CREATE ...
Hi, My database users have problems with the missing sub-query feature of MySql that I would like to solve by letting them create temporary tables since their scope is a connection thread. However I cannot let them to start creating tables that are not temporary. Unfortunately I cannot find such privilege system currently supported by MySQL. Could anyone confirm that or suggest a solution? Thanks for any response! Charlie _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MAX_ROWS limits
Hi, I am using MySql 3.23.47 for nt (W2000). The number of rows of my table on an NTFS file system is estimated to become around 6,000,000,000. I am trying to increase my default MAX_ROWS=4294967295 with ALTER TABLE test AVG_ROW_LENGTH=9 MAX_ROWS=60; Following this, SHOW TABLE STATUS still gives the original number for MAX_ROWS! Could someone help me to understand, if MAX_ROWS is limited to the maximum value of the integer, or do I need to change some other settings in order to go beyond this number? Thanks for any ideas! Charlie _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MAX_ROWS limits
Hi, I am using MySql 3.23.47 for nt (W2000). The number of rows of my table on an NTFS file system is estimated to become around 6,000,000,000. I am trying to increase my default MAX_ROWS=4294967295 with ALTER TABLE test AVG_ROW_LENGTH=9 MAX_ROWS=60; Following this, SHOW TABLE STATUS still gives the original number for MAX_ROWS! Could someone help me to understand, if MAX_ROWS is limited to the maximum value of the integer, or do I need to change some other settings in order to go beyond this number? Thanks for any ideas! Charlie _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php