An error occurred fetching the project authors.
  1. 10 Nov, 2004 1 commit
    • unknown's avatar
      1. When mixing NULL to a character string, · c5e6941e
      unknown authored
      the result takes its charset/collation
      attributes from the character string,
      e.g.  SELECT func(NULL, _latin2'string')
      now returns a latin2 result. This is
      done by introducing a new derivation
      (aka coercibility) level DERIVATION_IGNORABLE,
      which is used with Item_null.
      2. 'Pure' NULL is now BINARY(0), not CHAR(0).
      I.e. NULL is now more typeless.
      
      
      mysql-test/r/metadata.result:
        Fixing test results:
        CHAR(0) -> BINARY(0) for NULLs
      mysql-test/r/null.result:
        Testing mixing NULL with a character string with a number of functions.
      mysql-test/r/ps_2myisam.result:
        Fixing test results:
        CHAR(0) -> BINARY(0) for NULLs
      mysql-test/r/ps_3innodb.result:
        Fixing test results:
        CHAR(0) -> BINARY(0) for NULLs
      mysql-test/r/ps_4heap.result:
        Fixing test results:
        CHAR(0) -> BINARY(0) for NULLs
      mysql-test/r/ps_5merge.result:
        Fixing test results:
        CHAR(0) -> BINARY(0) for NULLs
      mysql-test/r/ps_6bdb.result:
        Fixing test results:
        CHAR(0) -> BINARY(0) for NULLs
      mysql-test/r/ps_7ndb.result:
        Fixing test results:
        CHAR(0) -> BINARY(0) for NULLs
      mysql-test/t/null.test:
        Testing mixing NULL with a character string with a number of functions.
      sql/item.cc:
        New derivation level.
      sql/item.h:
        New derivation level.
      c5e6941e
  2. 05 Nov, 2004 1 commit
    • unknown's avatar
      As it is wrong and confusing to associate any · aee1e78a
      unknown authored
      character set with NULL, @A should be latin2
      after this query sequence:
      
         SET @A=_latin2'string';
         SET @A=NULL;
      
      I.e. the second query should not change the charset
      to the current default value, but should keep the
      original value assigned during the first query.
      In order to do it, we don't copy charset
      from the argument if the argument is NULL
      and the variable has previously been initialized.
      
      
      mysql-test/r/ps_6bdb.result:
        t
      mysql-test/r/ps_5merge.result:
        t
      mysql-test/r/ps_3innodb.result:
        t
      mysql-test/r/ps_7ndb.result:
        t
      mysql-test/r/ps_4heap.result:
        t
      mysql-test/r/ps_2myisam.result:
        t
      sql/item_func.cc:
        t
      aee1e78a
  3. 30 Oct, 2004 1 commit
    • unknown's avatar
      Enable REPLACE ... SELECT in prepared statements. · d46c7366
      unknown authored
      mysql-test/include/ps_modify.inc:
        replace ... select now works.
      mysql-test/r/ps_2myisam.result:
        replace ... select now works.
      mysql-test/r/ps_3innodb.result:
        replace ... select now works.
      mysql-test/r/ps_4heap.result:
        replace ... select now works.
      mysql-test/r/ps_5merge.result:
        replace ... select now works.
      mysql-test/r/ps_6bdb.result:
        replace ... select now works.
      mysql-test/r/ps_7ndb.result:
        replace ... select now works.
      mysql-test/t/ps_7ndb.test:
        replace ... select now works.
      sql/sql_prepare.cc:
        Enable SQLCOM_REPLACE_SELECT: no need for any code changes but
        enable this SQLCOM in the switch.
      d46c7366
  4. 11 Oct, 2004 1 commit
  5. 07 Oct, 2004 3 commits
  6. 28 Sep, 2004 1 commit
    • unknown's avatar
      Some of the recently pushed prepared statements · 22cca358
      unknown authored
      tests were disabled due to failures caused by floating point conversion
      issues on optimized builds).
      
      
      mysql-test/include/ps_conv.inc:
        Disable some of the tests for the test suite to pass on an optimized 
        build (floating point issues...).
      mysql-test/include/ps_query.inc:
        Disable some of the tests for the test suite to pass on an optimized 
        build (floating point issues...).
      mysql-test/r/ps_2myisam.result:
        Fix test results.
      mysql-test/r/ps_3innodb.result:
        Fix test results.
      mysql-test/r/ps_4heap.result:
        Fix test results.
      mysql-test/r/ps_5merge.result:
        Fix test results.
      mysql-test/r/ps_6bdb.result:
        Fix test results.
      mysql-test/r/ps_7ndb.result:
        Fix test results.
      22cca358
  7. 25 Sep, 2004 1 commit
    • unknown's avatar
      Results of WL#1856 "Conversion of client_test.c tests cases to mysqltest · 9ff04fe5
      unknown authored
      if possible"
              - many new test cases
              - more and improved comments
            New files: t/ps_7ndb.test       test suite for NDB tables
                       r/ps_7ndb.result     expected results
                       include/ps_conv.inc  conversion test cases
      + review comments and fixes.
      
      
      mysql-test/include/ps_create.inc:
        Rename of t_many_col_types -> t9
      mysql-test/include/ps_modify.inc:
        WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
        Rename: t_many_col_types -> t9
        Cleanups and comments.
        New test cases (derived from client_test.c)
      mysql-test/include/ps_modify1.inc:
        WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
        Rename: t_many_col_types -> t9
        Cleanups and comments.
        New test cases (derived from client_test.c)
      mysql-test/include/ps_query.inc:
        WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
        Rename: t_many_col_types -> t9
        Cleanups and comments.
        New test cases (derived from client_test.c)
      mysql-test/include/ps_renew.inc:
        WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
        Rename: t_many_col_types -> t9
      mysql-test/r/ps_1general.result:
        Results updated.
      mysql-test/r/ps_2myisam.result:
        Resutls updated.
      mysql-test/r/ps_3innodb.result:
        Results updated.
      mysql-test/r/ps_4heap.result:
        Results updated.
      mysql-test/r/ps_5merge.result:
        Results updated.
      mysql-test/r/ps_6bdb.result:
        Results updated.
      mysql-test/t/ps_1general.test:
        WL#1856 "Conversion of client_test.c tests cases to mysqltest if
         possible": new test cases added.
      mysql-test/t/ps_2myisam.test:
        WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
        Call of file include/ps_conv.inc (with new test cases) and 
        fulltext test case added.
      mysql-test/t/ps_3innodb.test:
        WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
        Call of file include/ps_conv.inc (with new test cases) added.
      mysql-test/t/ps_4heap.test:
        WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
        Call of file include/ps_conv.inc (with new test cases) added.
      mysql-test/t/ps_5merge.test:
        WL#1856 Conversion of client_test.c tests cases to mysqltest if possible
        Call of file include/ps_conv.inc (with new test cases) added.
      mysql-test/t/ps_6bdb.test:
        WL#1856 Conversion of client_test.c tests cases to mysqltest if possible.
        Call of file include/ps_conv.inc (with new test cases) added.
      9ff04fe5