~skinny.moey/drizzle/innodb-replication

« back to all changes in this revision

Viewing changes to tests/t/type_newdecimal.test

• browse files at revision 1807
• compare with another revision
• download diff
• download tarball
• view history from revision 1807

Show diffs side-by-side

added

removed

tests/t/type_newdecimal.test

105

105

#

106

106

# Trydy's tests

107

107

#

 

108

--error ER_DIVISION_BY_ZERO

108

109

select 1e10/0e0;

109

110

#create table wl1612 (col1 int, col2 decimal(38,10), col3 numeric(38,10));

110

111

#insert into wl1612 values(1,12345678901234567890.1234567890,12345678901234567890.1234567890);

722

723

select 1E-500 = 0;

723

724

#-- should return 1 (true).

724

725

#

 

726

--error ER_DIVISION_BY_ZERO

725

727

select 1 / 1E-500;

726

728

#

727

729

#-- should return SQLSTATE 22012 division by zero.

728

730

#

 

731

--error ER_DIVISION_BY_ZERO

729

732

select 1 / 0;

730

733

#-- should return SQLSTATE 22012 division by zero.

731

734

#

849

852

#-- error 1365

850

853

#UPDATE Sow6_2f SET col1 = col1 / 0 WHERE col1 > 0;

851

854

#-- should return SQLSTATE 22012 division by zero

 

855

--error ER_DIVISION_BY_ZERO

852

856

SELECT MOD(col1,0) FROM Sow6_2f;

853

857

#-- should return SQLSTATE 22012 division by zero

854

858

-- error 1366

865

869

# Bug #10404

866

870

#

867

871

 

 

872

--error ER_DIVISION_BY_ZERO

868

873

select 0/0;

869

874

 

870

875

#

901

906

# Bug #10599: problem with NULL

902

907

#

903

908

 

 

909

--error ER_DIVISION_BY_ZERO

904

910

select abs(10/0);

905

911

select abs(NULL);

906

912

 

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1