1535
1535
locate('lo','hello',-18446744073709551615)
1538
Error 1292 Truncated incorrect DECIMAL value: ''
1538
Warning 1292 Truncated incorrect DECIMAL value: ''
1539
1539
select locate('lo','hello',18446744073709551615);
1540
1540
locate('lo','hello',18446744073709551615)
1543
1543
locate('lo','hello',-18446744073709551616)
1546
Error 1292 Truncated incorrect DECIMAL value: ''
1546
Warning 1292 Truncated incorrect DECIMAL value: ''
1547
1547
select locate('lo','hello',18446744073709551616);
1548
1548
locate('lo','hello',18446744073709551616)
1551
Error 1292 Truncated incorrect DECIMAL value: ''
1551
Warning 1292 Truncated incorrect DECIMAL value: ''
1552
1552
select locate('lo','hello',-18446744073709551617);
1553
1553
locate('lo','hello',-18446744073709551617)
1556
Error 1292 Truncated incorrect DECIMAL value: ''
1556
Warning 1292 Truncated incorrect DECIMAL value: ''
1557
1557
select locate('lo','hello',18446744073709551617);
1558
1558
locate('lo','hello',18446744073709551617)
1561
Error 1292 Truncated incorrect DECIMAL value: ''
1561
Warning 1292 Truncated incorrect DECIMAL value: ''
1562
1562
select left('hello', 10);
1563
1563
left('hello', 10)
1590
1590
left('hello', -18446744073709551615)
1593
Error 1292 Truncated incorrect DECIMAL value: ''
1594
Error 1292 Truncated incorrect DECIMAL value: ''
1593
Warning 1292 Truncated incorrect DECIMAL value: ''
1594
Warning 1292 Truncated incorrect DECIMAL value: ''
1595
1595
select left('hello', 18446744073709551615);
1596
1596
left('hello', 18446744073709551615)
1599
1599
left('hello', -18446744073709551616)
1602
Error 1292 Truncated incorrect DECIMAL value: ''
1603
Error 1292 Truncated incorrect DECIMAL value: ''
1602
Warning 1292 Truncated incorrect DECIMAL value: ''
1603
Warning 1292 Truncated incorrect DECIMAL value: ''
1604
1604
select left('hello', 18446744073709551616);
1605
1605
left('hello', 18446744073709551616)
1608
Error 1292 Truncated incorrect DECIMAL value: ''
1609
Error 1292 Truncated incorrect DECIMAL value: ''
1608
Warning 1292 Truncated incorrect DECIMAL value: ''
1609
Warning 1292 Truncated incorrect DECIMAL value: ''
1610
1610
select left('hello', -18446744073709551617);
1611
1611
left('hello', -18446744073709551617)
1614
Error 1292 Truncated incorrect DECIMAL value: ''
1615
Error 1292 Truncated incorrect DECIMAL value: ''
1614
Warning 1292 Truncated incorrect DECIMAL value: ''
1615
Warning 1292 Truncated incorrect DECIMAL value: ''
1616
1616
select left('hello', 18446744073709551617);
1617
1617
left('hello', 18446744073709551617)
1620
Error 1292 Truncated incorrect DECIMAL value: ''
1621
Error 1292 Truncated incorrect DECIMAL value: ''
1620
Warning 1292 Truncated incorrect DECIMAL value: ''
1621
Warning 1292 Truncated incorrect DECIMAL value: ''
1622
1622
select right('hello', 10);
1623
1623
right('hello', 10)
1650
1650
right('hello', -18446744073709551615)
1653
Error 1292 Truncated incorrect DECIMAL value: ''
1654
Error 1292 Truncated incorrect DECIMAL value: ''
1653
Warning 1292 Truncated incorrect DECIMAL value: ''
1654
Warning 1292 Truncated incorrect DECIMAL value: ''
1655
1655
select right('hello', 18446744073709551615);
1656
1656
right('hello', 18446744073709551615)
1659
1659
right('hello', -18446744073709551616)
1662
Error 1292 Truncated incorrect DECIMAL value: ''
1663
Error 1292 Truncated incorrect DECIMAL value: ''
1662
Warning 1292 Truncated incorrect DECIMAL value: ''
1663
Warning 1292 Truncated incorrect DECIMAL value: ''
1664
1664
select right('hello', 18446744073709551616);
1665
1665
right('hello', 18446744073709551616)
1668
Error 1292 Truncated incorrect DECIMAL value: ''
1669
Error 1292 Truncated incorrect DECIMAL value: ''
1668
Warning 1292 Truncated incorrect DECIMAL value: ''
1669
Warning 1292 Truncated incorrect DECIMAL value: ''
1670
1670
select right('hello', -18446744073709551617);
1671
1671
right('hello', -18446744073709551617)
1674
Error 1292 Truncated incorrect DECIMAL value: ''
1675
Error 1292 Truncated incorrect DECIMAL value: ''
1674
Warning 1292 Truncated incorrect DECIMAL value: ''
1675
Warning 1292 Truncated incorrect DECIMAL value: ''
1676
1676
select right('hello', 18446744073709551617);
1677
1677
right('hello', 18446744073709551617)
1680
Error 1292 Truncated incorrect DECIMAL value: ''
1681
Error 1292 Truncated incorrect DECIMAL value: ''
1680
Warning 1292 Truncated incorrect DECIMAL value: ''
1681
Warning 1292 Truncated incorrect DECIMAL value: ''
1682
1682
select substring('hello', 2, -1);
1683
1683
substring('hello', 2, -1)
1710
1710
substring('hello', -18446744073709551615, 1)
1713
Error 1292 Truncated incorrect DECIMAL value: ''
1714
Error 1292 Truncated incorrect DECIMAL value: ''
1713
Warning 1292 Truncated incorrect DECIMAL value: ''
1714
Warning 1292 Truncated incorrect DECIMAL value: ''
1715
1715
select substring('hello', 18446744073709551615, 1);
1716
1716
substring('hello', 18446744073709551615, 1)
1719
1719
substring('hello', -18446744073709551616, 1)
1722
Error 1292 Truncated incorrect DECIMAL value: ''
1723
Error 1292 Truncated incorrect DECIMAL value: ''
1722
Warning 1292 Truncated incorrect DECIMAL value: ''
1723
Warning 1292 Truncated incorrect DECIMAL value: ''
1724
1724
select substring('hello', 18446744073709551616, 1);
1725
1725
substring('hello', 18446744073709551616, 1)
1728
Error 1292 Truncated incorrect DECIMAL value: ''
1729
Error 1292 Truncated incorrect DECIMAL value: ''
1728
Warning 1292 Truncated incorrect DECIMAL value: ''
1729
Warning 1292 Truncated incorrect DECIMAL value: ''
1730
1730
select substring('hello', -18446744073709551617, 1);
1731
1731
substring('hello', -18446744073709551617, 1)
1734
Error 1292 Truncated incorrect DECIMAL value: ''
1735
Error 1292 Truncated incorrect DECIMAL value: ''
1734
Warning 1292 Truncated incorrect DECIMAL value: ''
1735
Warning 1292 Truncated incorrect DECIMAL value: ''
1736
1736
select substring('hello', 18446744073709551617, 1);
1737
1737
substring('hello', 18446744073709551617, 1)
1740
Error 1292 Truncated incorrect DECIMAL value: ''
1741
Error 1292 Truncated incorrect DECIMAL value: ''
1740
Warning 1292 Truncated incorrect DECIMAL value: ''
1741
Warning 1292 Truncated incorrect DECIMAL value: ''
1742
1742
select substring('hello', 1, -1);
1743
1743
substring('hello', 1, -1)
1764
1764
substring('hello', 1, -18446744073709551615)
1767
Error 1292 Truncated incorrect DECIMAL value: ''
1768
Error 1292 Truncated incorrect DECIMAL value: ''
1767
Warning 1292 Truncated incorrect DECIMAL value: ''
1768
Warning 1292 Truncated incorrect DECIMAL value: ''
1769
1769
select substring('hello', 1, 18446744073709551615);
1770
1770
substring('hello', 1, 18446744073709551615)
1773
1773
substring('hello', 1, -18446744073709551616)
1776
Error 1292 Truncated incorrect DECIMAL value: ''
1777
Error 1292 Truncated incorrect DECIMAL value: ''
1776
Warning 1292 Truncated incorrect DECIMAL value: ''
1777
Warning 1292 Truncated incorrect DECIMAL value: ''
1778
1778
select substring('hello', 1, 18446744073709551616);
1779
1779
substring('hello', 1, 18446744073709551616)
1782
Error 1292 Truncated incorrect DECIMAL value: ''
1783
Error 1292 Truncated incorrect DECIMAL value: ''
1782
Warning 1292 Truncated incorrect DECIMAL value: ''
1783
Warning 1292 Truncated incorrect DECIMAL value: ''
1784
1784
select substring('hello', 1, -18446744073709551617);
1785
1785
substring('hello', 1, -18446744073709551617)
1788
Error 1292 Truncated incorrect DECIMAL value: ''
1789
Error 1292 Truncated incorrect DECIMAL value: ''
1788
Warning 1292 Truncated incorrect DECIMAL value: ''
1789
Warning 1292 Truncated incorrect DECIMAL value: ''
1790
1790
select substring('hello', 1, 18446744073709551617);
1791
1791
substring('hello', 1, 18446744073709551617)
1794
Error 1292 Truncated incorrect DECIMAL value: ''
1795
Error 1292 Truncated incorrect DECIMAL value: ''
1794
Warning 1292 Truncated incorrect DECIMAL value: ''
1795
Warning 1292 Truncated incorrect DECIMAL value: ''
1796
1796
select substring('hello', -1, -1);
1797
1797
substring('hello', -1, -1)
1818
1818
substring('hello', -18446744073709551615, -18446744073709551615)
1821
Error 1292 Truncated incorrect DECIMAL value: ''
1822
Error 1292 Truncated incorrect DECIMAL value: ''
1823
Error 1292 Truncated incorrect DECIMAL value: ''
1824
Error 1292 Truncated incorrect DECIMAL value: ''
1821
Warning 1292 Truncated incorrect DECIMAL value: ''
1822
Warning 1292 Truncated incorrect DECIMAL value: ''
1823
Warning 1292 Truncated incorrect DECIMAL value: ''
1824
Warning 1292 Truncated incorrect DECIMAL value: ''
1825
1825
select substring('hello', 18446744073709551615, 18446744073709551615);
1826
1826
substring('hello', 18446744073709551615, 18446744073709551615)
1829
1829
substring('hello', -18446744073709551616, -18446744073709551616)
1832
Error 1292 Truncated incorrect DECIMAL value: ''
1833
Error 1292 Truncated incorrect DECIMAL value: ''
1834
Error 1292 Truncated incorrect DECIMAL value: ''
1835
Error 1292 Truncated incorrect DECIMAL value: ''
1832
Warning 1292 Truncated incorrect DECIMAL value: ''
1833
Warning 1292 Truncated incorrect DECIMAL value: ''
1834
Warning 1292 Truncated incorrect DECIMAL value: ''
1835
Warning 1292 Truncated incorrect DECIMAL value: ''
1836
1836
select substring('hello', 18446744073709551616, 18446744073709551616);
1837
1837
substring('hello', 18446744073709551616, 18446744073709551616)
1840
Error 1292 Truncated incorrect DECIMAL value: ''
1841
Error 1292 Truncated incorrect DECIMAL value: ''
1842
Error 1292 Truncated incorrect DECIMAL value: ''
1843
Error 1292 Truncated incorrect DECIMAL value: ''
1840
Warning 1292 Truncated incorrect DECIMAL value: ''
1841
Warning 1292 Truncated incorrect DECIMAL value: ''
1842
Warning 1292 Truncated incorrect DECIMAL value: ''
1843
Warning 1292 Truncated incorrect DECIMAL value: ''
1844
1844
select substring('hello', -18446744073709551617, -18446744073709551617);
1845
1845
substring('hello', -18446744073709551617, -18446744073709551617)
1848
Error 1292 Truncated incorrect DECIMAL value: ''
1849
Error 1292 Truncated incorrect DECIMAL value: ''
1850
Error 1292 Truncated incorrect DECIMAL value: ''
1851
Error 1292 Truncated incorrect DECIMAL value: ''
1848
Warning 1292 Truncated incorrect DECIMAL value: ''
1849
Warning 1292 Truncated incorrect DECIMAL value: ''
1850
Warning 1292 Truncated incorrect DECIMAL value: ''
1851
Warning 1292 Truncated incorrect DECIMAL value: ''
1852
1852
select substring('hello', 18446744073709551617, 18446744073709551617);
1853
1853
substring('hello', 18446744073709551617, 18446744073709551617)
1856
Error 1292 Truncated incorrect DECIMAL value: ''
1857
Error 1292 Truncated incorrect DECIMAL value: ''
1858
Error 1292 Truncated incorrect DECIMAL value: ''
1859
Error 1292 Truncated incorrect DECIMAL value: ''
1856
Warning 1292 Truncated incorrect DECIMAL value: ''
1857
Warning 1292 Truncated incorrect DECIMAL value: ''
1858
Warning 1292 Truncated incorrect DECIMAL value: ''
1859
Warning 1292 Truncated incorrect DECIMAL value: ''
1860
1860
select insert('hello', -1, 1, 'hi');
1861
1861
insert('hello', -1, 1, 'hi')
1882
1882
insert('hello', -18446744073709551615, 1, 'hi')
1885
Error 1292 Truncated incorrect DECIMAL value: ''
1885
Warning 1292 Truncated incorrect DECIMAL value: ''
1886
1886
select insert('hello', 18446744073709551615, 1, 'hi');
1887
1887
insert('hello', 18446744073709551615, 1, 'hi')
1890
1890
insert('hello', -18446744073709551616, 1, 'hi')
1893
Error 1292 Truncated incorrect DECIMAL value: ''
1893
Warning 1292 Truncated incorrect DECIMAL value: ''
1894
1894
select insert('hello', 18446744073709551616, 1, 'hi');
1895
1895
insert('hello', 18446744073709551616, 1, 'hi')
1898
Error 1292 Truncated incorrect DECIMAL value: ''
1898
Warning 1292 Truncated incorrect DECIMAL value: ''
1899
1899
select insert('hello', -18446744073709551617, 1, 'hi');
1900
1900
insert('hello', -18446744073709551617, 1, 'hi')
1903
Error 1292 Truncated incorrect DECIMAL value: ''
1903
Warning 1292 Truncated incorrect DECIMAL value: ''
1904
1904
select insert('hello', 18446744073709551617, 1, 'hi');
1905
1905
insert('hello', 18446744073709551617, 1, 'hi')
1908
Error 1292 Truncated incorrect DECIMAL value: ''
1908
Warning 1292 Truncated incorrect DECIMAL value: ''
1909
1909
select insert('hello', 1, -1, 'hi');
1910
1910
insert('hello', 1, -1, 'hi')
1931
1931
insert('hello', 1, -18446744073709551615, 'hi')
1934
Error 1292 Truncated incorrect DECIMAL value: ''
1934
Warning 1292 Truncated incorrect DECIMAL value: ''
1935
1935
select insert('hello', 1, 18446744073709551615, 'hi');
1936
1936
insert('hello', 1, 18446744073709551615, 'hi')
1939
1939
insert('hello', 1, -18446744073709551616, 'hi')
1942
Error 1292 Truncated incorrect DECIMAL value: ''
1942
Warning 1292 Truncated incorrect DECIMAL value: ''
1943
1943
select insert('hello', 1, 18446744073709551616, 'hi');
1944
1944
insert('hello', 1, 18446744073709551616, 'hi')
1947
Error 1292 Truncated incorrect DECIMAL value: ''
1947
Warning 1292 Truncated incorrect DECIMAL value: ''
1948
1948
select insert('hello', 1, -18446744073709551617, 'hi');
1949
1949
insert('hello', 1, -18446744073709551617, 'hi')
1952
Error 1292 Truncated incorrect DECIMAL value: ''
1952
Warning 1292 Truncated incorrect DECIMAL value: ''
1953
1953
select insert('hello', 1, 18446744073709551617, 'hi');
1954
1954
insert('hello', 1, 18446744073709551617, 'hi')
1957
Error 1292 Truncated incorrect DECIMAL value: ''
1957
Warning 1292 Truncated incorrect DECIMAL value: ''
1958
1958
select insert('hello', -1, -1, 'hi');
1959
1959
insert('hello', -1, -1, 'hi')
1980
1980
insert('hello', -18446744073709551615, -18446744073709551615, 'hi')
1983
Error 1292 Truncated incorrect DECIMAL value: ''
1984
Error 1292 Truncated incorrect DECIMAL value: ''
1983
Warning 1292 Truncated incorrect DECIMAL value: ''
1984
Warning 1292 Truncated incorrect DECIMAL value: ''
1985
1985
select insert('hello', 18446744073709551615, 18446744073709551615, 'hi');
1986
1986
insert('hello', 18446744073709551615, 18446744073709551615, 'hi')
1989
1989
insert('hello', -18446744073709551616, -18446744073709551616, 'hi')
1992
Error 1292 Truncated incorrect DECIMAL value: ''
1993
Error 1292 Truncated incorrect DECIMAL value: ''
1992
Warning 1292 Truncated incorrect DECIMAL value: ''
1993
Warning 1292 Truncated incorrect DECIMAL value: ''
1994
1994
select insert('hello', 18446744073709551616, 18446744073709551616, 'hi');
1995
1995
insert('hello', 18446744073709551616, 18446744073709551616, 'hi')
1998
Error 1292 Truncated incorrect DECIMAL value: ''
1999
Error 1292 Truncated incorrect DECIMAL value: ''
1998
Warning 1292 Truncated incorrect DECIMAL value: ''
1999
Warning 1292 Truncated incorrect DECIMAL value: ''
2000
2000
select insert('hello', -18446744073709551617, -18446744073709551617, 'hi');
2001
2001
insert('hello', -18446744073709551617, -18446744073709551617, 'hi')
2004
Error 1292 Truncated incorrect DECIMAL value: ''
2005
Error 1292 Truncated incorrect DECIMAL value: ''
2004
Warning 1292 Truncated incorrect DECIMAL value: ''
2005
Warning 1292 Truncated incorrect DECIMAL value: ''
2006
2006
select insert('hello', 18446744073709551617, 18446744073709551617, 'hi');
2007
2007
insert('hello', 18446744073709551617, 18446744073709551617, 'hi')
2010
Error 1292 Truncated incorrect DECIMAL value: ''
2011
Error 1292 Truncated incorrect DECIMAL value: ''
2010
Warning 1292 Truncated incorrect DECIMAL value: ''
2011
Warning 1292 Truncated incorrect DECIMAL value: ''
2012
2012
select repeat('hello', -1);
2013
2013
repeat('hello', -1)
2040
2040
repeat('hello', -18446744073709551615)
2043
Error 1292 Truncated incorrect DECIMAL value: ''
2044
Error 1292 Truncated incorrect DECIMAL value: ''
2043
Warning 1292 Truncated incorrect DECIMAL value: ''
2044
Warning 1292 Truncated incorrect DECIMAL value: ''
2045
2045
select repeat('hello', 18446744073709551615);
2046
2046
repeat('hello', 18446744073709551615)
2051
2051
repeat('hello', -18446744073709551616)
2054
Error 1292 Truncated incorrect DECIMAL value: ''
2055
Error 1292 Truncated incorrect DECIMAL value: ''
2054
Warning 1292 Truncated incorrect DECIMAL value: ''
2055
Warning 1292 Truncated incorrect DECIMAL value: ''
2056
2056
select repeat('hello', 18446744073709551616);
2057
2057
repeat('hello', 18446744073709551616)
2060
Error 1292 Truncated incorrect DECIMAL value: ''
2061
Error 1292 Truncated incorrect DECIMAL value: ''
2060
Warning 1292 Truncated incorrect DECIMAL value: ''
2061
Warning 1292 Truncated incorrect DECIMAL value: ''
2062
2062
Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated
2063
2063
select repeat('hello', -18446744073709551617);
2064
2064
repeat('hello', -18446744073709551617)
2067
Error 1292 Truncated incorrect DECIMAL value: ''
2068
Error 1292 Truncated incorrect DECIMAL value: ''
2067
Warning 1292 Truncated incorrect DECIMAL value: ''
2068
Warning 1292 Truncated incorrect DECIMAL value: ''
2069
2069
select repeat('hello', 18446744073709551617);
2070
2070
repeat('hello', 18446744073709551617)
2073
Error 1292 Truncated incorrect DECIMAL value: ''
2074
Error 1292 Truncated incorrect DECIMAL value: ''
2073
Warning 1292 Truncated incorrect DECIMAL value: ''
2074
Warning 1292 Truncated incorrect DECIMAL value: ''
2075
2075
Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated
2076
2076
select space(-1);
2104
2104
space(-18446744073709551615)
2107
Error 1292 Truncated incorrect DECIMAL value: ''
2108
Error 1292 Truncated incorrect DECIMAL value: ''
2107
Warning 1292 Truncated incorrect DECIMAL value: ''
2108
Warning 1292 Truncated incorrect DECIMAL value: ''
2109
2109
select space(18446744073709551615);
2110
2110
space(18446744073709551615)
2115
2115
space(-18446744073709551616)
2118
Error 1292 Truncated incorrect DECIMAL value: ''
2119
Error 1292 Truncated incorrect DECIMAL value: ''
2118
Warning 1292 Truncated incorrect DECIMAL value: ''
2119
Warning 1292 Truncated incorrect DECIMAL value: ''
2120
2120
select space(18446744073709551616);
2121
2121
space(18446744073709551616)
2124
Error 1292 Truncated incorrect DECIMAL value: ''
2125
Error 1292 Truncated incorrect DECIMAL value: ''
2124
Warning 1292 Truncated incorrect DECIMAL value: ''
2125
Warning 1292 Truncated incorrect DECIMAL value: ''
2126
2126
Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated
2127
2127
select space(-18446744073709551617);
2128
2128
space(-18446744073709551617)
2131
Error 1292 Truncated incorrect DECIMAL value: ''
2132
Error 1292 Truncated incorrect DECIMAL value: ''
2131
Warning 1292 Truncated incorrect DECIMAL value: ''
2132
Warning 1292 Truncated incorrect DECIMAL value: ''
2133
2133
select space(18446744073709551617);
2134
2134
space(18446744073709551617)
2137
Error 1292 Truncated incorrect DECIMAL value: ''
2138
Error 1292 Truncated incorrect DECIMAL value: ''
2137
Warning 1292 Truncated incorrect DECIMAL value: ''
2138
Warning 1292 Truncated incorrect DECIMAL value: ''
2139
2139
Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated
2140
2140
select rpad('hello', -1, '1');
2141
2141
rpad('hello', -1, '1')
2168
2168
rpad('hello', -18446744073709551615, '1')
2171
Error 1292 Truncated incorrect DECIMAL value: ''
2172
Error 1292 Truncated incorrect DECIMAL value: ''
2171
Warning 1292 Truncated incorrect DECIMAL value: ''
2172
Warning 1292 Truncated incorrect DECIMAL value: ''
2173
2173
select rpad('hello', 18446744073709551615, '1');
2174
2174
rpad('hello', 18446744073709551615, '1')
2179
2179
rpad('hello', -18446744073709551616, '1')
2182
Error 1292 Truncated incorrect DECIMAL value: ''
2183
Error 1292 Truncated incorrect DECIMAL value: ''
2182
Warning 1292 Truncated incorrect DECIMAL value: ''
2183
Warning 1292 Truncated incorrect DECIMAL value: ''
2184
2184
select rpad('hello', 18446744073709551616, '1');
2185
2185
rpad('hello', 18446744073709551616, '1')
2188
Error 1292 Truncated incorrect DECIMAL value: ''
2189
Error 1292 Truncated incorrect DECIMAL value: ''
2188
Warning 1292 Truncated incorrect DECIMAL value: ''
2189
Warning 1292 Truncated incorrect DECIMAL value: ''
2190
2190
Warning 1301 Result of rpad() was larger than max_allowed_packet (1048576) - truncated
2191
2191
select rpad('hello', -18446744073709551617, '1');
2192
2192
rpad('hello', -18446744073709551617, '1')
2195
Error 1292 Truncated incorrect DECIMAL value: ''
2196
Error 1292 Truncated incorrect DECIMAL value: ''
2195
Warning 1292 Truncated incorrect DECIMAL value: ''
2196
Warning 1292 Truncated incorrect DECIMAL value: ''
2197
2197
select rpad('hello', 18446744073709551617, '1');
2198
2198
rpad('hello', 18446744073709551617, '1')
2201
Error 1292 Truncated incorrect DECIMAL value: ''
2202
Error 1292 Truncated incorrect DECIMAL value: ''
2201
Warning 1292 Truncated incorrect DECIMAL value: ''
2202
Warning 1292 Truncated incorrect DECIMAL value: ''
2203
2203
Warning 1301 Result of rpad() was larger than max_allowed_packet (1048576) - truncated
2204
2204
select lpad('hello', -1, '1');
2205
2205
lpad('hello', -1, '1')
2232
2232
lpad('hello', -18446744073709551615, '1')
2235
Error 1292 Truncated incorrect DECIMAL value: ''
2236
Error 1292 Truncated incorrect DECIMAL value: ''
2235
Warning 1292 Truncated incorrect DECIMAL value: ''
2236
Warning 1292 Truncated incorrect DECIMAL value: ''
2237
2237
select lpad('hello', 18446744073709551615, '1');
2238
2238
lpad('hello', 18446744073709551615, '1')
2243
2243
lpad('hello', -18446744073709551616, '1')
2246
Error 1292 Truncated incorrect DECIMAL value: ''
2247
Error 1292 Truncated incorrect DECIMAL value: ''
2246
Warning 1292 Truncated incorrect DECIMAL value: ''
2247
Warning 1292 Truncated incorrect DECIMAL value: ''
2248
2248
select lpad('hello', 18446744073709551616, '1');
2249
2249
lpad('hello', 18446744073709551616, '1')
2252
Error 1292 Truncated incorrect DECIMAL value: ''
2253
Error 1292 Truncated incorrect DECIMAL value: ''
2252
Warning 1292 Truncated incorrect DECIMAL value: ''
2253
Warning 1292 Truncated incorrect DECIMAL value: ''
2254
2254
Warning 1301 Result of lpad() was larger than max_allowed_packet (1048576) - truncated
2255
2255
select lpad('hello', -18446744073709551617, '1');
2256
2256
lpad('hello', -18446744073709551617, '1')
2259
Error 1292 Truncated incorrect DECIMAL value: ''
2260
Error 1292 Truncated incorrect DECIMAL value: ''
2259
Warning 1292 Truncated incorrect DECIMAL value: ''
2260
Warning 1292 Truncated incorrect DECIMAL value: ''
2261
2261
select lpad('hello', 18446744073709551617, '1');
2262
2262
lpad('hello', 18446744073709551617, '1')
2265
Error 1292 Truncated incorrect DECIMAL value: ''
2266
Error 1292 Truncated incorrect DECIMAL value: ''
2265
Warning 1292 Truncated incorrect DECIMAL value: ''
2266
Warning 1292 Truncated incorrect DECIMAL value: ''
2267
2267
Warning 1301 Result of lpad() was larger than max_allowed_packet (1048576) - truncated
2268
2268
SET @orig_sql_mode = @@SQL_MODE;
2269
2269
SET SQL_MODE=traditional;