This seems to work:

WITH first_1000 AS (
    SELECT
        html_url,
        id,
        author,
        node_id,
        tag_name,
        target_commitish,
        name,
        draft,
        prerelease,
        created_at,
        published_at,
        body,
        repo,
        reactions,
        mentions_count
    FROM releases
    LIMIT 1000
)
SELECT
    MAX(CASE WHEN INSTR(html_url, '\n') > 0 THEN 1 ELSE 0 END) AS html_url_has_newline,
    MAX(CASE WHEN INSTR(id, '\n') > 0 THEN 1 ELSE 0 END) AS id_has_newline,
    MAX(CASE WHEN INSTR(author, '\n') > 0 THEN 1 ELSE 0 END) AS author_has_newline,
    MAX(CASE WHEN INSTR(node_id, '\n') > 0 THEN 1 ELSE 0 END) AS node_id_has_newline,
    MAX(CASE WHEN INSTR(tag_name, '\n') > 0 THEN 1 ELSE 0 END) AS tag_name_has_newline,
    MAX(CASE WHEN INSTR(target_commitish, '\n') > 0 THEN 1 ELSE 0 END) AS target_commitish_has_newline,
    MAX(CASE WHEN INSTR(name, '\n') > 0 THEN 1 ELSE 0 END) AS name_has_newline,
    MAX(CASE WHEN INSTR(draft, '\n') > 0 THEN 1 ELSE 0 END) AS draft_has_newline,
    MAX(CASE WHEN INSTR(prerelease, '\n') > 0 THEN 1 ELSE 0 END) AS prerelease_has_newline,
    MAX(CASE WHEN INSTR(created_at, '\n') > 0 THEN 1 ELSE 0 END) AS created_at_has_newline,
    MAX(CASE WHEN INSTR(published_at, '\n') > 0 THEN 1 ELSE 0 END) AS published_at_has_newline,
    MAX(CASE WHEN INSTR(body, '\n') > 0 THEN 1 ELSE 0 END) AS body_has_newline,
    MAX(CASE WHEN INSTR(repo, '\n') > 0 THEN 1 ELSE 0 END) AS repo_has_newline,
    MAX(CASE WHEN INSTR(reactions, '\n') > 0 THEN 1 ELSE 0 END) AS reactions_has_newline,
    MAX(CASE WHEN INSTR(mentions_count, '\n') > 0 THEN 1 ELSE 0 END) AS mentions_count_has_newline
FROM first_1000;

Uh oh!

Row action item for "Update using SQL" #10

Description

Metadata

Metadata

Assignees

Labels

Projects

Milestone

Relationships

Development

Issue actions