Skip to content
Trino 475 Documentation logo
Trino 475 Documentation Release 0.173
Type to start searching
    Trino
    Trino
    • Overview
    • Installation
    • Clients
    • Security
    • Administration
    • Query optimizer
    • Connectors
    • Object storage
    • Functions and operators
    • User-defined functions
    • SQL language
    • SQL statement syntax
    • Developer guide
    • Glossary
    • Appendix
    • Release notes
      • Release 475 (23 Apr 2025)
      • Release 474 (21 Mar 2025)
      • Release 473 (19 Mar 2025)
      • Release 472 (5 Mar 2025)
      • Release 471 (19 Feb 2025)
      • Release 470 (5 Feb 2025)
      • Release 469 (27 Jan 2025)
      • Release 468 (17 Dec 2024)
      • Release 467 (6 Dec 2024)
      • Release 466 (27 Nov 2024)
      • Release 465 (20 Nov 2024)
      • Release 464 (30 Oct 2024)
      • Release 463 (23 Oct 2024)
      • Release 462 (16 Oct 2024)
      • Release 461 (10 Oct 2024)
      • Release 460 (3 Oct 2024)
      • Release 459 (25 Sep 2024)
      • Release 458 (17 Sep 2024)
      • Release 457 (6 Sep 2024)
      • Release 456 (6 Sep 2024)
      • Release 455 (29 Aug 2024)
      • Release 454 (15 Aug 2024)
      • Release 453 (25 Jul 2024)
      • Release 452 (11 Jul 2024)
      • Release 451 (27 Jun 2024)
      • Release 450 (19 Jun 2024)
      • Release 449 (31 May 2024)
      • Release 448 (15 May 2024)
      • Release 447 (8 May 2024)
      • Release 446 (1 May 2024)
      • Release 445 (17 Apr 2024)
      • Release 444 (3 Apr 2024)
      • Release 443 (21 Mar 2024)
      • Release 442 (14 Mar 2024)
      • Release 441 (13 Mar 2024)
      • Release 440 (8 Mar 2024)
      • Release 439 (15 Feb 2024)
      • Release 438 (1 Feb 2024)
      • Release 437 (24 Jan 2024)
      • Release 436 (11 Jan 2024)
      • Release 435 (13 Dec 2023)
      • Release 434 (29 Nov 2023)
      • Release 433 (10 Nov 2023)
      • Release 432 (2 Nov 2023)
      • Release 431 (27 Oct 2023)
      • Release 430 (20 Oct 2023)
      • Release 429 (11 Oct 2023)
      • Release 428 (4 Oct 2023)
      • Release 427 (26 Sep 2023)
      • Release 426 (5 Sep 2023)
      • Release 425 (24 Aug 2023)
      • Release 424 (17 Aug 2023)
      • Release 423 (10 Aug 2023)
      • Release 422 (13 Jul 2023)
      • Release 421 (6 Jul 2023)
      • Release 420 (22 Jun 2023)
      • Release 419 (5 Jun 2023)
      • Release 418 (17 May 2023)
      • Release 417 (10 May 2023)
      • Release 416 (3 May 2023)
      • Release 415 (28 Apr 2023)
      • Release 414 (19 Apr 2023)
      • Release 413 (12 Apr 2023)
      • Release 412 (5 Apr 2023)
      • Release 411 (29 Mar 2023)
      • Release 410 (8 Mar 2023)
      • Release 409 (3 Mar 2023)
      • Release 408 (23 Feb 2023)
      • Release 407 (16 Feb 2023)
      • Release 406 (25 Jan 2023)
      • Release 405 (28 Dec 2022)
      • Release 404 (???)
      • Release 403 (15 Nov 2022)
      • Release 402 (2 Nov 2022)
      • Release 401 (26 Oct 2022)
      • Release 400 (13 Oct 2022)
      • Release 399 (6 Oct 2022)
      • Release 398 (28 Sep 2022)
      • Release 397 (21 Sep 2022)
      • Release 396 (15 Sep 2022)
      • Release 395 (7 Sep 2022)
      • Release 394 (29 Aug 2022)
      • Release 393 (17 Aug 2022)
      • Release 392 (3 Aug 2022)
      • Release 391 (22 Jul 2022)
      • Release 390 (13 Jul 2022)
      • Release 389 (7 Jul 2022)
      • Release 388 (29 Jun 2022)
      • Release 387 (22 Jun 2022)
      • Release 386 (15 Jun 2022)
      • Release 385 (8 Jun 2022)
      • Release 384 (3 Jun 2022)
      • Release 383 (1 Jun 2022)
      • Release 382 (25 May 2022)
      • Release 381 (16 May 2022)
      • Release 380 (6 May 2022)
      • Release 379 (28 Apr 2022)
      • Release 378 (21 Apr 2022)
      • Release 377 (13 Apr 2022)
      • Release 376 (7 Apr 2022)
      • Release 375 (28 Mar 2022)
      • Release 374 (17 Mar 2022)
      • Release 373 (9 Mar 2022)
      • Release 372 (2 Mar 2022)
      • Release 371 (16 Feb 2022)
      • Release 370 (3 Feb 2022)
      • Release 369 (24 Jan 2022)
      • Release 368 (11 Jan 2022)
      • Release 367 (22 Dec 2021)
      • Release 366 (14 Dec 2021)
      • Release 365 (3 Dec 2021)
      • Release 364 (1 Nov 2021)
      • Release 363 (6 Oct 2021)
      • Release 362 (20 Sep 2021)
      • Release 361 (27 Aug 2021)
      • Release 360 (30 Jul 2021)
      • Release 359 (1 Jul 2021)
      • Release 358 (1 Jun 2021)
      • Release 357 (21 May 2021)
      • Release 356 (30 Apr 2021)
      • Release 355 (8 Apr 2021)
      • Release 354 (19 Mar 2021)
      • Release 353 (5 Mar 2021)
      • Release 352 (9 Feb 2021)
      • Release 351 (3 Jan 2021)
      • Release 350 (28 Dec 2020)
      • Release 349 (28 Dec 2020)
      • Release 348 (14 Dec 2020)
      • Release 347 (25 Nov 2020)
      • Release 346 (10 Nov 2020)
      • Release 345 (23 Oct 2020)
      • Release 344 (9 Oct 2020)
      • Release 343 (25 Sep 2020)
      • Release 342 (24 Sep 2020)
      • Release 341 (8 Sep 2020)
      • Release 340 (8 Aug 2020)
      • Release 339 (21 Jul 2020)
      • Release 338 (07 Jul 2020)
      • Release 337 (25 Jun 2020)
      • Release 336 (16 Jun 2020)
      • Release 335 (14 Jun 2020)
      • Release 334 (29 May 2020)
      • Release 333 (04 May 2020)
      • Release 332 (08 Apr 2020)
      • Release 331 (16 Mar 2020)
      • Release 330 (18 Feb 2020)
      • Release 329 (23 Jan 2020)
      • Release 328 (10 Jan 2020)
      • Release 327 (20 Dec 2019)
      • Release 326 (27 Nov 2019)
      • Release 325 (14 Nov 2019)
      • Release 324 (1 Nov 2019)
      • Release 323 (23 Oct 2019)
      • Release 322 (16 Oct 2019)
      • Release 321 (15 Oct 2019)
      • Release 320 (10 Oct 2019)
      • Release 319 (22 Sep 2019)
      • Release 318 (26 Aug 2019)
      • Release 317 (1 Aug 2019)
      • Release 316 (8 Jul 2019)
      • Release 315 (14 Jun 2019)
      • Release 314 (7 Jun 2019)
      • Release 313 (31 May 2019)
      • Release 312 (29 May 2019)
      • Release 311 (14 May 2019)
      • Release 310 (3 May 2019)
      • Release 309 (25 Apr 2019)
      • Release 308 (11 Apr 2019)
      • Release 307 (3 Apr 2019)
      • Release 306 (16 Mar 2019)
      • Release 305 (7 Mar 2019)
      • Release 304 (27 Feb 2019)
      • Release 303 (13 Feb 2019)
      • Release 302 (6 Feb 2019)
      • Release 301 (31 Jan 2019)
      • Release 300 (22 Jan 2019)
      • Release 0.215
      • Release 0.214
      • Release 0.213
      • Release 0.212
      • Release 0.211
      • Release 0.210
      • Release 0.209
      • Release 0.208
      • Release 0.207
      • Release 0.206
      • Release 0.205
      • Release 0.204
      • Release 0.203
      • Release 0.202
      • Release 0.201
      • Release 0.200
      • Release 0.199
      • Release 0.198
      • Release 0.197
      • Release 0.196
      • Release 0.195
      • Release 0.194
      • Release 0.193
      • Release 0.192
      • Release 0.191
      • Release 0.190
      • Release 0.189
      • Release 0.188
      • Release 0.187
      • Release 0.186
      • Release 0.185
      • Release 0.184
      • Release 0.183
      • Release 0.182
      • Release 0.181
      • Release 0.180
      • Release 0.179
      • Release 0.178
      • Release 0.177
      • Release 0.176
      • Release 0.175
      • Release 0.174
      • Release 0.173
        • General
      • Release 0.172
      • Release 0.171
      • Release 0.170
      • Release 0.169
      • Release 0.168
      • Release 0.167
      • Release 0.166
      • Release 0.165
      • Release 0.164
      • Release 0.163
      • Release 0.162
      • Release 0.161
      • Release 0.160
      • Release 0.159
      • Release 0.158
      • Release 0.157.1
      • Release 0.157
      • Release 0.156
      • Release 0.155
      • Release 0.154
      • Release 0.153
      • Release 0.152.3
      • Release 0.152.2
      • Release 0.152.1
      • Release 0.152
      • Release 0.151
      • Release 0.150
      • Release 0.149
      • Release 0.148
      • Release 0.147
      • Release 0.146
      • Release 0.145
      • Release 0.144.7
      • Release 0.144.6
      • Release 0.144.5
      • Release 0.144.4
      • Release 0.144.3
      • Release 0.144.2
      • Release 0.144.1
      • Release 0.144
      • Release 0.143
      • Release 0.142
      • Release 0.141
      • Release 0.140
      • Release 0.139
      • Release 0.138
      • Release 0.137
      • Release 0.136
      • Release 0.135
      • Release 0.134
      • Release 0.133
      • Release 0.132
      • Release 0.131
      • Release 0.130
      • Release 0.129
      • Release 0.128
      • Release 0.127
      • Release 0.126
      • Release 0.125
      • Release 0.124
      • Release 0.123
      • Release 0.122
      • Release 0.121
      • Release 0.120
      • Release 0.119
      • Release 0.118
      • Release 0.117
      • Release 0.116
      • Release 0.115
      • Release 0.114
      • Release 0.113
      • Release 0.112
      • Release 0.111
      • Release 0.110
      • Release 0.109
      • Release 0.108
      • Release 0.107
      • Release 0.106
      • Release 0.105
      • Release 0.104
      • Release 0.103
      • Release 0.102
      • Release 0.101
      • Release 0.100
      • Release 0.99
      • Release 0.98
      • Release 0.97
      • Release 0.96
      • Release 0.95
      • Release 0.94
      • Release 0.93
      • Release 0.92
      • Release 0.91
      • Release 0.90
      • Release 0.89
      • Release 0.88
      • Release 0.87
      • Release 0.86
      • Release 0.85
      • Release 0.84
      • Release 0.83
      • Release 0.82
      • Release 0.81
      • Release 0.80
      • Release 0.79
      • Release 0.78
      • Release 0.77
      • Release 0.76
      • Release 0.75
      • Release 0.74
      • Release 0.73
      • Release 0.72
      • Release 0.71
      • Release 0.70
      • Release 0.69
      • Release 0.68
      • Release 0.67
      • Release 0.66
      • Release 0.65
      • Release 0.64
      • Release 0.63
      • Release 0.62
      • Release 0.61
      • Release 0.60
      • Release 0.59
      • Release 0.58
      • Release 0.57
      • Release 0.56
      • Release 0.55
      • Release 0.54
    • General

    Release 0.173#

    General#

    • Fix issue where FILTER was ignored for count() with a constant argument.

    • Support table comments for CREATE TABLE and CREATE TABLE AS.

    Previous Release 0.174
    Next Release 0.172