1. 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
  2. 30 Jul, 2006 3 commits
  3. 29 Jul, 2006 2 commits
  4. 26 Jul, 2006 2 commits
  5. 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
  6. 21 Jul, 2006 3 commits
  7. 19 Jul, 2006 2 commits
  8. 18 Jul, 2006 1 commit
  9. 17 Jul, 2006 1 commit
  10. 12 Jul, 2006 5 commits
  11. 11 Jul, 2006 6 commits
  12. 10 Jul, 2006 13 commits