database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-07-29 08:21:15 +03:00
Code Activity
Files
stable-23.10-assert-bigjoin
mariadb-columnstore-engine/mysql-test/columnstore/devregression/r/mcs7087_regression_bug3488.result
root 2ed151fa59 Recorded reference results
2022-12-09 02:24:40 +00:00

158 lines
20 KiB
Plaintext
Raw Permalink Blame History

USE tpch1;
drop table if exists bug3488;
create table bug3488 (c1 bigint, c2 decimal(18,2), c3 float, c4 double, c5 char(120), c6 varchar(120)) engine=columnstore;
insert into bug3488 values
(1, 1.1, 1.1, 1.1, '1.1', '1.1'),
(1234567890, 1234567890.1, 1234567890.1, 1234567890.1, '1234567890.1', '1234567890.1'),
(1234567890, 1234567890.8, 1234567890.8, 1234567890.8, '1234567890.8', '1234567890.8'),
(1.234567890e10, 1.2345678901e10, 1.2345678901e10, 1.2345678901e10, '1.2345678901e10', '1.2345678901e10'),
(1234567890, 1234567890123456.78, 1.2345678901e20, 1.2345678901e208, '12345678901234567890', '12345678901234567890'),
(1234567890, 1234567890987654.32, 1.2345678901e38, 1.2345678901e308, '12345678901234567890123456789012345678901234567890', '1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'),
(-1, -1.1, -1.1, -1.1, '-1.1', '-1.1'),
(-1234567890, -1234567890.1, -1234567890.1, -1234567890.1, '-1234567890.1', '-1234567890.1'),
(-1234567890, -1234567890.8, -1234567890.8, -1234567890.8, '-1234567890.8', '-1234567890.8'),
(-1.234567890e10, -1.2345678901e10, -1.2345678901e10, -1.2345678901e10, '-1.2345678901e10', '-1.2345678901e10'),
(-1234567890, -1234567890123456.78, -1.2345678901e20, -1.2345678901e208, '-12345678901234567890', '-12345678901234567890'),
(-1234567890, -1234567890987654.32, -1.2345678901e38, -1.2345678901e308, '-12345678901234567890123456789012345678901234567890', '-1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890');
select c1, format(c1, -2), format(c1, 0), format(c1, 2) from bug3488;
c1 format(c1, -2) format(c1, 0) format(c1, 2)
1 1 1 1.00
1234567890 1,234,567,890 1,234,567,890 1,234,567,890.00
1234567890 1,234,567,890 1,234,567,890 1,234,567,890.00
12345678900 12,345,678,900 12,345,678,900 12,345,678,900.00
1234567890 1,234,567,890 1,234,567,890 1,234,567,890.00
1234567890 1,234,567,890 1,234,567,890 1,234,567,890.00
-1 -1 -1 -1.00
-1234567890 -1,234,567,890 -1,234,567,890 -1,234,567,890.00
-1234567890 -1,234,567,890 -1,234,567,890 -1,234,567,890.00
-12345678900 -12,345,678,900 -12,345,678,900 -12,345,678,900.00
-1234567890 -1,234,567,890 -1,234,567,890 -1,234,567,890.00
-1234567890 -1,234,567,890 -1,234,567,890 -1,234,567,890.00
select c2, format(c2, -2), format(c2, 0), format(c2, 2) from bug3488;
c2 format(c2, -2) format(c2, 0) format(c2, 2)
1.10 1 1 1.10
1234567890.10 1,234,567,890 1,234,567,890 1,234,567,890.10
1234567890.80 1,234,567,891 1,234,567,891 1,234,567,890.80
12345678901.00 12,345,678,901 12,345,678,901 12,345,678,901.00
1234567890123456.78 1,234,567,890,123,457 1,234,567,890,123,457 1,234,567,890,123,456.78
1234567890987654.32 1,234,567,890,987,654 1,234,567,890,987,654 1,234,567,890,987,654.32
-1.10 -1 -1 -1.10
-1234567890.10 -1,234,567,890 -1,234,567,890 -1,234,567,890.10
-1234567890.80 -1,234,567,891 -1,234,567,891 -1,234,567,890.80
-12345678901.00 -12,345,678,901 -12,345,678,901 -12,345,678,901.00
-1234567890123456.78 -1,234,567,890,123,457 -1,234,567,890,123,457 -1,234,567,890,123,456.78
-1234567890987654.32 -1,234,567,890,987,654 -1,234,567,890,987,654 -1,234,567,890,987,654.32
select c4, format(c4, -2), format(c4, 0), format(c4, 2) from bug3488;
c4 format(c4, -2) format(c4, 0) format(c4, 2)
1.1 1 1 1.10
1234567890.1 1,234,567,890 1,234,567,890 1,234,567,890.10
1234567890.8 1,234,567,891 1,234,567,891 1,234,567,890.80
12345678901 12,345,678,901 12,345,678,901 12,345,678,901.00
1.2345678901e208 12,345,678,900,999,999,233,702,015,044,958,622,693,183,936,076,284,780,362,474,237,068,469,512,109,091,905,769,475,650,956,406,726,044,392,324,291,673,911,579,673,435,841,679,894,322,111,543,979,736,271,655,002,247,372,787,505,331,443,016,571,555,565,037,648,415,185,327,620,096 12,345,678,900,999,999,233,702,015,044,958,622,693,183,936,076,284,780,362,474,237,068,469,512,109,091,905,769,475,650,956,406,726,044,392,324,291,673,911,579,673,435,841,679,894,322,111,543,979,736,271,655,002,247,372,787,505,331,443,016,571,555,565,037,648,415,185,327,620,096 12,345,678,900,999,999,233,702,015,044,958,622,693,183,936,076,284,780,362,474,237,068,469,512,109,091,905,769,475,650,956,406,726,044,392,324,291,673,911,579,673,435,841,679,894,322,111,543,979,736,271,655,002,247,372,787,505,331,443,016,571,555,565,037,648,415,185,327,620,096.00
1.2345678901e308 123,456,789,010,000,003,013,769,221,302,475,265,236,473,260,868,443,180,100,707,231,243,197,604,846,678,491,603,701,791,833,592,622,260,767,755,587,241,551,101,641,071,285,970,395,887,287,299,936,335,501,367,119,307,918,969,722,323,877,313,450,129,317,836,543,043,061,686,055,660,760,257,877,809,447,984,085,651,532,908,811,501,208,193,676,911,145,259,694,125,922,340,467,359,889,260,267,302,158,242,651,570,176 123,456,789,010,000,003,013,769,221,302,475,265,236,473,260,868,443,180,100,707,231,243,197,604,846,678,491,603,701,791,833,592,622,260,767,755,587,241,551,101,641,071,285,970,395,887,287,299,936,335,501,367,119,307,918,969,722,323,877,313,450,129,317,836,543,043,061,686,055,660,760,257,877,809,447,984,085,651,532,908,811,501,208,193,676,911,145,259,694,125,922,340,467,359,889,260,267,302,158,242,651,570,176 123,456,789,010,000,003,013,769,221,302,475,265,236,473,260,868,443,180,100,707,231,243,197,604,846,678,491,603,701,791,833,592,622,260,767,755,587,241,551,101,641,071,285,970,395,887,287,299,936,335,501,367,119,307,918,969,722,323,877,313,450,129,317,836,543,043,061,686,055,660,760,257,877,809,447,984,085,651,532,908,811,501,208,193,676,911,145,259,694,125,922,340,467,359,889,260,267,302,158,242,651,570,176.00
-1.1 -1 -1 -1.10
-1234567890.1 -1,234,567,890 -1,234,567,890 -1,234,567,890.10
-1234567890.8 -1,234,567,891 -1,234,567,891 -1,234,567,890.80
-12345678901 -12,345,678,901 -12,345,678,901 -12,345,678,901.00
-1.2345678901e208 -12,345,678,900,999,999,233,702,015,044,958,622,693,183,936,076,284,780,362,474,237,068,469,512,109,091,905,769,475,650,956,406,726,044,392,324,291,673,911,579,673,435,841,679,894,322,111,543,979,736,271,655,002,247,372,787,505,331,443,016,571,555,565,037,648,415,185,327,620,096 -12,345,678,900,999,999,233,702,015,044,958,622,693,183,936,076,284,780,362,474,237,068,469,512,109,091,905,769,475,650,956,406,726,044,392,324,291,673,911,579,673,435,841,679,894,322,111,543,979,736,271,655,002,247,372,787,505,331,443,016,571,555,565,037,648,415,185,327,620,096 -12,345,678,900,999,999,233,702,015,044,958,622,693,183,936,076,284,780,362,474,237,068,469,512,109,091,905,769,475,650,956,406,726,044,392,324,291,673,911,579,673,435,841,679,894,322,111,543,979,736,271,655,002,247,372,787,505,331,443,016,571,555,565,037,648,415,185,327,620,096.00
-1.2345678901e308 -123,456,789,010,000,003,013,769,221,302,475,265,236,473,260,868,443,180,100,707,231,243,197,604,846,678,491,603,701,791,833,592,622,260,767,755,587,241,551,101,641,071,285,970,395,887,287,299,936,335,501,367,119,307,918,969,722,323,877,313,450,129,317,836,543,043,061,686,055,660,760,257,877,809,447,984,085,651,532,908,811,501,208,193,676,911,145,259,694,125,922,340,467,359,889,260,267,302,158,242,651,570,176 -123,456,789,010,000,003,013,769,221,302,475,265,236,473,260,868,443,180,100,707,231,243,197,604,846,678,491,603,701,791,833,592,622,260,767,755,587,241,551,101,641,071,285,970,395,887,287,299,936,335,501,367,119,307,918,969,722,323,877,313,450,129,317,836,543,043,061,686,055,660,760,257,877,809,447,984,085,651,532,908,811,501,208,193,676,911,145,259,694,125,922,340,467,359,889,260,267,302,158,242,651,570,176 -123,456,789,010,000,003,013,769,221,302,475,265,236,473,260,868,443,180,100,707,231,243,197,604,846,678,491,603,701,791,833,592,622,260,767,755,587,241,551,101,641,071,285,970,395,887,287,299,936,335,501,367,119,307,918,969,722,323,877,313,450,129,317,836,543,043,061,686,055,660,760,257,877,809,447,984,085,651,532,908,811,501,208,193,676,911,145,259,694,125,922,340,467,359,889,260,267,302,158,242,651,570,176.00
select c5, format(c5, -2), format(c5, 0), format(c5, 2) from bug3488;
c5 format(c5, -2) format(c5, 0) format(c5, 2)
1.1 1 1 1.10
1234567890.1 1,234,567,890 1,234,567,890 1,234,567,890.10
1234567890.8 1,234,567,891 1,234,567,891 1,234,567,890.80
1.2345678901e10 12,345,678,901 12,345,678,901 12,345,678,901.00
12345678901234567890 12,345,678,901,234,567,168 12,345,678,901,234,567,168 12,345,678,901,234,567,168.00
12345678901234567890123456789012345678901234567890 12,345,678,901,234,566,660,398,341,115,085,767,575,755,770,822,656 12,345,678,901,234,566,660,398,341,115,085,767,575,755,770,822,656 12,345,678,901,234,566,660,398,341,115,085,767,575,755,770,822,656.00
-1.1 -1 -1 -1.10
-1234567890.1 -1,234,567,890 -1,234,567,890 -1,234,567,890.10
-1234567890.8 -1,234,567,891 -1,234,567,891 -1,234,567,890.80
-1.2345678901e10 -12,345,678,901 -12,345,678,901 -12,345,678,901.00
-12345678901234567890 -12,345,678,901,234,567,168 -12,345,678,901,234,567,168 -12,345,678,901,234,567,168.00
-12345678901234567890123456789012345678901234567890 -12,345,678,901,234,566,660,398,341,115,085,767,575,755,770,822,656 -12,345,678,901,234,566,660,398,341,115,085,767,575,755,770,822,656 -12,345,678,901,234,566,660,398,341,115,085,767,575,755,770,822,656.00
select c6, format(c6, -2), format(c6, 0), format(c6, 2) from bug3488;
c6 format(c6, -2) format(c6, 0) format(c6, 2)
1.1 1 1 1.10
1234567890.1 1,234,567,890 1,234,567,890 1,234,567,890.10
1234567890.8 1,234,567,891 1,234,567,891 1,234,567,890.80
1.2345678901e10 12,345,678,901 12,345,678,901 12,345,678,901.00
12345678901234567890 12,345,678,901,234,567,168 12,345,678,901,234,567,168 12,345,678,901,234,567,168.00
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890 1,234,567,890,123,456,718,070,421,139,719,794,622,419,313,690,432,875,243,234,074,448,189,700,007,474,323,004,944,782,828,398,182,400 1,234,567,890,123,456,718,070,421,139,719,794,622,419,313,690,432,875,243,234,074,448,189,700,007,474,323,004,944,782,828,398,182,400 1,234,567,890,123,456,718,070,421,139,719,794,622,419,313,690,432,875,243,234,074,448,189,700,007,474,323,004,944,782,828,398,182,400.00
-1.1 -1 -1 -1.10
-1234567890.1 -1,234,567,890 -1,234,567,890 -1,234,567,890.10
-1234567890.8 -1,234,567,891 -1,234,567,891 -1,234,567,890.80
-1.2345678901e10 -12,345,678,901 -12,345,678,901 -12,345,678,901.00
-12345678901234567890 -12,345,678,901,234,567,168 -12,345,678,901,234,567,168 -12,345,678,901,234,567,168.00
-1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890 -1,234,567,890,123,456,718,070,421,139,719,794,622,419,313,690,432,875,243,234,074,448,189,700,007,474,323,004,944,782,828,398,182,400 -1,234,567,890,123,456,718,070,421,139,719,794,622,419,313,690,432,875,243,234,074,448,189,700,007,474,323,004,944,782,828,398,182,400 -1,234,567,890,123,456,718,070,421,139,719,794,622,419,313,690,432,875,243,234,074,448,189,700,007,474,323,004,944,782,828,398,182,400.00
select c1, format(c1, -2), format(c1, 0), format(c1, 2) from (select * from bug3488) sub;
c1 format(c1, -2) format(c1, 0) format(c1, 2)
1 1 1 1.00
1234567890 1,234,567,890 1,234,567,890 1,234,567,890.00
1234567890 1,234,567,890 1,234,567,890 1,234,567,890.00
12345678900 12,345,678,900 12,345,678,900 12,345,678,900.00
1234567890 1,234,567,890 1,234,567,890 1,234,567,890.00
1234567890 1,234,567,890 1,234,567,890 1,234,567,890.00
-1 -1 -1 -1.00
-1234567890 -1,234,567,890 -1,234,567,890 -1,234,567,890.00
-1234567890 -1,234,567,890 -1,234,567,890 -1,234,567,890.00
-12345678900 -12,345,678,900 -12,345,678,900 -12,345,678,900.00
-1234567890 -1,234,567,890 -1,234,567,890 -1,234,567,890.00
-1234567890 -1,234,567,890 -1,234,567,890 -1,234,567,890.00
select c2, format(c2, -2), format(c2, 0), format(c2, 2) from (select * from bug3488) sub;
c2 format(c2, -2) format(c2, 0) format(c2, 2)
1.10 1 1 1.10
1234567890.10 1,234,567,890 1,234,567,890 1,234,567,890.10
1234567890.80 1,234,567,891 1,234,567,891 1,234,567,890.80
12345678901.00 12,345,678,901 12,345,678,901 12,345,678,901.00
1234567890123456.78 1,234,567,890,123,457 1,234,567,890,123,457 1,234,567,890,123,456.78
1234567890987654.32 1,234,567,890,987,654 1,234,567,890,987,654 1,234,567,890,987,654.32
-1.10 -1 -1 -1.10
-1234567890.10 -1,234,567,890 -1,234,567,890 -1,234,567,890.10
-1234567890.80 -1,234,567,891 -1,234,567,891 -1,234,567,890.80
-12345678901.00 -12,345,678,901 -12,345,678,901 -12,345,678,901.00
-1234567890123456.78 -1,234,567,890,123,457 -1,234,567,890,123,457 -1,234,567,890,123,456.78
-1234567890987654.32 -1,234,567,890,987,654 -1,234,567,890,987,654 -1,234,567,890,987,654.32
select c4, format(c4, -2), format(c4, 0), format(c4, 2) from (select * from bug3488) sub;
c4 format(c4, -2) format(c4, 0) format(c4, 2)
1.1 1 1 1.10
1234567890.1 1,234,567,890 1,234,567,890 1,234,567,890.10
1234567890.8 1,234,567,891 1,234,567,891 1,234,567,890.80
12345678901 12,345,678,901 12,345,678,901 12,345,678,901.00
1.2345678901e208 12,345,678,900,999,999,233,702,015,044,958,622,693,183,936,076,284,780,362,474,237,068,469,512,109,091,905,769,475,650,956,406,726,044,392,324,291,673,911,579,673,435,841,679,894,322,111,543,979,736,271,655,002,247,372,787,505,331,443,016,571,555,565,037,648,415,185,327,620,096 12,345,678,900,999,999,233,702,015,044,958,622,693,183,936,076,284,780,362,474,237,068,469,512,109,091,905,769,475,650,956,406,726,044,392,324,291,673,911,579,673,435,841,679,894,322,111,543,979,736,271,655,002,247,372,787,505,331,443,016,571,555,565,037,648,415,185,327,620,096 12,345,678,900,999,999,233,702,015,044,958,622,693,183,936,076,284,780,362,474,237,068,469,512,109,091,905,769,475,650,956,406,726,044,392,324,291,673,911,579,673,435,841,679,894,322,111,543,979,736,271,655,002,247,372,787,505,331,443,016,571,555,565,037,648,415,185,327,620,096.00
1.2345678901e308 123,456,789,010,000,003,013,769,221,302,475,265,236,473,260,868,443,180,100,707,231,243,197,604,846,678,491,603,701,791,833,592,622,260,767,755,587,241,551,101,641,071,285,970,395,887,287,299,936,335,501,367,119,307,918,969,722,323,877,313,450,129,317,836,543,043,061,686,055,660,760,257,877,809,447,984,085,651,532,908,811,501,208,193,676,911,145,259,694,125,922,340,467,359,889,260,267,302,158,242,651,570,176 123,456,789,010,000,003,013,769,221,302,475,265,236,473,260,868,443,180,100,707,231,243,197,604,846,678,491,603,701,791,833,592,622,260,767,755,587,241,551,101,641,071,285,970,395,887,287,299,936,335,501,367,119,307,918,969,722,323,877,313,450,129,317,836,543,043,061,686,055,660,760,257,877,809,447,984,085,651,532,908,811,501,208,193,676,911,145,259,694,125,922,340,467,359,889,260,267,302,158,242,651,570,176 123,456,789,010,000,003,013,769,221,302,475,265,236,473,260,868,443,180,100,707,231,243,197,604,846,678,491,603,701,791,833,592,622,260,767,755,587,241,551,101,641,071,285,970,395,887,287,299,936,335,501,367,119,307,918,969,722,323,877,313,450,129,317,836,543,043,061,686,055,660,760,257,877,809,447,984,085,651,532,908,811,501,208,193,676,911,145,259,694,125,922,340,467,359,889,260,267,302,158,242,651,570,176.00
-1.1 -1 -1 -1.10
-1234567890.1 -1,234,567,890 -1,234,567,890 -1,234,567,890.10
-1234567890.8 -1,234,567,891 -1,234,567,891 -1,234,567,890.80
-12345678901 -12,345,678,901 -12,345,678,901 -12,345,678,901.00
-1.2345678901e208 -12,345,678,900,999,999,233,702,015,044,958,622,693,183,936,076,284,780,362,474,237,068,469,512,109,091,905,769,475,650,956,406,726,044,392,324,291,673,911,579,673,435,841,679,894,322,111,543,979,736,271,655,002,247,372,787,505,331,443,016,571,555,565,037,648,415,185,327,620,096 -12,345,678,900,999,999,233,702,015,044,958,622,693,183,936,076,284,780,362,474,237,068,469,512,109,091,905,769,475,650,956,406,726,044,392,324,291,673,911,579,673,435,841,679,894,322,111,543,979,736,271,655,002,247,372,787,505,331,443,016,571,555,565,037,648,415,185,327,620,096 -12,345,678,900,999,999,233,702,015,044,958,622,693,183,936,076,284,780,362,474,237,068,469,512,109,091,905,769,475,650,956,406,726,044,392,324,291,673,911,579,673,435,841,679,894,322,111,543,979,736,271,655,002,247,372,787,505,331,443,016,571,555,565,037,648,415,185,327,620,096.00
-1.2345678901e308 -123,456,789,010,000,003,013,769,221,302,475,265,236,473,260,868,443,180,100,707,231,243,197,604,846,678,491,603,701,791,833,592,622,260,767,755,587,241,551,101,641,071,285,970,395,887,287,299,936,335,501,367,119,307,918,969,722,323,877,313,450,129,317,836,543,043,061,686,055,660,760,257,877,809,447,984,085,651,532,908,811,501,208,193,676,911,145,259,694,125,922,340,467,359,889,260,267,302,158,242,651,570,176 -123,456,789,010,000,003,013,769,221,302,475,265,236,473,260,868,443,180,100,707,231,243,197,604,846,678,491,603,701,791,833,592,622,260,767,755,587,241,551,101,641,071,285,970,395,887,287,299,936,335,501,367,119,307,918,969,722,323,877,313,450,129,317,836,543,043,061,686,055,660,760,257,877,809,447,984,085,651,532,908,811,501,208,193,676,911,145,259,694,125,922,340,467,359,889,260,267,302,158,242,651,570,176 -123,456,789,010,000,003,013,769,221,302,475,265,236,473,260,868,443,180,100,707,231,243,197,604,846,678,491,603,701,791,833,592,622,260,767,755,587,241,551,101,641,071,285,970,395,887,287,299,936,335,501,367,119,307,918,969,722,323,877,313,450,129,317,836,543,043,061,686,055,660,760,257,877,809,447,984,085,651,532,908,811,501,208,193,676,911,145,259,694,125,922,340,467,359,889,260,267,302,158,242,651,570,176.00
select c5, format(c5, -2), format(c5, 0), format(c5, 2) from (select * from bug3488) sub;
c5 format(c5, -2) format(c5, 0) format(c5, 2)
1.1 1 1 1.10
1234567890.1 1,234,567,890 1,234,567,890 1,234,567,890.10
1234567890.8 1,234,567,891 1,234,567,891 1,234,567,890.80
1.2345678901e10 12,345,678,901 12,345,678,901 12,345,678,901.00
12345678901234567890 12,345,678,901,234,567,168 12,345,678,901,234,567,168 12,345,678,901,234,567,168.00
12345678901234567890123456789012345678901234567890 12,345,678,901,234,566,660,398,341,115,085,767,575,755,770,822,656 12,345,678,901,234,566,660,398,341,115,085,767,575,755,770,822,656 12,345,678,901,234,566,660,398,341,115,085,767,575,755,770,822,656.00
-1.1 -1 -1 -1.10
-1234567890.1 -1,234,567,890 -1,234,567,890 -1,234,567,890.10
-1234567890.8 -1,234,567,891 -1,234,567,891 -1,234,567,890.80
-1.2345678901e10 -12,345,678,901 -12,345,678,901 -12,345,678,901.00
-12345678901234567890 -12,345,678,901,234,567,168 -12,345,678,901,234,567,168 -12,345,678,901,234,567,168.00
-12345678901234567890123456789012345678901234567890 -12,345,678,901,234,566,660,398,341,115,085,767,575,755,770,822,656 -12,345,678,901,234,566,660,398,341,115,085,767,575,755,770,822,656 -12,345,678,901,234,566,660,398,341,115,085,767,575,755,770,822,656.00
select c6, format(c6, -2), format(c6, 0), format(c6, 2) from (select * from bug3488) sub;
c6 format(c6, -2) format(c6, 0) format(c6, 2)
1.1 1 1 1.10
1234567890.1 1,234,567,890 1,234,567,890 1,234,567,890.10
1234567890.8 1,234,567,891 1,234,567,891 1,234,567,890.80
1.2345678901e10 12,345,678,901 12,345,678,901 12,345,678,901.00
12345678901234567890 12,345,678,901,234,567,168 12,345,678,901,234,567,168 12,345,678,901,234,567,168.00
1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890 1,234,567,890,123,456,718,070,421,139,719,794,622,419,313,690,432,875,243,234,074,448,189,700,007,474,323,004,944,782,828,398,182,400 1,234,567,890,123,456,718,070,421,139,719,794,622,419,313,690,432,875,243,234,074,448,189,700,007,474,323,004,944,782,828,398,182,400 1,234,567,890,123,456,718,070,421,139,719,794,622,419,313,690,432,875,243,234,074,448,189,700,007,474,323,004,944,782,828,398,182,400.00
-1.1 -1 -1 -1.10
-1234567890.1 -1,234,567,890 -1,234,567,890 -1,234,567,890.10
-1234567890.8 -1,234,567,891 -1,234,567,891 -1,234,567,890.80
-1.2345678901e10 -12,345,678,901 -12,345,678,901 -12,345,678,901.00
-12345678901234567890 -12,345,678,901,234,567,168 -12,345,678,901,234,567,168 -12,345,678,901,234,567,168.00
-1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890 -1,234,567,890,123,456,718,070,421,139,719,794,622,419,313,690,432,875,243,234,074,448,189,700,007,474,323,004,944,782,828,398,182,400 -1,234,567,890,123,456,718,070,421,139,719,794,622,419,313,690,432,875,243,234,074,448,189,700,007,474,323,004,944,782,828,398,182,400 -1,234,567,890,123,456,718,070,421,139,719,794,622,419,313,690,432,875,243,234,074,448,189,700,007,474,323,004,944,782,828,398,182,400.00
drop table bug3488;
View Git Blame Copy Permalink