Gecko [ www.jdcpatala.org ]

Name	Size	Permission
json_client.inc	594 B	-rw-r--r--
json_ddl.inc	2.51 KB	-rw-r--r--
json_fulltext.inc	3.55 KB	-rw-r--r--
json_functions.inc	125.65 KB	-rw-r--r--
json_gcol.inc	5.91 KB	-rw-r--r--
json_group_concat.inc	1.77 KB	-rw-r--r--
json_insert.inc	5.02 KB	-rw-r--r--
json_vs_json_comparator.inc	7.26 KB	-rw-r--r--
sql_vs_json_equalto.inc	22.79 KB	-rw-r--r--
sql_vs_json_greaterthan.inc	22.79 KB	-rw-r--r--
sql_vs_json_greaterthanequalto...	22.89 KB	-rw-r--r--
sql_vs_json_lessthan.inc	22.79 KB	-rw-r--r--
sql_vs_json_lessthanequalto.in...	22.89 KB	-rw-r--r--
sql_vs_json_notequal.inc	22.89 KB	-rw-r--r--
sql_vs_json_null_safe_equal_to...	22.99 KB	-rw-r--r--

Code Editor : json_vs_json_comparator.inc

# These are tests for JSON vs JSON datatypes.
# Comparator >
#-----------------------
echo "Test for JSON vs JSON";
echo "";
echo "";

--disable_query_log
select 
a.col as side1,  
b.col as side2,
JSON_TYPE(CAST(a.col as JSON)) as side1_json_type,
JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) as side1_json_weightage,
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
a.col >  b.col as json_compare,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) >
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
from jj a , jj b
where a.col is not NULL 
and b.col is not NULL
and ((a.col >  b.col) != (
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) 
> 
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
))AND JSON_TYPE(CAST(a.col as JSON)) !='BLOB'
AND JSON_TYPE(CAST(b.col as JSON)) !='BLOB'
AND GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) != GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)));

echo "Comparator <";
echo "==============";
# Comparator <
#-----------------------

select 
a.col as side1,  
b.col as side2,
JSON_TYPE(CAST(a.col as JSON)) as side1_json_type,
JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) as side1_json_weightage,
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
a.col <  b.col as json_compare,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) <
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
from jj a , jj b
where a.col is not NULL 
and b.col is not NULL
and ((a.col <  b.col) != (
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) 
< 
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
))AND JSON_TYPE(CAST(a.col as JSON)) !='BLOB'
AND JSON_TYPE(CAST(b.col as JSON)) !='BLOB'
AND GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) != GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)));

echo "Comparator >=";
echo "==============";
# Comparator >=
#-----------------------

select 
a.col as side1,  
b.col as side2,
JSON_TYPE(CAST(a.col as JSON)) as side1_json_type,
JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) as side1_json_weightage,
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
a.col >=  b.col as json_compare,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) >=
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
from jj a , jj b
where a.col is not NULL 
and b.col is not NULL
and ((a.col >=  b.col) != (
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) 
>= 
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
))AND JSON_TYPE(CAST(a.col as JSON)) !='BLOB'
AND JSON_TYPE(CAST(b.col as JSON)) !='BLOB'
AND GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) != GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)));

echo "Comparator <=";
echo "==============";
# Comparator <=
#-----------------------

select 
a.col as side1,  
b.col as side2,
JSON_TYPE(CAST(a.col as JSON)) as side1_json_type,
JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) as side1_json_weightage,
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
a.col <=  b.col as json_compare,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) <=
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
from jj a , jj b
where a.col is not NULL 
and b.col is not NULL
and ((a.col <=  b.col) != (
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) 
<= 
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
))AND JSON_TYPE(CAST(a.col as JSON)) !='BLOB'
AND JSON_TYPE(CAST(b.col as JSON)) !='BLOB'
AND GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) != GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)));

echo "Comparator =";
echo "==============";
# Comparator =
#-----------------------

select 
a.col as side1,  
b.col as side2,
JSON_TYPE(CAST(a.col as JSON)) as side1_json_type,
JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) as side1_json_weightage,
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
a.col =  b.col as json_compare,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) =
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
from jj a , jj b
where a.col is not NULL 
and b.col is not NULL
and ((a.col =  b.col) != (
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) 
= 
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
))AND JSON_TYPE(CAST(a.col as JSON)) !='BLOB'
AND JSON_TYPE(CAST(b.col as JSON)) !='BLOB'
AND GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) != GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)));

echo "Comparator !=";
echo "==============";
# Comparator !=
#-----------------------

select 
a.col as side1,  
b.col as side2,
JSON_TYPE(CAST(a.col as JSON)) as side1_json_type,
JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) as side1_json_weightage,
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
a.col !=  b.col as json_compare,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) !=
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
from jj a , jj b
where a.col is not NULL 
and b.col is not NULL
and ((a.col !=  b.col) != (
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) 
!= 
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
))AND JSON_TYPE(CAST(a.col as JSON)) !='BLOB'
AND JSON_TYPE(CAST(b.col as JSON)) !='BLOB'
AND GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) != GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)));

echo "Comparator <>";
echo "==============";
# Comparator <>
#-----------------------
select 
a.col as side1,  
b.col as side2,
JSON_TYPE(CAST(a.col as JSON)) as side1_json_type,
JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) as side1_json_weightage,
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
a.col <>  b.col as json_compare,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) <>
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
from jj a , jj b
where a.col is not NULL 
and b.col is not NULL
and ((a.col <>  b.col) != (
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) 
<> 
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
))AND JSON_TYPE(CAST(a.col as JSON)) !='BLOB'
AND JSON_TYPE(CAST(b.col as JSON)) !='BLOB'
AND GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) != GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)));

echo "Comparator <=>";
echo "==============";
# Comparator <=>
#-----------------------
select 
a.col as side1,  
b.col as side2,
JSON_TYPE(CAST(a.col as JSON)) as side1_json_type,
JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) as side1_json_weightage,
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
a.col <=>  b.col as json_compare,
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) <=>
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
from jj a , jj b
where a.col is not NULL 
and b.col is not NULL
and ((a.col <=>  b.col) != (
GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) 
<=> 
GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
))AND JSON_TYPE(CAST(a.col as JSON)) !='BLOB'
AND JSON_TYPE(CAST(b.col as JSON)) !='BLOB'
AND GET_JSON_WEIGHT(JSON_TYPE(CAST(a.col as JSON))) != GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)));

${this.title}

Code Editor : json_vs_json_comparator.inc