/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/ |
H A D | null.test | 323 SELECT a,NULLIF(a,2000),NULLIF(2000,a) FROM t1; 324 SELECT a,NULLIF(a,2001),NULLIF(2001,a) FROM t1; 341 NULLIF(1,1), 342 NULLIF(1,1.0), 343 NULLIF(1,1e0), 351 NULLIF(1.0,1), 352 NULLIF(1.0,1.0), 361 NULLIF(1e0,1), 370 NULLIF('1',1), 886 NULLIF(1, 1), [all …]
|
H A D | null.result | 415 SELECT a,NULLIF(a,2000),NULLIF(2000,a) FROM t1; 416 a NULLIF(a,2000) NULLIF(2000,a) 418 SELECT a,NULLIF(a,2001),NULLIF(2001,a) FROM t1; 419 a NULLIF(a,2001) NULLIF(2001,a) 439 NULLIF(1,1), 440 NULLIF(1,1.0), 441 NULLIF(1,1e0), 458 NULLIF(1.0,1), 477 NULLIF(1e0,1), 1765 NULLIF(AVG(a),0) NULLIF(AVG(LAST_VALUE(@a:=@a+1,a)),0) [all …]
|
H A D | empty_string_literal.result | 18 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 19 CHARSET(NULLIF('','')) NULLIF('','') 25 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 26 CHARSET(NULLIF('','')) NULLIF('','') 35 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 36 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 42 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 43 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 52 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 53 CHARSET(NULLIF(_cp1250 '',_cp1250 '')) NULLIF(_cp1250 '',_cp1250 '') [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/main/ |
H A D | null.test | 323 SELECT a,NULLIF(a,2000),NULLIF(2000,a) FROM t1; 324 SELECT a,NULLIF(a,2001),NULLIF(2001,a) FROM t1; 341 NULLIF(1,1), 342 NULLIF(1,1.0), 343 NULLIF(1,1e0), 351 NULLIF(1.0,1), 352 NULLIF(1.0,1.0), 361 NULLIF(1e0,1), 370 NULLIF('1',1), 886 NULLIF(1, 1), [all …]
|
H A D | null.result | 415 SELECT a,NULLIF(a,2000),NULLIF(2000,a) FROM t1; 416 a NULLIF(a,2000) NULLIF(2000,a) 418 SELECT a,NULLIF(a,2001),NULLIF(2001,a) FROM t1; 419 a NULLIF(a,2001) NULLIF(2001,a) 439 NULLIF(1,1), 440 NULLIF(1,1.0), 441 NULLIF(1,1e0), 458 NULLIF(1.0,1), 477 NULLIF(1e0,1), 1765 NULLIF(AVG(a),0) NULLIF(AVG(LAST_VALUE(@a:=@a+1,a)),0) [all …]
|
H A D | empty_string_literal.result | 18 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 19 CHARSET(NULLIF('','')) NULLIF('','') 25 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 26 CHARSET(NULLIF('','')) NULLIF('','') 35 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 36 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 42 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 43 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 52 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 53 CHARSET(NULLIF(_cp1250 '',_cp1250 '')) NULLIF(_cp1250 '',_cp1250 '') [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/main/ |
H A D | null.test | 323 SELECT a,NULLIF(a,2000),NULLIF(2000,a) FROM t1; 324 SELECT a,NULLIF(a,2001),NULLIF(2001,a) FROM t1; 341 NULLIF(1,1), 342 NULLIF(1,1.0), 343 NULLIF(1,1e0), 351 NULLIF(1.0,1), 352 NULLIF(1.0,1.0), 361 NULLIF(1e0,1), 370 NULLIF('1',1), 886 NULLIF(1, 1), [all …]
|
H A D | null.result | 415 SELECT a,NULLIF(a,2000),NULLIF(2000,a) FROM t1; 416 a NULLIF(a,2000) NULLIF(2000,a) 418 SELECT a,NULLIF(a,2001),NULLIF(2001,a) FROM t1; 419 a NULLIF(a,2001) NULLIF(2001,a) 439 NULLIF(1,1), 440 NULLIF(1,1.0), 441 NULLIF(1,1e0), 458 NULLIF(1.0,1), 477 NULLIF(1e0,1), 1765 NULLIF(AVG(a),0) NULLIF(AVG(LAST_VALUE(@a:=@a+1,a)),0) [all …]
|
H A D | empty_string_literal.result | 18 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 19 CHARSET(NULLIF('','')) NULLIF('','') 25 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 26 CHARSET(NULLIF('','')) NULLIF('','') 35 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 36 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 42 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 43 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 52 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 53 CHARSET(NULLIF(_cp1250 '',_cp1250 '')) NULLIF(_cp1250 '',_cp1250 '') [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/main/ |
H A D | null.test | 323 SELECT a,NULLIF(a,2000),NULLIF(2000,a) FROM t1; 324 SELECT a,NULLIF(a,2001),NULLIF(2001,a) FROM t1; 341 NULLIF(1,1), 342 NULLIF(1,1.0), 343 NULLIF(1,1e0), 351 NULLIF(1.0,1), 352 NULLIF(1.0,1.0), 361 NULLIF(1e0,1), 370 NULLIF('1',1), 886 NULLIF(1, 1), [all …]
|
H A D | null.result | 415 SELECT a,NULLIF(a,2000),NULLIF(2000,a) FROM t1; 416 a NULLIF(a,2000) NULLIF(2000,a) 418 SELECT a,NULLIF(a,2001),NULLIF(2001,a) FROM t1; 419 a NULLIF(a,2001) NULLIF(2001,a) 439 NULLIF(1,1), 440 NULLIF(1,1.0), 441 NULLIF(1,1e0), 458 NULLIF(1.0,1), 477 NULLIF(1e0,1), 1765 NULLIF(AVG(a),0) NULLIF(AVG(LAST_VALUE(@a:=@a+1,a)),0) [all …]
|
H A D | empty_string_literal.result | 18 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 19 CHARSET(NULLIF('','')) NULLIF('','') 25 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 26 CHARSET(NULLIF('','')) NULLIF('','') 35 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 36 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 42 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 43 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 52 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 53 CHARSET(NULLIF(_cp1250 '',_cp1250 '')) NULLIF(_cp1250 '',_cp1250 '') [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/main/ |
H A D | null.test | 323 SELECT a,NULLIF(a,2000),NULLIF(2000,a) FROM t1; 324 SELECT a,NULLIF(a,2001),NULLIF(2001,a) FROM t1; 341 NULLIF(1,1), 342 NULLIF(1,1.0), 343 NULLIF(1,1e0), 351 NULLIF(1.0,1), 352 NULLIF(1.0,1.0), 361 NULLIF(1e0,1), 370 NULLIF('1',1), 886 NULLIF(1, 1), [all …]
|
H A D | null.result | 415 SELECT a,NULLIF(a,2000),NULLIF(2000,a) FROM t1; 416 a NULLIF(a,2000) NULLIF(2000,a) 418 SELECT a,NULLIF(a,2001),NULLIF(2001,a) FROM t1; 419 a NULLIF(a,2001) NULLIF(2001,a) 439 NULLIF(1,1), 440 NULLIF(1,1.0), 441 NULLIF(1,1e0), 458 NULLIF(1.0,1), 477 NULLIF(1e0,1), 1765 NULLIF(AVG(a),0) NULLIF(AVG(LAST_VALUE(@a:=@a+1,a)),0) [all …]
|
H A D | empty_string_literal.result | 18 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 19 CHARSET(NULLIF('','')) NULLIF('','') 25 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 26 CHARSET(NULLIF('','')) NULLIF('','') 35 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 36 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 42 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 43 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 52 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 53 CHARSET(NULLIF(_cp1250 '',_cp1250 '')) NULLIF(_cp1250 '',_cp1250 '') [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/main/ |
H A D | null.test | 323 SELECT a,NULLIF(a,2000),NULLIF(2000,a) FROM t1; 324 SELECT a,NULLIF(a,2001),NULLIF(2001,a) FROM t1; 341 NULLIF(1,1), 342 NULLIF(1,1.0), 343 NULLIF(1,1e0), 351 NULLIF(1.0,1), 352 NULLIF(1.0,1.0), 361 NULLIF(1e0,1), 370 NULLIF('1',1), 886 NULLIF(1, 1), [all …]
|
H A D | null.result | 415 SELECT a,NULLIF(a,2000),NULLIF(2000,a) FROM t1; 416 a NULLIF(a,2000) NULLIF(2000,a) 418 SELECT a,NULLIF(a,2001),NULLIF(2001,a) FROM t1; 419 a NULLIF(a,2001) NULLIF(2001,a) 439 NULLIF(1,1), 440 NULLIF(1,1.0), 441 NULLIF(1,1e0), 458 NULLIF(1.0,1), 477 NULLIF(1e0,1), 1765 NULLIF(AVG(a),0) NULLIF(AVG(LAST_VALUE(@a:=@a+1,a)),0) [all …]
|
H A D | empty_string_literal.result | 18 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 19 CHARSET(NULLIF('','')) NULLIF('','') 25 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 26 CHARSET(NULLIF('','')) NULLIF('','') 35 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 36 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 42 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 43 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 52 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 53 CHARSET(NULLIF(_cp1250 '',_cp1250 '')) NULLIF(_cp1250 '',_cp1250 '') [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/suite/compat/oracle/r/ |
H A D | empty_string_literal.result | 18 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 19 CHARSET(NULLIF('','')) NULLIF('','') 25 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 26 CHARSET(NULLIF('','')) NULLIF('','') 35 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 36 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 42 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 43 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 52 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 53 CHARSET(NULLIF(_cp1250 '',_cp1250 '')) NULLIF(_cp1250 '',_cp1250 '') [all …]
|
/dports/databases/mariadb104-client/mariadb-10.4.24/mysql-test/suite/compat/oracle/r/ |
H A D | empty_string_literal.result | 18 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 19 CHARSET(NULLIF('','')) NULLIF('','') 25 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 26 CHARSET(NULLIF('','')) NULLIF('','') 35 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 36 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 42 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 43 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 52 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 53 CHARSET(NULLIF(_cp1250 '',_cp1250 '')) NULLIF(_cp1250 '',_cp1250 '') [all …]
|
/dports/databases/mariadb104-server/mariadb-10.4.24/mysql-test/suite/compat/oracle/r/ |
H A D | empty_string_literal.result | 18 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 19 CHARSET(NULLIF('','')) NULLIF('','') 25 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 26 CHARSET(NULLIF('','')) NULLIF('','') 35 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 36 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 42 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 43 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 52 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 53 CHARSET(NULLIF(_cp1250 '',_cp1250 '')) NULLIF(_cp1250 '',_cp1250 '') [all …]
|
/dports/databases/mariadb105-server/mariadb-10.5.15/mysql-test/suite/compat/oracle/r/ |
H A D | empty_string_literal.result | 18 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 19 CHARSET(NULLIF('','')) NULLIF('','') 25 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 26 CHARSET(NULLIF('','')) NULLIF('','') 35 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 36 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 42 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 43 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 52 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 53 CHARSET(NULLIF(_cp1250 '',_cp1250 '')) NULLIF(_cp1250 '',_cp1250 '') [all …]
|
/dports/databases/mariadb103-server/mariadb-10.3.34/mysql-test/suite/compat/oracle/r/ |
H A D | empty_string_literal.result | 18 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 19 CHARSET(NULLIF('','')) NULLIF('','') 25 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 26 CHARSET(NULLIF('','')) NULLIF('','') 35 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 36 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 42 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 43 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 52 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 53 CHARSET(NULLIF(_cp1250 '',_cp1250 '')) NULLIF(_cp1250 '',_cp1250 '') [all …]
|
/dports/databases/mariadb103-client/mariadb-10.3.34/mysql-test/suite/compat/oracle/r/ |
H A D | empty_string_literal.result | 18 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 19 CHARSET(NULLIF('','')) NULLIF('','') 25 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 26 CHARSET(NULLIF('','')) NULLIF('','') 35 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 36 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 42 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 43 CHARSET(NULLIF(N'',N'')) NULLIF(N'',N'') 52 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 53 CHARSET(NULLIF(_cp1250 '',_cp1250 '')) NULLIF(_cp1250 '',_cp1250 '') [all …]
|
/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/include/ |
H A D | empty_string_literal.inc | 10 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 13 SELECT CHARSET(NULLIF('','')),NULLIF('',''); 20 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 23 SELECT CHARSET(NULLIF(N'',N'')),NULLIF(N'',N''); 30 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 33 SELECT CHARSET(NULLIF(_cp1250 '',_cp1250 '')),NULLIF(_cp1250 '',_cp1250 ''); 73 SELECT NULLIF(_cp1250 '',_cp1250 '') 75 SELECT NULLIF(N'',N'');
|