commented out bits in enum test

Bug #579311 reported by Stewart Smith
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
Medium
Stewart Smith
Dexter
Fix Released
Medium
Stewart Smith

Bug Description

jay spotted in embedded_Innodb review. comes from main test:

 1840 +##
 1841 +## Bug #2077
 1842 +##
 1843 +#create table t1 (a enum(0xE4, '1', '2') not null default 0xE4);
 1844 +#show columns from t1;
 1845 +#show create table t1;
 1846 +#drop table t1;
 1847 +
 1848 +# Test currently turned off because of this bug:
 1849 +# Bug 308841 queries with German umlauts in insert statem
 1850 +#
 1851 +# Bug #5628 German characters in field-defs will be '?'
 1852 +# with some table definitions
 1853 +#
 1854 +#set names latin1;
 1855 +#CREATE TABLE t1 (
 1856 +# a INT default 1,
 1857 +# b ENUM('value','öäü_value','ÊÃÕ') character set latin1 NOT NULL
 1858 +#);
 1859 +#show create table t1;
 1860 +#show columns from t1;
 1861 +#drop table t1;
 1862 +
 1863 +# Test currently turned off because of this bug:
 1864 +# Bug 308841 queries with German umlauts in insert statem
 1865 +#CREATE TABLE t1 (c enum('ae','oe','ue','ss') collate utf8_swedish_ci);
 1866 +#INSERT INTO t1 VALUES ('ä'),('ö'),('ü'),('ß');
 1867 +#SELECT * FROM t1;
 1868 +#DROP TABLE t1;
 1869 +
 1870 +# Test currently turned off because of this bug:
 1871 +# Bug 308841 queries with German umlauts in insert statements fail
 1872 +#
 1873 +# Bug #6379: ENUM values are incorrectly converted
 1874 +#
 1875 +# Check latin1 -> utf8 conversion
 1876 +#
 1877 +#CREATE TABLE t1 (
 1878 +# a ENUM('ä','ö','ü') character set utf8 default 'ü'
 1879 +#);
 1880 +#show create table t1;
 1881 +#insert into t1 values ('ä'), ('ö'), ('ü');
 1882 +#select a from t1 order by a;
 1883 +#drop table t1;
 1884 +
 1885 +# Test currently turned off because of this bug:
 1886 +# Bug 308841 queries with German umlauts in insert statements fail
 1887 +#
 1888 +# Now check utf8 -> latin1 conversion
 1889 +# This test emulates loading a script generated with mysqldump
 1890 +#
 1891 +#CREATE TABLE t1 (
 1892 +# a ENUM('ä','ö','ü') character set latin1 default 'ü'
 1893 +#);
 1894 +#insert into t1 values ('ä'),('ö'),('ü');
 1895 +# Now check what has been loaded
 1896 +#show create table t1;
 1897 +#select a from t1 order by a;
 1898 +#drop table t1;

Related branches

Stewart Smith (stewart)
Changed in drizzle:
milestone: 2010-05-24 → 2010-06-07
Stewart Smith (stewart)
Changed in drizzle:
status: Confirmed → Fix Committed
Stewart Smith (stewart)
Changed in drizzle:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.