Table doesn't exist from stored function

N 1; END; I can't see why I am receiving this error, as I am checking if the table exists before the select. If this is a limitation in MySQL, any ideas how to circumvent it? Thanks ImRe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem with new mysql versions. (They hang)

Hi, I am running relatively complex queries to analyse a dataset. I have query execution times of around half an hour with version 5.27 I tried both version 5.33 and 5.34, and experienced the following: The first few queries ar run faster than with version 5.27, but after a while a query r

mysql server has gone away

your source as described in bug report #24572, and recompile. ImRe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: UNIQUE KEY vs NULLs

D IF; Here Id is a non NULL field, so setting it to NULL should trigger an error. But when I run an insert where the trigger body would run, then I get the following error. Table 'Target' was not locked with LOCK TABLES I am pretty sure, I don't use LOCK TABLES at all. What is going

UNIQUE KEY vs NULLs

x27;t allow such duplicates? Thx ImRe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

odd return value from mysql_stmt_execute()

Hi, It seems that mysql_stmt_execute() sometimes returns 1, and in this case mysql_stmt_error() says that it "Lost connection to MySQL server during query" Can/should I treate this situation as an ordinary CR_SERVER_LOST, or is this something completely different? Thx ImRe -- MyS

RE: Weird error with stored function

more than a few hours of experience with the MySQL codebase can see some possible pitfalls in this fix. Thx ImRe > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 23 November 2006 12:14 > To: 'mysql@lists.mysql.com' > Subject: Weird error

Weird error with stored function

unity-log. I am using InnoDB for my database, and the server SQL mode is sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ANS I,ONLY_FULL_GROUP_BY" Thanks in advance ImRe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

RE: Hungarian collation

e, i.e. ccs > cds > > I expect that there is no rule which could apply for all LIKE > searches. I think, it would be nice (again, because of certain suffix rules) if e.g., LIKE 'cs%' would also match 'ccs' > > - Composit words are sorted according to word p

Join on nearest value

Hi, I have two tables, both containing a UNIX_TIMESTAMP column. Is it possible to join the tables on the nearest values of these columns? If no, then could anybody show me a query to circumvent this limitation? Thanks ImRe -- MySQL General Mailing List For list archives: http

RE: Speed of DECIMAL

database from CHAR(15) ASCII to DEC(15) UNSIGNED > > ZEROFILL. I was expecting a speedup as DEC(15) is more > compact, and > > this columns are also part of InnoDB indices. In contrary to my > > expectations, running my test suit took approximate

Speed of DECIMAL

test suit took approximately three times as much time, as before. Could anybody give me a probable reason for this slowdown? Thx ImRe P.S.: Ver 5.0.24a -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Embedded server with the archive storage engine

undef for it) So I put an explicite #define at the beginning of handler.cpp (before the first #include). After that, it built. But now I have the assertion. Is there anything else I can do, or it is not supposed to work on the first place. Thanks ImRe -- MySQL General Mailing List For

RE: Hungarian collation

ents out of the business. I hope this helps. ImRe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

merging mysql databases

lysis application see the databases copied from the devices. (I'd rather not go through csv exports if possible ...) Any ideas? Thx ImRe P.S.: Ver 5.0.24a -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Charset for SELECT ... INTO OUTFILE

, or is it always uses the database character set? Thx. ImRe P.S.: Ver 5.0.24a-community-log -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Enums vs prepared statements

em to work woth the same setup properly, only selects have this problem. Thx. ImRe P.S.: version = 5.0.22 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

speed problems (?!)

hi all i've mysql 2.32.52 installed, and there is a table with nearly 2.000.000 records in it (4 field/record). i have 256megs of RAM, and the linux version is RedHat 7.3. i do a simple delete, like: delete from foo_db where foo>10; (this is around 15.000 record) and after 30 minutes, still