1. 14 Sep, 2006 2 commits
  2. 12 Sep, 2006 1 commit
    • svoj@april.(none)'s avatar
      BUG#20256 - LOCK WRITE - MyISAM · 44f167ee
      svoj@april.(none) authored
      Only MyISAM tables locked with LOCK TABLES ... WRITE were affected.
      
      A query that is optimized with index_merge doesn't reflect rows
      inserted within LOCK TABLES.
      
      MyISAM doesn't flush a state within LOCK TABLES. index_merge
      optimization creates a copy of the handler, which thus gets
      outdated MyISAM state.
      
      New handler->clone() method is introduced to fix this problem.
      For non-MyISAM storage engines it allocates a handler and opens
      it with ha_open(). For MyISAM it additionally copies MyISAM state
      pointer to cloned handler.
      44f167ee
  3. 07 Sep, 2006 3 commits
  4. 29 Aug, 2006 2 commits
  5. 10 Aug, 2006 1 commit
  6. 07 Aug, 2006 2 commits
  7. 02 Aug, 2006 1 commit
    • svoj@may.pils.ru's avatar
      BUG#14770 - LOAD DATA INFILE doesn't respect default values for · 6c6f435b
      svoj@may.pils.ru authored
                  columns
      Fixed confusing warning.
      
      Quoting INSERT section of the manual:
      ----
      Inserting NULL into a column that has been declared NOT NULL. For
      multiple-row INSERT statements or INSERT INTO ... SELECT statements, the
      column is set to the implicit default value for the column data type. This
      is 0 for numeric types, the empty string ('') for string types, and the
      "zero" value for date and time types. INSERT INTO ... SELECT statements are
      handled the same way as multiple-row inserts because the server does not
      examine the result set from the SELECT to see whether it returns a single
      row. (For a single-row INSERT, no warning occurs when NULL is inserted into
      a NOT NULL column. Instead, the statement fails with an error.)
      ----
      This is also true for LOAD DATA INFILE. For INSERT user can specify
      DEFAULT keyword as a value to set column default. There is no similiar
      feature available for LOAD DATA INFILE.
      6c6f435b
  8. 01 Aug, 2006 1 commit
    • acurtis/antony@xiphis.org/ltantony.xiphis.org's avatar
      Bug#15669 · a1936d28
        "Test case 'csv' produces incorrect result on OpenBSD"
        mmapped pages were not being invalidated when writes occurred to the
        file vi a fd i/o operation. 
        Force explicit invalidation and not rely on implicit invalidation.
      a1936d28
  9. 30 Jul, 2006 3 commits
  10. 29 Jul, 2006 2 commits
  11. 26 Jul, 2006 2 commits
  12. 25 Jul, 2006 1 commit
    • pgalbraith/patg@buffy.netfrastructure.com's avatar
      BUG #15133 "unique index with nullable value not accepted in federated table" · cf8b64a1
      Added HA_NULL_IN_KEY to table flags to allow for nullable unique indexes
      and added test to verify
      
      ha_federated.h:
        BUG #15133 "unique index with nullable value not accepted in federated table"
        added HA_NULL_IN_KEY to table flags to allow for nullable unique indexes
      federated.test:
        BUG #15133 "unique index with nullable value not accepted in federated table"
        New test to show that nullable unique indexes work
      federated.result:
        BUG #15133 "unique index with nullable value not accepted in federated table"
        New results for new test
      cf8b64a1
  13. 21 Jul, 2006 3 commits
  14. 19 Jul, 2006 2 commits
  15. 18 Jul, 2006 1 commit
  16. 17 Jul, 2006 1 commit
  17. 12 Jul, 2006 5 commits
  18. 11 Jul, 2006 6 commits
  19. 10 Jul, 2006 1 commit