Jump to Content
data-api
GuidesAPI ReferenceChangelog
v2.0

Log Indata-api
Log In
v2.0GuidesAPI ReferenceChangelog

Introduction

  • Get started

Data

  • Design concept
  • Coverage
  • Layers
  • Domains
  • Naming convention
  • Sources
  • Interfaces

Web application

  • Get started
  • Use cases
  • Charts
    • No code
    • SQL
    • No code -> SQL
    • Alerts
  • Visualisations
    • Line chart
    • Tables
    • Number and Trend
    • Bar chart
    • Pivot Table
    • Line and Row Race
    • Dynamic Pie
    • Advanced. Pie Chart Rose, Nested Pies, Sunburst and Treemap
  • Dashboards
    • Create
    • Forks (templates)
    • Design
    • Embed

Reference

  • FAQ
  • Query troubleshooting
    • Incompatible data updates
    • Native SQL functions
    • Integer overflows
    • Different types compared
    • Query Timeout

Links

  • Discord
  • Twitter
  • Medium
  • Press kit
Powered by 

Integer overflows

Suggest Edits

Content

When multiplying two integers, the result may exceed the maximum integer length limit

How to solve

  • cast one of the integers to type double

FP Console Output

bigint multiplication overflow: 715932 * 24403000000000

Code Example

cast( 715932 as double )* 24403000000000

Updated 3 months ago


  • Table of Contents
    • Content
    • How to solve
    • FP Console Output
    • Code Example