| postgresql |
mysql |
|
INSERT INTO x (id_x, name, short_name) VALUES (12, 'Name of x', DEFAULT)
|
INSERT INTO x (id_x, name, short_name) VALUES (12, 'Name of x', DEFAULT(short_name))
|
|
INSERT INTO x VALUES (12 , 'Name of x', DEFAULT)
|
Error: can not translate
MYSQL backend does not support inserting default values without identifier list
|
|
SELECT TIMESTAMP '2001-01-01 15:00:12' AT TIME ZONE 'GMT' FROM foo |
Error: can not translate
AT TIME ZONE struct not implemented in MySQL backend
|
|
SELECT TIMESTAMP '2001-01-01 15:00:12' AT TIME ZONE INTERVAL '-02:00' FROM foo
|
Error: can not translate
AT TIME ZONE struct not implemented in MySQL backend
|
|
SELECT product_id, p.name, (sum(s.units) * (p.price - p.cost)) AS profit FROM products AS p LEFT OUTER JOIN sales AS s USING(product_id) WHERE s.date > CURRENT_DATE() - INTERVAL '4 weeks' GROUP BY product_id, p.name, p.price, p.cost HAVING sum(p.price * s.units) > 5000
|
SELECT product_id, p.name, (sum(s.units) * (p.price - p.cost)) AS profit FROM products AS p LEFT OUTER JOIN sales AS s USING(product_id) WHERE s.date > CURRENT_DATE() - INTERVAL 4 week GROUP BY product_id, p.name, p.price, p.cost HAVING sum(p.price * s.units) > 5000
|
|
SELECT bar IS FALSE FROM foo
|
SELECT IF(IF(bar IS NULL, 0, bar = 0) IS NULL, 'UNKNOW', IF(IF(bar IS NULL, 0, bar = 0), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT bar IS NOT FALSE FROM foo
|
SELECT IF(IF(bar IS NULL, 1, bar != 0) IS NULL, 'UNKNOW', IF(IF(bar IS NULL, 1, bar != 0), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT bar IS TRUE FROM foo
|
SELECT IF(IF(bar IS NULL, 0, bar != 0) IS NULL, 'UNKNOW', IF(IF(bar IS NULL, 0, bar != 0), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT bar IS NOT TRUE FROM foo
|
SELECT IF(IF(bar IS NULL, 1, bar = 0) IS NULL, 'UNKNOW', IF(IF(bar IS NULL, 1, bar = 0), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT bar IS UNKNOW FROM foo
|
SELECT IF(bar IS NULL IS NULL, 'UNKNOW', IF(bar IS NULL, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT bar IS NOT UNKNOW FROM foo
|
SELECT IF(bar IS NOT NULL IS NULL, 'UNKNOW', IF(bar IS NOT NULL, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT (((||/ c) + -b * 12) - 34) || 'c' FROM foo |
SELECT CONCAT((((POWER(c, 1/3)) + - b * 12) - 34), 'c') FROM foo
|
|
SELECT AGE(TIMESTAMP '2001-01-01', TIMESTAMP '199-05-05') FROM foo |
Error: can not translate
AGE function not implemented in MySQL backend
|
|
SELECT AGE(TIMESTAMP '2001-01-01') FROM foo |
Error: can not translate
AGE function not implemented in MySQL backend
|
|
SELECT BIT_OR(rights) FROM user_rights WHERE id_user = 12 |
SELECT IF(COUNT(rights) = 0, NULL, BIT_OR(rights)) FROM user_rights WHERE id_user = 12
|
|
SELECT BIT_AND(rights) FROM user_rights WHERE id_user = 12 |
SELECT IF(COUNT(rights) = 0, NULL, BIT_AND(rights)) FROM user_rights WHERE id_user = 12
|
|
SELECT BOOL_AND(p) FROM ps |
SELECT IF(IF(COUNT(p) = 0, NULL, BIT_AND(p != 0)) IS NULL, 'UNKNOW', IF(IF(COUNT(p) = 0, NULL, BIT_AND(p != 0)), 'TRUE', 'FALSE')) FROM ps
|
|
SELECT BOOL_OR(p) FROM ps |
SELECT IF(IF(COUNT(p) = 0, NULL, BIT_OR(p != 0)) IS NULL, 'UNKNOW', IF(IF(COUNT(p) = 0, NULL, BIT_OR(p != 0)), 'TRUE', 'FALSE')) FROM ps
|
|
SELECT BTRIM('aaabbbbddd', 'ad') FROM foo |
Error: can not translate
BTRIM function not implemented in MySQL backend
|
|
SELECT CBRT(a) FROM foo |
SELECT POWER(a, 1/3) FROM foo
|
|
SELECT CHR(70) FROM foo |
SELECT CHAR(70) FROM foo
|
|
SELECT DATE_PART('CENTURY', TIMESTAMP '2001-01-01 12:00:00') FROM foo |
SELECT FLOOR((EXTRACT(YEAR FROM CAST('2001-01-01 12:00:00' AS DATETIME)) + 99) / 100) FROM foo
|
|
SELECT DATE_PART('CENTURY', INTERVAL '283 years 3 month 2 hours 1 minute') FROM foo |
SELECT FLOOR((EXTRACT(YEAR FROM '0000-01-01 00:00:00' + INTERVAL 283 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute - INTERVAL 1 month - INTERVAL 1 day) + 99) / 100) FROM foo
|
|
SELECT DATE_PART('DAY', TIMESTAMP '1999-09-09 20:00:00') FROM foo |
SELECT DAYOFMONTH(CAST('1999-09-09 20:00:00' AS DATETIME)) FROM foo
|
|
SELECT DATE_PART('DAY', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
SELECT DAYOFMONTH('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute) FROM foo
|
|
SELECT DATE_PART('DECADE', TIMESTAMP '1999-09-09 12:00') FROM foo |
SELECT FLOOR(EXTRACT(YEAR FROM CAST('1999-09-09 12:00' AS DATETIME)) / 10) FROM foo
|
|
SELECT DATE_PART('DECADE', INTERVAL '282 years 3 month 2 hours 1 minute') FROM foo |
SELECT FLOOR(EXTRACT(YEAR FROM '0000-01-01 00:00:00' + INTERVAL 282 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute - INTERVAL 1 month - INTERVAL 1 day) / 10) FROM foo
|
|
SELECT DATE_PART('DOW', TIMESTAMP '2001-02-16 12:00:00') FROM foo |
SELECT (DAYOFWEEK(CAST('2001-02-16 12:00:00' AS DATETIME)) - 1) FROM foo
|
|
SELECT DATE_PART('DOW', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
Error: can not translate
EXTRACT/DATE_PART functions with this field and intervals not implemented in MySQL backend
|
|
SELECT DATE_PART('DOY', TIMESTAMP '1999-09-09 12:00:00') FROM foo |
SELECT DAYOFYEAR(CAST('1999-09-09 12:00:00' AS DATETIME)) FROM foo
|
|
SELECT DATE_PART('DOY', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
Error: can not translate
EXTRACT/DATE_PART functions with this field and intervals not implemented in MySQL backend
|
|
SELECT DATE_PART('EPOCH', TIMESTAMP '2001-01-01 12:00:00') FROM foo |
SELECT UNIX_TIMESTAMP(CAST('2001-01-01 12:00:00' AS DATETIME)) FROM foo
|
|
SELECT DATE_PART('EPOCH', INTERVAL '3 days 5 hours') FROM foo |
SELECT UNIX_TIMESTAMP('1970-01-01 00:00:00' + INTERVAL 3 day + INTERVAL 5 hour) FROM foo
|
|
SELECT DATE_PART('HOUR', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo |
SELECT HOUR(CAST('1999-09-09 12:01:02.25' AS DATETIME)) FROM foo
|
|
SELECT DATE_PART('HOUR', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
SELECT HOUR('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute) FROM foo
|
|
SELECT DATE_PART('MICROSECONDS', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT (MICROSECOND(CAST('1999-09-09 12:01:02.25' AS DATETIME)) + 1000000 * SECOND(CAST('1999-09-09 12:01:02.25' AS DATETIME))) FROM foo
|
|
SELECT DATE_PART('MICROSECONDS', INTERVAL '2 years 3 month 2 hours 1 minute 3 microseconds') FROM foo
|
SELECT (MICROSECOND('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute + INTERVAL 3 microsecond) + 1000000 * SECOND('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute + INTERVAL 3 microsecond)) FROM foo
|
|
SELECT DATE_PART('MILISECONDS', '1999-09-09 00:00:01.1231') FROM foo
|
SELECT (FLOOR(MICROSECOND('1999-09-09 00:00:01.1231')) / 1000 + 1000 * SECOND('1999-09-09 00:00:01.1231')) FROM foo
|
|
SELECT DATE_PART('MILISECONDS', INTERVAL '2 years 3 month 2 hours 1 minute 4 seconds') FROM foo
|
SELECT (FLOOR(MICROSECOND('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute + INTERVAL 4 second)) / 1000 + 1000 * SECOND('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute + INTERVAL 4 second)) FROM foo
|
|
SELECT DATE_PART('MILLENNIUM', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT FLOOR((EXTRACT(YEAR FROM CAST('1999-09-09 12:01:02.25' AS DATETIME)) + 999) / 1000) FROM foo
|
|
SELECT DATE_PART('MILLENNIUM', INTERVAL '1999 years 3 month 2 hours 1 minute') FROM foo
|
SELECT FLOOR((EXTRACT(YEAR FROM '0000-01-01 00:00:00' + INTERVAL 1999 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute - INTERVAL 1 month - INTERVAL 1 day) + 999) / 1000) FROM foo
|
|
SELECT DATE_PART('MINUTE', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT MINUTE(CAST('1999-09-09 12:01:02.25' AS DATETIME)) FROM foo
|
|
SELECT DATE_PART('MINUTE', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo
|
SELECT MINUTE('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute) FROM foo
|
|
SELECT DATE_PART('MONTH', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT MONTH(CAST('1999-09-09 12:01:02.25' AS DATETIME)) FROM foo
|
|
SELECT DATE_PART('MONTH', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo
|
SELECT (MONTH('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute) - 1) FROM foo
|
|
SELECT DATE_PART('QUARTER', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT FLOOR((MONTH(CAST('1999-09-09 12:01:02.25' AS DATETIME)) + 2) / 3) FROM foo
|
|
SELECT DATE_PART('QUARTER', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo
|
SELECT FLOOR((MONTH('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute) + 1) / 3) FROM foo
|
|
SELECT DATE_PART('SECOND', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT (SECOND(CAST('1999-09-09 12:01:02.25' AS DATETIME)) + MICROSECOND(CAST('1999-09-09 12:01:02.25' AS DATETIME)) / 1000000) FROM foo
|
|
SELECT DATE_PART('SECOND', INTERVAL '2 years 3 month 2 hours 1 minute 3 seconds') FROM foo
|
SELECT (SECOND('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute + INTERVAL 3 second) + MICROSECOND('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute + INTERVAL 3 second) / 1000000) FROM foo
|
|
SELECT DATE_PART('WEEK', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT WEEK(CAST('1999-09-09 12:01:02.25' AS DATETIME), 7) FROM foo
|
|
SELECT DATE_PART('WEEK', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo
|
Error: can not translate
EXTRACT/DATE_PART functions with this field and intervals not implemented in MySQL backend
|
|
SELECT DATE_PART('YEAR', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo |
SELECT YEAR(CAST('1999-09-09 12:01:02.25' AS DATETIME)) FROM foo
|
|
SELECT DATE_PART('YEAR', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
Error: can not translate
EXTRACT/DATE_PART functions with this field and intervals not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('CENTURY', TIMESTAMP '2001-01-01 12:00:00') FROM foo |
Error: can not translate
DATE_TRUNC functions with this field not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('CENTURY', INTERVAL '283 years 3 month 2 hours 1 minute') FROM foo |
Error: can not translate
DATE_TRUNC with intervals not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('DAY', TIMESTAMP '1999-09-09 20:00:00') FROM foo |
SELECT DATE_FORMAT(CAST('1999-09-09 20:00:00' AS DATETIME), '%Y-%m-%d 00:00:00') FROM foo
|
|
SELECT DATE_TRUNC('DAY', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
Error: can not translate
DATE_TRUNC with intervals not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('DECADE', TIMESTAMP '1999-09-09 12:00') FROM foo |
Error: can not translate
DATE_TRUNC functions with this field not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('DECADE', INTERVAL '282 years 3 month 2 hours 1 minute') FROM foo |
Error: can not translate
DATE_TRUNC with intervals not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('HOUR', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo |
SELECT DATE_FORMAT(CAST('1999-09-09 12:01:02.25' AS DATETIME), '%Y-%m-%d %H:00:00') FROM foo
|
|
SELECT DATE_TRUNC('HOUR', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
Error: can not translate
DATE_TRUNC with intervals not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('MICROSECONDS', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT DATE_FORMAT(CAST('1999-09-09 12:01:02.25' AS DATETIME), '%Y-%m-%d %H:%i:%s.%f') FROM foo
|
|
SELECT DATE_TRUNC('MICROSECONDS', INTERVAL '2 years 3 month 2 hours 1 minute 3 microseconds') FROM foo
|
Error: can not translate
DATE_TRUNC with intervals not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('MILISECONDS', '1999-09-09 00:00:01.1231') FROM foo
|
Error: can not translate
DATE_TRUNC functions with this field not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('MILISECONDS', INTERVAL '2 years 3 month 2 hours 1 minute 4 seconds') FROM foo
|
Error: can not translate
DATE_TRUNC with intervals not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('MILLENNIUM', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
Error: can not translate
DATE_TRUNC functions with this field not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('MILLENNIUM', INTERVAL '1999 years 3 month 2 hours 1 minute') FROM foo
|
Error: can not translate
DATE_TRUNC with intervals not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('MINUTE', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT DATE_FORMAT(CAST('1999-09-09 12:01:02.25' AS DATETIME), '%Y-%m-%d %H:%i:00') FROM foo
|
|
SELECT DATE_TRUNC('MINUTE', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo
|
Error: can not translate
DATE_TRUNC with intervals not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('MONTH', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT DATE_FORMAT(CAST('1999-09-09 12:01:02.25' AS DATETIME), '%Y-%m-01 00:00:00') FROM foo
|
|
SELECT DATE_TRUNC('MONTH', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo
|
Error: can not translate
DATE_TRUNC with intervals not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('SECOND', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT DATE_FORMAT(CAST('1999-09-09 12:01:02.25' AS DATETIME), '%Y-%m-%d %H:%i:%s') FROM foo
|
|
SELECT DATE_TRUNC('SECOND', INTERVAL '2 years 3 month 2 hours 1 minute 3 seconds') FROM foo
|
Error: can not translate
DATE_TRUNC with intervals not implemented in MySQL backend
|
|
SELECT DATE_TRUNC('YEAR', TIMESTAMP '1999-09-09 12:01:02.25') FROM foo |
SELECT DATE_FORMAT(CAST('1999-09-09 12:01:02.25' AS DATETIME), '%Y-01-01 00:00:00') FROM foo
|
|
SELECT DATE_TRUNC('YEAR', INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
Error: can not translate
DATE_TRUNC with intervals not implemented in MySQL backend
|
|
SELECT DECODE('ABC', 'base64') FROM foo |
Error: can not translate
DECODE function not implemented in MySQL backend
|
|
SELECT ENCODE('ABC', 'base64') FROM foo |
Error: can not translate
ENCODE function not implemented in MySQL backend
|
|
SELECT BOOL_AND(p) FROM ps |
SELECT IF(IF(COUNT(p) = 0, NULL, BIT_AND(p != 0)) IS NULL, 'UNKNOW', IF(IF(COUNT(p) = 0, NULL, BIT_AND(p != 0)), 'TRUE', 'FALSE')) FROM ps
|
|
SELECT EXTRACT(CENTURY FROM TIMESTAMP '2001-01-01 12:00:00') FROM foo |
SELECT FLOOR((EXTRACT(YEAR FROM CAST('2001-01-01 12:00:00' AS DATETIME)) + 99) / 100) FROM foo
|
|
SELECT EXTRACT(CENTURY FROM INTERVAL '283 years 3 month 2 hours 1 minute') FROM foo |
SELECT FLOOR((EXTRACT(YEAR FROM '0000-01-01 00:00:00' + INTERVAL 283 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute - INTERVAL 1 month - INTERVAL 1 day) + 99) / 100) FROM foo
|
|
SELECT EXTRACT(DAY FROM TIMESTAMP '1999-09-09 20:00:00') FROM foo |
SELECT DAYOFMONTH(CAST('1999-09-09 20:00:00' AS DATETIME)) FROM foo
|
|
SELECT EXTRACT(DAY FROM INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
SELECT DAYOFMONTH('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute) FROM foo
|
|
SELECT EXTRACT(DECADE FROM TIMESTAMP '1999-09-09 12:00') FROM foo |
SELECT FLOOR(EXTRACT(YEAR FROM CAST('1999-09-09 12:00' AS DATETIME)) / 10) FROM foo
|
|
SELECT EXTRACT(DECADE FROM INTERVAL '282 years 3 month 2 hours 1 minute') FROM foo |
SELECT FLOOR(EXTRACT(YEAR FROM '0000-01-01 00:00:00' + INTERVAL 282 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute - INTERVAL 1 month - INTERVAL 1 day) / 10) FROM foo
|
|
SELECT EXTRACT(DOW FROM TIMESTAMP '2001-02-16 12:00:00') FROM foo |
SELECT (DAYOFWEEK(CAST('2001-02-16 12:00:00' AS DATETIME)) - 1) FROM foo
|
|
SELECT EXTRACT(DOW FROM INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
Error: can not translate
EXTRACT/DATE_PART functions with this field and intervals not implemented in MySQL backend
|
|
SELECT EXTRACT(DOY FROM TIMESTAMP '1999-09-09 12:00:00') FROM foo |
SELECT DAYOFYEAR(CAST('1999-09-09 12:00:00' AS DATETIME)) FROM foo
|
|
SELECT EXTRACT(DOY FROM INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
Error: can not translate
EXTRACT/DATE_PART functions with this field and intervals not implemented in MySQL backend
|
|
SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-01-01 12:00:00') FROM foo |
SELECT UNIX_TIMESTAMP(CAST('2001-01-01 12:00:00' AS DATETIME)) FROM foo
|
|
SELECT EXTRACT(EPOCH FROM INTERVAL '3 days 5 hours') FROM foo |
SELECT UNIX_TIMESTAMP('1970-01-01 00:00:00' + INTERVAL 3 day + INTERVAL 5 hour) FROM foo
|
|
SELECT EXTRACT(HOUR FROM TIMESTAMP '1999-09-09 12:01:02.25') FROM foo |
SELECT HOUR(CAST('1999-09-09 12:01:02.25' AS DATETIME)) FROM foo
|
|
SELECT EXTRACT(HOUR FROM INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
SELECT HOUR('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute) FROM foo
|
|
SELECT EXTRACT(MICROSECONDS FROM TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT (MICROSECOND(CAST('1999-09-09 12:01:02.25' AS DATETIME)) + 1000000 * SECOND(CAST('1999-09-09 12:01:02.25' AS DATETIME))) FROM foo
|
|
SELECT EXTRACT(MICROSECONDS FROM INTERVAL '2 years 3 month 2 hours 1 minute 3 microseconds') FROM foo
|
SELECT (MICROSECOND('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute + INTERVAL 3 microsecond) + 1000000 * SECOND('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute + INTERVAL 3 microsecond)) FROM foo
|
|
SELECT EXTRACT(MILISECONDS FROM '1999-09-09 00:00:01.1231') FROM foo
|
SELECT (FLOOR(MICROSECOND('1999-09-09 00:00:01.1231')) / 1000 + 1000 * SECOND('1999-09-09 00:00:01.1231')) FROM foo
|
|
SELECT EXTRACT(MILISECONDS FROM INTERVAL '2 years 3 month 2 hours 1 minute 4 seconds') FROM foo
|
SELECT (FLOOR(MICROSECOND('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute + INTERVAL 4 second)) / 1000 + 1000 * SECOND('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute + INTERVAL 4 second)) FROM foo
|
|
SELECT EXTRACT(MILLENNIUM FROM TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT FLOOR((EXTRACT(YEAR FROM CAST('1999-09-09 12:01:02.25' AS DATETIME)) + 999) / 1000) FROM foo
|
|
SELECT EXTRACT(MILLENNIUM FROM INTERVAL '1999 years 3 month 2 hours 1 minute') FROM foo
|
SELECT FLOOR((EXTRACT(YEAR FROM '0000-01-01 00:00:00' + INTERVAL 1999 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute - INTERVAL 1 month - INTERVAL 1 day) + 999) / 1000) FROM foo
|
|
SELECT EXTRACT(MINUTE FROM TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT MINUTE(CAST('1999-09-09 12:01:02.25' AS DATETIME)) FROM foo
|
|
SELECT EXTRACT(MINUTE FROM INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo
|
SELECT MINUTE('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute) FROM foo
|
|
SELECT EXTRACT(MONTH FROM TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT MONTH(CAST('1999-09-09 12:01:02.25' AS DATETIME)) FROM foo
|
|
SELECT EXTRACT(MONTH FROM INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo
|
SELECT (MONTH('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute) - 1) FROM foo
|
|
SELECT EXTRACT(QUARTER FROM TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT FLOOR((MONTH(CAST('1999-09-09 12:01:02.25' AS DATETIME)) + 2) / 3) FROM foo
|
|
SELECT EXTRACT(QUARTER FROM INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo
|
SELECT FLOOR((MONTH('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute) + 1) / 3) FROM foo
|
|
SELECT EXTRACT(SECOND FROM TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT (SECOND(CAST('1999-09-09 12:01:02.25' AS DATETIME)) + MICROSECOND(CAST('1999-09-09 12:01:02.25' AS DATETIME)) / 1000000) FROM foo
|
|
SELECT EXTRACT(SECOND FROM INTERVAL '2 years 3 month 2 hours 1 minute 3 seconds') FROM foo
|
SELECT (SECOND('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute + INTERVAL 3 second) + MICROSECOND('0000-01-01 00:00:00' + INTERVAL 2 year + INTERVAL 3 month + INTERVAL 2 hour + INTERVAL 1 minute + INTERVAL 3 second) / 1000000) FROM foo
|
|
SELECT EXTRACT(WEEK FROM TIMESTAMP '1999-09-09 12:01:02.25') FROM foo
|
SELECT WEEK(CAST('1999-09-09 12:01:02.25' AS DATETIME), 7) FROM foo
|
|
SELECT EXTRACT(WEEK FROM INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo
|
Error: can not translate
EXTRACT/DATE_PART functions with this field and intervals not implemented in MySQL backend
|
|
SELECT EXTRACT(YEAR FROM TIMESTAMP '1999-09-09 12:01:02.25') FROM foo |
SELECT YEAR(CAST('1999-09-09 12:01:02.25' AS DATETIME)) FROM foo
|
|
SELECT EXTRACT(YEAR FROM INTERVAL '2 years 3 month 2 hours 1 minute') FROM foo |
Error: can not translate
EXTRACT/DATE_PART functions with this field and intervals not implemented in MySQL backend
|
|
SELECT INITCAP('iT iS a somEThiNG') FROM foo |
Error: can not translate
INITCAP function not implemented in MySQL backend
|
|
SELECT ISFINITE(TIMESTAMP '2001-01-01 00:00:00') FROM foo |
Error: can not translate
ISFINITE function not implemented in MySQL backend
|
|
SELECT ISFINITE(INTERVAL '20 years') FROM foo |
Error: can not translate
ISFINITE function not implemented in MySQL backend
|
|
SELECT LOG(a) FROM foo |
SELECT LOG(10, a) FROM foo
|
|
SELECT LTRIM(' aaa', ' ') FROM foo |
SELECT LTRIM(' aaa') FROM foo
|
|
SELECT LTRIM(' aaa', 'b') FROM foo |
SELECT TRIM(LEADING 'b' FROM ' aaa') FROM foo
|
|
SELECT LTRIM(' aaa', 'abcd') FROM foo |
Error: can not translate
TRIM function with string argument not implemented in MySQL backend
|
|
SELECT OVERLAY('Txxxxas' placing 'hom' from 2 for 4) FROM foo
|
SELECT CONCAT(SUBSTR('Txxxxas', 1, 2 - 1), 'hom', SUBSTR('Txxxxas', 2 + 4)) FROM foo
|
|
SELECT OVERLAY('Txxxxas' placing 'hom' from 2) FROM foo
|
Error: can not translate
OVERLAY function without all arguments not implemented in MySQL backend
|
|
SELECT PG_CLIENT_ENCODING() FROM foo |
Error: can not translate
PG_CLIENT_ENCODING function not implemented in MySQL backend
|
|
SELECT QUOTE_IDENT('a') FROM foo |
Error: can not translate
QUOTE_IDENT function not implemented in MySQL backend
|
|
SELECT QUOTE_LITERAL('a') FROM foo |
Error: can not translate
QUOTE_LITERAL function not implemented in MySQL backend
|
|
SELECT RANDOM() FROM foo |
SELECT RAND() FROM foo
|
|
SELECT RTRIM(' aaa', ' ') FROM foo |
SELECT RTRIM(' aaa') FROM foo
|
|
SELECT RTRIM(' aaa', 'b') FROM foo |
SELECT TRIM(TRAILING 'b' FROM ' aaa') FROM foo
|
|
SELECT RTRIM(' aaa', 'abcd') FROM foo |
Error: can not translate
TRIM function with string argument not implemented in MySQL backend
|
|
SELECT SETSEED(a) FROM foo |
Error: can not translate
SETSEED function not implemented in MySQL backend
|
|
SELECT SPLIT_PART('1,2,3,4', ',', 3) FROM foo |
Error: can not translate
SPLIT_PART function not implemented in MySQL backend
|
|
SELECT STRPOS('abcdef', 'de') FROM foo |
SELECT POSITION('de' IN 'abcdef') FROM foo
|
|
SELECT SUBSTRING(a PLACING b FROM 'string') FROM foo |
Error: can not translate
SUBSTRING function with regexps not implemented in MySQL backend
|
|
SELECT SUBSTRING(a PLACING b FROM 'string' FOR 's') FROM foo |
Error: can not translate
SUBSTRING function with regexps not implemented in MySQL backend
|
|
SELECT SUM(value::float8) FROM results |
SELECT SUM(value) FROM results
|
|
SELECT SUM(value::int8) FROM results |
SELECT SUM(CAST(value AS SIGNED INTEGER)) FROM results
|
|
SELECT TIMEOFDAY() FROM foo |
Error: can not translate
TIMEOFDAY function not implemented in MySQL backend
|
|
SELECT TIMEZONE(TIMESTAMP '2001-01-01 12:12:32', 'GMT') FROM foo |
Error: can not translate
TIMEZONE function not implemented in MySQL backend
|
|
SELECT TO_ASCII('String') FROM foo |
Error: can not translate
TO_ASCII function not implemented in MySQL backend
|
|
SELECT TO_CHAR(NOW(), '"Today\'s date is:" YYYY-MM-DD, %"%%"')
|
SELECT DATE_FORMAT(NOW(), 'Today\'s date is: %Y-%M-%d, %%%%%%')
|
|
SELECT TO_CHAR(NOW(), 'FMHH')
|
SELECT DATE_FORMAT(NOW(), '%l')
|
|
SELECT TO_CHAR(NOW(), 'FMHH24')
|
SELECT DATE_FORMAT(NOW(), '%k')
|
|
SELECT TO_CHAR(NOW(), 'HH')
|
SELECT DATE_FORMAT(NOW(), '%I')
|
|
SELECT TO_CHAR(NOW(), 'HH24')
|
SELECT DATE_FORMAT(NOW(), '%H')
|
|
SELECT TO_CHAR(NOW(), 'MI')
|
SELECT DATE_FORMAT(NOW(), '%i')
|
|
SELECT TO_CHAR(NOW(), 'SS')
|
SELECT DATE_FORMAT(NOW(), '%s')
|
|
SELECT TO_HEX(20) FROM foo |
Error: can not translate
TO_HEX function not implemented in MySQL backend
|
|
SELECT TRANSLATE('12345', '14', '41') FROM foo |
Error: can not translate
TRANSLATE function not implemented in MySQL backend
|
|
SELECT TRUNC(a) FROM foo |
SELECT TRUNCATE(a, 0) FROM foo
|
|
SELECT TRUNC(a, 2) FROM foo |
SELECT TRUNCATE(a, 2) FROM foo
|
|
SELECT WIDTH_BUCKET(a, b, c, d) FROM foo |
Error: can not translate
WIDTH_BUCKET function not implemented in MySQL backend
|
|
SELECT a FROM foo LIMIT 2 OFFSET 30 |
SELECT a FROM foo LIMIT 30,2
|
|
SELECT a FROM foo OFFSET 30 |
Error: can not translate
LIMIT structure with only OFFSET is not supported in MySQL 4.1.13
|
|
SELECT @(-12) FROM foo |
SELECT ABS((- 12)) FROM foo
|
|
SELECT DATE '1999-09-09' + INTEGER '24' FROM foo |
SELECT CAST('1999-09-09' AS DATE) + INTERVAL CAST('24' AS SIGNED INTEGER) DAY FROM foo
|
|
SELECT TIME '12:00' + INTERVAL '5 hours' FROM foo |
Error: can not translate
MySQL backend does not support adding interval to interval or time
|
|
SELECT INTERVAL '5 hours' + TIME '12:00' FROM foo
|
Error: can not translate
MySQL backend does not support adding interval to interval or time
|
|
SELECT INTEGER '24' + DATE '1999-09-09' FROM foo |
SELECT CAST('1999-09-09' AS DATE) + INTERVAL CAST('24' AS SIGNED INTEGER) DAY FROM foo
|
|
SELECT DATE '1999-09-09' + INTERVAL '1 HOUR' FROM foo
|
SELECT CAST('1999-09-09' AS DATE) + INTERVAL 1 HOUR FROM foo
|
|
SELECT INTERVAL '1 HOUR' + DATE '1999-09-09' FROM foo
|
SELECT INTERVAL 1 HOUR + CAST('1999-09-09' AS DATE) FROM foo
|
|
SELECT DATE '1999-09-09' + TIME '11:22' FROM foo |
SELECT ADDTIME(CAST(CAST('1999-09-09' AS DATE) AS DATETIME), CAST('11:22' AS TIME)) FROM foo
|
|
SELECT TIME '11:22' + DATE '1999-09-09' FROM foo
|
SELECT ADDTIME(CAST(CAST('1999-09-09' AS DATE) AS DATETIME), CAST('11:22' AS TIME)) FROM foo
|
|
SELECT INTERVAL '10 days' + INTERVAL '5 hours' FROM foo |
Error: can not translate
MySQL backend does not support adding interval to interval or time
|
|
SELECT TIMESTAMP '1999-09-09 02:30' + INTERVAL '50 hours' FROM foo |
SELECT CAST('1999-09-09 02:30' AS DATETIME) + INTERVAL 50 hour FROM foo
|
|
SELECT INTERVAL '50 hours' + TIMESTAMP '1999-09-09 02:30' FROM foo
|
SELECT INTERVAL 50 hour + CAST('1999-09-09 02:30' AS DATETIME) FROM foo
|
|
SELECT TRUE and b FROM foo |
SELECT IF(1 AND b IS NULL, 'UNKNOW', IF(1 AND b, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT x BETWEEN 12 AND 100 FROM foo |
SELECT IF(x BETWEEN 12 AND 100 IS NULL, 'UNKNOW', IF(x BETWEEN 12 AND 100, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT ~a FROM foo |
SELECT -(~(~(a) - 1)) FROM foo
|
|
SELECT a # b FROM foo |
SELECT a ^ b FROM foo
|
|
SELECT imie || ' ' || nazwisko FROM foo |
SELECT CONCAT(CONCAT(imie, ' '), nazwisko) FROM foo
|
|
SELECT ||/8 = 2 FROM foo |
SELECT IF(POWER(8, 1/3) = 2 IS NULL, 'UNKNOW', IF(POWER(8, 1/3) = 2, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT ||/a FROM foo |
SELECT POWER(a, 1/3) FROM foo
|
|
SELECT ||/a + b FROM foo |
SELECT POWER(a, 1/3) + b FROM foo
|
|
SELECT ||/(a + b) FROM foo |
SELECT POWER((a + b), 1/3) FROM foo
|
|
SELECT date '2001-01-01' + (interval '1 hour' / double precision '12.5') FROM foo
|
Error: can not translate
MySQL backend does not support dividing intervals
|
|
SELECT pensja = minimalna_pensja FROM foo |
SELECT IF(pensja = minimalna_pensja IS NULL, 'UNKNOW', IF(pensja = minimalna_pensja, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT a! FROM foo |
Error: can not translate
FACTORIAL operator not implemented in MySQL backend
|
|
SELECT !!a FROM foo |
Error: can not translate
FACTORIAL operator not implemented in MySQL backend
|
|
SELECT minimum > maksimum FROM foo |
SELECT IF(minimum > maksimum IS NULL, 'UNKNOW', IF(minimum > maksimum, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT a ILIKE '%toja%' FROM foo |
SELECT IF(a LIKE '%toja%' IS NULL, 'UNKNOW', IF(a LIKE '%toja%', 'TRUE', 'FALSE')) FROM foo
|
|
SELECT a ILIKE '%toja%' ESCAPE 'a' FROM foo |
SELECT IF(a LIKE '%toja%' ESCAPE 'a' IS NULL, 'UNKNOW', IF(a LIKE '%toja%' ESCAPE 'a', 'TRUE', 'FALSE')) FROM foo
|
|
SELECT 'abc' ~* '.B.' FROM foo |
SELECT IF('abc' REGEXP '.B.' IS NULL, 'UNKNOW', IF('abc' REGEXP '.B.', 'TRUE', 'FALSE')) FROM foo
|
|
SELECT a IS DISTINCT FROM b FROM foo |
SELECT IF(IF(a IS NULL, IF(b IS NULL, 0, 1), IF(b IS NULL, 1, a != b)) IS NULL, 'UNKNOW', IF(IF(a IS NULL, IF(b IS NULL, 0, 1), IF(b IS NULL, 1, a != b)), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT id_osoby IS NOT NULL FROM foo |
SELECT IF(id_osoby IS NOT NULL IS NULL, 'UNKNOW', IF(id_osoby IS NOT NULL, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT id_osoby IS NULL FROM foo |
SELECT IF(id_osoby IS NULL IS NULL, 'UNKNOW', IF(id_osoby IS NULL, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT lesser < lesser2 FROM foo |
SELECT IF(lesser < lesser2 IS NULL, 'UNKNOW', IF(lesser < lesser2, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT asia LIKE 'arek' FROM foo |
SELECT IF(asia LIKE BINARY ('arek') IS NULL, 'UNKNOW', IF(asia LIKE BINARY ('arek'), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT asia LIKE 'arek' ESCAPE 'r' FROM foo |
SELECT IF(asia LIKE BINARY ('arek') ESCAPE 'r' IS NULL, 'UNKNOW', IF(asia LIKE BINARY ('arek') ESCAPE 'r', 'TRUE', 'FALSE')) FROM foo
|
|
SELECT date '2001-01-01' + (interval '1 hour' * double precision '12.5') FROM foo |
Error: can not translate
MySQL backend does not support multipling intervals
|
|
SELECT NOT NOT x FROM foo |
SELECT IF(NOT NOT x IS NULL, 'UNKNOW', IF(NOT NOT x, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT wiek NOT BETWEEN 18 AND 21 FROM foo |
SELECT IF(wiek NOT BETWEEN 18 AND 21 IS NULL, 'UNKNOW', IF(wiek NOT BETWEEN 18 AND 21, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT a <> b FROM foo |
SELECT IF(a != b IS NULL, 'UNKNOW', IF(a != b, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT a != b FROM foo |
SELECT IF(a != b IS NULL, 'UNKNOW', IF(a != b, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT a <= b FROM foo |
SELECT IF(a <= b IS NULL, 'UNKNOW', IF(a <= b, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT a NOT ILIKE 'nie lubi mnie' FROM foo |
SELECT IF(a NOT LIKE 'nie lubi mnie' IS NULL, 'UNKNOW', IF(a NOT LIKE 'nie lubi mnie', 'TRUE', 'FALSE')) FROM foo
|
|
SELECT a NOT ILIKE 'nie lubi mnie' ESCAPE 'l' FROM foo |
SELECT IF(a NOT LIKE 'nie lubi mnie' ESCAPE 'l' IS NULL, 'UNKNOW', IF(a NOT LIKE 'nie lubi mnie' ESCAPE 'l', 'TRUE', 'FALSE')) FROM foo
|
|
SELECT 'abc' !~* '.B.' FROM foo |
SELECT IF(NOT ('abc' REGEXP '.B.') IS NULL, 'UNKNOW', IF(NOT ('abc' REGEXP '.B.'), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT a >= b FROM foo |
SELECT IF(a >= b IS NULL, 'UNKNOW', IF(a >= b, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT b NOT LIKE 'tym bardziej mnie nie lubi ;(' FROM foo |
SELECT IF(b NOT LIKE BINARY ('tym bardziej mnie nie lubi ;(') IS NULL, 'UNKNOW', IF(b NOT LIKE BINARY ('tym bardziej mnie nie lubi ;('), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT b NOT LIKE 'tym bardziej mnie nie lubi ;(' ESCAPE 'u' FROM foo |
SELECT IF(b NOT LIKE BINARY ('tym bardziej mnie nie lubi ;(') ESCAPE 'u' IS NULL, 'UNKNOW', IF(b NOT LIKE BINARY ('tym bardziej mnie nie lubi ;(') ESCAPE 'u', 'TRUE', 'FALSE')) FROM foo
|
|
SELECT 'abc' !~ '.B.' FROM foo |
SELECT IF(NOT (BINARY ('abc') REGEXP '.B.') IS NULL, 'UNKNOW', IF(NOT (BINARY ('abc') REGEXP '.B.'), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT x NOT SIMILAR TO 'nie jest podobny' FROM foo |
Error: can not translate
NOT SIMILAR TO operator not implemented in MySQL backend
|
|
SELECT x NOT SIMILAR TO 'nie jest podobny' ESCAPE '|' FROM foo |
Error: can not translate
NOT SIMILAR TO operator not implemented in MySQL backend
|
|
SELECT a OR b FROM foo |
SELECT IF(a OR b IS NULL, 'UNKNOW', IF(a OR b, 'TRUE', 'FALSE')) FROM foo
|
|
SELECT (DATE '1999-01-01', DATE '1999-02-02') OVERLAPS (DATE '2000-01-01', DATE '2000-02-02') FROM foo |
SELECT IF((NOT ((CAST('2000-02-02' AS DATE) < CAST('1999-01-01' AS DATE)) OR (CAST('2000-01-01' AS DATE) > CAST('1999-02-02' AS DATE)))) IS NULL, 'UNKNOW', IF((NOT ((CAST('2000-02-02' AS DATE) < CAST('1999-01-01' AS DATE)) OR (CAST('2000-01-01' AS DATE) > CAST('1999-02-02' AS DATE)))), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT (DATE '2000-01-01', DATE '2000-02-02') OVERLAPS (DATE '1999-01-01', DATE '1999-02-02') FROM foo |
SELECT IF((NOT ((CAST('1999-02-02' AS DATE) < CAST('2000-01-01' AS DATE)) OR (CAST('1999-01-01' AS DATE) > CAST('2000-02-02' AS DATE)))) IS NULL, 'UNKNOW', IF((NOT ((CAST('1999-02-02' AS DATE) < CAST('2000-01-01' AS DATE)) OR (CAST('1999-01-01' AS DATE) > CAST('2000-02-02' AS DATE)))), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT (DATE '1999-01-01', DATE '2003-02-02') OVERLAPS (DATE '2000-01-01', DATE '2000-02-02') FROM foo |
SELECT IF((NOT ((CAST('2000-02-02' AS DATE) < CAST('1999-01-01' AS DATE)) OR (CAST('2000-01-01' AS DATE) > CAST('2003-02-02' AS DATE)))) IS NULL, 'UNKNOW', IF((NOT ((CAST('2000-02-02' AS DATE) < CAST('1999-01-01' AS DATE)) OR (CAST('2000-01-01' AS DATE) > CAST('2003-02-02' AS DATE)))), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT (DATE '1999-01-01', DATE '1999-02-02') OVERLAPS (DATE '1998-01-01', DATE '2000-02-02') FROM foo |
SELECT IF((NOT ((CAST('2000-02-02' AS DATE) < CAST('1999-01-01' AS DATE)) OR (CAST('1998-01-01' AS DATE) > CAST('1999-02-02' AS DATE)))) IS NULL, 'UNKNOW', IF((NOT ((CAST('2000-02-02' AS DATE) < CAST('1999-01-01' AS DATE)) OR (CAST('1998-01-01' AS DATE) > CAST('1999-02-02' AS DATE)))), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT (DATE '1999-01-01', DATE '2000-01-02') OVERLAPS (DATE '2000-01-01', DATE '2000-02-02') FROM foo |
SELECT IF((NOT ((CAST('2000-02-02' AS DATE) < CAST('1999-01-01' AS DATE)) OR (CAST('2000-01-01' AS DATE) > CAST('2000-01-02' AS DATE)))) IS NULL, 'UNKNOW', IF((NOT ((CAST('2000-02-02' AS DATE) < CAST('1999-01-01' AS DATE)) OR (CAST('2000-01-01' AS DATE) > CAST('2000-01-02' AS DATE)))), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT (DATE '2000-01-10', DATE '2003-02-02') OVERLAPS (DATE '2000-01-01', DATE '2000-02-02') FROM foo |
SELECT IF((NOT ((CAST('2000-02-02' AS DATE) < CAST('2000-01-10' AS DATE)) OR (CAST('2000-01-01' AS DATE) > CAST('2003-02-02' AS DATE)))) IS NULL, 'UNKNOW', IF((NOT ((CAST('2000-02-02' AS DATE) < CAST('2000-01-10' AS DATE)) OR (CAST('2000-01-01' AS DATE) > CAST('2003-02-02' AS DATE)))), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT (DATE '1999-01-01', INTERVAL '100 days') OVERLAPS (DATE '2000-01-01', DATE '2000-02-02') FROM foo |
SELECT IF((NOT ((CAST('2000-02-02' AS DATE) < CAST('1999-01-01' AS DATE)) OR (CAST('2000-01-01' AS DATE) > (CAST('1999-01-01' AS DATE) + INTERVAL 100 day)))) IS NULL, 'UNKNOW', IF((NOT ((CAST('2000-02-02' AS DATE) < CAST('1999-01-01' AS DATE)) OR (CAST('2000-01-01' AS DATE) > (CAST('1999-01-01' AS DATE) + INTERVAL 100 day)))), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT 2 ^ 3 FROM foo |
SELECT POWER(2, 3) FROM foo
|
|
SELECT 'abc' ~ '.B.' FROM foo |
SELECT IF(BINARY ('abc') REGEXP '.B.' IS NULL, 'UNKNOW', IF(BINARY ('abc') REGEXP '.B.', 'TRUE', 'FALSE')) FROM foo
|
|
SELECT a SIMILAR TO b FROM foo |
Error: can not translate
SIMILAR TO operator not implemented in MySQL backend
|
|
SELECT a SIMILAR TO b ESCAPE 'x' FROM foo |
Error: can not translate
SIMILAR TO operator not implemented in MySQL backend
|
|
SELECT |/4 = (2 + 2) FROM foo |
SELECT IF(SQRT(4) = (2 + 2) IS NULL, 'UNKNOW', IF(SQRT(4) = (2 + 2), 'TRUE', 'FALSE')) FROM foo
|
|
SELECT |/a FROM foo |
SELECT SQRT(a) FROM foo
|
|
SELECT |/a + b FROM foo |
SELECT SQRT(a) + b FROM foo
|
|
SELECT |/(a + b) FROM foo |
SELECT SQRT((a + b)) FROM foo
|
|
SELECT DATE '1999-10-01' - DATE '1999-09-28' FROM foo |
SELECT TO_DAYS(CAST('1999-10-01' AS DATE)) - TO_DAYS(CAST('1999-09-28' AS DATE)) FROM foo
|
|
SELECT DATE '1999-09-09' - INTEGER '7' FROM foo |
SELECT CAST('1999-09-09' AS DATE) - INTERVAL CAST('7' AS SIGNED INTEGER) DAY FROM foo
|
|
SELECT - INTEGER '7' + DATE '1999-09-09' FROM foo
|
SELECT CAST('1999-09-09' AS DATE) + INTERVAL - CAST('7' AS SIGNED INTEGER) DAY FROM foo
|
|
SELECT DATE '1999-09-09' - INTERVAL '1 hour' FROM foo |
SELECT CAST('1999-09-09' AS DATE) - INTERVAL 1 hour FROM foo
|
|
SELECT - INTERVAL '1 hour' + DATE '1999-09-09' FROM foo
|
SELECT INTERVAL -1 hour + CAST('1999-09-09' AS DATE) FROM foo
|
|
SELECT TIME '06:10' - TIME '02:11' FROM foo |
Error: can not translate
MySQL backend does not support substracting these arguments (interval, time, timestamp)
|
|
SELECT TIME '06:10' - INTERVAL '2 hours' FROM foo
|
Error: can not translate
MySQL backend does not support substracting these arguments (interval, time, timestamp)
|
|
SELECT - INTERVAL '2 hours' + TIME '06:10' FROM foo
|
Error: can not translate
MySQL backend does not support adding interval to interval or time
|
|
SELECT TIMESTAMP '1999-09-09 02:00' - TIMESTAMP '1998-12-31 23:59' FROM foo |
Error: can not translate
MySQL backend does not support substracting these arguments (interval, time, timestamp)
|
