Home
last modified time | relevance | path

Searched refs:NULLIF (Results 1 – 25 of 1631) sorted by relevance

12345678910>>...66

/dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/
H A Dnull.test323 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 Dnull.result415 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 Dempty_string_literal.result18 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 Dnull.test323 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 Dnull.result415 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 Dempty_string_literal.result18 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 Dnull.test323 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 Dnull.result415 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 Dempty_string_literal.result18 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 Dnull.test323 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 Dnull.result415 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 Dempty_string_literal.result18 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 Dnull.test323 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 Dnull.result415 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 Dempty_string_literal.result18 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 Dnull.test323 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 Dnull.result415 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 Dempty_string_literal.result18 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 Dempty_string_literal.result18 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 Dempty_string_literal.result18 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 Dempty_string_literal.result18 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 Dempty_string_literal.result18 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 Dempty_string_literal.result18 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 Dempty_string_literal.result18 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 Dempty_string_literal.inc10 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'');

12345678910>>...66