Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

reduce: costfuzz reducer does not print SELECT statements #87418

Closed
mgartner opened this issue Sep 6, 2022 · 1 comment
Closed

reduce: costfuzz reducer does not print SELECT statements #87418

mgartner opened this issue Sep 6, 2022 · 1 comment
Assignees
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. E-quick-win Likely to be a quick win for someone experienced. T-sql-queries SQL Queries Team

Comments

@mgartner
Copy link
Collaborator

mgartner commented Sep 6, 2022

I tried reducing this costfuzz failure with ./bin/reduce -binary ./cockroach -chunk 15 -costfuzz -file failure.log -v, and it was reduced to three SQL statements with the costfuzz SELECT queries missing. The SELECT queries should be printed, like they are for TLP reductions.

CREATE TABLE table2 (
  col2_0 BIT(24),
  col2_1 INT2,
  col2_2 TIMETZ NOT NULL,
  col2_3 TIMESTAMPTZ,
  col2_4 BIT(2),
  col2_5 FLOAT8,
  col2_6 STRING AS (lower(NULL)) VIRTUAL,
  col2_7 INT8,
  PRIMARY KEY (col2_1),
  INDEX (col2_2, col2_4 ASC) STORING(col2_0),
  UNIQUE (col2_2)
);

INSERT
  INTO table2 (col2_0, col2_1, col2_2, col2_3, col2_4, col2_5)
VALUES (NULL, 14831, '20:09:25.985305-12:13:00', '1997-06-25 14:53:21.000746+00:00', B'00', 0);

INSERT
  INTO table2 (col2_1, col2_2, col2_3, col2_4, col2_5)
VALUES (0, '20:30:19.373128-12:02:00', '1970-01-12 03:46:40+00:00', B'00', 0);

Jira issue: CRDB-19337

@mgartner mgartner added C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. E-quick-win Likely to be a quick win for someone experienced. labels Sep 6, 2022
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Sep 6, 2022
@rytaft
Copy link
Collaborator

rytaft commented Oct 27, 2022

Either do this today or close :)

@mgartner mgartner moved this to Done in SQL Queries Jul 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. E-quick-win Likely to be a quick win for someone experienced. T-sql-queries SQL Queries Team
Projects
Archived in project
Development

No branches or pull requests

2 participants