Revision 12424
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 878 | 878 |
|
| 879 | 879 |
|
| 880 | 880 |
-- |
| 881 |
-- Name: =(`~type._traits_04_count_records_per_trait`, `~type._traits_04_count_records_per_trait`); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 881 |
-- Name: %==(`~type._traits_04_count_records_per_trait`, `~type._traits_04_count_records_per_trait`); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 882 | 882 |
-- |
| 883 | 883 |
|
| 884 | 884 |
|
| ... | ... | |
| 1053 | 1053 |
|
| 1054 | 1054 |
|
| 1055 | 1055 |
-- |
| 1056 |
-- Name: =; Type: OPERATOR; Schema: public_validations; Owner: - |
|
| 1056 |
-- Name: %==; Type: OPERATOR; Schema: public_validations; Owner: -
|
|
| 1057 | 1057 |
-- |
| 1058 | 1058 |
|
| 1059 |
CREATE OPERATOR = ( |
|
| 1060 |
PROCEDURE = `=`, |
|
| 1059 |
CREATE OPERATOR %== (
|
|
| 1060 |
PROCEDURE = `%==`,
|
|
| 1061 | 1061 |
LEFTARG = `~type._traits_04_count_records_per_trait`, |
| 1062 | 1062 |
RIGHTARG = `~type._traits_04_count_records_per_trait` |
| 1063 | 1063 |
); |
Also available in: Unified diff
bugfix: schemas/util.sql: diff(text, text) and types that use its custom FULL JOIN matching: need to use separate operator %== for determining which records to put on the same row, so that the = filter for identical rows only excludes rows that are actually the same, not all rows with the same keys (which would usually remove all rows)