Drizzle

  1. Bug #644760
  2. Comment #6

Comment 6 for bug 644760

Revision history for this message
Patrick Crews (patrick-crews) wrote : Re: Transaction log appears to lose data on implicit commit after a large number of queries have been executed.

The bug is being caused by this query (line 387 in the test case).

It would appear that encountering the 1093 ERROR is causing log data to be lost.

#--error ER_UPDATE_TABLE_USED
#DELETE FROM `c` WHERE `col_char_10_not_null_key` IN ( SELECT `col_enum_key` FROM `c` WHERE `pk` = 112 ) ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 4 ;
# 2010-09-20T13:05:55 Query: DELETE FROM `c` WHERE `col_char_10_not_null_key` IN ( SELECT `col_enum_key` FROM `c` WHERE `pk` = 112 ) ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,`col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`pk` LIMIT 4 failed: 1093 You can't specify target table '%s' for update in FROM clause. Further errors of this kind will be suppressed.;