📄 comparisons.out
字号:
ij> select c1 from varchartab where c1 = 'a ';C1 ----a a ij> select c1 from varchartab where c1 = 'b ';C1 ----b b ij> select c1 from varchartab where c1 = 'bb';C1 ----ij> select c3 from varchartab where c3 = ' ';C3 -----ij> select c3 from varchartab where c3 = '';C3 -----ij> select c3 from varchartab where c3 = 'a ';C3 -----a a ij> select c3 from varchartab where c3 = 'bcdef ';C3 -----bcdefij> select c3 from varchartab where c3 = 'bbbb';C3 -----ij> -- test char = varchar semantics. Test with trailing blanks.select c1 from varchartab where ' ' = c1;C1 ----ij> select c1 from varchartab where '' = c1;C1 ----ij> select c1 from varchartab where 'a ' = c1;C1 ----a a ij> select c1 from varchartab where 'b ' = c1;C1 ----b b ij> select c1 from varchartab where 'bb' = c1;C1 ----ij> select c3 from varchartab where ' ' = c3;C3 -----ij> select c3 from varchartab where '' = c3;C3 -----ij> select c3 from varchartab where 'a ' = c3;C3 -----a a ij> select c3 from varchartab where 'bcdef ' = c3;C3 -----bcdefij> select c3 from varchartab where 'bbbb' = c3;C3 -----ij> -- Now test <>select c1 from varchartab where c1 <> c2;C1 ----a b ij> select c3 from varchartab where c3 <> c4;C3 -----a b ij> -- test varchar <> char semantics. Test with trailing blanks.select c1 from varchartab where c1 <> ' ';C1 ----a b a b ij> select c1 from varchartab where c1 <> '';C1 ----a b a b ij> select c1 from varchartab where c1 <> 'a ';C1 ----b b ij> select c1 from varchartab where c1 <> 'b ';C1 ----a a ij> select c1 from varchartab where c1 <> 'bb';C1 ----a b a b ij> select c3 from varchartab where c3 <> ' ';C3 -----a bcdefa b ij> select c3 from varchartab where c3 <> '';C3 -----a bcdefa b ij> select c3 from varchartab where c3 <> 'a ';C3 -----bcdefb ij> select c3 from varchartab where c3 <> 'bcdef ';C3 -----a a b ij> select c3 from varchartab where c3 <> 'bbbb';C3 -----a bcdefa b ij> select c1 from varchartab where c1 != ' ';C1 ----a b a b ij> select c1 from varchartab where c1 != '';C1 ----a b a b ij> select c1 from varchartab where c1 != 'a ';C1 ----b b ij> select c1 from varchartab where c1 != 'b ';C1 ----a a ij> select c1 from varchartab where c1 != 'bb';C1 ----a b a b ij> select c3 from varchartab where c3 != ' ';C3 -----a bcdefa b ij> select c3 from varchartab where c3 != '';C3 -----a bcdefa b ij> select c3 from varchartab where c3 != 'a ';C3 -----bcdefb ij> select c3 from varchartab where c3 != 'bcdef ';C3 -----a a b ij> select c3 from varchartab where c3 != 'bbbb';C3 -----a bcdefa b ij> -- test char <> varchar semantics. Test with trailing blanks.select c1 from varchartab where ' ' <> c1;C1 ----a b a b ij> select c1 from varchartab where '' <> c1;C1 ----a b a b ij> select c1 from varchartab where 'a ' <> c1;C1 ----b b ij> select c1 from varchartab where 'b ' <> c1;C1 ----a a ij> select c1 from varchartab where 'bb' <> c1;C1 ----a b a b ij> select c3 from varchartab where ' ' <> c3;C3 -----a bcdefa b ij> select c3 from varchartab where '' <> c3;C3 -----a bcdefa b ij> select c3 from varchartab where 'a ' <> c3;C3 -----bcdefb ij> select c3 from varchartab where 'bcdef ' <> c3;C3 -----a a b ij> select c3 from varchartab where 'bbbb' <> c3;C3 -----a bcdefa b ij> -- Now test <select c1 from varchartab where c1 < c2;C1 ----a ij> select c3 from varchartab where c3 < c4;C3 -----a b ij> -- test varchar < char semantics. Test with trailing blanks.select c1 from varchartab where c1 < ' ';C1 ----ij> select c1 from varchartab where c1 < '';C1 ----ij> select c1 from varchartab where c1 < 'a ';C1 ----ij> select c1 from varchartab where c1 < 'b ';C1 ----a a ij> select c1 from varchartab where c1 < 'bb';C1 ----a b a b ij> select c3 from varchartab where c3 < ' ';C3 -----ij> select c3 from varchartab where c3 < '';C3 -----ij> select c3 from varchartab where c3 < 'a ';C3 -----ij> select c3 from varchartab where c3 < 'bcdef ';C3 -----a a b ij> select c3 from varchartab where c3 < 'bbbb';C3 -----a a b ij> -- test char < varchar semantics. Test with trailing blanks.select c1 from varchartab where ' ' < c1;C1 ----a b a b ij> select c1 from varchartab where '' < c1;C1 ----a b a b ij> select c1 from varchartab where 'a ' < c1;C1 ----b b ij> select c1 from varchartab where 'b ' < c1;C1 ----ij> select c1 from varchartab where 'bb' < c1;C1 ----ij> select c3 from varchartab where ' ' < c3;C3 -----a bcdefa b ij> select c3 from varchartab where '' < c3;C3 -----a bcdefa b ij> select c3 from varchartab where 'a ' < c3;C3 -----bcdefb ij> select c3 from varchartab where 'bcdef ' < c3;C3 -----ij> select c3 from varchartab where 'bbbb' < c3;C3 -----bcdefij> -- Now test >select c1 from varchartab where c1 > c2;C1 ----b ij> select c3 from varchartab where c3 > c4;C3 -----ij> -- test varchar > char semantics. Test with trailing blanks.select c1 from varchartab where c1 > ' ';C1 ----a b a b ij> select c1 from varchartab where c1 > '';C1 ----a b a b ij> select c1 from varchartab where c1 > 'a ';C1 ----b b ij> select c1 from varchartab where c1 > 'b ';C1 ----ij> select c1 from varchartab where c1 > 'bb';C1 ----ij> select c3 from varchartab where c3 > ' ';C3 -----a bcdefa b ij> select c3 from varchartab where c3 > '';C3 -----a bcdefa b ij> select c3 from varchartab where c3 > 'a ';C3 -----bcdefb ij> select c3 from varchartab where c3 > 'bcdef ';C3 -----ij> select c3 from varchartab where c3 > 'bbbb';C3 -----bcdefij> -- test char > varchar semantics. Test with trailing blanks.select c1 from varchartab where ' ' > c1;C1 ----ij> select c1 from varchartab where '' > c1;C1 ----ij> select c1 from varchartab where 'a ' > c1;C1 ----ij> select c1 from varchartab where 'b ' > c1;C1 ----a a ij> select c1 from varchartab where 'bb' > c1;C1 ----a b a b ij> select c3 from varchartab where ' ' > c3;C3 -----ij> select c3 from varchartab where '' > c3;C3 -----ij> select c3 from varchartab where 'a ' > c3;C3 -----ij> select c3 from varchartab where 'bcdef ' > c3;C3 -----a a b ij> select c3 from varchartab where 'bbbb' > c3;C3 -----a a b ij> -- Now test <=select c1 from varchartab where c1 <= c2;C1 ----a b a ij> select c3 from varchartab where c3 <= c4;C3 -----a bcdefa b ij> -- test varchar <= char semantics. Test with trailing blanks.select c1 from varchartab where c1 <= ' ';C1 ----ij> select c1 from varchartab where c1 <= '';C1 ----ij> select c1 from varchartab where c1 <= 'a ';C1 ----a a ij> select c1 from varchartab where c1 <= 'b ';C1 ----a b a b ij> select c1 from varchartab where c1 <= 'bb';C1 ----a b a b ij> select c3 from varchartab where c3 <= ' ';C3 -----ij> select c3 from varchartab where c3 <= '';C3 -----ij> select c3 from varchartab where c3 <= 'a ';C3 -----a a ij> select c3 from varchartab where c3 <= 'bcdef ';C3 -----a bcdefa b ij> select c3 from varchartab where c3 <= 'bbbb';C3 -----a a b ij> -- test char <= varchar semantics. Test with trailing blanks.select c1 from varchartab where ' ' <= c1;C1 ----a b a b ij> select c1 from varchartab where '' <= c1;C1 ----a b a b ij> select c1 from varchartab where 'a ' <= c1;C1 ----a b a b ij> select c1 from varchartab where 'b ' <= c1;C1 ----b b ij> select c1 from varchartab where 'bb' <= c1;C1 ----ij> select c3 from varchartab where ' ' <= c3;C3 -----a bcdefa b ij> select c3 from varchartab where '' <= c3;C3 -----a bcdefa b ij> select c3 from varchartab where 'a ' <= c3;C3 -----a bcdefa b ij> select c3 from varchartab where 'bcdef ' <= c3;C3 -----bcdefij> select c3 from varchartab where 'bbbb' <= c3;C3 -----bcdefij> -- Now test >=select c1 from varchartab where c1 >= c2;C1 ----a b b ij> select c3 from varchartab where c3 >= c4;C3 -----a bcdefij> -- test varchar >= char semantics. Test with trailing blanks.select c1 from varchartab where c1 >= ' ';C1 ----a b a b ij> select c1 from varchartab where c1 >= '';C1 ----a b a b ij> select c1 from varchartab where c1 >= 'a ';C1 ----a b a b ij> select c1 from varchartab where c1 >= 'b ';C1 ----b b ij> select c1 from varchartab where c1 >= 'bb';C1 ----ij> select c3 from varchartab where c3 >= ' ';C3 -----a bcdefa b ij> select c3 from varchartab where c3 >= '';C3 -----a bcdefa b ij> select c3 from varchartab where c3 >= 'a ';C3 -----a bcdefa b ij> select c3 from varchartab where c3 >= 'bcdef ';C3 -----bcdefij> select c3 from varchartab where c3 >= 'bbbb';C3 -----bcdefij> -- test char >= varchar semantics. Test with trailing blanks.select c1 from varchartab where ' ' >= c1;C1 ----ij> select c1 from varchartab where '' >= c1;C1 ----ij> select c1 from varchartab where 'a ' >= c1;C1 ----a a ij> select c1 from varchartab where 'b ' >= c1;C1 ----a b a b ij> select c1 from varchartab where 'bb' >= c1;C1 ----a b a b ij> select c3 from varchartab where ' ' >= c3;C3 -----ij> select c3 from varchartab where '' >= c3;C3 -----ij> select c3 from varchartab where 'a ' >= c3;C3 -----a a ij> select c3 from varchartab where 'bcdef ' >= c3;C3 -----a bcdefa b ij> select c3 from varchartab where 'bbbb' >= c3;C3 -----a a b ij> -- test is null semanticsselect c1 from varchartab where c1 is null;C1 ----NULLij> select c1 from varchartab where c1 is not null;C1 ----a b a b ij> select c1 from varchartab where not c1 is null;C1 ----a b a b ij> -- clean updrop table inttab;0 rows inserted/updated/deletedij> drop table smallinttab;0 rows inserted/updated/deletedij> drop table biginttab;0 rows inserted/updated/deletedij> drop table chartab;0 rows inserted/updated/deletedij> drop table varchartab;0 rows inserted/updated/deletedij> ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -