Changeset: 086911f286a7 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=086911f286a7 Added Files: sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit sql/benchmarks/tpch/Tests/13-explain.stable.out.32bit sql/benchmarks/tpch/Tests/21-explain.stable.out.32bit sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out.32bit sql/test/BugTracker-2016/Tests/cast_and_floor.Bug-6071.sql sql/test/BugTracker-2016/Tests/cast_and_floor.Bug-6071.stable.err sql/test/BugTracker-2016/Tests/cast_and_floor.Bug-6071.stable.out sql/test/BugTracker-2016/Tests/union.Bug-6069.sql sql/test/BugTracker-2016/Tests/union.Bug-6069.stable.err sql/test/BugTracker-2016/Tests/union.Bug-6069.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out.int128 sql/test/pg_regress/Tests/oid.stable.out.oid32 sql/test/pg_regress/Tests/without_oid.stable.out.oid32 Modified Files: clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 geom/sql/conformance/Tests/T10.stable.out geom/sql/conformance/Tests/T11.stable.out geom/sql/conformance/Tests/T12.stable.out geom/sql/conformance/Tests/T13.stable.out geom/sql/conformance/Tests/T14.stable.out geom/sql/conformance/Tests/T15.stable.out geom/sql/conformance/Tests/T16.stable.out geom/sql/conformance/Tests/T17.stable.out geom/sql/conformance/Tests/T18.stable.out geom/sql/conformance/Tests/T21.stable.out geom/sql/conformance/Tests/T22.stable.out geom/sql/conformance/Tests/T23.stable.out geom/sql/conformance/Tests/T24.stable.out geom/sql/conformance/Tests/T25.stable.out geom/sql/conformance/Tests/T26.stable.out geom/sql/conformance/Tests/T27.stable.out geom/sql/conformance/Tests/T28.stable.out geom/sql/conformance/Tests/T29.stable.out geom/sql/conformance/Tests/T30.stable.out geom/sql/conformance/Tests/T31.stable.out geom/sql/conformance/Tests/T32.stable.out geom/sql/conformance/Tests/T33.stable.out geom/sql/conformance/Tests/T34.stable.out geom/sql/conformance/Tests/T35.stable.out geom/sql/conformance/Tests/T36.stable.out geom/sql/conformance/Tests/T37.stable.out geom/sql/conformance/Tests/T38.stable.out geom/sql/conformance/Tests/T39.stable.out geom/sql/conformance/Tests/T40.stable.out geom/sql/conformance/Tests/T41.stable.out geom/sql/conformance/Tests/T42.stable.out geom/sql/conformance/Tests/T43.stable.out geom/sql/conformance/Tests/T44.stable.out geom/sql/conformance/Tests/T45.stable.out geom/sql/conformance/Tests/T46.stable.out geom/sql/conformance/Tests/T47.stable.out geom/sql/conformance/Tests/T48.stable.out geom/sql/conformance/Tests/T49.stable.out geom/sql/conformance/Tests/T50.stable.out geom/sql/conformance/Tests/T51.stable.out geom/sql/conformance/Tests/T52.stable.out geom/sql/conformance/Tests/T6.stable.out geom/sql/conformance/Tests/T7.stable.out geom/sql/conformance/Tests/T8.stable.out geom/sql/functions/Tests/ST_AsEWKT.stable.out geom/sql/functions/Tests/ST_AsText.stable.out geom/sql/functions/Tests/ST_Boundary.stable.out geom/sql/functions/Tests/ST_Contains.stable.out geom/sql/functions/Tests/ST_CoordDim.stable.out geom/sql/functions/Tests/ST_Dimension.stable.out geom/sql/functions/Tests/ST_GeomFromText.stable.out geom/sql/functions/Tests/ST_GeometryN.stable.out geom/sql/functions/Tests/ST_GeometryType.stable.out geom/sql/functions/Tests/ST_IsClosed.stable.out geom/sql/functions/Tests/ST_IsEmpty.stable.out geom/sql/functions/Tests/ST_IsRing.stable.out geom/sql/functions/Tests/ST_IsSimple.stable.out geom/sql/functions/Tests/ST_IsValid.stable.out geom/sql/functions/Tests/ST_LineFromText.stable.out geom/sql/functions/Tests/ST_MLineFromText.stable.out geom/sql/functions/Tests/ST_MPointFromText.stable.out geom/sql/functions/Tests/ST_MPolygonFromText.stable.out geom/sql/functions/Tests/ST_MakeBox2D.stable.out geom/sql/functions/Tests/ST_MakePoint.stable.out geom/sql/functions/Tests/ST_NPoints.stable.out geom/sql/functions/Tests/ST_NRings.stable.out geom/sql/functions/Tests/ST_NumGeometries.stable.out geom/sql/functions/Tests/ST_NumInteriorRings.stable.out geom/sql/functions/Tests/ST_NumPoints.stable.out geom/sql/functions/Tests/ST_PointFromText.stable.out geom/sql/functions/Tests/ST_PolygonFromText.stable.out geom/sql/functions/Tests/XYZ.stable.out geom/sql/functions/Tests/XYZMinMax.stable.out geom/sql/pg_regression/Tests/boundary.stable.out geom/sql/pg_regression/Tests/delaunaytriangles.stable.out geom/sql/pg_regression/Tests/dump.stable.out geom/sql/pg_regression/Tests/regress_ogc_cover.stable.out monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.Windows.single monetdb5/extras/mal_optimizer_template/Tests/opt_sql_append.stable.out.single sql/backends/monet5/Tests/int_notation_1e5.stable.out sql/backends/monet5/Tests/optimizers.stable.out sql/backends/monet5/Tests/pyapi02.stable.out sql/backends/monet5/Tests/pyapi04.stable.out sql/backends/monet5/Tests/pyapi06.stable.out sql/backends/monet5/Tests/pyapi07.stable.out sql/backends/monet5/Tests/pyapi09.stable.out sql/backends/monet5/Tests/pyapi10.stable.out sql/backends/monet5/Tests/pyapi11.stable.out sql/backends/monet5/Tests/pyapi12.stable.out sql/backends/monet5/Tests/pyapi13.stable.out sql/backends/monet5/Tests/pyapi14.stable.out sql/backends/monet5/Tests/pyapi17.stable.out sql/backends/monet5/Tests/pyapi18.stable.out sql/backends/monet5/Tests/pyapi19.stable.out sql/backends/monet5/Tests/pyapi21.stable.out sql/backends/monet5/Tests/pyapi23.stable.out sql/backends/monet5/Tests/pyapi24.stable.out sql/backends/monet5/Tests/pyapi25.stable.out sql/backends/monet5/Tests/pyapi26.stable.out sql/backends/monet5/Tests/pyapi27.stable.out sql/backends/monet5/Tests/pyapi28.stable.out sql/backends/monet5/Tests/pyapi32.stable.out sql/backends/monet5/Tests/rapi02.stable.out sql/backends/monet5/Tests/rapi06.stable.out sql/backends/monet5/Tests/rapi07.stable.out sql/backends/monet5/Tests/rapi09.stable.out sql/backends/monet5/Tests/rapi10.stable.out sql/backends/monet5/Tests/rapi13.stable.out sql/backends/monet5/Tests/rapi14.stable.out sql/backends/monet5/Tests/rapi15.stable.out sql/backends/monet5/Tests/rapi17.stable.out sql/backends/monet5/Tests/rapi18.stable.out sql/backends/monet5/Tests/rapi19.stable.out sql/backends/monet5/Tests/simpleSQL.stable.out sql/backends/monet5/UDF/cudf/Tests/udf-fuse.stable.out sql/backends/monet5/UDF/cudf/Tests/udf-reverse.stable.out sql/backends/monet5/generator/Tests/generator03.stable.out sql/backends/monet5/gsl/Tests/gsl01.stable.out sql/backends/monet5/vaults/bam/Tests/bam_lib.stable.out sql/backends/monet5/vaults/bam/Tests/mergetable.stable.out sql/backends/monet5/vaults/bam/Tests/query1.1.stable.out sql/backends/monet5/vaults/bam/Tests/query1.2.stable.out sql/backends/monet5/vaults/bam/Tests/query2.1.stable.out sql/backends/monet5/vaults/bam/Tests/query2.10.stable.out sql/backends/monet5/vaults/bam/Tests/query2.11.stable.out sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out.int128 sql/backends/monet5/vaults/bam/Tests/query2.5.stable.out sql/backends/monet5/vaults/bam/Tests/query2.5.stable.out.int128 sql/backends/monet5/vaults/bam/Tests/query2.6.stable.out sql/backends/monet5/vaults/bam/Tests/query2.7.stable.out sql/backends/monet5/vaults/bam/Tests/query2.8.stable.out sql/backends/monet5/vaults/bam/Tests/sam_export.stable.out sql/benchmarks/nobench/Tests/nobench.stable.out sql/benchmarks/ssbm/Tests/01-13.stable.out sql/benchmarks/ssbm/Tests/01-13.stable.out.int128 sql/benchmarks/ssbm/Tests/01-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/01-plan.stable.out sql/benchmarks/ssbm/Tests/01.stable.out sql/benchmarks/ssbm/Tests/01.stable.out.int128 sql/benchmarks/ssbm/Tests/02-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/02-plan.stable.out sql/benchmarks/ssbm/Tests/02.stable.out sql/benchmarks/ssbm/Tests/02.stable.out.int128 sql/benchmarks/ssbm/Tests/03-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/03-plan.stable.out sql/benchmarks/ssbm/Tests/03.stable.out sql/benchmarks/ssbm/Tests/03.stable.out.int128 sql/benchmarks/ssbm/Tests/04-explain.stable.out sql/benchmarks/ssbm/Tests/04-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/04-plan.stable.out sql/benchmarks/ssbm/Tests/04.stable.out sql/benchmarks/ssbm/Tests/04.stable.out.int128 sql/benchmarks/ssbm/Tests/05-explain.stable.out sql/benchmarks/ssbm/Tests/05-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/05-plan.stable.out sql/benchmarks/ssbm/Tests/05.stable.out sql/benchmarks/ssbm/Tests/05.stable.out.int128 sql/benchmarks/ssbm/Tests/06-explain.stable.out sql/benchmarks/ssbm/Tests/06-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/06-plan.stable.out sql/benchmarks/ssbm/Tests/06.stable.out sql/benchmarks/ssbm/Tests/06.stable.out.int128 sql/benchmarks/ssbm/Tests/07-explain.stable.out sql/benchmarks/ssbm/Tests/07-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/07-plan.stable.out sql/benchmarks/ssbm/Tests/07.stable.out sql/benchmarks/ssbm/Tests/07.stable.out.int128 sql/benchmarks/ssbm/Tests/08-explain.stable.out sql/benchmarks/ssbm/Tests/08-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/08-plan.stable.out sql/benchmarks/ssbm/Tests/08.stable.out sql/benchmarks/ssbm/Tests/08.stable.out.int128 sql/benchmarks/ssbm/Tests/09-explain.stable.out sql/benchmarks/ssbm/Tests/09-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/09-plan.stable.out sql/benchmarks/ssbm/Tests/09.stable.out sql/benchmarks/ssbm/Tests/09.stable.out.int128 sql/benchmarks/ssbm/Tests/10-explain.stable.out sql/benchmarks/ssbm/Tests/10-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/10-plan.stable.out sql/benchmarks/ssbm/Tests/10.stable.out sql/benchmarks/ssbm/Tests/10.stable.out.int128 sql/benchmarks/ssbm/Tests/11-explain.stable.out sql/benchmarks/ssbm/Tests/11-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/11-plan.stable.out sql/benchmarks/ssbm/Tests/11.stable.out sql/benchmarks/ssbm/Tests/11.stable.out.int128 sql/benchmarks/ssbm/Tests/12-explain.stable.out sql/benchmarks/ssbm/Tests/12-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/12-plan.stable.out sql/benchmarks/ssbm/Tests/12.stable.out sql/benchmarks/ssbm/Tests/12.stable.out.int128 sql/benchmarks/ssbm/Tests/13-explain.stable.out sql/benchmarks/ssbm/Tests/13-explain.stable.out.int128 sql/benchmarks/ssbm/Tests/13-plan.stable.out sql/benchmarks/ssbm/Tests/13.stable.out sql/benchmarks/ssbm/Tests/13.stable.out.int128 sql/benchmarks/ssbm/Tests/check1.stable.out sql/benchmarks/ssbm/Tests/load.stable.out sql/benchmarks/tpch/Tests/01-22.stable.out sql/benchmarks/tpch/Tests/01-22.stable.out.int128 sql/benchmarks/tpch/Tests/01-explain.stable.out sql/benchmarks/tpch/Tests/01-explain.stable.out.int128 sql/benchmarks/tpch/Tests/01-plan.stable.out.int128 sql/benchmarks/tpch/Tests/01.stable.out sql/benchmarks/tpch/Tests/01.stable.out.int128 sql/benchmarks/tpch/Tests/02-plan.stable.out sql/benchmarks/tpch/Tests/03-explain.stable.out sql/benchmarks/tpch/Tests/03-explain.stable.out.int128 sql/benchmarks/tpch/Tests/03-plan.stable.out.int128 sql/benchmarks/tpch/Tests/03.stable.out sql/benchmarks/tpch/Tests/03.stable.out.int128 sql/benchmarks/tpch/Tests/04-explain.stable.out sql/benchmarks/tpch/Tests/04-plan.stable.out sql/benchmarks/tpch/Tests/04.stable.out sql/benchmarks/tpch/Tests/05-explain.stable.out sql/benchmarks/tpch/Tests/05-explain.stable.out.32bit sql/benchmarks/tpch/Tests/05-explain.stable.out.int128 sql/benchmarks/tpch/Tests/05-plan.stable.out.int128 sql/benchmarks/tpch/Tests/05.stable.out sql/benchmarks/tpch/Tests/05.stable.out.int128 sql/benchmarks/tpch/Tests/06-explain.stable.out.int128 sql/benchmarks/tpch/Tests/06-plan.stable.out.int128 sql/benchmarks/tpch/Tests/06.stable.out sql/benchmarks/tpch/Tests/06.stable.out.int128 sql/benchmarks/tpch/Tests/07-explain.stable.out sql/benchmarks/tpch/Tests/07-explain.stable.out.int128 sql/benchmarks/tpch/Tests/07-plan.stable.out.int128 sql/benchmarks/tpch/Tests/07.stable.out sql/benchmarks/tpch/Tests/07.stable.out.int128 sql/benchmarks/tpch/Tests/08-explain.stable.out.int128 sql/benchmarks/tpch/Tests/08-plan.stable.out.int128 sql/benchmarks/tpch/Tests/08.stable.out sql/benchmarks/tpch/Tests/08.stable.out.int128 sql/benchmarks/tpch/Tests/09-explain.stable.out sql/benchmarks/tpch/Tests/09-explain.stable.out.int128 sql/benchmarks/tpch/Tests/09-plan.stable.out.int128 sql/benchmarks/tpch/Tests/09.stable.out sql/benchmarks/tpch/Tests/09.stable.out.int128 sql/benchmarks/tpch/Tests/10-explain.stable.out sql/benchmarks/tpch/Tests/10-explain.stable.out.int128 sql/benchmarks/tpch/Tests/10-plan.stable.out.int128 sql/benchmarks/tpch/Tests/10.stable.out sql/benchmarks/tpch/Tests/10.stable.out.int128 sql/benchmarks/tpch/Tests/11-explain.stable.out.int128 sql/benchmarks/tpch/Tests/11-plan.stable.out.int128 sql/benchmarks/tpch/Tests/11.stable.out sql/benchmarks/tpch/Tests/11.stable.out.int128 sql/benchmarks/tpch/Tests/12-explain.stable.out sql/benchmarks/tpch/Tests/12-explain.stable.out.int128 sql/benchmarks/tpch/Tests/12-plan.stable.out sql/benchmarks/tpch/Tests/12.stable.out sql/benchmarks/tpch/Tests/12.stable.out.int128 sql/benchmarks/tpch/Tests/13-explain.stable.out sql/benchmarks/tpch/Tests/13-plan.stable.out sql/benchmarks/tpch/Tests/13.stable.out sql/benchmarks/tpch/Tests/14-explain.stable.out.int128 sql/benchmarks/tpch/Tests/14-plan.stable.out.int128 sql/benchmarks/tpch/Tests/14.stable.out sql/benchmarks/tpch/Tests/14.stable.out.int128 sql/benchmarks/tpch/Tests/15-plan.stable.out.int128 sql/benchmarks/tpch/Tests/16-explain.stable.out sql/benchmarks/tpch/Tests/16-explain.stable.out.32bit sql/benchmarks/tpch/Tests/16-plan.stable.out sql/benchmarks/tpch/Tests/16.stable.out sql/benchmarks/tpch/Tests/17-explain.stable.out.int128 sql/benchmarks/tpch/Tests/17-plan.stable.out sql/benchmarks/tpch/Tests/17-plan.stable.out.int128 sql/benchmarks/tpch/Tests/17.stable.out sql/benchmarks/tpch/Tests/17.stable.out.int128 sql/benchmarks/tpch/Tests/18-explain.stable.out sql/benchmarks/tpch/Tests/18-explain.stable.out.int128 sql/benchmarks/tpch/Tests/18-plan.stable.out sql/benchmarks/tpch/Tests/18-plan.stable.out.int128 sql/benchmarks/tpch/Tests/18.stable.out sql/benchmarks/tpch/Tests/18.stable.out.int128 sql/benchmarks/tpch/Tests/19-explain.stable.out.int128 sql/benchmarks/tpch/Tests/19-plan.stable.out.int128 sql/benchmarks/tpch/Tests/19.stable.out sql/benchmarks/tpch/Tests/19.stable.out.int128 sql/benchmarks/tpch/Tests/21-explain.stable.out sql/benchmarks/tpch/Tests/21-plan.stable.out sql/benchmarks/tpch/Tests/21.stable.out sql/benchmarks/tpch/Tests/22-explain.stable.out sql/benchmarks/tpch/Tests/22-explain.stable.out.int128 sql/benchmarks/tpch/Tests/22-plan.stable.out sql/benchmarks/tpch/Tests/22.stable.out sql/benchmarks/tpch/Tests/22.stable.out.int128 sql/benchmarks/tpch/Tests/check1.stable.out sql/benchmarks/tpch/Tests/load.stable.out sql/benchmarks/tpch/Tests/lowcardinality.stable.out sql/jdbc/tests/Tests/Test_JdbcClient.stable.out sql/jdbc/tests/Tests/Test_PSmetadata.stable.out sql/server/rel_rel.c sql/test/ADT2006/Tests/benesamo.stable.out sql/test/ADT2006/Tests/bram.stable.out sql/test/ADT2006/Tests/slam.stable.out sql/test/ADT2006/Tests/woud.stable.out sql/test/BugDay_2005-10-06_2.8/Tests/mixed_type.SF-917372.stable.out sql/test/BugDay_2005-10-06_2.8/Tests/select_null.stable.out sql/test/BugDay_2005-10-06_2.8/Tests/string_quotes.SF-919539.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/BATpropcheck_error.SF-1012739.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-1.SF-921673.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/CrashMe_SQL_server_crash-2.SF-921673.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/basic_arithmetics.SF-922252.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/bool_boolean.SF-935601.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/case.SF-929151.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/cross_product.SF-1122802.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/custom_function_in_where.SF-937859.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/huge_expression_and_column_name.SF-921173.stable.out.int128 sql/test/BugDay_2005-10-06_2.9.3/Tests/max_min_sum_null.SF-1123132.stable.out.int128 sql/test/BugDay_2005-10-06_2.9.3/Tests/multiple_select_on_view.SF-935639.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/not_null.SF-933194.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/quoted_keywords.SF-922288.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/reserved_words.SF-939112.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/select_not_true.SF-1314945.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/set_types.SF-932360.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_1.SF-923709.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_2.SF-923709.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/timestamp_parsing.SF-927300.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/type_dump_test.SF-989257.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/union_limitation.SF-921992.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/var_char_cast_truncate.SF-1150907.stable.out sql/test/BugDay_2005-10-06_2.9.3/Tests/variable_arg_substring.SF_942981.stable.out sql/test/BugDay_2005-11-09_2.8/Tests/crash_in_case.SF-1097749.stable.out sql/test/BugDay_2005-11-09_2.9.3/Tests/date_functions.SF-967145.stable.out sql/test/BugDay_2005-11-09_2.9.3/Tests/empty_avg.SF-1207887.stable.out sql/test/BugDay_2005-11-09_2.9.3/Tests/interval_on_time_stamp.SF-1080488.stable.out sql/test/BugDay_2005-11-09_2.9.3/Tests/like_doesnot_like_strings.SF-1076605.stable.out sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_abort.SF-1080025.stable.out sql/test/BugDay_2005-11-09_2.9.3/Tests/sql_server_crash.SF-1080024.stable.out sql/test/BugDay_2005-11-09_2.9.3/Tests/union-duplicates.SF-1119186.stable.out sql/test/BugDay_2005-12-19_2.9.3/Tests/NULL_in_CASE.SF-1211335.stable.out sql/test/BugDay_2005-12-19_2.9.3/Tests/aggregate_functions_with_limit.SF-1367127.stable.out sql/test/BugDay_2005-12-19_2.9.3/Tests/delete_cascade.SF-1296395.stable.out sql/test/BugDay_2005-12-19_2.9.3/Tests/in_operator.SF-1211925.stable.out sql/test/BugDay_2005-12-19_2.9.3/Tests/interval_times_int.SF-1281996.stable.out sql/test/BugDay_2005-12-19_2.9.3/Tests/timestamp_fraction.SF-1357342.stable.out sql/test/BugTracker-2008/Tests/OOM_query.SF-2457195.stable.out sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out.int128 sql/test/BugTracker-2008/Tests/copy-count.SF-2485215.stable.out sql/test/BugTracker-2008/Tests/extract_bug.SF-2075266.stable.out.int128 sql/test/BugTracker-2008/Tests/groupby_with_NULL.SF-2155606.stable.out sql/test/BugTracker-2008/Tests/groupby_with_NULL.SF-2155606.stable.out.int128 sql/test/BugTracker-2008/Tests/select_between_wrong_result.SF-2080189.stable.out sql/test/BugTracker-2008/Tests/select_not_wrong_result.SF-2080151.stable.out sql/test/BugTracker-2008/Tests/varchar_char_semantics.SF-2075085.stable.out sql/test/BugTracker-2009/Tests/AVG_ReturnsNoLines.SF-2596084.stable.out sql/test/BugTracker-2009/Tests/AVG_of_SQRT.SF-2757642.stable.out sql/test/BugTracker-2009/Tests/BOM.SF-2787813.stable.out sql/test/BugTracker-2009/Tests/Division_by_zero_error.SF-2791361.stable.out sql/test/BugTracker-2009/Tests/Floating_point_exception.SF-2791356.stable.out sql/test/BugTracker-2009/Tests/IS_NULL_in_CASE.stable.out sql/test/BugTracker-2009/Tests/LE_vs_GE_in_CASE.SF-2562264.stable.out sql/test/BugTracker-2009/Tests/POWER_vs_prod.SF-2596114.stable.out sql/test/BugTracker-2009/Tests/TribooleanFailureWithSubquery.SF-2679434.stable.out sql/test/BugTracker-2009/Tests/TribooleanFailureWithSubquery.SF-2679434.stable.out.int128 sql/test/BugTracker-2009/Tests/TypeException_having_count_distinct.SF-2494227.stable.out sql/test/BugTracker-2009/Tests/addmonths_missing.SF-2854949.stable.out sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.stable.out.int128 sql/test/BugTracker-2009/Tests/avg-bug.SF-2132666.stable.out.int128 sql/test/BugTracker-2009/Tests/bit_and.SF-2850341.stable.out.int128 sql/test/BugTracker-2009/Tests/case_evaluates_all_branches.SF-2893484.stable.out sql/test/BugTracker-2009/Tests/case_evaluates_all_branches.SF-2893484.stable.out.int128 sql/test/BugTracker-2009/Tests/caselessthen.stable.out sql/test/BugTracker-2009/Tests/coercion.stable.out sql/test/BugTracker-2009/Tests/correlated-selection-bug.stable.out sql/test/BugTracker-2009/Tests/count_distinct_bug.SF-2826015.stable.out sql/test/BugTracker-2009/Tests/double_count_limit_bug.SF-2862146.stable.out sql/test/BugTracker-2009/Tests/explain_gives_crash.SF-2741829.stable.out sql/test/BugTracker-2009/Tests/function_call_not_handled.SF-2864179.stable.out sql/test/BugTracker-2009/Tests/having_or_bug.stable.out sql/test/BugTracker-2009/Tests/leftjoin_undefined.SF-2879011.stable.out sql/test/BugTracker-2009/Tests/like_bug.SF-2878994.stable.out sql/test/BugTracker-2009/Tests/old_views_incorrectly_reused.SF-2863804.stable.out sql/test/BugTracker-2009/Tests/order_by_column_position_rel_name_bug.stable.out sql/test/BugTracker-2009/Tests/orderby_with_row_number.SF-2895791.stable.out sql/test/BugTracker-2009/Tests/parallel_bulk-load.SF-2771052.test.stable.out sql/test/BugTracker-2009/Tests/pow_operator.SF-2812721.stable.out sql/test/BugTracker-2009/Tests/primekeyconstraint.SF-2783425.stable.out sql/test/BugTracker-2009/Tests/push-select-div-down.SF-2593341.stable.out sql/test/BugTracker-2009/Tests/push_select_down_crash.stable.out sql/test/BugTracker-2009/Tests/random.SF-2737889.stable.out sql/test/BugTracker-2009/Tests/restart_with_large_int.SF-2846238.stable.out sql/test/BugTracker-2009/Tests/set_and_arg_null.SF-2812729.stable.out sql/test/BugTracker-2009/Tests/subtraction_between_two_columns.SF-2582389.stable.out sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-1.stable.out sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-2.stable.out sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_KO-3.stable.out sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-0.stable.out sql/test/BugTracker-2009/Tests/updating_non-loaded_columns.SF-2864313_OK-4.stable.out sql/test/BugTracker-2009/Tests/utf8_bug.SF-2822855.stable.out sql/test/BugTracker-2010/Tests/TypeException_with_missing_function.Bug-2674.stable.out sql/test/BugTracker-2010/Tests/and_not_broken.Bug-2602.stable.out sql/test/BugTracker-2010/Tests/between-timestamp.Bug-2718.stable.out sql/test/BugTracker-2010/Tests/cast-varchar.Bug-2682.stable.out sql/test/BugTracker-2010/Tests/concat_type_check_problem.Bug-2354.stable.out sql/test/BugTracker-2010/Tests/constants-optimizer.Bug-2317.stable.out sql/test/BugTracker-2010/Tests/count-and-not.Bug-2663.stable.out sql/test/BugTracker-2010/Tests/crash_on_complex_join_exp.Bug-2353.stable.out sql/test/BugTracker-2010/Tests/crash_on_where_in.Bug-2333.stable.out sql/test/BugTracker-2010/Tests/decimal-function.BUG-2624.stable.out sql/test/BugTracker-2010/Tests/decimal_div_whole_nrs.Bug-2579.stable.out sql/test/BugTracker-2010/Tests/distinct-order-by-limit.Bug-2691.stable.out sql/test/BugTracker-2010/Tests/function_results_NULL.Bug-2626.stable.out sql/test/BugTracker-2010/Tests/group-by_ordered_column.Bug-2564.stable.out sql/test/BugTracker-2010/Tests/join_problem.Bug-2694.stable.out sql/test/BugTracker-2010/Tests/keycheck_crash.Bug-2583.stable.out sql/test/BugTracker-2010/Tests/predicate_in_select.Bug-2535.stable.out sql/test/BugTracker-2010/Tests/prepare_stmt.Bug-2533.Bug-2534.stable.out sql/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.stable.out.int128 sql/test/BugTracker-2010/Tests/sequence-restart-with-null.Bug-2648.stable.out sql/test/BugTracker-2010/Tests/shift_with_cast.Bug-2638.stable.out sql/test/BugTracker-2010/Tests/substring_display_width.Bug-2683.stable.out sql/test/BugTracker-2010/Tests/unicode-bom.Bug-2641.stable.out sql/test/BugTracker-2010/Tests/update_statement_in_function_ignored.Bug-2614.stable.out sql/test/BugTracker-2010/Tests/with-between.Bug-2732.stable.out sql/test/BugTracker-2011/Tests/CASE_division_exception.Bug-2822.stable.out sql/test/BugTracker-2011/Tests/CASE_nested_functions.Bug-2852.stable.out sql/test/BugTracker-2011/Tests/aggregate-in-subquery.Bug-2739.stable.out sql/test/BugTracker-2011/Tests/and-power.Bug-3013.stable.out sql/test/BugTracker-2011/Tests/and-power.Bug-3013.stable.out.int128 sql/test/BugTracker-2011/Tests/bulk_rotate_xor_hash-error.Bug-2734.stable.out sql/test/BugTracker-2011/Tests/case-when-alias.Bug-2848.stable.out sql/test/BugTracker-2011/Tests/cast-crash.Bug-2678.stable.out sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808.stable.out sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128 sql/test/BugTracker-2011/Tests/delete-large-table.Bug-2882.stable.out sql/test/BugTracker-2011/Tests/div_by_zero.Bug-2887.stable.out sql/test/BugTracker-2011/Tests/exists-select.Bug-2933.stable.out sql/test/BugTracker-2011/Tests/extract_seconds.Bug-2793.stable.out sql/test/BugTracker-2011/Tests/history.Bug-2909.stable.out sql/test/BugTracker-2011/Tests/jena-optional-1-test.Bug-2915.stable.out sql/test/BugTracker-2011/Tests/many-connects-cache.Bug-2904.stable.out sql/test/BugTracker-2011/Tests/multiple-joins.Bug-2879.stable.out sql/test/BugTracker-2011/Tests/non-stable-select-bug.Bug-2894.stable.out.int128 sql/test/BugTracker-2011/Tests/predicate.Bug-2908.stable.out sql/test/BugTracker-2011/Tests/rand-with-seed.Bug-2900.stable.out sql/test/BugTracker-2011/Tests/recursive_case.Bug-2838.stable.out sql/test/BugTracker-2011/Tests/sqltables.Bug-2921.stable.out sql/test/BugTracker-2011/Tests/subquery_in_from_clause.Bug-2812.stable.out sql/test/BugTracker-2011/Tests/subquery_in_from_clause.Bug-2812.stable.out.int128 sql/test/BugTracker-2011/Tests/supertype.Bug-2830.stable.out sql/test/BugTracker-2011/Tests/time_precision.Bug-2873.stable.out sql/test/BugTracker-2011/Tests/view_avg_incorrect_result.Bug-2790.stable.out sql/test/BugTracker-2012/Tests/aggregate_incorrect_precision_scale.Bug-3182.stable.out sql/test/BugTracker-2012/Tests/aggregate_incorrect_precision_scale.Bug-3182.stable.out.int128 sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out sql/test/BugTracker-2012/Tests/algebra_find.Bug-2728.stable.out sql/test/BugTracker-2012/Tests/any_null.Bug-2594.stable.out sql/test/BugTracker-2012/Tests/boolean_coersion.Bug-3012.stable.out sql/test/BugTracker-2012/Tests/case_evaluated_too_early.Bug-3186.stable.out sql/test/BugTracker-2012/Tests/cast-tinyint-Bug-3137.stable.out sql/test/BugTracker-2012/Tests/cast_varchar_to_double.Bug-3071.stable.out sql/test/BugTracker-2012/Tests/correlated_groupby_in_selection.Bug-3011.stable.out sql/test/BugTracker-2012/Tests/currenttime.Bug-2781.stable.out sql/test/BugTracker-2012/Tests/date_script_test.Bug-2973.stable.out sql/test/BugTracker-2012/Tests/day-of-month-localization.Bug-2962.stable.out sql/test/BugTracker-2012/Tests/fixed_limit_for_prepare.Bug-3208.stable.out sql/test/BugTracker-2012/Tests/float-mod.Bug-3086.stable.out sql/test/BugTracker-2012/Tests/incorrect_cast_from_double_to_int.Bug-2579.stable.out sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out.int128 sql/test/BugTracker-2012/Tests/many-columns-truncated.Bug-3161.stable.out sql/test/BugTracker-2012/Tests/not-equal-Bug.3139.stable.out sql/test/BugTracker-2012/Tests/now_results_in_illegal_argument.Bug-2978.stable.out sql/test/BugTracker-2012/Tests/order_by_on_column_exp.Bug-3193.stable.out sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.stable.out sql/test/BugTracker-2012/Tests/power_priority.Bug-2291.stable.out.int128 sql/test/BugTracker-2012/Tests/round-type-inference.Bug-2987.stable.out sql/test/BugTracker-2012/Tests/row_number_does_not_work_in_complex_query.Bug-2805.stable.out sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.stable.out sql/test/BugTracker-2012/Tests/server-crash.Bug-3046.stable.out sql/test/BugTracker-2012/Tests/set_operation.Bug-3059.stable.out sql/test/BugTracker-2012/Tests/simple_select.Bug-2988.stable.out sql/test/BugTracker-2012/Tests/sticky-precision.Bug-2969.stable.out sql/test/BugTracker-2012/Tests/timestamp-diff.Bug-3190.stable.out sql/test/BugTracker-2012/Tests/tuples_INTERSECT_vs_count_intersect_differs.Bug-2659.stable.out sql/test/BugTracker-2012/Tests/url_script_test.Bug-2972.stable.out sql/test/BugTracker-2012/Tests/user_defined_decimal_function.Bug-2992.stable.out sql/test/BugTracker-2012/Tests/with_and_exists.Bug-3099.stable.out sql/test/BugTracker-2013/Tests/Cannot_Find_Column_Type.Bug-3394.stable.out sql/test/BugTracker-2013/Tests/aggregates-typing-issues.Bug-3277.stable.out.int128 sql/test/BugTracker-2013/Tests/alter_resets_readonly.Bug-3362.stable.out sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128 sql/test/BugTracker-2013/Tests/bogus_aggregation_casts.Bug-3342.stable.out sql/test/BugTracker-2013/Tests/case-orderby.Bug-3388.stable.out sql/test/BugTracker-2013/Tests/case-orderby.Bug-3388.stable.out.int128 sql/test/BugTracker-2013/Tests/case_when.Bug-3395.stable.out sql/test/BugTracker-2013/Tests/correlated_select.Bug-3250.stable.out sql/test/BugTracker-2013/Tests/correlated_subquery.Bug-3317.stable.out sql/test/BugTracker-2013/Tests/env_errors.Bug-3370.stable.out sql/test/BugTracker-2013/Tests/groupby_on_value_view.Bug-3264.stable.out sql/test/BugTracker-2013/Tests/hashed_exp.Bug-3313.stable.out sql/test/BugTracker-2013/Tests/iso8601_weekofyear.Bug-3232.stable.out sql/test/BugTracker-2013/Tests/median-null.Bug-3280.stable.out sql/test/BugTracker-2013/Tests/median.Bug-3352.stable.out sql/test/BugTracker-2013/Tests/mitosis-floor.Bug-3330.stable.out sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.stable.out sql/test/BugTracker-2013/Tests/nestedcalls.stable.out sql/test/BugTracker-2013/Tests/numeric-column-alias.Bug-3279.stable.out sql/test/BugTracker-2013/Tests/php-size-limit-bug.stable.out sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332.stable.out sql/test/BugTracker-2013/Tests/recursion.stable.out sql/test/BugTracker-2013/Tests/segfault_in_aggregation.Bug-3225.stable.out sql/test/BugTracker-2013/Tests/singleton-median.Bug-3389.stable.out sql/test/BugTracker-2013/Tests/stddev-group.Bug-3257.stable.out sql/test/BugTracker-2013/Tests/subtract-one-year.Bug-3215.stable.out sql/test/BugTracker-2013/Tests/udf_error.Bug-3396.stable.out sql/test/BugTracker-2013/Tests/unop_vs_aggr.Bug-3885.stable.out sql/test/BugTracker-2014/Tests/BOM-in-string.Bug-3641.stable.out sql/test/BugTracker-2014/Tests/aggr-with-limit.Bug-3498.stable.out sql/test/BugTracker-2014/Tests/bug_in_cse.Bug-3511.stable.out sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.out sql/test/BugTracker-2014/Tests/column-with-comma.Bug-3616.stable.out sql/test/BugTracker-2014/Tests/crash_on_groupby_distinct_serial.Bug-3463.stable.out sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.stable.out sql/test/BugTracker-2014/Tests/div_by_zero_in_return.Bug-3555.stable.out sql/test/BugTracker-2014/Tests/empty_intermediate_quantile.Bug-3611.stable.out sql/test/BugTracker-2014/Tests/groupby.Bug-3421.stable.out.int128 sql/test/BugTracker-2014/Tests/groupby_distict.Bug-3423.stable.out sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.stable.out.int128 sql/test/BugTracker-2014/Tests/ifthenelse.Bug-3546.stable.out sql/test/BugTracker-2014/Tests/ifthenelse.Bug-3546.stable.out.int128 sql/test/BugTracker-2014/Tests/ifthenelse.Bug-3629.stable.out sql/test/BugTracker-2014/Tests/incorrect_floating_point_cast.Bug-3633.stable.out sql/test/BugTracker-2014/Tests/indices.Bug-3435.stable.out sql/test/BugTracker-2014/Tests/locate-offset.Bug-3563.stable.out sql/test/BugTracker-2014/Tests/manifold.Bug-3556.stable.out sql/test/BugTracker-2014/Tests/missing_alias.Bug-3626.stable.out sql/test/BugTracker-2014/Tests/orderby_count.Bug-3526.stable.out sql/test/BugTracker-2014/Tests/orderby_on_constant.Bug-3554.stable.out sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out sql/test/BugTracker-2014/Tests/querylog.Bug-3607.stable.out.single sql/test/BugTracker-2014/Tests/queueError.Bug-3604.stable.out sql/test/BugTracker-2014/Tests/round-properties.Bug-3515.stable.out sql/test/BugTracker-2014/Tests/round-sorted.Bug-3562.stable.out sql/test/BugTracker-2014/Tests/round.Bug-3542.stable.out.int128 sql/test/BugTracker-2014/Tests/select-having.Bug-3458.stable.out sql/test/BugTracker-2014/Tests/select_in_crash.Bug-3491.stable.out sql/test/BugTracker-2014/Tests/sign-sorted.Bug-3594.stable.out sql/test/BugTracker-2014/Tests/stddev-empty.Bug-3628.stable.out sql/test/BugTracker-2014/Tests/two-column-aggr-with-null.Bug-3428.stable.out sql/test/BugTracker-2014/Tests/type_resolution.Bug-3622.stable.out sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.stable.out sql/test/BugTracker-2014/Tests/union_with_subqueries.Bug-3518.stable.out.int128 sql/test/BugTracker-2014/Tests/unsafe_project_push_down.Bug-3523.stable.out sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part1.stable.out sql/test/BugTracker-2015/Tests/alter-table.Bug-3828-part2.stable.out sql/test/BugTracker-2015/Tests/ambiguous.Bug-3803.stable.out sql/test/BugTracker-2015/Tests/ambiguous.Bug-3803.stable.out.int128 sql/test/BugTracker-2015/Tests/apply_merge_distinct.Bug-3760.stable.out sql/test/BugTracker-2015/Tests/assertHead.Bug-3706.stable.out sql/test/BugTracker-2015/Tests/cardinality.Bug-3761.stable.out sql/test/BugTracker-2015/Tests/case_aggr.Bug-3705.stable.out sql/test/BugTracker-2015/Tests/case_type.Bug-3821.stable.out sql/test/BugTracker-2015/Tests/cast_on_groupby_col_crash.Bug-3769.stable.out sql/test/BugTracker-2015/Tests/coalesce.Bug-3830.stable.out sql/test/BugTracker-2015/Tests/constant-random.Bug-3836.stable.out sql/test/BugTracker-2015/Tests/convert-to-bit.Bug-3719.stable.out sql/test/BugTracker-2015/Tests/copy_into.Bug-3813.stable.out sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.stable.out sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.stable.out.int128 sql/test/BugTracker-2015/Tests/crash_timestamp_convert.Bug-3816.stable.out sql/test/BugTracker-2015/Tests/div_zero.Bug-3742.stable.out sql/test/BugTracker-2015/Tests/epoch_now.Bug-3740.stable.out sql/test/BugTracker-2015/Tests/find_fk.Bug-3690.stable.out sql/test/BugTracker-2015/Tests/fractional_precision_limitation.Bug-3808.stable.out sql/test/BugTracker-2015/Tests/incorrect_result_type.Bug-3687.stable.out.int128 sql/test/BugTracker-2015/Tests/inet-funcs.Bug-3645.stable.out sql/test/BugTracker-2015/Tests/inet-ordering.Bug-3660.stable.out sql/test/BugTracker-2015/Tests/inf-nan-handling.Bug-3696.stable.out sql/test/BugTracker-2015/Tests/leftjoin.Bug-3720.stable.out sql/test/BugTracker-2015/Tests/like-escape.Bug-3822.stable.out sql/test/BugTracker-2015/Tests/long_insert.Bug-3845.stable.out sql/test/BugTracker-2015/Tests/missed-error.Bug-3842.stable.out sql/test/BugTracker-2015/Tests/mserver-crashes-under-specific-combination-of-JOIN-and-WHERE-conditions.Bug-3872.stable.out sql/test/BugTracker-2015/Tests/nil_cast.Bug-3787.stable.out.int128 sql/test/BugTracker-2015/Tests/null.Bug-3833.stable.out sql/test/BugTracker-2015/Tests/null_is_null.Bug-3739.stable.out sql/test/BugTracker-2015/Tests/operator-priority.Bug-3686.stable.out sql/test/BugTracker-2015/Tests/outerjoin_project.Bug-3725.stable.out sql/test/BugTracker-2015/Tests/project_rewrite.Bug-3693_2.stable.out sql/test/BugTracker-2015/Tests/quantile_function_resolution.Bug-3773.stable.out sql/test/BugTracker-2015/Tests/select-push-crash.Bug-3829.stable.out sql/test/BugTracker-2015/Tests/select-tilde-arg.Bug-3814.stable.out sql/test/BugTracker-2015/Tests/sessions_crash.Bug-3759.stable.out sql/test/BugTracker-2015/Tests/set_default_role.Bug-3364.stable.out sql/test/BugTracker-2015/Tests/sharp-alias.Bug-3467.stable.out sql/test/BugTracker-2015/Tests/sql2pcre.Bug-3800.stable.out sql/test/BugTracker-2015/Tests/string_split.Bug-3564.stable.out sql/test/BugTracker-2015/Tests/sum_interval.Bug-3785.stable.out sql/test/BugTracker-2015/Tests/timestamp_convert.Bug-3815.stable.out sql/test/BugTracker-2015/Tests/ukey_check_unaligned.Bug-3669.stable.out sql/test/BugTracker-2016/Tests/All sql/test/BugTracker-2016/Tests/CREATE_INDEX_breaks_table_queries.Bug-4053.stable.out sql/test/BugTracker-2016/Tests/DISTINCT_with_correlated_scalar_subquery_crashes_mserver.Bug-3920.stable.out sql/test/BugTracker-2016/Tests/case-with-string-Bug.3932.stable.out sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out sql/test/BugTracker-2016/Tests/column_alias_in_where_clause.Bug-3947.stable.out.int128 sql/test/BugTracker-2016/Tests/column_not_found.Bug-4064.stable.out sql/test/BugTracker-2016/Tests/date_calculation_and_comparison_wrong_results.Bug-3940.stable.out sql/test/BugTracker-2016/Tests/decimal_vs_integer.Bug-3941.stable.out sql/test/BugTracker-2016/Tests/epoch.Bug-3979.stable.out sql/test/BugTracker-2016/Tests/group_distinct_quantile.Bug-3927.stable.out sql/test/BugTracker-2016/Tests/isaUUID_function.Bug-3997.stable.out sql/test/BugTracker-2016/Tests/merge_project.Bug-3955.stable.out sql/test/BugTracker-2016/Tests/min-max-uuid-column-wrong-results.Bug-3953.stable.out sql/test/BugTracker-2016/Tests/name_conflict_in_union.Bug-6065.stable.out sql/test/BugTracker-2016/Tests/nested-mal-with-multiplex.Bug-4035.stable.out sql/test/BugTracker-2016/Tests/null_in_null.Bug-3900.stable.out sql/test/BugTracker-2016/Tests/outer_constant_predicate.Bug-4070.stable.out sql/test/BugTracker-2016/Tests/prepare_without_querycache.Bug-4047.stable.out sql/test/BugTracker-2016/Tests/rename_exps.Bug-3974.stable.out sql/test/BugTracker-2016/Tests/storagemodel.stable.out sql/test/BugTracker-2016/Tests/storagemodel.stable.out.32bit sql/test/BugTracker-2016/Tests/string-length.Bug-3999.stable.out sql/test/BugTracker-2016/Tests/subcorr-missing.Bug-3978.stable.out sql/test/BugTracker-2016/Tests/wrong-nonil-property-with-copy-binary-into.Bug-3937.stable.out sql/test/BugTracker/Tests/authorization.SF-1430616.stable.out sql/test/BugTracker/Tests/auto_increment.SF-1834820.stable.out sql/test/BugTracker/Tests/bug_in_selection.SF-1892413.stable.out sql/test/BugTracker/Tests/case_in_aggr_bug.SF-1506545.stable.out sql/test/BugTracker/Tests/case_with_aggr.SF-1876779.stable.out.int128 sql/test/BugTracker/Tests/cast_interval2time.SF-1488247.stable.out sql/test/BugTracker/Tests/connect_crash.SF-1436626.stable.out sql/test/BugTracker/Tests/convert_dec2varchar.SF-1774312.stable.out sql/test/BugTracker/Tests/convert_dec2varchar_crash.SF-1775550.stable.out sql/test/BugTracker/Tests/count_crash.SF-1918780.stable.out sql/test/BugTracker/Tests/crash_on_delete.SF-1639108.stable.out sql/test/BugTracker/Tests/crash_on_delete.SF-1651567.stable.out sql/test/BugTracker/Tests/crash_on_insert.SF-1639113.stable.out sql/test/BugTracker/Tests/drop_schema_crash.SF-1504794.stable.out sql/test/BugTracker/Tests/explain.SF-1739353.stable.out sql/test/BugTracker/Tests/groupby_with_alias.SF-1520575.stable.out.int128 sql/test/BugTracker/Tests/insert_not_exists.SF-1380287.stable.out sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit sql/test/BugTracker/Tests/large_prepare_2.SF-1363729.stable.out sql/test/BugTracker/Tests/like_for_time_values.SF-1715659.stable.out sql/test/BugTracker/Tests/mdb_starts_with_sql_debug_64.SF-1999354.stable.out sql/test/BugTracker/Tests/ms_round.SF-1907063.stable.out sql/test/BugTracker/Tests/orderby_in_function.SF-1892708.stable.out sql/test/BugTracker/Tests/proc_insert_into.SF-1958572.stable.out sql/test/BugTracker/Tests/rand_not_executed_for_every_row.SF-1723791.stable.out sql/test/BugTracker/Tests/rank_over.SF-1691098.stable.out sql/test/BugTracker/Tests/select_crashes_in_the_optimization.SF-1848553.stable.out sql/test/BugTracker/Tests/select_mod.SF-1838813.stable.out sql/test/BugTracker/Tests/set_a_new_user_password.SF-1844050.stable.out sql/test/BugTracker/Tests/set_sql_debug_64__breaking_the_DB.SF-1906287.stable.out sql/test/BugTracker/Tests/sql_prepare_prob.SF-1909638.stable.out sql/test/BugTracker/Tests/variable_names.SF-1838816.stable.out sql/test/BugTracker/Tests/variables.SF-1508160.stable.out sql/test/BugTracker/Tests/with_row_number.SF-1898089.stable.out sql/test/Dependencies/Tests/Dependencies.stable.out sql/test/Dependencies/Tests/dependency_loop.stable.out sql/test/Dependencies/Tests/dependency_loop.stable.out.int128 sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out.int128 sql/test/SQLite_regress/sqllogictest/Tests/select2.test.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select2.test.stable.out.int128 sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out.int128 sql/test/Skyserver/Tests/Skyserver.stable.out sql/test/Tests/50ways.stable.out sql/test/Tests/alastair_udf_mergetable_bug.stable.out sql/test/Tests/alastair_udf_mergetable_bug.stable.out.int128 sql/test/Tests/coalesce.stable.out sql/test/Tests/count.stable.out sql/test/Tests/decimal2.stable.out sql/test/Tests/identifiers.stable.out sql/test/Tests/marcin1.stable.out sql/test/Tests/marcin3.stable.out sql/test/Tests/marcin3.stable.out.int128 sql/test/Tests/median_stdev.stable.out sql/test/Tests/order_by_simple_exp.stable.out sql/test/Tests/orderby_limit.stable.out sql/test/Tests/outerref_in_selection.stable.out sql/test/Tests/outerref_in_selection.stable.out.int128 sql/test/Tests/psm.stable.out sql/test/Tests/rank.stable.out sql/test/Tests/restart-sequence.stable.out sql/test/Tests/round.stable.out sql/test/Tests/session_vars.stable.out sql/test/Tests/setoptimizer.stable.out sql/test/Tests/setoptimizer.stable.out.Windows sql/test/Tests/str-pad.stable.out sql/test/Tests/str-trim.stable.out sql/test/Tests/string.stable.out sql/test/Tests/systemfunctions.stable.out sql/test/Tests/systemfunctions.stable.out.int128 sql/test/Tests/timezone.stable.out sql/test/Tests/zones.stable.out sql/test/Tests/zones.stable.out.int128 sql/test/Tests/zones2.stable.out sql/test/Users/Tests/changePasswordUser.stable.out sql/test/Users/Tests/copyinto.stable.out sql/test/Users/Tests/test_privs2_p1.stable.out sql/test/VOC/Tests/VOC.stable.out sql/test/VOC/Tests/double_is_null.Bug-3116.stable.out sql/test/VOC/Tests/median.Bug-3096.stable.out sql/test/Via-m/Tests/event_s03.stable.out sql/test/Via-m/Tests/event_s05.stable.out sql/test/Via-m/Tests/event_s07.stable.out sql/test/Via-m/Tests/event_s09.stable.out sql/test/Via-m/Tests/event_s11.stable.out sql/test/Via-m/Tests/file_s02.stable.out sql/test/Via-m/Tests/file_s04.stable.out sql/test/Via-m/Tests/file_s05.stable.out sql/test/Via-m/Tests/file_s06.stable.out sql/test/Via-m/Tests/file_s08.stable.out sql/test/Via-m/Tests/file_s10.stable.out sql/test/Via-m/Tests/file_s12.stable.out sql/test/Via-m/Tests/file_s15.stable.out sql/test/Via-m/Tests/media_s04.stable.out sql/test/Via-m/Tests/media_s06.stable.out sql/test/Via-m/Tests/media_s08.stable.out sql/test/Via-m/Tests/media_s10.stable.out sql/test/Via-m/Tests/media_s12.stable.out sql/test/Via-m/Tests/media_s14.stable.out sql/test/Via-m/Tests/media_s16.stable.out sql/test/Via-m/Tests/media_s18.stable.out sql/test/Via-m/Tests/media_s19.stable.out sql/test/bugs/Tests/aggr_single_value.stable.out.int128 sql/test/bugs/Tests/arith-bug-sf-949228.stable.out sql/test/bugs/Tests/case_cast-bug-sf-1019506.stable.out sql/test/bugs/Tests/case_parenthesis-bug-sf-1023056.stable.out sql/test/bugs/Tests/case_substring.stable.out sql/test/bugs/Tests/cast_bool2int-bug-sf-951800.stable.out sql/test/bugs/Tests/crash_order_by.stable.out sql/test/bugs/Tests/create_insert_select_aggr-bug-00001.stable.out sql/test/bugs/Tests/cur_date_crash-JIRA-42.stable.out sql/test/bugs/Tests/date_parsing-bug-sf-960166.stable.out sql/test/bugs/Tests/dbl_sht_cast_bug.stable.out sql/test/bugs/Tests/default_with_cast.SF-1334486.stable.out sql/test/bugs/Tests/distinct_count.stable.out sql/test/bugs/Tests/div_zero_bug.stable.out sql/test/bugs/Tests/escape_quote-bug-sf-1006469.stable.out sql/test/bugs/Tests/except-union-intersect-bug-sf-1146079.stable.out sql/test/bugs/Tests/extract_interval_bug-sf-1274088.stable.out sql/test/bugs/Tests/float_arith_cast2int-bug-sf-949255.stable.out sql/test/bugs/Tests/floor-bug-sf-967066.stable.out sql/test/bugs/Tests/groupby_having-bug-sf-947600.stable.out sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566.stable.out sql/test/bugs/Tests/in_or_bug.stable.out sql/test/bugs/Tests/innerjoin_between-bug-sf-960672.stable.out sql/test/bugs/Tests/insert_delete-bug-sf-904025.stable.out sql/test/bugs/Tests/interval_data_commutative_add_bug-sf-1263928.stable.out sql/test/bugs/Tests/interval_parse_bug-sf-1263967.stable.out sql/test/bugs/Tests/not.stable.out sql/test/bugs/Tests/or_in_crash.stable.out sql/test/bugs/Tests/polymorphism.stable.out sql/test/bugs/Tests/rangejoin_optimize_bug.stable.out sql/test/bugs/Tests/seconds2timestamp.stable.out sql/test/bugs/Tests/select_constant_from_where_1=1-bug-sf-1019529.stable.out sql/test/bugs/Tests/select_into.stable.out sql/test/bugs/Tests/select_orderby_alias-bug-sf-1024615.stable.out sql/test/bugs/Tests/select_select_bug.stable.out sql/test/bugs/Tests/selectlist_subquery-sf-1208599.stable.out sql/test/bugs/Tests/subselect_multiple_unionall_where_1=1-bug-sf-1005596.stable.out sql/test/bugs/Tests/subselect_single_value-bug-sf-962099.stable.out sql/test/bugs/Tests/timestamp_comparison-bug-sf-1158581.stable.out sql/test/bugs/Tests/trimtest-bug-sf-1023588.stable.out sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_JdbcClient.stable.out sql/test/bugs/Tests/unicode_varchar-bug-sf-1041324_MapiClient.stable.out sql/test/bugs/Tests/zero_or_one_bug.stable.out sql/test/emptydb/Tests/load.stable.out sql/test/json/Tests/aggregate00.stable.out sql/test/json/Tests/aggregate01.stable.out sql/test/json/Tests/books.stable.out sql/test/json/Tests/bulkjson.stable.out sql/test/json/Tests/bulklength.stable.out sql/test/json/Tests/bulkvalid.stable.out sql/test/json/Tests/components.stable.out sql/test/json/Tests/jsonvalidity.Bug-3753.stable.out sql/test/json/Tests/load.stable.out sql/test/json/Tests/pathexpr.stable.out sql/test/json/Tests/pgexample.stable.out sql/test/json/Tests/shop.stable.out sql/test/json/Tests/spaceissue.stable.out sql/test/leaks/Tests/check0.stable.out.int128 sql/test/leaks/Tests/check1.stable.out.int128 sql/test/leaks/Tests/check2.stable.out.int128 sql/test/leaks/Tests/check3.stable.out.int128 sql/test/leaks/Tests/check4.stable.out.int128 sql/test/leaks/Tests/check5.stable.out.int128 sql/test/leaks/Tests/drop3.stable.out.int128 sql/test/leaks/Tests/select1.stable.out.int128 sql/test/leaks/Tests/select2.stable.out.int128 sql/test/leaks/Tests/temp1.stable.out.int128 sql/test/leaks/Tests/temp2.stable.out.int128 sql/test/leaks/Tests/temp3.stable.out.int128 sql/test/mapi/Tests/perl_dbi.stable.out sql/test/mapi/Tests/smack01.stable.out sql/test/mapi/Tests/sql_int128.stable.out sql/test/miscellaneous/Tests/trace_test.stable.out sql/test/null/Tests/coalesce.stable.out sql/test/null/Tests/coalesce2.stable.out sql/test/null/Tests/null_in_case.stable.out sql/test/pg_regress/Tests/alter_table.stable.out sql/test/pg_regress/Tests/boolean.stable.out sql/test/pg_regress/Tests/box.stable.out sql/test/pg_regress/Tests/case.stable.out sql/test/pg_regress/Tests/char.stable.out sql/test/pg_regress/Tests/comments.stable.out sql/test/pg_regress/Tests/date.stable.out sql/test/pg_regress/Tests/float4.stable.out sql/test/pg_regress/Tests/float8.stable.out sql/test/pg_regress/Tests/float8.stable.out.Windows sql/test/pg_regress/Tests/horology.stable.out sql/test/pg_regress/Tests/inet.stable.out sql/test/pg_regress/Tests/int2.stable.out sql/test/pg_regress/Tests/int4.stable.out sql/test/pg_regress/Tests/int4.stable.out.int128 sql/test/pg_regress/Tests/int8.stable.out sql/test/pg_regress/Tests/int8.stable.out.int128 sql/test/pg_regress/Tests/interval.stable.out sql/test/pg_regress/Tests/interval.stable.out.int128 sql/test/pg_regress/Tests/limit.stable.out sql/test/pg_regress/Tests/numeric.stable.out sql/test/pg_regress/Tests/numerology.stable.out sql/test/pg_regress/Tests/oid.stable.out sql/test/pg_regress/Tests/path.stable.out sql/test/pg_regress/Tests/point.stable.out sql/test/pg_regress/Tests/polygon.stable.out sql/test/pg_regress/Tests/random.stable.out sql/test/pg_regress/Tests/reltime.stable.out sql/test/pg_regress/Tests/strings.stable.out sql/test/pg_regress/Tests/strings_cast.stable.out sql/test/pg_regress/Tests/strings_concat.stable.out sql/test/pg_regress/Tests/strings_like.stable.out sql/test/pg_regress/Tests/text.stable.out sql/test/pg_regress/Tests/time.stable.out sql/test/pg_regress/Tests/timestamp.stable.out sql/test/pg_regress/Tests/timestamptz.stable.out sql/test/pg_regress/Tests/timetz.stable.out sql/test/pg_regress/Tests/vacuum.stable.out sql/test/pg_regress/Tests/varchar.stable.out sql/test/pg_regress/Tests/without_oid.stable.out sql/test/snodgrass/Tests/cast_select.stable.out sql/test/snodgrass/Tests/date_parsing.stable.out sql/test/snodgrass/Tests/date_select.stable.out sql/test/snodgrass/Tests/extract_select.stable.out sql/test/snodgrass/Tests/interval_parsing.stable.out sql/test/snodgrass/Tests/interval_select.stable.out sql/test/sql_xml/Tests/xml.stable.out sql/test/sql_xml/Tests/xml_attribute_parsing.SF-1855673.stable.out sql/test/sql_xml/Tests/xmlelement_segfault.SF-2812767.stable.out sql/test/ssqq/Tests/insert_query.stable.out sql/test/ssqq/Tests/insert_queue.stable.out sql/test/ssqq/Tests/insert_quser.stable.out Branch: default Log Message:
merged with jun2016 diffs (truncated from 87580 to 300 lines): diff --git a/clients/Tests/SQL-dump.stable.out b/clients/Tests/SQL-dump.stable.out --- a/clients/Tests/SQL-dump.stable.out +++ b/clients/Tests/SQL-dump.stable.out @@ -1287,10 +1287,8 @@ drop function pcre_replace(string, strin [ "profiler", 3, 3, true ] [ "sys", 2, 3, true ] [ "tmp", 2, 3, true ] -#select s.name, t.name, replace(replace(pcre_replace(pcre_replace(pcre_replace(t.query, '--.* -#', '', ''), '[ -#]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query, t.type, t.system, t.commit_action, t.access from sys._tables t left outer join sys.schemas s on t.schema_id = s.id order by s.name, t.name; -% .s, .t, .L, .t, .t, .t, .t # table_name +#select s.name, t.name, replace(replace(pcre_replace(pcre_replace(pcre_replace(t.query, '--.*\n', '', ''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query, t.type, t.system, t.commit_action, t.access from sys._tables t left outer join sys.schemas s on t.schema_id = s.id order by s.name, t.name; +% .s, .t, .L1, .t, .t, .t, .t # table_name % name, name, query, type, system, commit_action, access # name % varchar, varchar, varchar, smallint, boolean, smallint, smallint # type % 3, 17, 597, 1, 5, 1, 1 # length @@ -1738,10 +1736,8 @@ drop function pcre_replace(string, strin [ "users", "name", "varchar", 1024, 0, NULL, true, 0, NULL ] [ "users", "fullname", "varchar", 2024, 0, NULL, true, 1, NULL ] [ "users", "default_schema", "int", 9, 0, NULL, true, 2, NULL ] -#select s.name, f.name, replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.* -#', '', ''), '[ -#]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query, f.mod, f.language, f.type, f.side_effect, f.varres, f.vararg from sys.functions f left outer join sys.schemas s on f.schema_id = s.id order by s.name, f.name, query; -% .s, .f, .L, .f, .f, .f, .f, .f, .f # table_name +#select s.name, f.name, replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*\n', '', ''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query, f.mod, f.language, f.type, f.side_effect, f.varres, f.vararg from sys.functions f left outer join sys.schemas s on f.schema_id = s.id order by s.name, f.name, query; +% .s, .f, .L1, .f, .f, .f, .f, .f, .f # table_name % name, name, query, mod, language, type, side_effect, varres, vararg # name % varchar, varchar, varchar, varchar, int, int, boolean, boolean, boolean # type % 8, 35, 831, 9, 1, 1, 5, 5, 5 # length @@ -4856,7 +4852,6 @@ drop function pcre_replace(string, strin % name, name, name, name, name # name % varchar, varchar, varchar, varchar, char # type % 3, 17, 3, 13, 20 # length -[ "sys", "ms_trunc", "sys", "ms_round", "FUNC_DEPENDENCY" ] [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNC_DEPENDENCY" ] [ "sys", "st_geometryn", "sys", "st_patchn", "FUNC_DEPENDENCY" ] [ "sys", "getproj4", "sys", "st_transform", "FUNC_DEPENDENCY" ] @@ -4918,92 +4913,198 @@ drop function pcre_replace(string, strin [ "sys", "triggers", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNC_DEPENDENCY" ] [ "sys", "storagemodelinput", "sys", "storagemodel", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "objects", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "schemas", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] [ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "tables", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] #select s1.name, t.name, c.name, s2.name, f.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), sys.dependencies d, sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type = dt.id and d.id = c.id and d.depend_id = f.id and c.table_id = t.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name, c.name; % sys.s1, sys.t, sys.c, sys.s2, sys.f, .dt # table_name % name, name, name, name, name, name # name % varchar, varchar, varchar, varchar, varchar, char # type -% 3, 17, 11, 3, 35, 20 # length +% 3, 17, 13, 3, 35, 20 # length [ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "func", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "functions", "id", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "language", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "mod", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "functions", "name", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "schema_id", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "side_effect", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "type", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "vararg", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "varres", "sys", "dependencies_columns_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "idxs", "id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "idxs", "name", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "idxs", "table_id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "idxs", "type", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "action", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "keys", "name", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "rkey", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "table_id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "type", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "objects", "id", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "objects", "name", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "objects", "nr", "sys", "dependencies_columns_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "action", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "id", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "name", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "rkey", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "table_id", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "type", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "objects", "id", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "objects", "name", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] +[ "sys", "objects", "nr", "sys", "dependencies_columns_on_keys", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "condition", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "event", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "id", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "name", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "new_name", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "old_name", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "orientation", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "statement", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "table_id", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "time", "sys", "dependencies_columns_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_views", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_columns_on_views", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_columns_on_views", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "func", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "functions", "id", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "language", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "mod", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "functions", "name", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "schema_id", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "side_effect", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "type", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "vararg", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "varres", "sys", "dependencies_functions_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "func", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] [ "sys", "functions", "id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "language", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "mod", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] [ "sys", "functions", "name", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "schema_id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "side_effect", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "type", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "vararg", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "varres", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "condition", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "event", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "name", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "new_name", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "old_name", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "orientation", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "statement", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "table_id", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "time", "sys", "dependencies_functions_os_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "action", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "id", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "name", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "table_id", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "type", "sys", "dependencies_keys_on_foreignkeys", "FUNC_DEPENDENCY" ] +[ "sys", "auths", "grantor", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "authorization", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "system", "sys", "dependencies_owners_on_schemas", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "authorization", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "owner", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] +[ "sys", "schemas", "system", "sys", "dependencies_schemas_on_users", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "action", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "id", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "name", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "rkey", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "keys", "table_id", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "type", "sys", "dependencies_tables_on_foreignkeys", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "func", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "functions", "id", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "language", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "mod", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "functions", "name", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "schema_id", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "side_effect", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "type", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "vararg", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "varres", "sys", "dependencies_tables_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "idxs", "id", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "idxs", "name", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "idxs", "table_id", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "idxs", "type", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "action", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "id", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "keys", "name", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "rkey", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "table_id", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "type", "sys", "dependencies_tables_on_indexes", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "condition", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "event", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "id", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "name", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "new_name", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "old_name", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "orientation", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "statement", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "table_id", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "time", "sys", "dependencies_tables_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_views", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_tables_on_views", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_tables_on_views", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "func", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "functions", "id", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "language", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "mod", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "functions", "name", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "schema_id", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "side_effect", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "type", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "vararg", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] +[ "sys", "functions", "varres", "sys", "dependencies_views_on_functions", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_id", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "depend_type", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "dependencies", "id", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "condition", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "event", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "id", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] [ "sys", "triggers", "name", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "new_name", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "old_name", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "orientation", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "statement", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "table_id", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "triggers", "time", "sys", "dependencies_views_on_triggers", "FUNC_DEPENDENCY" ] +[ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNC_DEPENDENCY" ] +[ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNC_DEPENDENCY" ] [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNC_DEPENDENCY" ] [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNC_DEPENDENCY" ] +[ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNC_DEPENDENCY" ] [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "FUNC_DEPENDENCY" ] [ "sys", "storagemodelinput", "column", "sys", "storagemodel", "FUNC_DEPENDENCY" ] [ "sys", "storagemodelinput", "count", "sys", "storagemodel", "FUNC_DEPENDENCY" ] @@ -5015,7 +5116,22 @@ drop function pcre_replace(string, strin [ "sys", "storagemodelinput", "sorted", "sys", "storagemodel", "FUNC_DEPENDENCY" ] [ "sys", "storagemodelinput", "table", "sys", "storagemodel", "FUNC_DEPENDENCY" ] [ "sys", "storagemodelinput", "type", "sys", "storagemodel", "FUNC_DEPENDENCY" ] +[ "sys", "storagemodelinput", "typewidth", "sys", "storagemodel", "FUNC_DEPENDENCY" ] [ "sys", "storagemodelinput", "unique", "sys", "storagemodel", "FUNC_DEPENDENCY" ] +[ "sys", "keys", "action", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "keys", "id", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "keys", "name", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "keys", "rkey", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "keys", "table_id", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "keys", "type", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "objects", "id", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "objects", "name", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "objects", "nr", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "schemas", "authorization", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "schemas", "id", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "schemas", "name", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "schemas", "owner", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] +[ "sys", "schemas", "system", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] [ "sys", "storagemodelinput", "column", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] [ "sys", "storagemodelinput", "count", "sys", "storagemodelinit", "PROC_DEPENDENCY" ] @@ -5033,23 +5149,10 @@ drop function pcre_replace(string, strin % sys.s1, sys.f1, sys.s2, sys.t2, .dt # table_name % name, name, name, name, name # name % varchar, varchar, varchar, varchar, char # type -% 3, 16, 3, 17, 20 # length -[ "sys", "environment", "sys", "environment", "VIEW_DEPENDENCY" ] +% 3, 8, 3, 16, 20 # length [ "sys", "get_type", "sys", "geometry_columns", "VIEW_DEPENDENCY" ] [ "sys", "has_m", "sys", "geometry_columns", "VIEW_DEPENDENCY" ] [ "sys", "has_z", "sys", "geometry_columns", "VIEW_DEPENDENCY" ] -[ "sys", "optimizers", "sys", "optimizers", "VIEW_DEPENDENCY" ] -[ "sys", "querylog_calls", "sys", "querylog_calls", "VIEW_DEPENDENCY" ] -[ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW_DEPENDENCY" ] -[ "sys", "querylog_calls", "sys", "querylog_history", "VIEW_DEPENDENCY" ] -[ "sys", "querylog_catalog", "sys", "querylog_history", "VIEW_DEPENDENCY" ] -[ "sys", "queue", "sys", "queue", "VIEW_DEPENDENCY" ] -[ "sys", "rejects", "sys", "rejects", "VIEW_DEPENDENCY" ] -[ "sys", "sessions", "sys", "sessions", "VIEW_DEPENDENCY" ] -[ "sys", "storage", "sys", "storage", "VIEW_DEPENDENCY" ] -[ "sys", "storagemodel", "sys", "storagemodel", "VIEW_DEPENDENCY" ] -[ "sys", "storagemodel", "sys", "tablestoragemodel", "VIEW_DEPENDENCY" ] -[ "sys", "tracelog", "sys", "tracelog", "VIEW_DEPENDENCY" ] #select s1.name, t1.name, s2.name, t2.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), schemas s1, _tables t1, schemas s2, _tables t2, dependencies d where d.depend_type = dt.id and d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; % sys.s1, sys.t1, sys.s2, sys.t2, .dt # table_name % name, name, name, name, name # name @@ -5067,8 +5170,8 @@ drop function pcre_replace(string, strin % 3, 7, 10, 3, 16, 20 # length [ "sys", "schemas", "id", "sys", "geometry_columns", "VIEW_DEPENDENCY" ] [ "sys", "schemas", "name", "sys", "geometry_columns", "VIEW_DEPENDENCY" ] +[ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW_DEPENDENCY" ] [ "sys", "types", "sqlname", "sys", "geometry_columns", "VIEW_DEPENDENCY" ] -[ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW_DEPENDENCY" ] #select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name, dt.name from (values (1, 'SCHEMA_DEPENDENCY'), (2, 'TABLE_DEPENDENCY'), (3, 'COLUMN_DEPENDENCY'), (4, 'KEY_DEPENDENCY'), (5, 'VIEW_DEPENDENCY'), (6, 'USER_DEPENDENCY'), (7, 'FUNC_DEPENDENCY'), (8, 'TRIGGER_DEPENDENCY'), (9, 'OWNER_DEPENDENCY'), (10, 'INDEX_DEPENDENCY'), (11, 'FKEY_DEPENDENCY'), (12, 'SEQ_DEPENDENCY'), (13, 'PROC_DEPENDENCY'), (14, 'BEDROPPED_DEPENDENCY'), (15, 'TYPE_DEPENDENCY')) as dt (id, name), dependencies d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where d.depend_type = dt.id and d.id = c1.id and d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id = s1.id and k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, k2.name, s1.name, t1.name, c1.name; % sys.s1, sys.t1, sys.c1, sys.s2, sys.t2, sys.k2, .dt # table_name % name, name, name, name, name, name, name # name @@ -5542,13 +5645,13 @@ drop function pcre_replace(string, strin % varchar, varchar, bigint, bigint, bigint, bigint, bigint, boolean # type % 0, 0, 1, 1, 1, 1, 1, 5 # length #select count(*) from sys.statistics; -% sys.L1 # table_name _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list